PREVIEW / futures_1hour / 2016-04-05

all futures 1-hour files

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

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-05 00:00:00	ES	Futures	2215.46	2216.54	2215.19	2215.46	4197.0
2016-04-05 01:00:00	ES	Futures	2215.73	2215.73	2212.49	2213.84	6577.0
2016-04-05 02:00:00	ES	Futures	2213.84	2216.54	2211.68	2211.68	18998.0
2016-04-05 03:00:00	ES	Futures	2211.68	2213.84	2203.31	2206.55	70363.0
2016-04-05 04:00:00	ES	Futures	2206.28	2208.17	2202.23	2206.55	38900.0
2016-04-05 05:00:00	ES	Futures	2206.55	2207.09	2200.61	2202.23	38200.0
2016-04-05 06:00:00	ES	Futures	2201.96	2205.74	2201.42	2205.2	27930.0
2016-04-05 07:00:00	ES	Futures	2205.2	2207.9	2203.04	2204.93	36219.0
2016-04-05 08:00:00	ES	Futures	2204.93	2206.82	2201.96	2204.39	47124.0
2016-04-05 09:00:00	ES	Futures	2204.39	2208.98	2199.53	2204.39	255545.0
2016-04-05 10:00:00	ES	Futures	2204.39	2211.68	2201.96	2202.77	327861.0
2016-04-05 11:00:00	ES	Futures	2202.77	2208.44	2202.23	2204.12	173698.0
2016-04-05 12:00:00	ES	Futures	2204.12	2206.55	2200.07	2201.42	134648.0
2016-04-05 13:00:00	ES	Futures	2201.42	2206.01	2198.99	2204.12	126666.0
2016-04-05 14:00:00	ES	Futures	2204.12	2209.52	2203.04	2208.17	112478.0
2016-04-05 15:00:00	ES	Futures	2207.9	2208.71	2196.83	2200.34	252480.0
2016-04-05 16:00:00	ES	Futures	2200.34	2205.47	2200.07	2204.93	84606.0
2016-04-05 18:00:00	ES	Futures	2205.2	2206.28	2204.66	2205.2	3837.0
2016-04-05 19:00:00	ES	Futures	2205.2	2207.09	2204.93	2206.01	5052.0
2016-04-05 20:00:00	ES	Futures	2206.01	2208.98	2206.01	2206.01	9882.0
2016-04-05 21:00:00	ES	Futures	2206.01	2210.33	2205.2	2209.79	10609.0
2016-04-05 22:00:00	ES	Futures	2209.52	2213.3	2208.98	2212.49	12743.0
2016-04-05 23:00:00	ES	Futures	2212.49	2213.03	2211.14	2212.49	5151.0
2016-04-05 00:00:00	NQ	Futures	5345.12	5348.39	5344.53	5345.42	526.0
2016-04-05 01:00:00	NQ	Futures	5345.72	5345.72	5337.09	5340.06	768.0
2016-04-05 02:00:00	NQ	Futures	5340.36	5346.01	5333.52	5334.71	1548.0
2016-04-05 03:00:00	NQ	Futures	5334.41	5340.66	5314.48	5321.62	7129.0
2016-04-05 04:00:00	NQ	Futures	5321.02	5326.08	5315.07	5325.48	4612.0
2016-04-05 05:00:00	NQ	Futures	5325.48	5327.57	5314.18	5318.94	3013.0
2016-04-05 06:00:00	NQ	Futures	5318.34	5326.08	5316.26	5325.19	2707.0
2016-04-05 07:00:00	NQ	Futures	5325.19	5328.76	5315.07	5318.94	4817.0
2016-04-05 08:00:00	NQ	Futures	5319.24	5325.19	5312.99	5318.64	5612.0
2016-04-05 09:00:00	NQ	Futures	5318.64	5326.97	5305.25	5316.26	35736.0
2016-04-05 10:00:00	NQ	Futures	5316.26	5340.96	5315.67	5323.7	43950.0
2016-04-05 11:00:00	NQ	Futures	5323.7	5335.6	5313.29	5316.86	23190.0
2016-04-05 12:00:00	NQ	Futures	5316.56	5323.7	5303.76	5310.31	18702.0
2016-04-05 13:00:00	NQ	Futures	5310.61	5329.95	5305.25	5323.4	13415.0
2016-04-05 14:00:00	NQ	Futures	5323.4	5336.49	5318.34	5333.52	11540.0
2016-04-05 15:00:00	NQ	Futures	5332.92	5335.3	5304.36	5312.1	27192.0
2016-04-05 16:00:00	NQ	Futures	5312.1	5327.86	5311.5	5326.97	6192.0
2016-04-05 18:00:00	NQ	Futures	5326.97	5328.76	5325.19	5326.67	480.0
2016-04-05 19:00:00	NQ	Futures	5325.78	5331.43	5325.78	5329.35	762.0
2016-04-05 20:00:00	NQ	Futures	5329.35	5337.98	5329.35	5331.43	1340.0
2016-04-05 21:00:00	NQ	Futures	5331.14	5342.74	5328.16	5341.55	1454.0
2016-04-05 22:00:00	NQ	Futures	5340.96	5351.37	5339.77	5348.1	1531.0
2016-04-05 23:00:00	NQ	Futures	5347.8	5350.18	5346.01	5348.99	667.0
2016-04-05 00:00:00	YM	Futures	18841.0	18850.6	18837.8	18842.1	960.0
2016-04-05 01:00:00	YM	Futures	18843.1	18843.1	18817.5	18828.2	1157.0
2016-04-05 02:00:00	YM	Futures	18827.1	18845.3	18808.9	18811.0	1526.0
2016-04-05 03:00:00	YM	Futures	18811.0	18827.1	18751.1	18772.5	8184.0

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

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