PREVIEW / futures_1hour / 2019-03-15

all futures 1-hour files

  file:    by_date/futures_1hour/2019/2019-03-15.parquet
  size:    46 KB
  rows:    1,396

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-15 00:00:00	ES	Futures	3057.22	3058.85	3056.68	3057.76	3379.0
2019-03-15 01:00:00	ES	Futures	3057.76	3058.03	3054.51	3055.05	5672.0
2019-03-15 02:00:00	ES	Futures	3055.05	3057.22	3054.51	3056.95	4337.0
2019-03-15 03:00:00	ES	Futures	3056.68	3057.49	3055.32	3056.95	5320.0
2019-03-15 04:00:00	ES	Futures	3056.95	3059.39	3055.32	3058.58	12536.0
2019-03-15 05:00:00	ES	Futures	3058.58	3059.39	3056.95	3058.58	11121.0
2019-03-15 06:00:00	ES	Futures	3058.58	3063.46	3058.3	3062.91	22293.0
2019-03-15 07:00:00	ES	Futures	3062.91	3065.08	3062.1	3063.46	20873.0
2019-03-15 08:00:00	ES	Futures	3063.46	3065.08	3059.12	3060.47	35778.0
2019-03-15 09:00:00	ES	Futures	3060.2	3063.46	3052.61	3060.47	226289.0
2019-03-15 10:00:00	ES	Futures	3060.47	3061.56	3055.05	3058.85	180553.0
2019-03-15 11:00:00	ES	Futures	3058.85	3070.23	3057.22	3068.06	171014.0
2019-03-15 12:00:00	ES	Futures	3068.34	3075.93	3066.71	3072.4	123270.0
2019-03-15 13:00:00	ES	Futures	3072.67	3074.03	3069.96	3070.5	59328.0
2019-03-15 14:00:00	ES	Futures	3070.5	3071.32	3066.44	3068.61	78221.0
2019-03-15 15:00:00	ES	Futures	3068.88	3068.88	3061.83	3066.98	244761.0
2019-03-15 16:00:00	ES	Futures	3066.98	3069.69	3064.0	3068.88	76018.0
2019-03-15 00:00:00	NQ	Futures	8497.39	8502.92	8494.77	8499.72	1663.0
2019-03-15 01:00:00	NQ	Futures	8499.43	8500.88	8487.49	8489.24	2504.0
2019-03-15 02:00:00	NQ	Futures	8488.65	8495.64	8485.45	8495.06	1790.0
2019-03-15 03:00:00	NQ	Futures	8495.06	8497.97	8490.98	8495.64	2161.0
2019-03-15 04:00:00	NQ	Futures	8495.35	8504.67	8492.15	8502.63	5478.0
2019-03-15 05:00:00	NQ	Futures	8502.92	8504.09	8497.39	8499.72	3484.0
2019-03-15 06:00:00	NQ	Futures	8499.72	8518.35	8498.26	8516.02	7015.0
2019-03-15 07:00:00	NQ	Futures	8515.73	8518.06	8504.67	8511.36	5803.0
2019-03-15 08:00:00	NQ	Futures	8510.78	8519.52	8499.14	8503.5	9519.0
2019-03-15 09:00:00	NQ	Futures	8503.21	8539.61	8483.7	8533.2	78731.0
2019-03-15 10:00:00	NQ	Futures	8533.49	8536.99	8511.36	8529.13	63591.0
2019-03-15 11:00:00	NQ	Futures	8529.42	8550.96	8524.47	8546.3	50571.0
2019-03-15 12:00:00	NQ	Futures	8546.01	8568.72	8542.52	8556.49	41323.0
2019-03-15 13:00:00	NQ	Futures	8556.79	8572.8	8556.2	8566.98	26761.0
2019-03-15 14:00:00	NQ	Futures	8566.68	8566.68	8556.79	8560.28	23672.0
2019-03-15 15:00:00	NQ	Futures	8560.28	8560.57	8530.87	8543.97	50692.0
2019-03-15 16:00:00	NQ	Futures	8543.97	8556.49	8536.7	8555.33	12971.0
2019-03-15 00:00:00	YM	Futures	28094.4	28107.5	28086.8	28097.7	907.0
2019-03-15 01:00:00	YM	Futures	28096.6	28101.0	28067.3	28072.7	1286.0
2019-03-15 02:00:00	YM	Futures	28071.6	28093.4	28066.2	28087.9	1298.0
2019-03-15 03:00:00	YM	Futures	28087.9	28090.1	28064.0	28080.3	1901.0
2019-03-15 04:00:00	YM	Futures	28079.2	28089.0	28049.8	28086.8	3500.0
2019-03-15 05:00:00	YM	Futures	28086.8	28095.5	28072.7	28085.7	2477.0
2019-03-15 06:00:00	YM	Futures	28085.7	28134.7	28082.5	28126.0	4416.0
2019-03-15 07:00:00	YM	Futures	28124.9	28145.6	28115.1	28133.6	4580.0
2019-03-15 08:00:00	YM	Futures	28132.5	28160.8	28097.7	28107.5	6564.0
2019-03-15 09:00:00	YM	Futures	28106.4	28116.2	28005.3	28016.1	32295.0
2019-03-15 10:00:00	YM	Futures	28016.1	28025.9	27929.1	27978.1	28183.0
2019-03-15 11:00:00	YM	Futures	27979.2	28176.0	27963.9	28170.6	35537.0
2019-03-15 12:00:00	YM	Futures	28170.6	28236.9	28157.5	28213.0	22065.0
2019-03-15 13:00:00	YM	Futures	28215.2	28228.2	28181.5	28191.2	13581.0
2019-03-15 14:00:00	YM	Futures	28190.2	28194.5	28139.0	28169.5	12526.0
2019-03-15 15:00:00	YM	Futures	28169.5	28169.5	28112.9	28148.8	23805.0

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

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