PREVIEW / futures_1hour / 2022-01-17

all futures 1-hour files

  file:    by_date/futures_1hour/2022/2022-01-17.parquet
  size:    52 KB
  rows:    1,619

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
2022-01-17 00:00:00	ES	Futures	5253.61	5256.16	5250.79	5251.92	2943.0
2022-01-17 01:00:00	ES	Futures	5252.2	5261.53	5250.22	5259.55	3991.0
2022-01-17 02:00:00	ES	Futures	5259.55	5266.34	5255.03	5263.8	6901.0
2022-01-17 03:00:00	ES	Futures	5263.8	5269.73	5255.88	5267.75	12036.0
2022-01-17 04:00:00	ES	Futures	5267.75	5276.52	5264.36	5272.56	9702.0
2022-01-17 05:00:00	ES	Futures	5272.85	5278.5	5271.15	5271.15	6249.0
2022-01-17 06:00:00	ES	Futures	5271.15	5277.65	5270.3	5276.8	5334.0
2022-01-17 07:00:00	ES	Futures	5276.52	5278.5	5273.69	5275.67	4904.0
2022-01-17 08:00:00	ES	Futures	5275.39	5276.52	5268.04	5269.17	9583.0
2022-01-17 09:00:00	ES	Futures	5269.17	5272.0	5260.68	5266.91	18167.0
2022-01-17 10:00:00	ES	Futures	5267.19	5272.0	5264.36	5268.32	12670.0
2022-01-17 11:00:00	ES	Futures	5268.6	5271.71	5266.34	5266.62	5858.0
2022-01-17 12:00:00	ES	Futures	5266.62	5267.47	5262.38	5265.21	5562.0
2022-01-17 18:00:00	ES	Futures	5266.91	5270.3	5257.86	5268.04	9133.0
2022-01-17 19:00:00	ES	Futures	5268.04	5272.56	5264.64	5272.56	6482.0
2022-01-17 20:00:00	ES	Futures	5272.56	5273.41	5265.21	5270.58	6703.0
2022-01-17 21:00:00	ES	Futures	5270.58	5271.15	5264.36	5270.02	5257.0
2022-01-17 22:00:00	ES	Futures	5270.3	5271.15	5244.85	5247.68	21326.0
2022-01-17 23:00:00	ES	Futures	5247.68	5250.5	5232.12	5242.02	22301.0
2022-01-17 00:00:00	NQ	Futures	18003.73	18011.56	17986.63	17996.49	2512.0
2022-01-17 01:00:00	NQ	Futures	17997.36	18043.15	17988.95	18030.1	3679.0
2022-01-17 02:00:00	NQ	Futures	18029.53	18056.48	18012.72	18047.2	3856.0
2022-01-17 03:00:00	NQ	Futures	18045.75	18071.84	18005.76	18062.56	7727.0
2022-01-17 04:00:00	NQ	Futures	18062.27	18117.05	18055.61	18097.34	6220.0
2022-01-17 05:00:00	NQ	Futures	18098.21	18126.61	18086.91	18088.94	4568.0
2022-01-17 06:00:00	NQ	Futures	18088.94	18112.99	18085.75	18109.51	4149.0
2022-01-17 07:00:00	NQ	Futures	18108.07	18119.08	18098.5	18102.85	3025.0
2022-01-17 08:00:00	NQ	Futures	18102.56	18109.22	18086.91	18094.15	4738.0
2022-01-17 09:00:00	NQ	Futures	18094.44	18101.11	18022.57	18057.64	16348.0
2022-01-17 10:00:00	NQ	Futures	18057.93	18080.53	18034.74	18054.74	12194.0
2022-01-17 11:00:00	NQ	Futures	18055.32	18077.92	18050.1	18057.35	4563.0
2022-01-17 12:00:00	NQ	Futures	18057.35	18059.09	18019.09	18037.35	4659.0
2022-01-17 18:00:00	NQ	Futures	18040.54	18073.0	18024.89	18070.1	5229.0
2022-01-17 19:00:00	NQ	Futures	18070.39	18088.36	18056.77	18085.46	4568.0
2022-01-17 20:00:00	NQ	Futures	18085.17	18087.49	18050.68	18073.29	4773.0
2022-01-17 21:00:00	NQ	Futures	18073.29	18074.45	18039.38	18065.46	3940.0
2022-01-17 22:00:00	NQ	Futures	18066.04	18067.49	17911.57	17930.12	14917.0
2022-01-17 23:00:00	NQ	Futures	17929.54	17940.55	17860.27	17912.15	14390.0
2022-01-17 00:00:00	YM	Futures	40164.6	40182.6	40146.6	40153.4	604.0
2022-01-17 01:00:00	YM	Futures	40155.6	40214.1	40139.9	40199.5	944.0
2022-01-17 02:00:00	YM	Futures	40199.5	40257.9	40168.0	40238.8	1930.0
2022-01-17 03:00:00	YM	Futures	40238.8	40279.2	40189.3	40264.6	3571.0
2022-01-17 04:00:00	YM	Futures	40264.6	40305.1	40232.0	40279.2	2531.0
2022-01-17 05:00:00	YM	Futures	40281.5	40327.6	40280.4	40284.9	2597.0
2022-01-17 06:00:00	YM	Futures	40283.7	40304.0	40257.9	40295.0	1652.0
2022-01-17 07:00:00	YM	Futures	40293.9	40301.7	40270.3	40286.0	1223.0
2022-01-17 08:00:00	YM	Futures	40284.9	40297.2	40229.8	40242.2	2497.0
2022-01-17 09:00:00	YM	Futures	40243.3	40275.9	40217.4	40270.3	4978.0
2022-01-17 10:00:00	YM	Futures	40275.9	40293.9	40257.9	40272.5	2996.0
2022-01-17 11:00:00	YM	Futures	40273.6	40281.5	40234.3	40234.3	1914.0

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

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