PREVIEW / futures_1hour / 2016-11-30

all futures 1-hour files

  file:    by_date/futures_1hour/2016/2016-11-30.parquet
  size:    55 KB
  rows:    1,661

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
2016-11-30 00:00:00	ES	Futures	2397.29	2397.83	2395.66	2396.2	3557.0
2016-11-30 01:00:00	ES	Futures	2396.2	2399.46	2395.93	2399.19	4086.0
2016-11-30 02:00:00	ES	Futures	2399.19	2400.55	2398.92	2400.01	6717.0
2016-11-30 03:00:00	ES	Futures	2399.74	2403.82	2398.65	2402.73	24770.0
2016-11-30 04:00:00	ES	Futures	2402.73	2403.82	2399.74	2401.1	19224.0
2016-11-30 05:00:00	ES	Futures	2401.1	2402.46	2398.92	2400.83	15987.0
2016-11-30 06:00:00	ES	Futures	2401.1	2404.63	2400.83	2404.09	15888.0
2016-11-30 07:00:00	ES	Futures	2404.09	2405.45	2403.55	2404.36	21730.0
2016-11-30 08:00:00	ES	Futures	2404.09	2405.72	2403.27	2405.18	33513.0
2016-11-30 09:00:00	ES	Futures	2405.45	2409.26	2403.55	2404.09	221774.0
2016-11-30 10:00:00	ES	Futures	2404.36	2405.99	2398.65	2401.91	277063.0
2016-11-30 11:00:00	ES	Futures	2401.64	2405.18	2399.19	2400.28	227013.0
2016-11-30 12:00:00	ES	Futures	2400.28	2401.64	2398.1	2400.83	108754.0
2016-11-30 13:00:00	ES	Futures	2401.1	2403.0	2400.28	2401.37	82350.0
2016-11-30 14:00:00	ES	Futures	2401.64	2401.91	2394.02	2394.84	173249.0
2016-11-30 15:00:00	ES	Futures	2395.11	2400.28	2391.85	2392.12	483384.0
2016-11-30 16:00:00	ES	Futures	2392.12	2394.57	2391.3	2392.93	182533.0
2016-11-30 18:00:00	ES	Futures	2393.75	2394.3	2390.76	2393.75	8088.0
2016-11-30 19:00:00	ES	Futures	2393.48	2393.75	2391.85	2392.39	5896.0
2016-11-30 20:00:00	ES	Futures	2392.12	2393.48	2391.85	2392.66	6941.0
2016-11-30 21:00:00	ES	Futures	2392.66	2396.2	2392.39	2395.38	6470.0
2016-11-30 22:00:00	ES	Futures	2395.11	2396.2	2394.57	2395.38	3235.0
2016-11-30 23:00:00	ES	Futures	2395.66	2395.93	2394.57	2394.84	3109.0
2016-11-30 00:00:00	NQ	Futures	5815.74	5818.43	5813.65	5814.55	596.0
2016-11-30 01:00:00	NQ	Futures	5814.55	5821.71	5814.25	5820.81	426.0
2016-11-30 02:00:00	NQ	Futures	5821.11	5823.8	5819.02	5819.32	1114.0
2016-11-30 03:00:00	NQ	Futures	5819.32	5830.06	5816.34	5826.18	3364.0
2016-11-30 04:00:00	NQ	Futures	5825.88	5828.27	5815.44	5819.32	3122.0
2016-11-30 05:00:00	NQ	Futures	5819.62	5822.9	5812.76	5818.13	1827.0
2016-11-30 06:00:00	NQ	Futures	5818.43	5824.09	5818.13	5823.8	1734.0
2016-11-30 07:00:00	NQ	Futures	5824.09	5825.88	5820.51	5820.81	1935.0
2016-11-30 08:00:00	NQ	Futures	5821.11	5824.09	5815.14	5818.43	4140.0
2016-11-30 09:00:00	NQ	Futures	5818.13	5827.38	5803.21	5805.9	31466.0
2016-11-30 10:00:00	NQ	Futures	5806.19	5808.28	5775.17	5784.12	40192.0
2016-11-30 11:00:00	NQ	Futures	5784.12	5795.75	5762.94	5764.43	26755.0
2016-11-30 12:00:00	NQ	Futures	5764.43	5769.8	5755.18	5769.2	22675.0
2016-11-30 13:00:00	NQ	Futures	5769.2	5771.89	5763.83	5765.92	11963.0
2016-11-30 14:00:00	NQ	Futures	5766.22	5766.81	5744.74	5749.81	23443.0
2016-11-30 15:00:00	NQ	Futures	5749.51	5762.04	5743.25	5743.54	36806.0
2016-11-30 16:00:00	NQ	Futures	5743.54	5753.99	5742.95	5749.81	11186.0
2016-11-30 18:00:00	NQ	Futures	5750.7	5754.58	5746.83	5752.2	960.0
2016-11-30 19:00:00	NQ	Futures	5752.2	5752.79	5746.83	5749.21	1043.0
2016-11-30 20:00:00	NQ	Futures	5749.51	5753.69	5748.91	5752.79	1357.0
2016-11-30 21:00:00	NQ	Futures	5753.09	5760.85	5751.9	5757.86	1340.0
2016-11-30 22:00:00	NQ	Futures	5757.57	5759.95	5754.28	5757.57	882.0
2016-11-30 23:00:00	NQ	Futures	5757.86	5759.36	5754.88	5756.67	538.0
2016-11-30 00:00:00	YM	Futures	20653.4	20657.7	20645.8	20646.9	800.0
2016-11-30 01:00:00	YM	Futures	20646.9	20665.3	20646.9	20665.3	1057.0
2016-11-30 02:00:00	YM	Futures	20664.2	20670.7	20660.9	20665.3	1367.0
2016-11-30 03:00:00	YM	Futures	20664.2	20697.7	20657.7	20688.0	5332.0

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

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