PREVIEW / futures_1hour / 2016-04-21

all futures 1-hour files

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

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-21 00:00:00	ES	Futures	2271.34	2271.61	2270.26	2270.8	3586.0
2016-04-21 01:00:00	ES	Futures	2270.53	2271.88	2269.45	2271.07	4426.0
2016-04-21 02:00:00	ES	Futures	2271.07	2271.88	2267.83	2268.37	12146.0
2016-04-21 03:00:00	ES	Futures	2268.37	2270.26	2264.86	2267.29	40961.0
2016-04-21 04:00:00	ES	Futures	2267.29	2269.45	2266.48	2268.64	26246.0
2016-04-21 05:00:00	ES	Futures	2268.37	2268.91	2265.67	2267.02	21203.0
2016-04-21 06:00:00	ES	Futures	2267.02	2267.83	2264.05	2267.02	18793.0
2016-04-21 07:00:00	ES	Futures	2267.29	2268.1	2265.13	2265.13	19407.0
2016-04-21 08:00:00	ES	Futures	2265.13	2269.72	2264.05	2265.4	52051.0
2016-04-21 09:00:00	ES	Futures	2265.4	2266.48	2258.11	2258.11	224235.0
2016-04-21 10:00:00	ES	Futures	2258.11	2264.86	2256.22	2263.51	270911.0
2016-04-21 11:00:00	ES	Futures	2263.51	2265.13	2257.3	2257.84	146990.0
2016-04-21 12:00:00	ES	Futures	2257.84	2260.27	2255.68	2256.76	110664.0
2016-04-21 13:00:00	ES	Futures	2256.76	2259.19	2252.44	2253.52	127057.0
2016-04-21 14:00:00	ES	Futures	2253.25	2254.33	2248.66	2251.63	142159.0
2016-04-21 15:00:00	ES	Futures	2251.9	2254.33	2248.93	2252.17	227553.0
2016-04-21 16:00:00	ES	Futures	2252.17	2255.68	2244.88	2248.93	140013.0
2016-04-21 18:00:00	ES	Futures	2245.96	2247.58	2243.8	2247.04	6949.0
2016-04-21 19:00:00	ES	Futures	2247.04	2248.66	2246.5	2247.04	4698.0
2016-04-21 20:00:00	ES	Futures	2247.04	2250.28	2245.96	2247.85	8114.0
2016-04-21 21:00:00	ES	Futures	2247.85	2251.36	2247.31	2250.82	6617.0
2016-04-21 22:00:00	ES	Futures	2250.82	2251.63	2250.01	2250.55	5405.0
2016-04-21 23:00:00	ES	Futures	2250.55	2251.09	2248.66	2248.93	3867.0
2016-04-21 00:00:00	NQ	Futures	5412.66	5413.26	5409.09	5409.98	668.0
2016-04-21 01:00:00	NQ	Futures	5410.28	5414.15	5406.71	5412.36	704.0
2016-04-21 02:00:00	NQ	Futures	5411.47	5414.45	5401.06	5402.84	1342.0
2016-04-21 03:00:00	NQ	Futures	5403.73	5407.9	5390.64	5398.68	4859.0
2016-04-21 04:00:00	NQ	Futures	5397.49	5406.11	5395.4	5404.63	3000.0
2016-04-21 05:00:00	NQ	Futures	5404.33	5406.71	5396.3	5399.27	1983.0
2016-04-21 06:00:00	NQ	Futures	5398.97	5401.06	5389.16	5399.57	3026.0
2016-04-21 07:00:00	NQ	Futures	5399.57	5402.25	5393.62	5396.0	2355.0
2016-04-21 08:00:00	NQ	Futures	5396.0	5408.49	5392.73	5395.7	5741.0
2016-04-21 09:00:00	NQ	Futures	5395.7	5399.57	5372.49	5378.74	34749.0
2016-04-21 10:00:00	NQ	Futures	5378.74	5412.66	5373.68	5411.17	37037.0
2016-04-21 11:00:00	NQ	Futures	5411.17	5417.12	5389.16	5390.35	25266.0
2016-04-21 12:00:00	NQ	Futures	5390.35	5397.78	5383.2	5390.35	17999.0
2016-04-21 13:00:00	NQ	Futures	5390.05	5402.25	5385.88	5392.73	17058.0
2016-04-21 14:00:00	NQ	Futures	5392.73	5395.4	5381.42	5391.24	18712.0
2016-04-21 15:00:00	NQ	Futures	5390.94	5400.76	5385.59	5396.89	25205.0
2016-04-21 16:00:00	NQ	Futures	5397.19	5407.6	5341.25	5355.83	29953.0
2016-04-21 18:00:00	NQ	Futures	5341.55	5341.55	5328.46	5336.2	2683.0
2016-04-21 19:00:00	NQ	Futures	5336.49	5341.85	5336.2	5338.28	746.0
2016-04-21 20:00:00	NQ	Futures	5337.98	5346.61	5336.2	5340.06	1514.0
2016-04-21 21:00:00	NQ	Futures	5340.36	5348.39	5339.47	5347.5	900.0
2016-04-21 22:00:00	NQ	Futures	5347.5	5349.88	5345.42	5346.91	1025.0
2016-04-21 23:00:00	NQ	Futures	5347.2	5347.2	5340.36	5341.85	789.0
2016-04-21 00:00:00	YM	Futures	19346.2	19349.4	19336.6	19337.7	499.0
2016-04-21 01:00:00	YM	Futures	19340.9	19350.5	19330.2	19347.3	606.0
2016-04-21 02:00:00	YM	Futures	19345.2	19350.5	19319.5	19325.9	1081.0
2016-04-21 03:00:00	YM	Futures	19325.9	19343.0	19300.2	19325.9	4836.0

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

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