PREVIEW / futures_1hour / 2019-03-29

all futures 1-hour files

  file:    by_date/futures_1hour/2019/2019-03-29.parquet
  size:    48 KB
  rows:    1,445

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
2019-03-29 00:00:00	ES	Futures	3066.17	3066.71	3065.35	3065.62	2551.0
2019-03-29 01:00:00	ES	Futures	3065.35	3066.17	3063.18	3064.0	6567.0
2019-03-29 02:00:00	ES	Futures	3064.27	3065.35	3062.64	3064.81	4561.0
2019-03-29 03:00:00	ES	Futures	3064.54	3067.52	3063.18	3065.62	9774.0
2019-03-29 04:00:00	ES	Futures	3065.62	3067.25	3061.56	3061.83	14527.0
2019-03-29 05:00:00	ES	Futures	3061.83	3064.27	3061.83	3063.18	12206.0
2019-03-29 06:00:00	ES	Futures	3063.46	3065.62	3060.2	3065.35	16743.0
2019-03-29 07:00:00	ES	Futures	3065.62	3073.49	3065.08	3071.32	29634.0
2019-03-29 08:00:00	ES	Futures	3071.32	3073.49	3069.42	3072.67	23727.0
2019-03-29 09:00:00	ES	Futures	3072.94	3077.01	3066.71	3070.78	151750.0
2019-03-29 10:00:00	ES	Futures	3070.78	3073.22	3061.56	3065.08	196128.0
2019-03-29 11:00:00	ES	Futures	3065.08	3074.3	3065.08	3069.69	130752.0
2019-03-29 12:00:00	ES	Futures	3069.96	3072.67	3064.81	3071.32	104033.0
2019-03-29 13:00:00	ES	Futures	3071.32	3072.13	3066.98	3070.23	79328.0
2019-03-29 14:00:00	ES	Futures	3070.23	3078.64	3069.69	3077.28	113144.0
2019-03-29 15:00:00	ES	Futures	3077.28	3080.26	3071.32	3077.55	391980.0
2019-03-29 16:00:00	ES	Futures	3077.55	3080.54	3074.57	3079.18	93773.0
2019-03-29 00:00:00	NQ	Futures	8586.77	8590.56	8584.74	8585.9	1519.0
2019-03-29 01:00:00	NQ	Futures	8585.61	8587.07	8580.37	8583.57	2630.0
2019-03-29 02:00:00	NQ	Futures	8583.57	8589.1	8578.04	8584.74	2574.0
2019-03-29 03:00:00	NQ	Futures	8584.44	8597.55	8579.79	8591.14	4875.0
2019-03-29 04:00:00	NQ	Futures	8591.43	8596.67	8576.0	8576.58	7062.0
2019-03-29 05:00:00	NQ	Futures	8576.29	8584.15	8575.13	8580.08	5059.0
2019-03-29 06:00:00	NQ	Futures	8580.08	8584.74	8568.43	8582.99	7391.0
2019-03-29 07:00:00	NQ	Futures	8583.28	8605.7	8582.41	8601.33	10016.0
2019-03-29 08:00:00	NQ	Futures	8601.04	8608.32	8593.18	8605.12	9458.0
2019-03-29 09:00:00	NQ	Futures	8605.12	8622.88	8583.86	8596.96	58222.0
2019-03-29 10:00:00	NQ	Futures	8596.96	8612.4	8566.98	8578.91	60946.0
2019-03-29 11:00:00	NQ	Futures	8578.62	8617.05	8578.33	8599.59	46325.0
2019-03-29 12:00:00	NQ	Futures	8599.88	8608.9	8585.61	8603.95	34752.0
2019-03-29 13:00:00	NQ	Futures	8604.24	8606.86	8592.02	8600.46	19111.0
2019-03-29 14:00:00	NQ	Futures	8600.17	8620.26	8598.42	8618.22	25716.0
2019-03-29 15:00:00	NQ	Futures	8618.22	8625.79	8603.08	8620.84	59077.0
2019-03-29 16:00:00	NQ	Futures	8620.84	8635.11	8613.85	8633.07	14742.0
2019-03-29 00:00:00	YM	Futures	28066.2	28078.1	28060.7	28067.3	591.0
2019-03-29 01:00:00	YM	Futures	28068.3	28072.7	28043.3	28053.1	1407.0
2019-03-29 02:00:00	YM	Futures	28053.1	28064.0	28035.7	28052.0	1359.0
2019-03-29 03:00:00	YM	Futures	28053.1	28082.5	28041.1	28059.6	2241.0
2019-03-29 04:00:00	YM	Futures	28059.6	28078.1	28021.6	28023.7	3777.0
2019-03-29 05:00:00	YM	Futures	28023.7	28053.1	28023.7	28042.2	2603.0
2019-03-29 06:00:00	YM	Futures	28043.3	28057.5	28000.9	28054.2	3821.0
2019-03-29 07:00:00	YM	Futures	28055.3	28128.2	28047.7	28109.7	6281.0
2019-03-29 08:00:00	YM	Futures	28108.6	28145.6	28098.8	28136.9	5615.0
2019-03-29 09:00:00	YM	Futures	28138.0	28170.6	28062.9	28104.2	24433.0
2019-03-29 10:00:00	YM	Futures	28105.3	28144.5	28042.2	28083.6	27886.0
2019-03-29 11:00:00	YM	Futures	28083.6	28161.9	28083.6	28130.3	20527.0
2019-03-29 12:00:00	YM	Futures	28131.4	28163.0	28082.5	28153.2	16096.0
2019-03-29 13:00:00	YM	Futures	28153.2	28159.7	28110.8	28142.3	9885.0
2019-03-29 14:00:00	YM	Futures	28141.2	28196.7	28127.1	28189.1	14862.0
2019-03-29 15:00:00	YM	Futures	28189.1	28232.6	28136.9	28208.6	31185.0

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

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