PREVIEW / futures_1hour / 2021-02-09

all futures 1-hour files

  file:    by_date/futures_1hour/2021/2021-02-09.parquet
  size:    61 KB
  rows:    1,947

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-02-09 00:00:00	ES	Futures	4387.1	4389.9	4385.97	4388.5	4418.0
2021-02-09 01:00:00	ES	Futures	4388.5	4389.62	4385.69	4385.97	3869.0
2021-02-09 02:00:00	ES	Futures	4385.69	4388.5	4384.29	4388.22	6086.0
2021-02-09 03:00:00	ES	Futures	4388.22	4389.9	4384.29	4385.97	13527.0
2021-02-09 04:00:00	ES	Futures	4385.97	4386.53	4380.36	4383.45	15030.0
2021-02-09 05:00:00	ES	Futures	4383.73	4384.85	4380.36	4381.2	11541.0
2021-02-09 06:00:00	ES	Futures	4381.2	4383.17	4376.15	4382.61	13029.0
2021-02-09 07:00:00	ES	Futures	4382.89	4384.29	4379.24	4380.08	14651.0
2021-02-09 08:00:00	ES	Futures	4380.08	4381.48	4377.83	4381.2	18211.0
2021-02-09 09:00:00	ES	Futures	4380.92	4385.41	4372.78	4383.45	149469.0
2021-02-09 10:00:00	ES	Futures	4383.45	4387.38	4380.08	4382.61	127465.0
2021-02-09 11:00:00	ES	Futures	4382.32	4385.41	4375.31	4382.89	104931.0
2021-02-09 12:00:00	ES	Futures	4382.89	4391.31	4382.04	4389.9	61906.0
2021-02-09 13:00:00	ES	Futures	4389.9	4390.46	4384.01	4386.25	51884.0
2021-02-09 14:00:00	ES	Futures	4385.97	4392.15	4385.97	4390.74	50846.0
2021-02-09 15:00:00	ES	Futures	4391.03	4392.15	4380.92	4385.13	129514.0
2021-02-09 16:00:00	ES	Futures	4385.41	4391.31	4384.85	4390.46	42925.0
2021-02-09 18:00:00	ES	Futures	4392.15	4392.43	4388.22	4388.5	5634.0
2021-02-09 19:00:00	ES	Futures	4388.78	4390.18	4386.53	4389.62	4851.0
2021-02-09 20:00:00	ES	Futures	4389.62	4400.01	4389.06	4399.73	16328.0
2021-02-09 21:00:00	ES	Futures	4399.73	4400.85	4398.04	4399.45	9104.0
2021-02-09 22:00:00	ES	Futures	4399.45	4402.53	4399.16	4400.01	5988.0
2021-02-09 23:00:00	ES	Futures	4400.01	4401.13	4398.32	4400.01	4832.0
2021-02-09 00:00:00	NQ	Futures	15834.63	15847.65	15829.71	15837.24	2842.0
2021-02-09 01:00:00	NQ	Futures	15837.52	15841.29	15828.84	15830.0	1604.0
2021-02-09 02:00:00	NQ	Futures	15831.45	15831.45	15819.29	15828.55	2603.0
2021-02-09 03:00:00	NQ	Futures	15828.84	15833.76	15817.26	15829.42	3783.0
2021-02-09 04:00:00	NQ	Futures	15829.42	15830.58	15817.26	15826.24	4411.0
2021-02-09 05:00:00	NQ	Futures	15826.24	15832.31	15818.42	15820.45	2594.0
2021-02-09 06:00:00	NQ	Futures	15820.16	15827.11	15804.24	15825.95	4655.0
2021-02-09 07:00:00	NQ	Futures	15826.53	15835.79	15819.29	15823.63	5064.0
2021-02-09 08:00:00	NQ	Futures	15823.63	15825.37	15807.71	15814.08	6958.0
2021-02-09 09:00:00	NQ	Futures	15813.79	15870.52	15784.56	15865.6	63645.0
2021-02-09 10:00:00	NQ	Futures	15865.31	15901.78	15858.94	15872.26	62378.0
2021-02-09 11:00:00	NQ	Futures	15871.97	15873.12	15823.34	15850.55	53767.0
2021-02-09 12:00:00	NQ	Futures	15850.55	15867.63	15836.37	15853.73	32103.0
2021-02-09 13:00:00	NQ	Futures	15853.73	15856.92	15816.69	15828.26	25396.0
2021-02-09 14:00:00	NQ	Futures	15827.97	15869.94	15827.68	15866.47	22315.0
2021-02-09 15:00:00	NQ	Futures	15866.76	15873.41	15819.58	15838.39	42603.0
2021-02-09 16:00:00	NQ	Futures	15838.1	15860.39	15836.95	15858.07	9296.0
2021-02-09 18:00:00	NQ	Futures	15858.65	15865.31	15844.47	15846.79	2220.0
2021-02-09 19:00:00	NQ	Futures	15847.08	15848.23	15836.66	15844.76	2303.0
2021-02-09 20:00:00	NQ	Futures	15845.34	15891.07	15841.58	15887.31	8808.0
2021-02-09 21:00:00	NQ	Futures	15887.31	15900.33	15886.73	15899.17	6322.0
2021-02-09 22:00:00	NQ	Futures	15899.17	15920.59	15898.02	15904.67	4542.0
2021-02-09 23:00:00	NQ	Futures	15904.09	15909.59	15896.86	15905.54	1966.0
2021-02-09 00:00:00	YM	Futures	34671.2	34692.3	34662.3	34682.3	902.0
2021-02-09 01:00:00	YM	Futures	34682.3	34689.0	34662.3	34662.3	702.0
2021-02-09 02:00:00	YM	Futures	34662.3	34690.1	34651.3	34690.1	1397.0
2021-02-09 03:00:00	YM	Futures	34691.2	34701.2	34656.8	34670.1	2858.0

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

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