PREVIEW / futures_1hour / 2017-04-06

all futures 1-hour files

  file:    by_date/futures_1hour/2017/2017-04-06.parquet
  size:    53 KB
  rows:    1,641

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-06 00:00:00	ES	Futures	2559.35	2559.35	2557.71	2559.08	3863.0
2017-04-06 01:00:00	ES	Futures	2558.8	2559.08	2556.89	2558.53	5111.0
2017-04-06 02:00:00	ES	Futures	2558.53	2563.17	2557.98	2560.44	14881.0
2017-04-06 03:00:00	ES	Futures	2560.44	2562.35	2556.62	2558.8	32022.0
2017-04-06 04:00:00	ES	Futures	2559.08	2563.17	2558.53	2562.08	22285.0
2017-04-06 05:00:00	ES	Futures	2562.08	2564.54	2562.08	2563.17	15294.0
2017-04-06 06:00:00	ES	Futures	2562.9	2567.54	2562.9	2566.45	17213.0
2017-04-06 07:00:00	ES	Futures	2566.45	2567.54	2564.81	2565.09	17177.0
2017-04-06 08:00:00	ES	Futures	2565.09	2568.09	2563.45	2567.54	31211.0
2017-04-06 09:00:00	ES	Futures	2567.54	2571.91	2562.08	2571.64	257140.0
2017-04-06 10:00:00	ES	Futures	2571.64	2574.1	2567.27	2571.09	235888.0
2017-04-06 11:00:00	ES	Futures	2571.09	2576.01	2570.82	2574.92	137012.0
2017-04-06 12:00:00	ES	Futures	2574.65	2575.74	2570.55	2572.46	90211.0
2017-04-06 13:00:00	ES	Futures	2572.46	2579.84	2571.91	2575.47	122007.0
2017-04-06 14:00:00	ES	Futures	2575.74	2576.83	2567.0	2568.36	162073.0
2017-04-06 15:00:00	ES	Futures	2568.36	2573.28	2567.82	2572.46	271055.0
2017-04-06 16:00:00	ES	Futures	2572.46	2573.28	2570.0	2573.28	76375.0
2017-04-06 18:00:00	ES	Futures	2573.28	2574.37	2572.46	2573.28	3756.0
2017-04-06 19:00:00	ES	Futures	2573.28	2574.1	2572.19	2572.19	3073.0
2017-04-06 20:00:00	ES	Futures	2572.19	2574.65	2571.64	2573.01	5480.0
2017-04-06 21:00:00	ES	Futures	2572.73	2573.83	2553.07	2558.53	82385.0
2017-04-06 22:00:00	ES	Futures	2558.26	2562.08	2555.25	2561.26	44103.0
2017-04-06 23:00:00	ES	Futures	2560.99	2565.09	2560.99	2564.81	15760.0
2017-04-06 00:00:00	NQ	Futures	6442.51	6442.51	6437.74	6441.32	1229.0
2017-04-06 01:00:00	NQ	Futures	6441.32	6441.32	6435.95	6441.02	1074.0
2017-04-06 02:00:00	NQ	Futures	6441.02	6455.03	6439.23	6446.98	3068.0
2017-04-06 03:00:00	NQ	Futures	6446.98	6449.97	6438.93	6446.39	4954.0
2017-04-06 04:00:00	NQ	Futures	6446.09	6455.93	6445.19	6454.44	2663.0
2017-04-06 05:00:00	NQ	Futures	6454.74	6459.21	6452.95	6456.23	2225.0
2017-04-06 06:00:00	NQ	Futures	6456.23	6469.64	6456.23	6466.06	2590.0
2017-04-06 07:00:00	NQ	Futures	6466.06	6468.15	6463.08	6463.38	3609.0
2017-04-06 08:00:00	NQ	Futures	6463.38	6469.05	6460.1	6468.15	4543.0
2017-04-06 09:00:00	NQ	Futures	6468.45	6479.48	6452.05	6477.99	50875.0
2017-04-06 10:00:00	NQ	Futures	6478.29	6481.57	6456.82	6470.24	53428.0
2017-04-06 11:00:00	NQ	Futures	6470.24	6484.25	6467.85	6475.31	29296.0
2017-04-06 12:00:00	NQ	Futures	6475.01	6477.99	6460.7	6464.87	19478.0
2017-04-06 13:00:00	NQ	Futures	6464.57	6481.87	6462.79	6471.73	20758.0
2017-04-06 14:00:00	NQ	Futures	6471.43	6474.71	6449.07	6451.46	29846.0
2017-04-06 15:00:00	NQ	Futures	6451.46	6466.66	6451.46	6466.06	34967.0
2017-04-06 16:00:00	NQ	Futures	6466.06	6471.13	6461.59	6470.54	5825.0
2017-04-06 18:00:00	NQ	Futures	6471.73	6473.22	6469.64	6471.13	910.0
2017-04-06 19:00:00	NQ	Futures	6471.43	6472.92	6466.96	6466.96	661.0
2017-04-06 20:00:00	NQ	Futures	6467.26	6475.31	6466.66	6469.94	1822.0
2017-04-06 21:00:00	NQ	Futures	6469.64	6472.92	6419.26	6432.37	16858.0
2017-04-06 22:00:00	NQ	Futures	6432.37	6444.6	6426.71	6442.51	8802.0
2017-04-06 23:00:00	NQ	Futures	6442.21	6452.95	6442.21	6451.75	3182.0
2017-04-06 00:00:00	YM	Futures	22324.9	22327.0	22316.2	22322.7	865.0
2017-04-06 01:00:00	YM	Futures	22323.8	22324.9	22306.4	22319.4	1131.0
2017-04-06 02:00:00	YM	Futures	22321.6	22360.7	22316.2	22335.7	2883.0
2017-04-06 03:00:00	YM	Futures	22336.8	22348.8	22306.4	22322.7	5099.0

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

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