PREVIEW / futures_1hour / 2014-06-17

all futures 1-hour files

  file:    by_date/futures_1hour/2014/2014-06-17.parquet
  size:    47 KB
  rows:    1,526

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
2014-06-17 00:00:00	ES	Futures	2013.76	2014.29	2013.24	2014.29	1122.0
2014-06-17 01:00:00	ES	Futures	2014.29	2014.55	2012.98	2013.24	1621.0
2014-06-17 02:00:00	ES	Futures	2013.24	2014.02	2012.98	2012.98	3336.0
2014-06-17 03:00:00	ES	Futures	2012.98	2016.89	2012.72	2015.59	27949.0
2014-06-17 04:00:00	ES	Futures	2015.85	2017.15	2015.33	2016.89	10125.0
2014-06-17 05:00:00	ES	Futures	2016.89	2016.89	2014.02	2014.29	11303.0
2014-06-17 06:00:00	ES	Futures	2014.29	2014.55	2011.42	2011.68	19478.0
2014-06-17 07:00:00	ES	Futures	2011.42	2014.81	2011.42	2013.76	11230.0
2014-06-17 08:00:00	ES	Futures	2013.5	2014.02	2005.42	2007.51	69445.0
2014-06-17 09:00:00	ES	Futures	2007.51	2012.98	2005.95	2011.94	202427.0
2014-06-17 10:00:00	ES	Futures	2011.68	2015.85	2008.29	2010.64	199623.0
2014-06-17 11:00:00	ES	Futures	2010.64	2014.02	2008.29	2014.02	126245.0
2014-06-17 12:00:00	ES	Futures	2014.02	2016.63	2012.98	2015.59	69967.0
2014-06-17 13:00:00	ES	Futures	2015.85	2017.67	2013.76	2016.63	90466.0
2014-06-17 14:00:00	ES	Futures	2016.89	2017.93	2014.55	2017.15	71345.0
2014-06-17 15:00:00	ES	Futures	2017.15	2017.93	2014.81	2016.63	159343.0
2014-06-17 16:00:00	ES	Futures	2016.37	2016.63	2015.59	2016.63	73110.0
2014-06-17 17:00:00	ES	Futures	2016.37	2016.63	2015.85	2016.11	1670.0
2014-06-17 18:00:00	ES	Futures	2015.59	2016.63	2015.59	2016.37	1984.0
2014-06-17 19:00:00	ES	Futures	2016.63	2016.63	2015.59	2015.85	2912.0
2014-06-17 20:00:00	ES	Futures	2015.85	2015.85	2015.07	2015.59	2717.0
2014-06-17 21:00:00	ES	Futures	2015.59	2016.11	2015.07	2015.85	2078.0
2014-06-17 22:00:00	ES	Futures	2016.11	2016.63	2015.59	2016.37	1300.0
2014-06-17 23:00:00	ES	Futures	2016.63	2017.15	2016.37	2016.89	2254.0
2014-06-17 00:00:00	NQ	Futures	4411.76	4412.93	4410.88	4412.34	116.0
2014-06-17 01:00:00	NQ	Futures	4412.93	4413.22	4410.59	4410.88	235.0
2014-06-17 02:00:00	NQ	Futures	4410.59	4413.8	4410.3	4410.59	966.0
2014-06-17 03:00:00	NQ	Futures	4410.59	4422.27	4409.13	4416.43	5833.0
2014-06-17 04:00:00	NQ	Futures	4416.72	4420.81	4415.26	4419.64	1891.0
2014-06-17 05:00:00	NQ	Futures	4419.64	4420.81	4414.09	4416.72	2523.0
2014-06-17 06:00:00	NQ	Futures	4416.43	4416.72	4409.71	4410.88	2320.0
2014-06-17 07:00:00	NQ	Futures	4410.88	4417.01	4410.88	4414.97	2274.0
2014-06-17 08:00:00	NQ	Futures	4415.26	4415.55	4398.03	4402.41	9395.0
2014-06-17 09:00:00	NQ	Futures	4402.12	4414.97	4395.41	4413.22	34201.0
2014-06-17 10:00:00	NQ	Futures	4413.22	4421.1	4402.71	4407.09	33760.0
2014-06-17 11:00:00	NQ	Futures	4407.09	4412.05	4397.16	4410.88	23304.0
2014-06-17 12:00:00	NQ	Futures	4410.88	4416.72	4408.84	4414.09	12395.0
2014-06-17 13:00:00	NQ	Futures	4414.09	4418.77	4409.42	4416.43	12420.0
2014-06-17 14:00:00	NQ	Futures	4416.43	4419.35	4412.05	4417.6	8393.0
2014-06-17 15:00:00	NQ	Futures	4417.89	4418.18	4407.38	4408.25	24097.0
2014-06-17 16:00:00	NQ	Futures	4407.96	4409.13	4404.46	4408.55	6614.0
2014-06-17 17:00:00	NQ	Futures	4408.55	4409.13	4407.38	4407.38	113.0
2014-06-17 18:00:00	NQ	Futures	4407.38	4409.71	4406.5	4409.13	250.0
2014-06-17 19:00:00	NQ	Futures	4408.84	4408.84	4406.79	4407.09	161.0
2014-06-17 20:00:00	NQ	Futures	4406.79	4407.38	4404.75	4406.79	222.0
2014-06-17 21:00:00	NQ	Futures	4406.5	4407.96	4405.63	4407.67	183.0
2014-06-17 22:00:00	NQ	Futures	4407.67	4409.13	4407.38	4409.13	242.0
2014-06-17 23:00:00	NQ	Futures	4409.13	4410.88	4408.55	4409.71	385.0
2014-06-17 00:00:00	YM	Futures	17299.0	17302.1	17292.8	17300.0	117.0
2014-06-17 01:00:00	YM	Futures	17301.1	17303.1	17294.9	17294.9	316.0

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

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