PREVIEW / futures_1hour / 2014-06-18

all futures 1-hour files

  file:    by_date/futures_1hour/2014/2014-06-18.parquet
  size:    49 KB
  rows:    1,550

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-18 00:00:00	ES	Futures	2016.63	2017.67	2016.63	2017.41	1284.0
2014-06-18 01:00:00	ES	Futures	2017.41	2017.41	2016.37	2017.15	1834.0
2014-06-18 02:00:00	ES	Futures	2017.15	2017.15	2015.59	2015.85	4848.0
2014-06-18 03:00:00	ES	Futures	2015.85	2016.37	2014.81	2015.33	13204.0
2014-06-18 04:00:00	ES	Futures	2015.07	2017.67	2015.07	2016.37	12252.0
2014-06-18 05:00:00	ES	Futures	2016.37	2016.89	2015.07	2015.33	6796.0
2014-06-18 06:00:00	ES	Futures	2015.33	2016.89	2015.33	2016.37	8139.0
2014-06-18 07:00:00	ES	Futures	2016.37	2017.15	2015.59	2015.85	9113.0
2014-06-18 08:00:00	ES	Futures	2015.85	2016.89	2015.33	2016.37	12574.0
2014-06-18 09:00:00	ES	Futures	2016.37	2019.24	2015.07	2018.46	170763.0
2014-06-18 10:00:00	ES	Futures	2018.46	2019.24	2012.98	2013.24	155552.0
2014-06-18 11:00:00	ES	Futures	2012.98	2015.85	2012.46	2014.81	108172.0
2014-06-18 12:00:00	ES	Futures	2014.81	2017.41	2014.02	2017.15	62900.0
2014-06-18 13:00:00	ES	Futures	2016.89	2017.41	2013.24	2015.59	92534.0
2014-06-18 14:00:00	ES	Futures	2015.07	2025.75	2011.16	2024.45	352012.0
2014-06-18 15:00:00	ES	Futures	2024.71	2033.05	2024.45	2031.23	295887.0
2014-06-18 16:00:00	ES	Futures	2031.49	2032.53	2030.96	2031.49	99300.0
2014-06-18 17:00:00	ES	Futures	2031.49	2031.75	2031.23	2031.23	2052.0
2014-06-18 18:00:00	ES	Futures	2030.7	2032.01	2030.44	2031.75	5335.0
2014-06-18 19:00:00	ES	Futures	2031.75	2032.27	2030.96	2031.49	2693.0
2014-06-18 20:00:00	ES	Futures	2031.49	2032.27	2030.96	2032.27	3163.0
2014-06-18 21:00:00	ES	Futures	2032.27	2034.09	2032.01	2032.53	8944.0
2014-06-18 22:00:00	ES	Futures	2032.27	2033.31	2031.49	2032.79	4468.0
2014-06-18 23:00:00	ES	Futures	2032.79	2033.05	2032.01	2032.79	2066.0
2014-06-18 00:00:00	NQ	Futures	4409.71	4411.17	4409.42	4411.17	219.0
2014-06-18 01:00:00	NQ	Futures	4410.88	4411.17	4409.71	4411.17	273.0
2014-06-18 02:00:00	NQ	Futures	4411.17	4411.17	4407.96	4408.25	666.0
2014-06-18 03:00:00	NQ	Futures	4408.55	4411.76	4406.21	4410.59	3290.0
2014-06-18 04:00:00	NQ	Futures	4410.59	4414.97	4410.01	4412.05	2482.0
2014-06-18 05:00:00	NQ	Futures	4412.05	4413.22	4408.84	4409.42	1326.0
2014-06-18 06:00:00	NQ	Futures	4409.71	4413.22	4409.71	4412.63	917.0
2014-06-18 07:00:00	NQ	Futures	4412.34	4414.97	4410.88	4412.05	1684.0
2014-06-18 08:00:00	NQ	Futures	4412.05	4413.22	4410.59	4412.93	1957.0
2014-06-18 09:00:00	NQ	Futures	4412.63	4414.97	4405.04	4407.09	31016.0
2014-06-18 10:00:00	NQ	Futures	4407.09	4410.3	4397.74	4399.49	30307.0
2014-06-18 11:00:00	NQ	Futures	4399.79	4405.33	4397.74	4402.71	14267.0
2014-06-18 12:00:00	NQ	Futures	4402.71	4405.92	4399.49	4404.17	8763.0
2014-06-18 13:00:00	NQ	Futures	4404.17	4405.04	4389.86	4393.94	16021.0
2014-06-18 14:00:00	NQ	Futures	4393.07	4421.39	4386.06	4420.23	62170.0
2014-06-18 15:00:00	NQ	Futures	4420.23	4438.92	4419.35	4433.37	46712.0
2014-06-18 16:00:00	NQ	Futures	4433.37	4436.87	4432.49	4433.07	6897.0
2014-06-18 17:00:00	NQ	Futures	4433.37	4433.95	4432.2	4432.49	163.0
2014-06-18 18:00:00	NQ	Futures	4432.49	4434.24	4431.91	4433.95	640.0
2014-06-18 19:00:00	NQ	Futures	4433.95	4434.83	4432.2	4433.07	174.0
2014-06-18 20:00:00	NQ	Futures	4433.07	4435.7	4432.49	4435.12	500.0
2014-06-18 21:00:00	NQ	Futures	4435.12	4438.92	4435.12	4435.7	992.0
2014-06-18 22:00:00	NQ	Futures	4436.0	4437.46	4434.24	4437.16	437.0
2014-06-18 23:00:00	NQ	Futures	4436.87	4437.46	4435.7	4437.16	438.0
2014-06-18 00:00:00	YM	Futures	17312.5	17317.6	17311.4	17317.6	166.0
2014-06-18 01:00:00	YM	Futures	17316.6	17317.6	17309.4	17314.5	350.0

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

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