PREVIEW / futures_1hour / 2016-04-07

all futures 1-hour files

  file:    by_date/futures_1hour/2016/2016-04-07.parquet
  size:    55 KB
  rows:    1,613

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-07 00:00:00	ES	Futures	2223.29	2223.56	2221.67	2222.75	3038.0
2016-04-07 01:00:00	ES	Futures	2222.48	2224.1	2222.48	2223.56	4878.0
2016-04-07 02:00:00	ES	Futures	2223.56	2225.72	2222.48	2223.56	11243.0
2016-04-07 03:00:00	ES	Futures	2223.29	2224.37	2218.16	2220.05	43184.0
2016-04-07 04:00:00	ES	Futures	2220.05	2222.48	2218.7	2218.7	23775.0
2016-04-07 05:00:00	ES	Futures	2218.7	2219.24	2211.14	2213.84	38945.0
2016-04-07 06:00:00	ES	Futures	2213.57	2215.46	2211.95	2213.57	23033.0
2016-04-07 07:00:00	ES	Futures	2213.57	2216.27	2210.87	2212.49	30837.0
2016-04-07 08:00:00	ES	Futures	2212.49	2216.27	2211.95	2213.3	35991.0
2016-04-07 09:00:00	ES	Futures	2213.3	2214.65	2208.98	2212.22	228686.0
2016-04-07 10:00:00	ES	Futures	2211.95	2214.92	2202.5	2205.2	331661.0
2016-04-07 11:00:00	ES	Futures	2205.2	2205.47	2199.8	2203.58	225898.0
2016-04-07 12:00:00	ES	Futures	2203.58	2204.12	2198.45	2202.23	146891.0
2016-04-07 13:00:00	ES	Futures	2202.23	2206.28	2195.21	2195.75	155052.0
2016-04-07 14:00:00	ES	Futures	2196.02	2196.02	2188.19	2188.73	258473.0
2016-04-07 15:00:00	ES	Futures	2188.73	2198.72	2187.92	2197.37	332007.0
2016-04-07 16:00:00	ES	Futures	2197.37	2200.34	2196.56	2197.91	103882.0
2016-04-07 18:00:00	ES	Futures	2197.1	2197.1	2193.32	2194.4	7934.0
2016-04-07 19:00:00	ES	Futures	2194.67	2195.21	2192.51	2192.51	5781.0
2016-04-07 20:00:00	ES	Futures	2192.78	2197.37	2192.51	2196.02	11261.0
2016-04-07 21:00:00	ES	Futures	2196.29	2200.88	2196.02	2200.07	12169.0
2016-04-07 22:00:00	ES	Futures	2200.07	2200.61	2197.64	2198.18	6192.0
2016-04-07 23:00:00	ES	Futures	2198.45	2200.07	2197.1	2199.53	4736.0
2016-04-07 00:00:00	NQ	Futures	5392.43	5393.92	5388.86	5391.83	565.0
2016-04-07 01:00:00	NQ	Futures	5392.13	5396.0	5391.54	5394.81	574.0
2016-04-07 02:00:00	NQ	Futures	5395.4	5399.87	5393.02	5395.7	1392.0
2016-04-07 03:00:00	NQ	Futures	5395.11	5397.19	5381.72	5386.78	3593.0
2016-04-07 04:00:00	NQ	Futures	5386.48	5393.62	5383.8	5383.8	1548.0
2016-04-07 05:00:00	NQ	Futures	5383.8	5384.69	5365.65	5371.9	3889.0
2016-04-07 06:00:00	NQ	Futures	5371.9	5375.47	5367.14	5372.79	2417.0
2016-04-07 07:00:00	NQ	Futures	5373.09	5378.74	5366.25	5371.3	3603.0
2016-04-07 08:00:00	NQ	Futures	5371.3	5378.74	5368.33	5374.28	3833.0
2016-04-07 09:00:00	NQ	Futures	5373.98	5377.25	5355.24	5362.38	34765.0
2016-04-07 10:00:00	NQ	Futures	5362.38	5372.79	5332.62	5334.71	51274.0
2016-04-07 11:00:00	NQ	Futures	5334.41	5342.44	5321.02	5334.71	29173.0
2016-04-07 12:00:00	NQ	Futures	5335.01	5337.39	5323.1	5334.71	16709.0
2016-04-07 13:00:00	NQ	Futures	5334.41	5346.61	5316.26	5318.34	19810.0
2016-04-07 14:00:00	NQ	Futures	5318.05	5318.05	5298.71	5300.79	29174.0
2016-04-07 15:00:00	NQ	Futures	5300.49	5321.02	5296.92	5318.34	41766.0
2016-04-07 16:00:00	NQ	Futures	5318.05	5327.86	5315.67	5318.64	8124.0
2016-04-07 18:00:00	NQ	Futures	5316.86	5319.24	5308.52	5310.01	1127.0
2016-04-07 19:00:00	NQ	Futures	5310.61	5311.8	5305.85	5306.44	634.0
2016-04-07 20:00:00	NQ	Futures	5306.74	5319.24	5306.44	5315.07	1787.0
2016-04-07 21:00:00	NQ	Futures	5315.96	5327.27	5315.37	5324.29	2000.0
2016-04-07 22:00:00	NQ	Futures	5324.89	5327.86	5320.13	5322.81	1644.0
2016-04-07 23:00:00	NQ	Futures	5322.81	5328.46	5318.94	5325.78	847.0
2016-04-07 00:00:00	YM	Futures	18852.8	18857.1	18839.9	18850.6	884.0
2016-04-07 01:00:00	YM	Futures	18850.6	18863.5	18849.6	18860.3	829.0
2016-04-07 02:00:00	YM	Futures	18859.2	18874.2	18852.8	18860.3	1148.0
2016-04-07 03:00:00	YM	Futures	18860.3	18872.0	18819.6	18838.9	4744.0

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

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