PREVIEW / futures_1hour / 2015-08-10

all futures 1-hour files

  file:    by_date/futures_1hour/2015/2015-08-10.parquet
  size:    50 KB
  rows:    1,530

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-10 00:00:00	ES	Futures	2213.59	2214.92	2213.32	2214.92	1866.0
2015-08-10 01:00:00	ES	Futures	2214.65	2215.72	2214.12	2215.19	3014.0
2015-08-10 02:00:00	ES	Futures	2214.92	2215.98	2214.39	2215.19	5848.0
2015-08-10 03:00:00	ES	Futures	2215.19	2215.98	2209.59	2211.19	23129.0
2015-08-10 04:00:00	ES	Futures	2211.19	2215.45	2208.8	2214.65	20457.0
2015-08-10 05:00:00	ES	Futures	2214.92	2215.45	2212.79	2213.06	10548.0
2015-08-10 06:00:00	ES	Futures	2213.06	2216.25	2211.99	2214.65	14416.0
2015-08-10 07:00:00	ES	Futures	2214.65	2218.91	2214.39	2217.32	21348.0
2015-08-10 08:00:00	ES	Futures	2217.05	2224.77	2217.05	2222.91	50834.0
2015-08-10 09:00:00	ES	Futures	2222.91	2230.89	2221.58	2228.5	247157.0
2015-08-10 10:00:00	ES	Futures	2228.5	2231.43	2227.17	2230.36	172911.0
2015-08-10 11:00:00	ES	Futures	2230.36	2233.56	2230.1	2231.96	140293.0
2015-08-10 12:00:00	ES	Futures	2232.23	2233.82	2231.69	2233.56	56313.0
2015-08-10 13:00:00	ES	Futures	2233.56	2234.89	2233.02	2234.89	58309.0
2015-08-10 14:00:00	ES	Futures	2234.89	2237.28	2233.82	2234.62	99009.0
2015-08-10 15:00:00	ES	Futures	2234.89	2236.22	2232.76	2236.22	146645.0
2015-08-10 16:00:00	ES	Futures	2235.95	2237.82	2234.89	2237.28	88899.0
2015-08-10 17:00:00	ES	Futures	2237.02	2237.55	2236.75	2237.55	1875.0
2015-08-10 18:00:00	ES	Futures	2237.28	2238.35	2236.22	2236.49	5461.0
2015-08-10 19:00:00	ES	Futures	2236.49	2237.28	2235.95	2237.28	1364.0
2015-08-10 20:00:00	ES	Futures	2237.02	2237.28	2235.69	2236.22	2935.0
2015-08-10 21:00:00	ES	Futures	2236.22	2236.75	2234.62	2234.89	7090.0
2015-08-10 22:00:00	ES	Futures	2234.89	2234.89	2225.57	2227.43	29057.0
2015-08-10 23:00:00	ES	Futures	2227.7	2229.3	2225.84	2226.37	12626.0
2015-08-10 00:00:00	NQ	Futures	5357.34	5360.89	5356.45	5360.59	280.0
2015-08-10 01:00:00	NQ	Futures	5360.3	5362.96	5358.52	5361.48	440.0
2015-08-10 02:00:00	NQ	Futures	5361.77	5365.32	5360.0	5361.77	1020.0
2015-08-10 03:00:00	NQ	Futures	5362.07	5364.44	5347.58	5353.79	3741.0
2015-08-10 04:00:00	NQ	Futures	5353.2	5365.03	5346.39	5362.66	2703.0
2015-08-10 05:00:00	NQ	Futures	5363.25	5365.03	5357.34	5360.0	1772.0
2015-08-10 06:00:00	NQ	Futures	5360.0	5368.28	5357.04	5364.14	2807.0
2015-08-10 07:00:00	NQ	Futures	5363.85	5373.9	5362.37	5367.99	3737.0
2015-08-10 08:00:00	NQ	Futures	5367.69	5383.66	5367.69	5378.63	7011.0
2015-08-10 09:00:00	NQ	Futures	5378.63	5410.58	5376.86	5395.79	40740.0
2015-08-10 10:00:00	NQ	Futures	5396.09	5403.78	5382.48	5390.17	28056.0
2015-08-10 11:00:00	NQ	Futures	5390.76	5410.28	5390.47	5404.07	24254.0
2015-08-10 12:00:00	NQ	Futures	5404.07	5407.92	5399.04	5402.0	7365.0
2015-08-10 13:00:00	NQ	Futures	5402.0	5409.4	5401.71	5408.51	6952.0
2015-08-10 14:00:00	NQ	Futures	5408.51	5418.86	5404.96	5407.62	22765.0
2015-08-10 15:00:00	NQ	Futures	5407.92	5411.47	5399.34	5405.55	26833.0
2015-08-10 16:00:00	NQ	Futures	5405.55	5415.61	5400.52	5415.02	11888.0
2015-08-10 17:00:00	NQ	Futures	5415.02	5418.57	5414.43	5418.27	575.0
2015-08-10 18:00:00	NQ	Futures	5421.82	5424.48	5417.97	5418.86	1393.0
2015-08-10 19:00:00	NQ	Futures	5418.86	5421.52	5417.68	5421.23	258.0
2015-08-10 20:00:00	NQ	Futures	5420.93	5420.93	5416.5	5418.86	556.0
2015-08-10 21:00:00	NQ	Futures	5418.86	5420.05	5415.31	5415.61	1253.0
2015-08-10 22:00:00	NQ	Futures	5415.31	5415.61	5392.24	5397.86	3539.0
2015-08-10 23:00:00	NQ	Futures	5398.16	5400.23	5393.42	5394.31	1523.0
2015-08-10 00:00:00	YM	Futures	18280.7	18292.3	18277.5	18291.2	372.0
2015-08-10 01:00:00	YM	Futures	18292.3	18296.5	18287.0	18294.4	467.0

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

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