PREVIEW / futures_1hour / 2017-06-28

all futures 1-hour files

  file:    by_date/futures_1hour/2017/2017-06-28.parquet
  size:    54 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-06-28 00:00:00	ES	Futures	2643.74	2644.28	2642.92	2644.01	2790.0
2017-06-28 01:00:00	ES	Futures	2644.01	2644.83	2643.46	2644.01	3235.0
2017-06-28 02:00:00	ES	Futures	2644.01	2645.92	2643.74	2645.65	13019.0
2017-06-28 03:00:00	ES	Futures	2645.65	2645.92	2642.1	2643.19	27835.0
2017-06-28 04:00:00	ES	Futures	2642.92	2644.01	2639.09	2643.46	32475.0
2017-06-28 05:00:00	ES	Futures	2643.19	2648.93	2643.19	2647.56	29329.0
2017-06-28 06:00:00	ES	Futures	2647.56	2650.3	2647.29	2648.66	26423.0
2017-06-28 07:00:00	ES	Futures	2648.38	2650.57	2647.56	2650.02	20406.0
2017-06-28 08:00:00	ES	Futures	2650.02	2655.76	2648.93	2653.03	73228.0
2017-06-28 09:00:00	ES	Futures	2653.03	2657.13	2651.94	2653.3	214428.0
2017-06-28 10:00:00	ES	Futures	2653.03	2663.69	2652.76	2661.78	307684.0
2017-06-28 11:00:00	ES	Futures	2662.05	2665.88	2660.96	2663.69	144907.0
2017-06-28 12:00:00	ES	Futures	2663.96	2666.7	2662.87	2666.15	111188.0
2017-06-28 13:00:00	ES	Futures	2666.15	2668.34	2665.33	2666.97	105775.0
2017-06-28 14:00:00	ES	Futures	2667.24	2667.79	2664.24	2665.88	93707.0
2017-06-28 15:00:00	ES	Futures	2666.15	2668.34	2663.96	2665.33	196864.0
2017-06-28 16:00:00	ES	Futures	2665.33	2670.52	2664.51	2670.52	98510.0
2017-06-28 18:00:00	ES	Futures	2669.98	2672.71	2668.88	2670.8	8086.0
2017-06-28 19:00:00	ES	Futures	2671.07	2671.62	2670.25	2671.07	2464.0
2017-06-28 20:00:00	ES	Futures	2671.34	2671.89	2670.25	2670.8	5679.0
2017-06-28 21:00:00	ES	Futures	2670.8	2671.62	2670.25	2671.34	4024.0
2017-06-28 22:00:00	ES	Futures	2671.34	2672.16	2670.8	2671.89	3141.0
2017-06-28 23:00:00	ES	Futures	2671.89	2672.44	2671.62	2671.89	1467.0
2017-06-28 00:00:00	NQ	Futures	6741.68	6743.17	6733.05	6742.28	1430.0
2017-06-28 01:00:00	NQ	Futures	6741.98	6745.26	6736.92	6741.09	1292.0
2017-06-28 02:00:00	NQ	Futures	6741.09	6760.14	6740.19	6754.78	4373.0
2017-06-28 03:00:00	NQ	Futures	6755.38	6757.17	6730.37	6733.94	6616.0
2017-06-28 04:00:00	NQ	Futures	6733.94	6734.24	6707.74	6720.25	9668.0
2017-06-28 05:00:00	NQ	Futures	6720.25	6753.0	6719.05	6743.47	6045.0
2017-06-28 06:00:00	NQ	Futures	6744.07	6751.21	6733.64	6735.13	7991.0
2017-06-28 07:00:00	NQ	Futures	6735.43	6756.57	6731.26	6755.38	6713.0
2017-06-28 08:00:00	NQ	Futures	6754.78	6786.94	6753.59	6776.82	18761.0
2017-06-28 09:00:00	NQ	Futures	6777.12	6788.43	6744.07	6750.62	63259.0
2017-06-28 10:00:00	NQ	Futures	6750.02	6822.37	6748.23	6814.63	76804.0
2017-06-28 11:00:00	NQ	Futures	6814.63	6821.48	6801.53	6811.36	38560.0
2017-06-28 12:00:00	NQ	Futures	6811.66	6842.03	6809.57	6837.26	28445.0
2017-06-28 13:00:00	NQ	Futures	6837.56	6850.96	6834.58	6842.32	31759.0
2017-06-28 14:00:00	NQ	Futures	6842.32	6846.49	6832.8	6845.9	24971.0
2017-06-28 15:00:00	NQ	Futures	6845.9	6862.57	6844.71	6855.72	43665.0
2017-06-28 16:00:00	NQ	Futures	6855.72	6870.61	6854.83	6868.53	9430.0
2017-06-28 18:00:00	NQ	Futures	6867.63	6879.24	6866.14	6871.8	1917.0
2017-06-28 19:00:00	NQ	Futures	6871.8	6874.78	6870.91	6874.48	586.0
2017-06-28 20:00:00	NQ	Futures	6874.48	6877.76	6870.61	6871.8	1098.0
2017-06-28 21:00:00	NQ	Futures	6871.5	6876.27	6868.53	6874.48	2131.0
2017-06-28 22:00:00	NQ	Futures	6874.78	6876.86	6872.1	6873.89	642.0
2017-06-28 23:00:00	NQ	Futures	6874.48	6875.97	6872.99	6874.18	477.0
2017-06-28 00:00:00	YM	Futures	23164.0	23166.2	23159.6	23164.0	468.0
2017-06-28 01:00:00	YM	Futures	23165.1	23168.3	23159.6	23164.0	780.0
2017-06-28 02:00:00	YM	Futures	23164.0	23178.1	23160.7	23173.8	2671.0
2017-06-28 03:00:00	YM	Futures	23173.8	23176.0	23154.2	23159.6	4018.0

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

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