PREVIEW / futures_1hour / 2016-04-13

all futures 1-hour files

  file:    by_date/futures_1hour/2016/2016-04-13.parquet
  size:    54 KB
  rows:    1,634

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-13 00:00:00	ES	Futures	2225.72	2225.72	2224.37	2225.18	2924.0
2016-04-13 01:00:00	ES	Futures	2225.18	2226.25	2224.37	2225.45	5985.0
2016-04-13 02:00:00	ES	Futures	2225.45	2227.87	2223.83	2224.1	21820.0
2016-04-13 03:00:00	ES	Futures	2223.83	2230.03	2222.21	2229.76	37972.0
2016-04-13 04:00:00	ES	Futures	2229.76	2230.84	2228.41	2230.3	23756.0
2016-04-13 05:00:00	ES	Futures	2230.03	2234.62	2230.03	2231.65	36084.0
2016-04-13 06:00:00	ES	Futures	2231.65	2233.27	2229.76	2233.0	20116.0
2016-04-13 07:00:00	ES	Futures	2233.27	2234.08	2231.38	2232.19	28386.0
2016-04-13 08:00:00	ES	Futures	2232.46	2232.73	2228.41	2229.76	48830.0
2016-04-13 09:00:00	ES	Futures	2229.76	2235.97	2229.76	2234.08	215899.0
2016-04-13 10:00:00	ES	Futures	2233.81	2235.7	2228.95	2231.38	236166.0
2016-04-13 11:00:00	ES	Futures	2231.38	2239.48	2230.84	2237.05	232719.0
2016-04-13 12:00:00	ES	Futures	2236.78	2237.59	2233.0	2235.43	126803.0
2016-04-13 13:00:00	ES	Futures	2235.43	2238.67	2232.19	2238.13	109097.0
2016-04-13 14:00:00	ES	Futures	2238.13	2240.29	2236.24	2237.32	132400.0
2016-04-13 15:00:00	ES	Futures	2237.05	2242.99	2236.78	2241.91	231330.0
2016-04-13 16:00:00	ES	Futures	2241.64	2242.18	2240.83	2241.64	82260.0
2016-04-13 18:00:00	ES	Futures	2242.18	2242.45	2240.83	2241.37	5219.0
2016-04-13 19:00:00	ES	Futures	2241.1	2242.45	2240.56	2241.91	4002.0
2016-04-13 20:00:00	ES	Futures	2241.91	2242.18	2238.94	2239.21	7956.0
2016-04-13 21:00:00	ES	Futures	2239.21	2241.1	2237.86	2238.13	9042.0
2016-04-13 22:00:00	ES	Futures	2238.13	2240.02	2237.59	2239.75	5218.0
2016-04-13 23:00:00	ES	Futures	2239.75	2240.02	2237.86	2238.94	3657.0
2016-04-13 00:00:00	NQ	Futures	5364.16	5364.46	5360.59	5361.78	604.0
2016-04-13 01:00:00	NQ	Futures	5361.49	5364.46	5359.11	5360.89	672.0
2016-04-13 02:00:00	NQ	Futures	5361.19	5369.52	5359.11	5359.4	2686.0
2016-04-13 03:00:00	NQ	Futures	5359.4	5376.36	5355.53	5376.36	4269.0
2016-04-13 04:00:00	NQ	Futures	5376.06	5379.34	5370.71	5377.55	2755.0
2016-04-13 05:00:00	NQ	Futures	5377.25	5389.75	5377.25	5383.2	3334.0
2016-04-13 06:00:00	NQ	Futures	5382.61	5385.29	5378.15	5383.2	3293.0
2016-04-13 07:00:00	NQ	Futures	5383.5	5386.18	5379.93	5383.5	2668.0
2016-04-13 08:00:00	NQ	Futures	5383.2	5384.4	5375.47	5377.85	5468.0
2016-04-13 09:00:00	NQ	Futures	5377.85	5407.01	5376.36	5401.95	38349.0
2016-04-13 10:00:00	NQ	Futures	5402.25	5411.47	5389.75	5391.54	40686.0
2016-04-13 11:00:00	NQ	Futures	5391.24	5409.98	5387.97	5396.3	26906.0
2016-04-13 12:00:00	NQ	Futures	5396.0	5400.16	5385.88	5394.21	18193.0
2016-04-13 13:00:00	NQ	Futures	5393.92	5395.7	5382.91	5392.43	14732.0
2016-04-13 14:00:00	NQ	Futures	5392.73	5403.14	5386.78	5394.81	16790.0
2016-04-13 15:00:00	NQ	Futures	5395.11	5419.5	5394.21	5410.88	33239.0
2016-04-13 16:00:00	NQ	Futures	5411.17	5414.45	5408.49	5413.55	5595.0
2016-04-13 18:00:00	NQ	Futures	5410.88	5414.15	5410.28	5412.96	465.0
2016-04-13 19:00:00	NQ	Futures	5412.96	5415.04	5410.88	5413.85	468.0
2016-04-13 20:00:00	NQ	Futures	5413.85	5414.15	5406.11	5407.9	848.0
2016-04-13 21:00:00	NQ	Futures	5407.6	5413.26	5403.44	5404.33	932.0
2016-04-13 22:00:00	NQ	Futures	5404.92	5410.28	5403.73	5409.39	459.0
2016-04-13 23:00:00	NQ	Futures	5409.98	5409.98	5404.03	5407.01	418.0
2016-04-13 00:00:00	YM	Futures	18926.6	18929.8	18920.2	18925.6	425.0
2016-04-13 01:00:00	YM	Futures	18925.6	18932.0	18917.0	18923.4	794.0
2016-04-13 02:00:00	YM	Futures	18923.4	18945.9	18913.8	18917.0	3321.0
2016-04-13 03:00:00	YM	Futures	18915.9	18964.1	18906.3	18959.8	4790.0

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

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