PREVIEW / futures_1hour / 2021-05-27

all futures 1-hour files

  file:    by_date/futures_1hour/2021/2021-05-27.parquet
  size:    63 KB
  rows:    1,972

schema

  timestamp    TIMESTAMP
  symbol       VARCHAR
  asset_type   VARCHAR
  open         DOUBLE
  high         DOUBLE
  low          DOUBLE
  close        DOUBLE
  volume       DOUBLE

sample rows

timestamp	symbol	asset_type	open	high	low	close	volume
2021-05-27 00:00:00	ES	Futures	4707.36	4707.92	4703.71	4706.24	3867.0
2021-05-27 01:00:00	ES	Futures	4706.24	4708.76	4702.02	4707.92	7074.0
2021-05-27 02:00:00	ES	Futures	4707.92	4708.76	4695.28	4699.21	12530.0
2021-05-27 03:00:00	ES	Futures	4699.21	4704.27	4697.53	4701.18	19035.0
2021-05-27 04:00:00	ES	Futures	4701.18	4705.67	4698.65	4700.05	10320.0
2021-05-27 05:00:00	ES	Futures	4700.34	4702.02	4698.65	4698.65	7468.0
2021-05-27 06:00:00	ES	Futures	4698.93	4704.55	4697.25	4702.86	7252.0
2021-05-27 07:00:00	ES	Futures	4702.86	4710.17	4701.46	4709.61	14463.0
2021-05-27 08:00:00	ES	Futures	4709.89	4719.16	4704.83	4717.47	49969.0
2021-05-27 09:00:00	ES	Futures	4717.47	4730.68	4716.63	4724.5	162642.0
2021-05-27 10:00:00	ES	Futures	4724.78	4731.52	4721.13	4724.5	159103.0
2021-05-27 11:00:00	ES	Futures	4724.78	4727.87	4717.47	4726.75	122282.0
2021-05-27 12:00:00	ES	Futures	4726.75	4728.43	4723.09	4723.94	48737.0
2021-05-27 13:00:00	ES	Futures	4723.94	4725.9	4716.91	4720.28	83526.0
2021-05-27 14:00:00	ES	Futures	4720.0	4720.57	4714.67	4719.16	97880.0
2021-05-27 15:00:00	ES	Futures	4718.88	4725.06	4713.82	4714.67	217194.0
2021-05-27 16:00:00	ES	Futures	4714.67	4733.21	4713.82	4732.93	87411.0
2021-05-27 18:00:00	ES	Futures	4732.93	4733.77	4730.96	4732.37	4438.0
2021-05-27 19:00:00	ES	Futures	4732.37	4738.55	4730.4	4736.58	8291.0
2021-05-27 20:00:00	ES	Futures	4736.58	4739.95	4735.46	4736.86	9973.0
2021-05-27 21:00:00	ES	Futures	4736.58	4737.42	4733.49	4734.33	8644.0
2021-05-27 22:00:00	ES	Futures	4734.33	4735.18	4731.8	4733.21	6550.0
2021-05-27 23:00:00	ES	Futures	4733.49	4736.3	4733.49	4735.74	4192.0
2021-05-27 00:00:00	NQ	Futures	15838.87	15840.31	15824.1	15835.1	1851.0
2021-05-27 01:00:00	NQ	Futures	15834.81	15848.71	15819.47	15846.97	3545.0
2021-05-27 02:00:00	NQ	Futures	15846.39	15850.16	15797.76	15809.05	4432.0
2021-05-27 03:00:00	NQ	Futures	15809.63	15820.34	15772.57	15787.63	8633.0
2021-05-27 04:00:00	NQ	Futures	15787.91	15810.5	15780.39	15787.05	6173.0
2021-05-27 05:00:00	NQ	Futures	15787.63	15796.31	15771.99	15782.12	4609.0
2021-05-27 06:00:00	NQ	Futures	15782.7	15810.78	15776.62	15802.39	3590.0
2021-05-27 07:00:00	NQ	Futures	15802.1	15828.73	15788.2	15826.42	6104.0
2021-05-27 08:00:00	NQ	Futures	15826.42	15844.37	15774.02	15820.63	18890.0
2021-05-27 09:00:00	NQ	Futures	15819.76	15862.89	15799.49	15812.81	64648.0
2021-05-27 10:00:00	NQ	Futures	15812.81	15888.37	15802.1	15844.95	68385.0
2021-05-27 11:00:00	NQ	Futures	15844.95	15877.08	15838.87	15873.89	40992.0
2021-05-27 12:00:00	NQ	Futures	15873.61	15879.97	15853.92	15867.82	21857.0
2021-05-27 13:00:00	NQ	Futures	15867.53	15876.79	15840.02	15849.0	25301.0
2021-05-27 14:00:00	NQ	Futures	15849.29	15850.74	15806.73	15823.52	30994.0
2021-05-27 15:00:00	NQ	Futures	15823.81	15839.73	15802.68	15809.05	44239.0
2021-05-27 16:00:00	NQ	Futures	15809.05	15857.39	15806.44	15855.95	11674.0
2021-05-27 18:00:00	NQ	Futures	15858.26	15861.74	15847.26	15854.5	1833.0
2021-05-27 19:00:00	NQ	Futures	15854.79	15874.18	15844.37	15867.82	3263.0
2021-05-27 20:00:00	NQ	Futures	15868.1	15882.87	15863.18	15869.55	4106.0
2021-05-27 21:00:00	NQ	Futures	15869.84	15873.03	15848.42	15853.05	3801.0
2021-05-27 22:00:00	NQ	Futures	15853.63	15861.16	15846.1	15856.24	2274.0
2021-05-27 23:00:00	NQ	Futures	15856.24	15867.24	15856.24	15864.92	1760.0
2021-05-27 00:00:00	YM	Futures	38158.3	38163.9	38132.7	38152.7	792.0
2021-05-27 01:00:00	YM	Futures	38153.8	38175.0	38122.7	38167.2	1562.0
2021-05-27 02:00:00	YM	Futures	38168.3	38173.9	38059.2	38091.5	2776.0
2021-05-27 03:00:00	YM	Futures	38090.4	38148.3	38079.2	38137.1	3558.0

> showing 50 of 1,972 rows — these rows as CSV

> unlock the full archive -- $79 one-time