PREVIEW / futures_1hour / 2020-07-24

all futures 1-hour files

  file:    by_date/futures_1hour/2020/2020-07-24.parquet
  size:    50 KB
  rows:    1,481

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
2020-07-24 00:00:00	ES	Futures	3593.03	3599.45	3587.72	3594.7	12010.0
2020-07-24 01:00:00	ES	Futures	3594.42	3595.26	3584.93	3589.12	14578.0
2020-07-24 02:00:00	ES	Futures	3589.12	3595.82	3581.3	3581.86	22517.0
2020-07-24 03:00:00	ES	Futures	3581.86	3585.49	3573.48	3580.18	50400.0
2020-07-24 04:00:00	ES	Futures	3580.18	3592.19	3578.51	3592.19	27561.0
2020-07-24 05:00:00	ES	Futures	3591.91	3597.49	3588.56	3596.1	21638.0
2020-07-24 06:00:00	ES	Futures	3596.1	3601.96	3591.91	3594.98	25259.0
2020-07-24 07:00:00	ES	Futures	3595.26	3601.68	3584.09	3590.79	31581.0
2020-07-24 08:00:00	ES	Futures	3590.51	3595.82	3588.84	3591.63	24944.0
2020-07-24 09:00:00	ES	Futures	3591.63	3593.86	3567.89	3580.46	252581.0
2020-07-24 10:00:00	ES	Futures	3580.46	3594.42	3575.43	3593.58	210317.0
2020-07-24 11:00:00	ES	Futures	3593.58	3595.82	3582.69	3588.28	178498.0
2020-07-24 12:00:00	ES	Futures	3588.28	3589.4	3573.76	3576.27	212281.0
2020-07-24 13:00:00	ES	Futures	3576.55	3581.3	3564.82	3579.62	146364.0
2020-07-24 14:00:00	ES	Futures	3579.62	3589.4	3578.23	3582.69	156309.0
2020-07-24 15:00:00	ES	Futures	3582.42	3589.95	3569.85	3583.25	229098.0
2020-07-24 16:00:00	ES	Futures	3583.25	3585.77	3577.11	3578.23	48378.0
2020-07-24 00:00:00	NQ	Futures	12111.95	12159.67	12091.42	12138.85	7948.0
2020-07-24 01:00:00	NQ	Futures	12138.56	12143.19	12103.86	12121.21	7852.0
2020-07-24 02:00:00	NQ	Futures	12120.63	12132.77	12059.32	12060.77	10527.0
2020-07-24 03:00:00	NQ	Futures	12060.48	12082.75	12003.51	12048.91	19773.0
2020-07-24 04:00:00	NQ	Futures	12047.76	12076.96	12041.68	12072.05	9744.0
2020-07-24 05:00:00	NQ	Futures	12072.05	12107.33	12058.17	12105.3	7953.0
2020-07-24 06:00:00	NQ	Futures	12106.46	12126.99	12080.14	12108.77	10731.0
2020-07-24 07:00:00	NQ	Futures	12109.35	12143.19	12041.97	12083.61	16170.0
2020-07-24 08:00:00	NQ	Futures	12083.04	12107.04	12067.13	12082.75	16683.0
2020-07-24 09:00:00	NQ	Futures	12082.17	12092.87	11915.31	12008.72	103126.0
2020-07-24 10:00:00	NQ	Futures	12009.01	12149.84	12000.04	12146.94	96525.0
2020-07-24 11:00:00	NQ	Futures	12147.23	12181.36	12112.53	12155.91	70036.0
2020-07-24 12:00:00	NQ	Futures	12155.62	12158.22	12053.25	12065.4	61462.0
2020-07-24 13:00:00	NQ	Futures	12065.11	12128.73	12008.14	12114.27	54641.0
2020-07-24 14:00:00	NQ	Futures	12114.56	12159.09	12093.16	12119.18	45937.0
2020-07-24 15:00:00	NQ	Futures	12119.47	12150.99	12062.22	12110.51	64398.0
2020-07-24 16:00:00	NQ	Futures	12110.51	12122.08	12092.29	12100.1	9244.0
2020-07-24 00:00:00	YM	Futures	29109.7	29143.9	29063.5	29114.1	3153.0
2020-07-24 01:00:00	YM	Futures	29114.1	29120.7	29040.4	29076.7	2957.0
2020-07-24 02:00:00	YM	Futures	29073.4	29149.4	29022.7	29030.5	4109.0
2020-07-24 03:00:00	YM	Futures	29030.5	29056.9	28949.0	29008.4	9048.0
2020-07-24 04:00:00	YM	Futures	29006.2	29113.0	28996.3	29113.0	4825.0
2020-07-24 05:00:00	YM	Futures	29114.1	29192.3	29089.9	29167.0	4207.0
2020-07-24 06:00:00	YM	Futures	29169.2	29218.7	29142.8	29164.8	4971.0
2020-07-24 07:00:00	YM	Futures	29163.7	29202.2	29083.3	29123.0	6330.0
2020-07-24 08:00:00	YM	Futures	29123.0	29164.8	29113.0	29128.5	4431.0
2020-07-24 09:00:00	YM	Futures	29127.4	29137.3	29021.6	29107.5	26743.0
2020-07-24 10:00:00	YM	Futures	29108.6	29182.4	29069.0	29176.9	20937.0
2020-07-24 11:00:00	YM	Futures	29176.9	29202.2	29053.6	29092.1	15077.0
2020-07-24 12:00:00	YM	Futures	29088.8	29104.2	29030.5	29055.8	13730.0
2020-07-24 13:00:00	YM	Futures	29055.8	29082.2	28975.4	29032.7	12885.0
2020-07-24 14:00:00	YM	Futures	29033.8	29095.4	29015.0	29037.1	10767.0
2020-07-24 15:00:00	YM	Futures	29032.7	29103.1	28951.2	29032.7	18792.0

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

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