PREVIEW / futures_1hour / 2021-06-25

all futures 1-hour files

  file:    by_date/futures_1hour/2021/2021-06-25.parquet
  size:    51 KB
  rows:    1,535

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-25 00:00:00	ES	Futures	4802.38	4802.67	4798.16	4798.72	4089.0
2021-06-25 01:00:00	ES	Futures	4799.01	4801.54	4798.16	4800.41	4614.0
2021-06-25 02:00:00	ES	Futures	4800.7	4800.98	4794.78	4796.19	6898.0
2021-06-25 03:00:00	ES	Futures	4796.19	4797.03	4790.84	4795.91	12161.0
2021-06-25 04:00:00	ES	Futures	4795.91	4798.16	4793.66	4796.75	9198.0
2021-06-25 05:00:00	ES	Futures	4796.75	4800.98	4794.5	4799.29	9133.0
2021-06-25 06:00:00	ES	Futures	4799.29	4800.13	4796.47	4799.57	6126.0
2021-06-25 07:00:00	ES	Futures	4799.85	4800.7	4795.06	4796.47	10951.0
2021-06-25 08:00:00	ES	Futures	4796.47	4804.36	4795.91	4802.38	28356.0
2021-06-25 09:00:00	ES	Futures	4802.38	4805.2	4799.01	4802.38	111446.0
2021-06-25 10:00:00	ES	Futures	4802.1	4809.42	4799.57	4802.95	123441.0
2021-06-25 11:00:00	ES	Futures	4802.95	4808.02	4802.38	4807.45	69983.0
2021-06-25 12:00:00	ES	Futures	4807.45	4808.3	4804.92	4807.45	45071.0
2021-06-25 13:00:00	ES	Futures	4807.45	4807.73	4803.51	4806.89	47486.0
2021-06-25 14:00:00	ES	Futures	4806.89	4811.4	4805.48	4810.55	60753.0
2021-06-25 15:00:00	ES	Futures	4810.55	4817.03	4809.14	4810.27	219547.0
2021-06-25 16:00:00	ES	Futures	4810.27	4814.77	4809.14	4814.49	64214.0
2021-06-25 00:00:00	NQ	Futures	16655.22	16657.25	16635.82	16640.45	2291.0
2021-06-25 01:00:00	NQ	Futures	16641.32	16655.22	16634.37	16646.53	2569.0
2021-06-25 02:00:00	NQ	Futures	16646.53	16647.98	16631.47	16641.03	2895.0
2021-06-25 03:00:00	NQ	Futures	16640.45	16643.64	16621.33	16638.71	4458.0
2021-06-25 04:00:00	NQ	Futures	16639.29	16655.51	16634.95	16652.33	4740.0
2021-06-25 05:00:00	NQ	Futures	16652.33	16676.37	16644.22	16667.1	5247.0
2021-06-25 06:00:00	NQ	Futures	16666.52	16667.68	16652.91	16664.49	3343.0
2021-06-25 07:00:00	NQ	Futures	16664.49	16666.52	16635.82	16641.9	5469.0
2021-06-25 08:00:00	NQ	Futures	16641.03	16678.98	16628.86	16657.54	14865.0
2021-06-25 09:00:00	NQ	Futures	16657.54	16674.63	16603.66	16617.57	64621.0
2021-06-25 10:00:00	NQ	Futures	16617.57	16654.07	16585.12	16619.88	71493.0
2021-06-25 11:00:00	NQ	Futures	16620.17	16645.66	16608.3	16634.37	36392.0
2021-06-25 12:00:00	NQ	Futures	16634.08	16635.24	16594.39	16613.8	28058.0
2021-06-25 13:00:00	NQ	Futures	16613.8	16619.59	16590.34	16604.24	24322.0
2021-06-25 14:00:00	NQ	Futures	16604.53	16632.92	16594.97	16630.02	27882.0
2021-06-25 15:00:00	NQ	Futures	16630.02	16637.55	16591.2	16614.67	50096.0
2021-06-25 16:00:00	NQ	Futures	16614.96	16621.91	16595.55	16605.69	10505.0
2021-06-25 00:00:00	YM	Futures	38245.8	38246.9	38206.7	38217.8	974.0
2021-06-25 01:00:00	YM	Futures	38219.0	38238.0	38207.8	38231.2	913.0
2021-06-25 02:00:00	YM	Futures	38232.4	38234.6	38169.8	38183.2	1714.0
2021-06-25 03:00:00	YM	Futures	38183.2	38189.9	38135.2	38174.3	2487.0
2021-06-25 04:00:00	YM	Futures	38174.3	38179.9	38141.9	38167.6	1948.0
2021-06-25 05:00:00	YM	Futures	38167.6	38207.8	38149.7	38193.3	1875.0
2021-06-25 06:00:00	YM	Futures	38192.1	38204.4	38172.0	38196.6	1216.0
2021-06-25 07:00:00	YM	Futures	38197.7	38213.4	38174.3	38179.9	1884.0
2021-06-25 08:00:00	YM	Futures	38179.9	38258.1	38176.5	38255.8	4539.0
2021-06-25 09:00:00	YM	Futures	38254.7	38297.2	38205.5	38277.1	20237.0
2021-06-25 10:00:00	YM	Futures	38277.1	38348.6	38256.9	38289.3	16033.0
2021-06-25 11:00:00	YM	Futures	38290.5	38356.4	38286.0	38330.7	9684.0
2021-06-25 12:00:00	YM	Futures	38330.7	38364.2	38324.0	38348.6	5362.0
2021-06-25 13:00:00	YM	Futures	38348.6	38356.4	38315.0	38348.6	4667.0
2021-06-25 14:00:00	YM	Futures	38347.4	38353.0	38326.2	38348.6	4575.0
2021-06-25 15:00:00	YM	Futures	38348.6	38417.8	38340.7	38356.4	17306.0

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

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