AquaQ Analytics Releases Google BigQuery API To Seamlessly Connect KDB+Users to Refinitiv Tick History
Belfast-headquartered Big Data and Real-Time Analytics company AquaQ Analytics is pleased to announce the released of a new Google BigQuery API. The API allows kdb+ users to query data across both kdb+ and Google BigQuery, using queries written in q. By extension it opens clients up to a hybrid historical market data storage model on the Cloud, involving Refinitiv’s hosted Tick History (which is also hosted on BigQuery).
Marketing Technology News: Latest in Content Advertising: No more Facebook News for Australian Users
The data behind the API can be split, for example, with the most recent 3 months’ of data history (the most frequently accessed data), residing within the client’s kdb+ database as normal. The more historical data (accessed less frequently), is pulled directly from Refinitiv’s hosted Tick History.
The AquaQ API does the heavy lifting; allowing the end users to continue to use their pre-existing queries written in q, while behind the scenes, the API logic distributes the query appropriately across the financial institution’s kdb+ store, and Refinitiv’s hosted Tick History on BigQuery. This approach offers more flexibility to financial institutions, with the aim of reducing long term historical data maintenance and storage costs. Should the financial institution decide to put some of its own data onto BigQuery, the API can also be used to retrieve this data seamlessly for the kdb+ end user. Merging of the retrieved data and any additional analytical processing can be carried out in kdb+ before returning results to the user.
Jonny Press, AquaQ CTO, commented “We are delighted to be able to offer this solution to kdb+ clients. It provides clear savings on both data maintenance and data storage costs and takes advantage of Refinitiv’s hosted Tick History on the Cloud. We are already seeing a lot of interest from our clients on this innovative approach and we hope to extend to AWS Redshift, Azure Synapse, Snowflake and across other Market Data Providers in the near future.”
In conjunction with this new API release, AquaQ will be hosting a Virtual AquaQuarantine Tech Talk on Thursday 1 April 2021, where the solution will be discussed with a panel consisting of Sebastian Fuchs (Refinitiv), Martin Bradford (Refinitiv), Gary Davies (AquaQ Analytics) and Matthew Clark (AquaQ Analytics). For more information and signup details click on the AquaQuarantine link above.