PREVIEW / futures_1hour / 2021-06-08

all futures 1-hour files

  file:    by_date/futures_1hour/2021/2021-06-08.parquet
  size:    59 KB
  rows:    1,914

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-06-08 00:00:00	ES	Futures	4750.91	4752.6	4750.35	4752.32	2937.0
2021-06-08 01:00:00	ES	Futures	4752.32	4752.6	4749.22	4749.51	5022.0
2021-06-08 02:00:00	ES	Futures	4749.79	4753.44	4748.66	4750.07	7227.0
2021-06-08 03:00:00	ES	Futures	4750.07	4751.75	4745.29	4746.98	14730.0
2021-06-08 04:00:00	ES	Futures	4746.98	4750.91	4745.29	4750.91	8210.0
2021-06-08 05:00:00	ES	Futures	4750.63	4755.69	4748.1	4753.72	11010.0
2021-06-08 06:00:00	ES	Futures	4753.44	4753.72	4734.05	4751.19	53261.0
2021-06-08 07:00:00	ES	Futures	4751.47	4757.37	4749.79	4757.09	20320.0
2021-06-08 08:00:00	ES	Futures	4757.09	4761.59	4755.97	4757.65	26774.0
2021-06-08 09:00:00	ES	Futures	4757.93	4760.74	4741.92	4742.76	174692.0
2021-06-08 10:00:00	ES	Futures	4743.04	4748.94	4740.51	4744.73	151031.0
2021-06-08 11:00:00	ES	Futures	4744.45	4748.1	4726.75	4745.85	239159.0
2021-06-08 12:00:00	ES	Futures	4745.85	4752.88	4744.73	4752.32	107897.0
2021-06-08 13:00:00	ES	Futures	4752.03	4753.16	4747.54	4748.38	70753.0
2021-06-08 14:00:00	ES	Futures	4748.38	4754.84	4747.54	4754.28	82639.0
2021-06-08 15:00:00	ES	Futures	4754.28	4756.25	4748.38	4748.94	157499.0
2021-06-08 16:00:00	ES	Futures	4748.66	4750.35	4746.13	4748.66	33210.0
2021-06-08 18:00:00	ES	Futures	4748.94	4750.63	4744.45	4750.35	4090.0
2021-06-08 19:00:00	ES	Futures	4750.35	4751.75	4748.66	4749.51	3254.0
2021-06-08 20:00:00	ES	Futures	4749.22	4753.44	4747.26	4751.75	7552.0
2021-06-08 21:00:00	ES	Futures	4751.75	4752.03	4745.29	4750.63	8581.0
2021-06-08 22:00:00	ES	Futures	4750.63	4751.75	4747.82	4751.75	3298.0
2021-06-08 23:00:00	ES	Futures	4751.75	4752.6	4748.94	4749.79	3294.0
2021-06-08 00:00:00	NQ	Futures	16019.8	16024.72	16014.01	16023.85	1935.0
2021-06-08 01:00:00	NQ	Futures	16024.14	16026.17	16002.14	16003.3	4377.0
2021-06-08 02:00:00	NQ	Futures	16004.17	16022.7	16002.72	16009.67	3955.0
2021-06-08 03:00:00	NQ	Futures	16009.38	16013.72	15969.43	15982.17	10902.0
2021-06-08 04:00:00	NQ	Futures	15981.59	16018.93	15978.4	16018.35	6600.0
2021-06-08 05:00:00	NQ	Futures	16018.06	16037.75	16006.48	16033.41	7231.0
2021-06-08 06:00:00	NQ	Futures	16033.41	16035.43	15963.35	16030.51	24923.0
2021-06-08 07:00:00	NQ	Futures	16030.8	16070.46	16022.12	16066.99	11261.0
2021-06-08 08:00:00	NQ	Futures	16067.28	16092.17	16061.49	16068.44	17259.0
2021-06-08 09:00:00	NQ	Futures	16069.3	16115.91	16016.62	16025.88	79226.0
2021-06-08 10:00:00	NQ	Futures	16025.88	16043.83	15977.24	15989.69	74443.0
2021-06-08 11:00:00	NQ	Futures	15989.69	16009.09	15912.69	15960.74	79367.0
2021-06-08 12:00:00	NQ	Futures	15960.74	16008.51	15954.09	16006.19	34202.0
2021-06-08 13:00:00	NQ	Futures	16005.9	16006.48	15973.19	15980.72	25685.0
2021-06-08 14:00:00	NQ	Futures	15980.43	16018.35	15973.48	16014.3	23693.0
2021-06-08 15:00:00	NQ	Futures	16014.59	16024.14	15987.67	15990.56	40049.0
2021-06-08 16:00:00	NQ	Futures	15990.56	16001.56	15987.38	15994.9	5561.0
2021-06-08 18:00:00	NQ	Futures	15995.19	16006.19	15984.19	16004.75	1954.0
2021-06-08 19:00:00	NQ	Futures	16004.75	16007.93	15994.9	16000.4	1521.0
2021-06-08 20:00:00	NQ	Futures	16000.4	16019.22	15989.69	16016.04	4341.0
2021-06-08 21:00:00	NQ	Futures	16016.04	16017.48	15987.09	16003.3	3855.0
2021-06-08 22:00:00	NQ	Futures	16004.17	16010.54	15991.43	16010.25	1815.0
2021-06-08 23:00:00	NQ	Futures	16011.12	16016.62	16002.14	16003.88	1787.0
2021-06-08 00:00:00	YM	Futures	38515.8	38534.8	38511.4	38527.0	456.0
2021-06-08 01:00:00	YM	Futures	38523.6	38525.9	38502.5	38510.3	768.0
2021-06-08 02:00:00	YM	Futures	38510.3	38537.0	38502.5	38517.0	1284.0
2021-06-08 03:00:00	YM	Futures	38515.8	38529.2	38493.6	38513.6	2810.0

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

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