PREVIEW / futures_1hour / 2020-09-11

all futures 1-hour files

  file:    by_date/futures_1hour/2020/2020-09-11.parquet
  size:    48 KB
  rows:    1,438

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-09-11 00:00:00	ES	Futures	3751.92	3757.5	3751.64	3753.87	3984.0
2020-09-11 01:00:00	ES	Futures	3754.15	3761.41	3753.03	3759.18	4952.0
2020-09-11 02:00:00	ES	Futures	3759.46	3761.13	3751.92	3759.18	10914.0
2020-09-11 03:00:00	ES	Futures	3759.18	3769.23	3751.92	3754.15	22792.0
2020-09-11 04:00:00	ES	Futures	3753.87	3768.67	3753.59	3760.29	15037.0
2020-09-11 05:00:00	ES	Futures	3760.29	3769.79	3758.34	3769.23	12925.0
2020-09-11 06:00:00	ES	Futures	3769.23	3769.79	3757.5	3761.41	16093.0
2020-09-11 07:00:00	ES	Futures	3761.41	3765.88	3753.03	3758.9	22422.0
2020-09-11 08:00:00	ES	Futures	3758.9	3761.41	3743.54	3747.73	30934.0
2020-09-11 09:00:00	ES	Futures	3747.73	3758.06	3728.74	3731.53	126723.0
2020-09-11 10:00:00	ES	Futures	3731.53	3758.34	3725.95	3747.45	166474.0
2020-09-11 11:00:00	ES	Futures	3747.45	3762.53	3736.84	3737.95	98035.0
2020-09-11 12:00:00	ES	Futures	3738.23	3749.96	3718.97	3720.08	97725.0
2020-09-11 13:00:00	ES	Futures	3720.08	3724.27	3695.79	3701.09	160793.0
2020-09-11 14:00:00	ES	Futures	3701.37	3732.93	3696.9	3725.11	101065.0
2020-09-11 15:00:00	ES	Futures	3725.11	3744.66	3710.87	3730.41	145355.0
2020-09-11 16:00:00	ES	Futures	3730.41	3733.49	3720.36	3727.62	31614.0
2020-09-11 00:00:00	NQ	Futures	13010.72	13021.42	13001.76	13003.78	1884.0
2020-09-11 01:00:00	NQ	Futures	13003.78	13064.51	12997.42	13055.83	3172.0
2020-09-11 02:00:00	NQ	Futures	13054.39	13079.83	13032.12	13071.45	5013.0
2020-09-11 03:00:00	NQ	Futures	13072.32	13116.56	13053.23	13064.51	8490.0
2020-09-11 04:00:00	NQ	Futures	13065.38	13135.94	13061.91	13084.17	7665.0
2020-09-11 05:00:00	NQ	Futures	13085.33	13114.82	13079.83	13098.92	3533.0
2020-09-11 06:00:00	NQ	Futures	13098.63	13100.66	13014.77	13029.81	8203.0
2020-09-11 07:00:00	NQ	Futures	13028.65	13064.8	12999.73	13049.47	8393.0
2020-09-11 08:00:00	NQ	Futures	13047.74	13059.88	12958.09	12967.63	12408.0
2020-09-11 09:00:00	NQ	Futures	12967.63	13047.74	12869.6	12885.8	56640.0
2020-09-11 10:00:00	NQ	Futures	12884.93	13022.87	12837.5	12960.11	64399.0
2020-09-11 11:00:00	NQ	Futures	12959.83	13026.91	12856.88	12859.77	41611.0
2020-09-11 12:00:00	NQ	Futures	12858.9	12908.35	12742.65	12745.25	40576.0
2020-09-11 13:00:00	NQ	Futures	12746.12	12770.7	12651.56	12687.42	50110.0
2020-09-11 14:00:00	NQ	Futures	12688.29	12829.41	12677.59	12775.91	34014.0
2020-09-11 15:00:00	NQ	Futures	12775.62	12870.76	12715.76	12822.75	36853.0
2020-09-11 16:00:00	NQ	Futures	12820.73	12837.79	12782.85	12805.98	7150.0
2020-09-11 00:00:00	YM	Futures	30477.5	30527.3	30477.5	30505.1	481.0
2020-09-11 01:00:00	YM	Futures	30502.9	30552.7	30497.4	30532.8	577.0
2020-09-11 02:00:00	YM	Futures	30532.8	30532.8	30433.3	30488.6	1139.0
2020-09-11 03:00:00	YM	Futures	30488.6	30583.6	30433.3	30457.6	2111.0
2020-09-11 04:00:00	YM	Futures	30452.1	30552.7	30447.7	30493.0	1763.0
2020-09-11 05:00:00	YM	Futures	30496.3	30566.0	30474.2	30566.0	1210.0
2020-09-11 06:00:00	YM	Futures	30564.8	30574.8	30483.0	30529.5	2321.0
2020-09-11 07:00:00	YM	Futures	30527.3	30561.5	30460.9	30480.8	1870.0
2020-09-11 08:00:00	YM	Futures	30477.5	30497.4	30373.6	30411.2	2901.0
2020-09-11 09:00:00	YM	Futures	30410.1	30511.8	30338.2	30365.8	21701.0
2020-09-11 10:00:00	YM	Futures	30363.6	30598.0	30339.3	30508.5	30981.0
2020-09-11 11:00:00	YM	Futures	30508.5	30635.6	30457.6	30486.3	16191.0
2020-09-11 12:00:00	YM	Futures	30486.3	30587.0	30365.8	30375.8	15369.0
2020-09-11 13:00:00	YM	Futures	30375.8	30406.7	30207.7	30247.5	19965.0
2020-09-11 14:00:00	YM	Futures	30248.6	30470.9	30203.3	30418.9	15765.0
2020-09-11 15:00:00	YM	Futures	30418.9	30568.2	30320.5	30444.3	18048.0

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

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