PREVIEW / futures_1hour / 2017-04-13

all futures 1-hour files

  file:    by_date/futures_1hour/2017/2017-04-13.parquet
  size:    45 KB
  rows:    1,352

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
2017-04-13 00:00:00	ES	Futures	2556.62	2556.89	2555.53	2556.62	2545.0
2017-04-13 01:00:00	ES	Futures	2556.89	2560.44	2556.62	2559.35	7762.0
2017-04-13 02:00:00	ES	Futures	2559.35	2560.99	2557.98	2559.35	13002.0
2017-04-13 03:00:00	ES	Futures	2559.35	2559.62	2553.89	2554.98	31823.0
2017-04-13 04:00:00	ES	Futures	2554.71	2555.25	2551.7	2553.61	18221.0
2017-04-13 05:00:00	ES	Futures	2553.89	2553.89	2550.61	2551.16	20692.0
2017-04-13 06:00:00	ES	Futures	2551.16	2551.7	2548.15	2550.34	30116.0
2017-04-13 07:00:00	ES	Futures	2550.34	2552.52	2548.97	2551.16	24272.0
2017-04-13 08:00:00	ES	Futures	2551.16	2553.89	2550.61	2550.88	32032.0
2017-04-13 09:00:00	ES	Futures	2550.88	2559.62	2550.06	2557.71	187573.0
2017-04-13 10:00:00	ES	Futures	2557.71	2561.81	2557.16	2559.62	173475.0
2017-04-13 11:00:00	ES	Futures	2559.9	2562.08	2558.26	2559.9	110021.0
2017-04-13 12:00:00	ES	Futures	2559.62	2559.62	2550.61	2552.25	152338.0
2017-04-13 13:00:00	ES	Futures	2551.97	2552.25	2545.97	2547.06	148112.0
2017-04-13 14:00:00	ES	Futures	2547.06	2552.52	2546.24	2551.16	128685.0
2017-04-13 15:00:00	ES	Futures	2550.88	2551.97	2540.5	2540.78	313391.0
2017-04-13 16:00:00	ES	Futures	2540.5	2543.51	2539.14	2542.96	118879.0
2017-04-13 00:00:00	NQ	Futures	6407.33	6407.93	6404.35	6407.63	597.0
2017-04-13 01:00:00	NQ	Futures	6407.33	6418.36	6407.33	6415.38	1428.0
2017-04-13 02:00:00	NQ	Futures	6415.38	6418.36	6411.8	6416.28	2484.0
2017-04-13 03:00:00	NQ	Futures	6415.98	6416.87	6400.47	6402.86	3875.0
2017-04-13 04:00:00	NQ	Futures	6403.46	6404.95	6395.41	6399.88	2385.0
2017-04-13 05:00:00	NQ	Futures	6399.28	6399.28	6393.32	6396.6	2392.0
2017-04-13 06:00:00	NQ	Futures	6396.3	6396.9	6387.06	6392.13	4684.0
2017-04-13 07:00:00	NQ	Futures	6391.83	6396.9	6388.85	6394.21	4042.0
2017-04-13 08:00:00	NQ	Futures	6394.21	6401.67	6394.21	6396.3	5820.0
2017-04-13 09:00:00	NQ	Futures	6396.6	6429.1	6395.7	6423.43	42035.0
2017-04-13 10:00:00	NQ	Futures	6423.43	6438.04	6423.43	6435.06	31930.0
2017-04-13 11:00:00	NQ	Futures	6435.36	6439.23	6428.8	6430.88	18282.0
2017-04-13 12:00:00	NQ	Futures	6430.59	6430.59	6411.21	6414.19	29788.0
2017-04-13 13:00:00	NQ	Futures	6414.19	6414.78	6396.6	6399.58	29644.0
2017-04-13 14:00:00	NQ	Futures	6399.88	6412.4	6398.09	6409.42	27365.0
2017-04-13 15:00:00	NQ	Futures	6409.42	6411.5	6384.08	6384.37	49540.0
2017-04-13 16:00:00	NQ	Futures	6384.67	6391.83	6377.22	6389.14	10875.0
2017-04-13 00:00:00	YM	Futures	22286.8	22289.0	22279.2	22289.0	589.0
2017-04-13 01:00:00	YM	Futures	22289.0	22319.4	22289.0	22310.7	1845.0
2017-04-13 02:00:00	YM	Futures	22310.7	22320.5	22297.7	22308.6	2224.0
2017-04-13 03:00:00	YM	Futures	22308.6	22310.7	22269.4	22281.4	4714.0
2017-04-13 04:00:00	YM	Futures	22281.4	22285.7	22251.0	22271.6	2842.0
2017-04-13 05:00:00	YM	Futures	22270.5	22270.5	22244.4	22252.0	2080.0
2017-04-13 06:00:00	YM	Futures	22253.1	22266.2	22233.6	22255.3	3521.0
2017-04-13 07:00:00	YM	Futures	22256.4	22271.6	22247.7	22258.6	2974.0
2017-04-13 08:00:00	YM	Futures	22259.7	22278.1	22254.2	22257.5	3126.0
2017-04-13 09:00:00	YM	Futures	22257.5	22320.5	22243.4	22301.0	20768.0
2017-04-13 10:00:00	YM	Futures	22301.0	22332.5	22290.1	22314.0	17350.0
2017-04-13 11:00:00	YM	Futures	22312.9	22328.1	22295.5	22312.9	8893.0
2017-04-13 12:00:00	YM	Futures	22311.8	22311.8	22236.8	22242.3	17237.0
2017-04-13 13:00:00	YM	Futures	22242.3	22245.5	22187.9	22203.1	19244.0
2017-04-13 14:00:00	YM	Futures	22203.1	22249.9	22199.9	22243.4	13120.0
2017-04-13 15:00:00	YM	Futures	22242.3	22249.9	22161.8	22162.9	25700.0

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

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