PREVIEW / futures_1hour / 2021-06-22

all futures 1-hour files

  file:    by_date/futures_1hour/2021/2021-06-22.parquet
  size:    64 KB
  rows:    1,956

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-22 00:00:00	ES	Futures	4753.11	4760.15	4752.83	4756.49	5747.0
2021-06-22 01:00:00	ES	Futures	4756.49	4756.49	4751.98	4753.95	6179.0
2021-06-22 02:00:00	ES	Futures	4753.95	4757.05	4750.29	4751.7	10773.0
2021-06-22 03:00:00	ES	Futures	4751.7	4751.98	4737.9	4739.87	24683.0
2021-06-22 04:00:00	ES	Futures	4739.59	4744.1	4737.06	4739.03	17433.0
2021-06-22 05:00:00	ES	Futures	4739.03	4744.66	4737.9	4740.44	12516.0
2021-06-22 06:00:00	ES	Futures	4740.44	4748.04	4739.87	4746.35	11483.0
2021-06-22 07:00:00	ES	Futures	4746.35	4754.52	4745.22	4753.11	16688.0
2021-06-22 08:00:00	ES	Futures	4753.11	4755.36	4743.25	4745.22	27567.0
2021-06-22 09:00:00	ES	Futures	4745.22	4750.57	4737.62	4741.28	141341.0
2021-06-22 10:00:00	ES	Futures	4741.28	4757.61	4737.06	4757.61	145123.0
2021-06-22 11:00:00	ES	Futures	4757.61	4766.34	4756.21	4759.3	109782.0
2021-06-22 12:00:00	ES	Futures	4759.58	4764.37	4759.58	4762.4	55751.0
2021-06-22 13:00:00	ES	Futures	4762.12	4765.22	4760.43	4763.53	49874.0
2021-06-22 14:00:00	ES	Futures	4763.81	4770.85	4761.56	4769.72	81818.0
2021-06-22 15:00:00	ES	Futures	4769.72	4781.83	4769.44	4771.13	221449.0
2021-06-22 16:00:00	ES	Futures	4771.13	4775.63	4768.59	4771.97	57725.0
2021-06-22 18:00:00	ES	Futures	4772.82	4773.94	4770.57	4771.97	4018.0
2021-06-22 19:00:00	ES	Futures	4771.69	4774.51	4771.69	4773.1	3364.0
2021-06-22 20:00:00	ES	Futures	4773.1	4776.48	4771.13	4775.07	6955.0
2021-06-22 21:00:00	ES	Futures	4775.07	4778.45	4775.07	4776.76	6536.0
2021-06-22 22:00:00	ES	Futures	4776.76	4779.58	4776.48	4778.45	5064.0
2021-06-22 23:00:00	ES	Futures	4778.45	4780.7	4778.45	4778.73	3106.0
2021-06-22 00:00:00	NQ	Futures	16381.48	16399.44	16380.03	16391.61	1835.0
2021-06-22 01:00:00	NQ	Futures	16391.9	16392.19	16373.07	16377.42	2460.0
2021-06-22 02:00:00	NQ	Futures	16377.42	16390.74	16362.65	16364.96	4449.0
2021-06-22 03:00:00	NQ	Futures	16364.67	16367.28	16299.21	16309.63	9310.0
2021-06-22 04:00:00	NQ	Futures	16310.21	16327.59	16306.45	16322.09	6190.0
2021-06-22 05:00:00	NQ	Futures	16322.38	16356.56	16320.93	16346.71	6595.0
2021-06-22 06:00:00	NQ	Futures	16346.42	16388.72	16343.82	16382.92	7097.0
2021-06-22 07:00:00	NQ	Futures	16382.63	16429.56	16380.9	16420.58	10071.0
2021-06-22 08:00:00	NQ	Futures	16421.16	16427.53	16357.72	16370.47	13584.0
2021-06-22 09:00:00	NQ	Futures	16370.47	16426.96	16346.71	16387.27	78193.0
2021-06-22 10:00:00	NQ	Futures	16387.85	16436.22	16362.36	16419.13	66856.0
2021-06-22 11:00:00	NQ	Futures	16419.13	16471.28	16415.37	16452.74	44824.0
2021-06-22 12:00:00	NQ	Futures	16452.74	16492.13	16452.74	16478.52	27982.0
2021-06-22 13:00:00	NQ	Futures	16478.52	16485.47	16458.53	16478.52	22545.0
2021-06-22 14:00:00	NQ	Futures	16478.23	16499.95	16464.61	16497.64	27508.0
2021-06-22 15:00:00	NQ	Futures	16497.35	16545.72	16494.74	16520.81	61978.0
2021-06-22 16:00:00	NQ	Futures	16520.81	16544.86	16517.05	16533.27	10110.0
2021-06-22 18:00:00	NQ	Futures	16539.64	16539.64	16528.34	16533.56	1967.0
2021-06-22 19:00:00	NQ	Futures	16533.56	16544.86	16533.56	16537.61	1823.0
2021-06-22 20:00:00	NQ	Futures	16537.9	16553.55	16532.11	16548.91	3883.0
2021-06-22 21:00:00	NQ	Futures	16548.62	16556.44	16543.41	16551.23	2851.0
2021-06-22 22:00:00	NQ	Futures	16550.36	16565.42	16549.78	16559.63	2977.0
2021-06-22 23:00:00	NQ	Futures	16559.92	16571.22	16559.34	16561.66	2317.0
2021-06-22 00:00:00	YM	Futures	37785.5	37833.5	37784.3	37814.5	1545.0
2021-06-22 01:00:00	YM	Futures	37815.6	37815.6	37775.4	37795.5	1309.0
2021-06-22 02:00:00	YM	Futures	37794.4	37826.8	37769.8	37798.9	2664.0
2021-06-22 03:00:00	YM	Futures	37800.0	37804.5	37671.5	37690.5	4681.0

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

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