PREVIEW / futures_1hour / 2015-08-17

all futures 1-hour files

  file:    by_date/futures_1hour/2015/2015-08-17.parquet
  size:    47 KB
  rows:    1,494

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
2015-08-17 00:00:00	ES	Futures	2223.17	2224.5	2223.17	2223.71	1677.0
2015-08-17 01:00:00	ES	Futures	2223.44	2225.84	2223.44	2225.3	2194.0
2015-08-17 02:00:00	ES	Futures	2225.04	2227.7	2224.77	2227.17	5479.0
2015-08-17 03:00:00	ES	Futures	2226.9	2230.63	2220.78	2222.37	31600.0
2015-08-17 04:00:00	ES	Futures	2222.37	2224.5	2219.71	2224.5	20915.0
2015-08-17 05:00:00	ES	Futures	2224.24	2225.84	2223.44	2225.04	8104.0
2015-08-17 06:00:00	ES	Futures	2225.04	2225.3	2222.37	2223.71	12791.0
2015-08-17 07:00:00	ES	Futures	2223.71	2224.5	2221.58	2222.91	19834.0
2015-08-17 08:00:00	ES	Futures	2222.64	2222.91	2214.65	2216.25	64394.0
2015-08-17 09:00:00	ES	Futures	2215.98	2218.11	2209.59	2211.99	233528.0
2015-08-17 10:00:00	ES	Futures	2211.99	2226.1	2210.66	2225.57	279384.0
2015-08-17 11:00:00	ES	Futures	2225.57	2229.83	2225.57	2227.43	147830.0
2015-08-17 12:00:00	ES	Futures	2227.43	2232.23	2227.17	2231.69	75831.0
2015-08-17 13:00:00	ES	Futures	2231.69	2234.09	2231.16	2232.23	86369.0
2015-08-17 14:00:00	ES	Futures	2232.49	2234.09	2231.16	2233.56	67995.0
2015-08-17 15:00:00	ES	Futures	2233.56	2235.69	2231.96	2235.69	131332.0
2015-08-17 16:00:00	ES	Futures	2235.69	2237.02	2234.89	2235.15	72912.0
2015-08-17 17:00:00	ES	Futures	2234.89	2235.42	2234.62	2235.15	1220.0
2015-08-17 18:00:00	ES	Futures	2234.62	2236.75	2234.36	2235.42	2706.0
2015-08-17 19:00:00	ES	Futures	2235.69	2235.95	2234.89	2235.42	1828.0
2015-08-17 20:00:00	ES	Futures	2235.42	2240.48	2235.42	2239.68	8105.0
2015-08-17 21:00:00	ES	Futures	2239.41	2239.95	2238.88	2239.15	3070.0
2015-08-17 22:00:00	ES	Futures	2239.15	2239.15	2237.02	2237.28	3208.0
2015-08-17 23:00:00	ES	Futures	2237.02	2238.35	2236.49	2237.28	2526.0
2015-08-17 00:00:00	NQ	Futures	5360.0	5362.66	5358.82	5359.41	272.0
2015-08-17 01:00:00	NQ	Futures	5359.7	5365.62	5359.7	5364.14	273.0
2015-08-17 02:00:00	NQ	Futures	5364.14	5370.35	5362.37	5369.47	1025.0
2015-08-17 03:00:00	NQ	Futures	5369.47	5378.93	5353.79	5359.41	5143.0
2015-08-17 04:00:00	NQ	Futures	5358.52	5365.62	5352.31	5365.32	3398.0
2015-08-17 05:00:00	NQ	Futures	5364.44	5368.58	5362.96	5366.8	1004.0
2015-08-17 06:00:00	NQ	Futures	5366.8	5367.1	5358.52	5362.07	2215.0
2015-08-17 07:00:00	NQ	Futures	5361.48	5362.96	5356.15	5358.23	4209.0
2015-08-17 08:00:00	NQ	Futures	5358.52	5360.0	5338.7	5344.32	8537.0
2015-08-17 09:00:00	NQ	Futures	5344.03	5348.17	5328.05	5337.82	35854.0
2015-08-17 10:00:00	NQ	Futures	5337.52	5373.31	5333.67	5371.54	45296.0
2015-08-17 11:00:00	NQ	Futures	5371.24	5383.96	5370.94	5376.27	23289.0
2015-08-17 12:00:00	NQ	Futures	5376.27	5388.69	5373.61	5387.8	11149.0
2015-08-17 13:00:00	NQ	Futures	5388.1	5396.97	5386.92	5393.13	13096.0
2015-08-17 14:00:00	NQ	Futures	5392.83	5399.34	5389.58	5395.49	10487.0
2015-08-17 15:00:00	NQ	Futures	5395.49	5400.82	5391.06	5399.34	16399.0
2015-08-17 16:00:00	NQ	Futures	5399.04	5404.37	5398.45	5399.64	5514.0
2015-08-17 17:00:00	NQ	Futures	5399.64	5399.93	5397.27	5397.86	245.0
2015-08-17 18:00:00	NQ	Futures	5398.16	5402.0	5397.86	5399.93	319.0
2015-08-17 19:00:00	NQ	Futures	5399.93	5402.59	5398.75	5401.41	269.0
2015-08-17 20:00:00	NQ	Futures	5402.3	5411.17	5400.52	5409.1	1025.0
2015-08-17 21:00:00	NQ	Futures	5409.4	5410.28	5407.03	5407.33	800.0
2015-08-17 22:00:00	NQ	Futures	5407.92	5407.92	5401.41	5401.41	537.0
2015-08-17 23:00:00	NQ	Futures	5402.0	5404.37	5401.11	5403.19	415.0
2015-08-17 00:00:00	YM	Futures	18356.5	18366.0	18354.4	18355.5	448.0
2015-08-17 01:00:00	YM	Futures	18356.5	18373.4	18356.5	18369.2	440.0

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

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