PREVIEW / futures_1hour / 2016-04-06

all futures 1-hour files

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

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-04-06 00:00:00	ES	Futures	2212.76	2212.76	2210.33	2210.6	3862.0
2016-04-06 01:00:00	ES	Futures	2210.6	2211.14	2207.63	2209.25	5567.0
2016-04-06 02:00:00	ES	Futures	2209.25	2211.95	2209.25	2209.79	10726.0
2016-04-06 03:00:00	ES	Futures	2209.79	2212.49	2206.82	2209.52	38799.0
2016-04-06 04:00:00	ES	Futures	2209.52	2209.79	2203.58	2209.79	33302.0
2016-04-06 05:00:00	ES	Futures	2209.52	2210.6	2208.98	2209.25	18213.0
2016-04-06 06:00:00	ES	Futures	2209.25	2209.25	2204.66	2205.2	20418.0
2016-04-06 07:00:00	ES	Futures	2205.47	2207.9	2204.66	2206.55	20410.0
2016-04-06 08:00:00	ES	Futures	2206.82	2207.36	2201.96	2202.77	38654.0
2016-04-06 09:00:00	ES	Futures	2202.77	2204.93	2197.64	2201.96	228854.0
2016-04-06 10:00:00	ES	Futures	2201.69	2210.87	2198.18	2210.87	339299.0
2016-04-06 11:00:00	ES	Futures	2210.6	2216.27	2210.06	2215.46	241847.0
2016-04-06 12:00:00	ES	Futures	2215.46	2216.0	2212.76	2214.38	124924.0
2016-04-06 13:00:00	ES	Futures	2214.38	2218.7	2214.11	2215.73	94443.0
2016-04-06 14:00:00	ES	Futures	2216.0	2216.54	2209.25	2216.0	243662.0
2016-04-06 15:00:00	ES	Futures	2215.73	2225.18	2214.65	2224.37	309569.0
2016-04-06 16:00:00	ES	Futures	2224.1	2225.18	2222.75	2223.83	70717.0
2016-04-06 18:00:00	ES	Futures	2224.37	2224.37	2222.21	2222.48	4559.0
2016-04-06 19:00:00	ES	Futures	2222.48	2223.56	2222.21	2223.02	2887.0
2016-04-06 20:00:00	ES	Futures	2223.29	2224.37	2221.13	2223.02	9124.0
2016-04-06 21:00:00	ES	Futures	2223.02	2226.79	2222.75	2224.64	10925.0
2016-04-06 22:00:00	ES	Futures	2224.64	2224.91	2221.4	2221.94	8550.0
2016-04-06 23:00:00	ES	Futures	2221.67	2223.56	2220.59	2223.02	6877.0
2016-04-06 00:00:00	NQ	Futures	5348.99	5349.29	5340.96	5341.85	990.0
2016-04-06 01:00:00	NQ	Futures	5342.15	5342.74	5334.11	5337.68	1010.0
2016-04-06 02:00:00	NQ	Futures	5337.98	5345.12	5337.98	5340.06	1187.0
2016-04-06 03:00:00	NQ	Futures	5339.77	5345.72	5330.84	5335.3	3829.0
2016-04-06 04:00:00	NQ	Futures	5335.9	5336.79	5319.24	5336.49	3592.0
2016-04-06 05:00:00	NQ	Futures	5336.49	5341.55	5336.2	5338.28	2097.0
2016-04-06 06:00:00	NQ	Futures	5337.98	5338.58	5326.67	5329.05	2994.0
2016-04-06 07:00:00	NQ	Futures	5329.05	5331.73	5324.29	5330.54	2371.0
2016-04-06 08:00:00	NQ	Futures	5330.54	5332.03	5319.83	5322.51	3738.0
2016-04-06 09:00:00	NQ	Futures	5322.51	5335.9	5316.56	5331.73	33097.0
2016-04-06 10:00:00	NQ	Futures	5331.73	5348.99	5317.45	5348.99	44099.0
2016-04-06 11:00:00	NQ	Futures	5348.99	5366.84	5346.31	5364.16	31001.0
2016-04-06 12:00:00	NQ	Futures	5364.16	5369.52	5356.13	5365.35	14021.0
2016-04-06 13:00:00	NQ	Futures	5365.06	5379.04	5365.06	5372.49	12483.0
2016-04-06 14:00:00	NQ	Futures	5372.49	5378.15	5358.21	5376.96	30409.0
2016-04-06 15:00:00	NQ	Futures	5376.96	5400.46	5374.58	5398.68	40705.0
2016-04-06 16:00:00	NQ	Futures	5398.97	5398.97	5393.62	5393.62	5733.0
2016-04-06 18:00:00	NQ	Futures	5395.4	5396.59	5390.94	5392.43	1137.0
2016-04-06 19:00:00	NQ	Futures	5392.13	5395.4	5391.24	5393.62	507.0
2016-04-06 20:00:00	NQ	Futures	5393.92	5396.89	5389.16	5392.73	1014.0
2016-04-06 21:00:00	NQ	Futures	5392.73	5402.54	5392.43	5397.49	1289.0
2016-04-06 22:00:00	NQ	Futures	5397.78	5398.08	5388.26	5388.56	1477.0
2016-04-06 23:00:00	NQ	Futures	5388.86	5392.43	5386.18	5391.83	1071.0
2016-04-06 00:00:00	YM	Futures	18842.1	18843.1	18820.7	18823.9	1003.0
2016-04-06 01:00:00	YM	Futures	18822.8	18826.0	18800.3	18815.3	1020.0
2016-04-06 02:00:00	YM	Futures	18815.3	18835.7	18814.2	18820.7	1339.0
2016-04-06 03:00:00	YM	Futures	18818.5	18839.9	18790.7	18816.4	5291.0

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

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