PREVIEW / futures_1hour / 2021-06-09

all futures 1-hour files

  file:    by_date/futures_1hour/2021/2021-06-09.parquet
  size:    60 KB
  rows:    1,892

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-09 00:00:00	ES	Futures	4749.51	4750.35	4748.1	4748.94	2535.0
2021-06-09 01:00:00	ES	Futures	4748.94	4751.19	4747.82	4748.66	3470.0
2021-06-09 02:00:00	ES	Futures	4748.66	4750.07	4746.13	4749.79	5765.0
2021-06-09 03:00:00	ES	Futures	4749.79	4754.0	4747.54	4749.22	15554.0
2021-06-09 04:00:00	ES	Futures	4749.22	4754.84	4748.94	4753.44	13167.0
2021-06-09 05:00:00	ES	Futures	4753.16	4753.44	4748.38	4751.19	11622.0
2021-06-09 06:00:00	ES	Futures	4751.47	4754.0	4749.79	4753.72	7595.0
2021-06-09 07:00:00	ES	Futures	4753.44	4757.09	4747.26	4756.25	24482.0
2021-06-09 08:00:00	ES	Futures	4756.53	4758.78	4753.16	4756.25	24940.0
2021-06-09 09:00:00	ES	Futures	4756.53	4759.62	4750.63	4755.12	172294.0
2021-06-09 10:00:00	ES	Futures	4755.41	4757.93	4749.51	4755.41	141442.0
2021-06-09 11:00:00	ES	Futures	4755.41	4758.5	4748.1	4751.19	77857.0
2021-06-09 12:00:00	ES	Futures	4751.19	4754.84	4750.07	4754.28	54778.0
2021-06-09 13:00:00	ES	Futures	4754.28	4756.81	4751.47	4753.16	72114.0
2021-06-09 14:00:00	ES	Futures	4753.16	4755.97	4749.79	4750.63	69078.0
2021-06-09 15:00:00	ES	Futures	4750.63	4750.63	4739.39	4741.92	175466.0
2021-06-09 16:00:00	ES	Futures	4741.92	4745.57	4741.64	4745.29	37911.0
2021-06-09 18:00:00	ES	Futures	4745.29	4746.98	4744.73	4745.85	4182.0
2021-06-09 19:00:00	ES	Futures	4745.85	4747.54	4743.61	4744.73	5248.0
2021-06-09 20:00:00	ES	Futures	4744.45	4747.54	4743.32	4746.13	6181.0
2021-06-09 21:00:00	ES	Futures	4746.13	4748.94	4745.57	4747.26	7189.0
2021-06-09 22:00:00	ES	Futures	4747.26	4748.1	4746.41	4746.7	3662.0
2021-06-09 23:00:00	ES	Futures	4746.7	4748.38	4746.13	4748.1	2127.0
2021-06-09 00:00:00	NQ	Futures	16004.46	16007.93	15996.35	15999.54	1338.0
2021-06-09 01:00:00	NQ	Futures	15999.25	16009.09	15991.43	15998.67	1945.0
2021-06-09 02:00:00	NQ	Futures	15998.38	16013.14	15990.27	16010.25	3465.0
2021-06-09 03:00:00	NQ	Futures	16009.67	16032.54	15995.48	16003.88	7939.0
2021-06-09 04:00:00	NQ	Futures	16004.17	16029.06	16002.43	16019.51	7701.0
2021-06-09 05:00:00	NQ	Futures	16019.51	16021.54	15998.96	16011.69	5439.0
2021-06-09 06:00:00	NQ	Futures	16011.98	16042.67	16011.12	16039.78	5732.0
2021-06-09 07:00:00	NQ	Futures	16040.07	16054.25	16014.01	16046.43	9922.0
2021-06-09 08:00:00	NQ	Futures	16047.01	16063.22	16028.77	16051.64	10860.0
2021-06-09 09:00:00	NQ	Futures	16051.36	16100.86	16030.22	16063.8	77603.0
2021-06-09 10:00:00	NQ	Futures	16064.09	16072.78	16009.38	16034.85	59247.0
2021-06-09 11:00:00	NQ	Futures	16034.85	16056.57	16000.11	16014.88	33316.0
2021-06-09 12:00:00	NQ	Futures	16014.88	16060.04	16009.38	16058.59	26129.0
2021-06-09 13:00:00	NQ	Futures	16058.59	16068.44	16044.12	16050.2	24834.0
2021-06-09 14:00:00	NQ	Futures	16050.49	16061.78	16025.59	16027.04	26261.0
2021-06-09 15:00:00	NQ	Futures	16026.75	16031.67	15989.98	15998.38	45521.0
2021-06-09 16:00:00	NQ	Futures	15998.38	16004.17	15991.43	15993.46	7951.0
2021-06-09 18:00:00	NQ	Futures	15999.83	16007.93	15996.64	16000.98	1825.0
2021-06-09 19:00:00	NQ	Futures	16000.98	16009.67	15993.17	15997.8	2348.0
2021-06-09 20:00:00	NQ	Futures	15997.51	16013.14	15996.06	16008.8	2565.0
2021-06-09 21:00:00	NQ	Futures	16009.09	16023.27	16004.46	16014.3	3464.0
2021-06-09 22:00:00	NQ	Futures	16015.75	16025.88	16011.69	16014.59	2158.0
2021-06-09 23:00:00	NQ	Futures	16014.59	16020.38	16009.38	16018.93	1484.0
2021-06-09 00:00:00	YM	Futures	38521.4	38523.6	38508.0	38513.6	431.0
2021-06-09 01:00:00	YM	Futures	38513.6	38537.0	38508.0	38519.2	793.0
2021-06-09 02:00:00	YM	Futures	38517.0	38520.3	38498.0	38519.2	1011.0
2021-06-09 03:00:00	YM	Futures	38518.1	38545.9	38500.2	38506.9	2168.0

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

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