PREVIEW / futures_1hour / 2020-06-09

all futures 1-hour files

  file:    by_date/futures_1hour/2020/2020-06-09.parquet
  size:    61 KB
  rows:    1,859

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-06-09 00:00:00	ES	Futures	3537.2	3539.12	3534.46	3536.65	5094.0
2020-06-09 01:00:00	ES	Futures	3536.38	3544.34	3536.38	3543.79	8775.0
2020-06-09 02:00:00	ES	Futures	3543.79	3546.53	3534.73	3535.83	20095.0
2020-06-09 03:00:00	ES	Futures	3536.1	3538.85	3518.27	3521.28	64751.0
2020-06-09 04:00:00	ES	Futures	3521.28	3524.3	3501.53	3506.47	71811.0
2020-06-09 05:00:00	ES	Futures	3506.47	3515.25	3503.72	3506.19	41690.0
2020-06-09 06:00:00	ES	Futures	3506.47	3513.05	3501.8	3511.68	32714.0
2020-06-09 07:00:00	ES	Futures	3511.95	3519.09	3507.84	3514.97	35806.0
2020-06-09 08:00:00	ES	Futures	3514.7	3518.81	3506.47	3508.94	46195.0
2020-06-09 09:00:00	ES	Futures	3508.94	3517.72	3505.64	3507.01	180843.0
2020-06-09 10:00:00	ES	Futures	3507.01	3527.87	3502.35	3524.58	251782.0
2020-06-09 11:00:00	ES	Futures	3524.58	3528.69	3514.42	3516.34	177721.0
2020-06-09 12:00:00	ES	Futures	3516.34	3525.4	3511.41	3524.85	83324.0
2020-06-09 13:00:00	ES	Futures	3524.85	3533.91	3522.93	3531.16	72778.0
2020-06-09 14:00:00	ES	Futures	3531.16	3532.26	3519.64	3528.14	130319.0
2020-06-09 15:00:00	ES	Futures	3528.14	3535.55	3514.97	3518.81	252726.0
2020-06-09 16:00:00	ES	Futures	3519.09	3525.4	3514.42	3518.27	69518.0
2020-06-09 18:00:00	ES	Futures	3517.72	3526.5	3517.72	3524.58	8196.0
2020-06-09 19:00:00	ES	Futures	3524.85	3531.44	3520.46	3530.07	9583.0
2020-06-09 20:00:00	ES	Futures	3530.34	3535.01	3527.05	3534.46	17103.0
2020-06-09 21:00:00	ES	Futures	3534.18	3540.77	3530.61	3539.94	19896.0
2020-06-09 22:00:00	ES	Futures	3539.94	3542.41	3534.18	3538.3	11811.0
2020-06-09 23:00:00	ES	Futures	3538.3	3539.67	3533.63	3536.93	8075.0
2020-06-09 00:00:00	NQ	Futures	11293.66	11298.23	11285.38	11292.52	1981.0
2020-06-09 01:00:00	NQ	Futures	11291.66	11319.65	11291.37	11309.37	4056.0
2020-06-09 02:00:00	NQ	Futures	11309.37	11318.22	11293.66	11296.23	5097.0
2020-06-09 03:00:00	NQ	Futures	11296.8	11303.37	11254.81	11262.81	11580.0
2020-06-09 04:00:00	NQ	Futures	11263.1	11275.09	11211.68	11223.68	16150.0
2020-06-09 05:00:00	NQ	Futures	11223.68	11244.24	11217.68	11227.11	8704.0
2020-06-09 06:00:00	NQ	Futures	11227.39	11247.39	11210.25	11244.24	6830.0
2020-06-09 07:00:00	NQ	Futures	11244.53	11251.67	11222.25	11249.67	8758.0
2020-06-09 08:00:00	NQ	Futures	11249.67	11267.38	11245.67	11263.38	13598.0
2020-06-09 09:00:00	NQ	Futures	11263.1	11323.08	11249.96	11306.23	59687.0
2020-06-09 10:00:00	NQ	Futures	11306.8	11387.35	11283.38	11383.35	68621.0
2020-06-09 11:00:00	NQ	Futures	11383.64	11396.2	11359.64	11366.5	46683.0
2020-06-09 12:00:00	NQ	Futures	11366.5	11411.06	11354.5	11400.77	29465.0
2020-06-09 13:00:00	NQ	Futures	11400.49	11431.62	11388.78	11423.05	28822.0
2020-06-09 14:00:00	NQ	Futures	11423.05	11429.62	11380.21	11409.06	35151.0
2020-06-09 15:00:00	NQ	Futures	11408.77	11431.34	11375.64	11384.49	50716.0
2020-06-09 16:00:00	NQ	Futures	11384.49	11398.78	11359.64	11381.92	14789.0
2020-06-09 18:00:00	NQ	Futures	11379.92	11408.2	11379.92	11403.06	2450.0
2020-06-09 19:00:00	NQ	Futures	11403.63	11417.06	11391.06	11413.06	2853.0
2020-06-09 20:00:00	NQ	Futures	11413.34	11423.34	11403.92	11420.48	3831.0
2020-06-09 21:00:00	NQ	Futures	11420.48	11441.05	11410.77	11437.62	6196.0
2020-06-09 22:00:00	NQ	Futures	11437.91	11444.48	11428.77	11437.62	3975.0
2020-06-09 23:00:00	NQ	Futures	11437.91	11441.62	11427.05	11435.91	3177.0
2020-06-09 00:00:00	YM	Futures	30142.0	30160.7	30116.9	30136.6	1082.0
2020-06-09 01:00:00	YM	Futures	30136.6	30216.5	30135.5	30208.9	1558.0
2020-06-09 02:00:00	YM	Futures	30208.9	30257.1	30128.9	30140.9	4387.0
2020-06-09 03:00:00	YM	Futures	30142.0	30173.8	29951.5	29978.8	9819.0

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

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