PREVIEW / futures_1hour / 2016-01-29

all futures 1-hour files

  file:    by_date/futures_1hour/2016/2016-01-29.parquet
  size:    48 KB
  rows:    1,355

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-01-29 00:00:00	ES	Futures	2029.56	2041.38	2029.29	2035.47	27469.0
2016-01-29 01:00:00	ES	Futures	2035.74	2041.38	2033.05	2041.11	19253.0
2016-01-29 02:00:00	ES	Futures	2041.11	2043.26	2037.62	2042.99	25195.0
2016-01-29 03:00:00	ES	Futures	2042.73	2045.14	2033.59	2039.23	40281.0
2016-01-29 04:00:00	ES	Futures	2039.23	2045.68	2038.96	2042.19	27692.0
2016-01-29 05:00:00	ES	Futures	2042.19	2044.88	2032.52	2036.28	27901.0
2016-01-29 06:00:00	ES	Futures	2036.01	2038.16	2032.78	2036.55	21380.0
2016-01-29 07:00:00	ES	Futures	2036.28	2040.85	2034.4	2034.93	23654.0
2016-01-29 08:00:00	ES	Futures	2034.93	2038.96	2029.29	2037.89	59419.0
2016-01-29 09:00:00	ES	Futures	2037.89	2049.71	2034.13	2048.37	274115.0
2016-01-29 10:00:00	ES	Futures	2048.37	2054.55	2045.14	2047.56	330765.0
2016-01-29 11:00:00	ES	Futures	2047.56	2057.77	2046.76	2056.97	259764.0
2016-01-29 12:00:00	ES	Futures	2056.97	2063.15	2055.09	2062.34	154427.0
2016-01-29 13:00:00	ES	Futures	2062.34	2066.1	2059.65	2063.69	132091.0
2016-01-29 14:00:00	ES	Futures	2063.69	2067.98	2059.92	2064.49	148020.0
2016-01-29 15:00:00	ES	Futures	2064.76	2076.58	2063.69	2075.78	469189.0
2016-01-29 16:00:00	ES	Futures	2075.78	2077.66	2072.55	2075.78	179267.0
2016-01-29 00:00:00	NQ	Futures	4941.83	4974.19	4941.23	4960.24	5718.0
2016-01-29 01:00:00	NQ	Futures	4960.83	4976.27	4954.6	4975.08	2692.0
2016-01-29 02:00:00	NQ	Futures	4975.38	4980.43	4965.29	4979.24	3291.0
2016-01-29 03:00:00	NQ	Futures	4979.54	4984.59	4955.78	4971.22	6569.0
2016-01-29 04:00:00	NQ	Futures	4970.63	4986.66	4970.33	4978.65	4743.0
2016-01-29 05:00:00	NQ	Futures	4978.94	4986.07	4954.6	4964.1	4759.0
2016-01-29 06:00:00	NQ	Futures	4964.1	4969.74	4953.71	4962.02	4664.0
2016-01-29 07:00:00	NQ	Futures	4962.32	4972.71	4960.24	4962.61	4050.0
2016-01-29 08:00:00	NQ	Futures	4962.32	4966.47	4945.39	4963.8	8979.0
2016-01-29 09:00:00	NQ	Futures	4964.4	5012.2	4954.3	5005.97	46983.0
2016-01-29 10:00:00	NQ	Futures	5005.67	5023.48	4995.87	4999.14	44747.0
2016-01-29 11:00:00	NQ	Futures	4999.73	5026.45	4996.17	5022.3	31858.0
2016-01-29 12:00:00	NQ	Futures	5022.3	5043.68	5017.84	5040.71	27251.0
2016-01-29 13:00:00	NQ	Futures	5040.71	5046.35	5030.02	5040.71	17833.0
2016-01-29 14:00:00	NQ	Futures	5041.0	5051.69	5032.1	5038.33	16880.0
2016-01-29 15:00:00	NQ	Futures	5038.03	5068.91	5036.55	5066.84	45099.0
2016-01-29 16:00:00	NQ	Futures	5066.54	5073.07	5061.19	5071.29	17165.0
2016-01-29 00:00:00	YM	Futures	17075.3	17163.6	17074.2	17126.4	4777.0
2016-01-29 01:00:00	YM	Futures	17127.5	17166.8	17108.3	17164.7	3196.0
2016-01-29 02:00:00	YM	Futures	17164.7	17179.6	17138.1	17177.5	2931.0
2016-01-29 03:00:00	YM	Futures	17177.5	17191.3	17097.7	17142.4	8077.0
2016-01-29 04:00:00	YM	Futures	17142.4	17192.4	17142.4	17165.8	5164.0
2016-01-29 05:00:00	YM	Futures	17165.8	17189.2	17094.5	17118.9	4629.0
2016-01-29 06:00:00	YM	Futures	17118.9	17137.0	17097.7	17129.6	2828.0
2016-01-29 07:00:00	YM	Futures	17128.5	17162.6	17117.9	17123.2	2904.0
2016-01-29 08:00:00	YM	Futures	17124.3	17151.9	17081.7	17142.4	7320.0
2016-01-29 09:00:00	YM	Futures	17141.3	17228.6	17097.7	17216.9	26928.0
2016-01-29 10:00:00	YM	Futures	17217.9	17260.5	17184.9	17214.7	32062.0
2016-01-29 11:00:00	YM	Futures	17215.8	17275.4	17197.7	17272.2	22654.0
2016-01-29 12:00:00	YM	Futures	17272.2	17318.0	17259.5	17312.7	11310.0
2016-01-29 13:00:00	YM	Futures	17313.7	17346.7	17298.8	17323.3	10321.0
2016-01-29 14:00:00	YM	Futures	17323.3	17354.2	17304.2	17331.8	10916.0
2016-01-29 15:00:00	YM	Futures	17331.8	17424.4	17324.4	17420.2	23776.0

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

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