PREVIEW / futures_1hour / 2017-06-29

all futures 1-hour files

  file:    by_date/futures_1hour/2017/2017-06-29.parquet
  size:    55 KB
  rows:    1,645

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-29 00:00:00	ES	Futures	2671.89	2672.16	2671.34	2671.62	1533.0
2017-06-29 01:00:00	ES	Futures	2671.62	2671.89	2670.8	2671.34	2104.0
2017-06-29 02:00:00	ES	Futures	2671.34	2672.44	2671.07	2671.34	7408.0
2017-06-29 03:00:00	ES	Futures	2671.07	2673.26	2669.16	2669.43	26525.0
2017-06-29 04:00:00	ES	Futures	2669.43	2669.98	2668.34	2669.43	15079.0
2017-06-29 05:00:00	ES	Futures	2669.16	2670.52	2666.97	2668.06	15810.0
2017-06-29 06:00:00	ES	Futures	2668.34	2669.43	2666.7	2669.16	19019.0
2017-06-29 07:00:00	ES	Futures	2669.16	2672.98	2668.34	2671.89	25769.0
2017-06-29 08:00:00	ES	Futures	2671.89	2672.71	2666.15	2666.97	58008.0
2017-06-29 09:00:00	ES	Futures	2667.24	2668.34	2657.68	2659.59	282554.0
2017-06-29 10:00:00	ES	Futures	2659.59	2660.68	2652.48	2656.31	327714.0
2017-06-29 11:00:00	ES	Futures	2656.58	2657.13	2641.55	2642.1	325333.0
2017-06-29 12:00:00	ES	Futures	2642.37	2646.74	2637.72	2638.82	237713.0
2017-06-29 13:00:00	ES	Futures	2638.54	2641.55	2626.52	2636.63	320535.0
2017-06-29 14:00:00	ES	Futures	2636.36	2644.56	2633.35	2642.92	193383.0
2017-06-29 15:00:00	ES	Futures	2642.92	2648.66	2641.55	2642.37	345872.0
2017-06-29 16:00:00	ES	Futures	2642.64	2647.84	2642.1	2647.56	95391.0
2017-06-29 18:00:00	ES	Futures	2646.74	2648.38	2643.19	2644.01	9155.0
2017-06-29 19:00:00	ES	Futures	2644.01	2646.74	2643.74	2645.92	2849.0
2017-06-29 20:00:00	ES	Futures	2645.92	2647.29	2644.56	2645.65	8406.0
2017-06-29 21:00:00	ES	Futures	2645.65	2647.56	2643.19	2647.29	10396.0
2017-06-29 22:00:00	ES	Futures	2647.29	2647.56	2643.46	2644.56	6229.0
2017-06-29 23:00:00	ES	Futures	2644.56	2645.38	2644.01	2644.28	2927.0
2017-06-29 00:00:00	NQ	Futures	6874.48	6874.48	6870.01	6870.91	395.0
2017-06-29 01:00:00	NQ	Futures	6871.21	6871.5	6863.76	6866.44	896.0
2017-06-29 02:00:00	NQ	Futures	6866.14	6873.89	6866.14	6868.53	1400.0
2017-06-29 03:00:00	NQ	Futures	6868.53	6874.48	6854.23	6856.02	4306.0
2017-06-29 04:00:00	NQ	Futures	6856.32	6858.7	6851.26	6856.62	2189.0
2017-06-29 05:00:00	NQ	Futures	6856.02	6858.4	6848.28	6851.26	1646.0
2017-06-29 06:00:00	NQ	Futures	6851.26	6851.85	6840.83	6848.87	5314.0
2017-06-29 07:00:00	NQ	Futures	6848.87	6858.4	6848.58	6850.96	5386.0
2017-06-29 08:00:00	NQ	Futures	6850.66	6850.96	6821.18	6823.27	12418.0
2017-06-29 09:00:00	NQ	Futures	6823.57	6830.71	6778.31	6786.35	72121.0
2017-06-29 10:00:00	NQ	Futures	6786.64	6794.09	6756.87	6768.48	80836.0
2017-06-29 11:00:00	NQ	Futures	6768.48	6773.54	6711.91	6722.03	95102.0
2017-06-29 12:00:00	NQ	Futures	6722.33	6745.85	6704.46	6706.25	63456.0
2017-06-29 13:00:00	NQ	Futures	6706.25	6716.08	6670.82	6692.85	94688.0
2017-06-29 14:00:00	NQ	Futures	6692.55	6722.93	6682.13	6714.59	57384.0
2017-06-29 15:00:00	NQ	Futures	6714.89	6754.49	6713.4	6736.62	78899.0
2017-06-29 16:00:00	NQ	Futures	6736.62	6743.47	6727.99	6729.48	11900.0
2017-06-29 18:00:00	NQ	Futures	6727.09	6734.84	6710.12	6711.31	2882.0
2017-06-29 19:00:00	NQ	Futures	6712.5	6725.61	6711.31	6723.52	1181.0
2017-06-29 20:00:00	NQ	Futures	6723.52	6726.5	6712.8	6714.89	2165.0
2017-06-29 21:00:00	NQ	Futures	6715.18	6722.03	6697.62	6721.73	5227.0
2017-06-29 22:00:00	NQ	Futures	6722.03	6722.63	6708.34	6713.7	2615.0
2017-06-29 23:00:00	NQ	Futures	6713.99	6719.95	6704.46	6705.36	1402.0
2017-06-29 00:00:00	YM	Futures	23337.1	23338.1	23332.7	23333.8	359.0
2017-06-29 01:00:00	YM	Futures	23333.8	23337.1	23328.3	23331.6	456.0
2017-06-29 02:00:00	YM	Futures	23332.7	23339.2	23332.7	23336.0	1347.0
2017-06-29 03:00:00	YM	Futures	23334.9	23349.0	23317.5	23320.7	4155.0

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

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