PREVIEW / futures_1hour / 2020-08-17

all futures 1-hour files

  file:    by_date/futures_1hour/2020/2020-08-17.parquet
  size:    59 KB
  rows:    1,842

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-08-17 00:00:00	ES	Futures	3766.16	3767.0	3764.2	3765.04	3130.0
2020-08-17 01:00:00	ES	Futures	3764.76	3766.16	3763.09	3763.92	4304.0
2020-08-17 02:00:00	ES	Futures	3763.92	3767.0	3761.97	3765.6	8362.0
2020-08-17 03:00:00	ES	Futures	3765.6	3770.07	3758.34	3768.67	26896.0
2020-08-17 04:00:00	ES	Futures	3768.67	3769.51	3762.53	3767.55	14830.0
2020-08-17 05:00:00	ES	Futures	3767.55	3771.46	3765.32	3766.44	11238.0
2020-08-17 06:00:00	ES	Futures	3766.72	3768.39	3764.48	3767.27	9136.0
2020-08-17 07:00:00	ES	Futures	3767.27	3769.51	3764.48	3766.72	10745.0
2020-08-17 08:00:00	ES	Futures	3767.0	3773.42	3766.16	3772.58	22333.0
2020-08-17 09:00:00	ES	Futures	3772.3	3776.49	3771.18	3773.14	97161.0
2020-08-17 10:00:00	ES	Futures	3773.14	3778.44	3768.67	3774.81	103967.0
2020-08-17 11:00:00	ES	Futures	3774.81	3776.77	3771.46	3774.81	81010.0
2020-08-17 12:00:00	ES	Futures	3774.81	3776.77	3772.02	3775.93	44543.0
2020-08-17 13:00:00	ES	Futures	3776.21	3776.77	3774.26	3775.09	33509.0
2020-08-17 14:00:00	ES	Futures	3775.37	3776.49	3772.58	3773.7	50929.0
2020-08-17 15:00:00	ES	Futures	3773.7	3776.49	3770.07	3773.42	130790.0
2020-08-17 16:00:00	ES	Futures	3773.7	3776.49	3770.35	3774.53	40670.0
2020-08-17 18:00:00	ES	Futures	3774.53	3775.93	3772.58	3775.93	3511.0
2020-08-17 19:00:00	ES	Futures	3775.93	3783.19	3774.53	3782.07	10357.0
2020-08-17 20:00:00	ES	Futures	3781.79	3784.03	3780.12	3780.68	9671.0
2020-08-17 21:00:00	ES	Futures	3780.96	3781.24	3775.65	3777.61	10976.0
2020-08-17 22:00:00	ES	Futures	3777.89	3777.89	3771.74	3773.7	9346.0
2020-08-17 23:00:00	ES	Futures	3773.7	3777.33	3772.86	3775.93	6684.0
2020-08-17 00:00:00	NQ	Futures	12930.04	12938.72	12927.44	12934.09	1107.0
2020-08-17 01:00:00	NQ	Futures	12934.38	12940.74	12928.3	12936.4	1497.0
2020-08-17 02:00:00	NQ	Futures	12935.25	12951.44	12926.28	12939.0	3154.0
2020-08-17 03:00:00	NQ	Futures	12938.72	12964.45	12926.28	12960.11	7197.0
2020-08-17 04:00:00	NQ	Futures	12959.54	12963.3	12939.58	12949.7	4193.0
2020-08-17 05:00:00	NQ	Futures	12949.41	12966.19	12947.39	12952.89	2897.0
2020-08-17 06:00:00	NQ	Futures	12953.46	12965.32	12950.28	12961.56	1949.0
2020-08-17 07:00:00	NQ	Futures	12962.14	12976.02	12955.78	12959.83	4509.0
2020-08-17 08:00:00	NQ	Futures	12959.54	12993.66	12958.38	12986.72	7721.0
2020-08-17 09:00:00	NQ	Futures	12986.43	13033.57	12980.07	13028.94	38114.0
2020-08-17 10:00:00	NQ	Futures	13029.23	13043.98	12998.86	13020.84	44336.0
2020-08-17 11:00:00	NQ	Futures	13021.13	13032.99	12999.44	13017.08	24302.0
2020-08-17 12:00:00	NQ	Futures	13017.08	13043.11	13007.83	13039.06	17082.0
2020-08-17 13:00:00	NQ	Futures	13039.35	13052.94	13034.43	13044.55	16988.0
2020-08-17 14:00:00	NQ	Futures	13044.84	13063.64	13036.75	13061.91	15290.0
2020-08-17 15:00:00	NQ	Futures	13062.19	13071.45	13043.69	13052.65	28396.0
2020-08-17 16:00:00	NQ	Futures	13052.36	13062.77	13043.11	13055.83	6232.0
2020-08-17 18:00:00	NQ	Futures	13054.1	13064.51	13051.21	13061.33	1485.0
2020-08-17 19:00:00	NQ	Futures	13061.62	13081.28	13056.99	13076.65	2743.0
2020-08-17 20:00:00	NQ	Futures	13076.94	13085.04	13070.29	13073.76	2770.0
2020-08-17 21:00:00	NQ	Futures	13072.89	13076.94	13052.94	13063.93	4051.0
2020-08-17 22:00:00	NQ	Futures	13064.22	13065.95	13048.02	13054.68	2795.0
2020-08-17 23:00:00	NQ	Futures	13054.39	13066.82	13052.07	13061.04	1861.0
2020-08-17 00:00:00	YM	Futures	30727.3	30729.5	30707.5	30710.8	568.0
2020-08-17 01:00:00	YM	Futures	30713.0	30722.9	30683.3	30691.0	938.0
2020-08-17 02:00:00	YM	Futures	30691.0	30714.1	30670.1	30698.7	1698.0
2020-08-17 03:00:00	YM	Futures	30696.5	30739.4	30615.0	30705.3	6159.0

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

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