PREVIEW / futures_1hour / 2014-07-02

all futures 1-hour files

  file:    by_date/futures_1hour/2014/2014-07-02.parquet
  size:    48 KB
  rows:    1,546

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-07-02 00:00:00	ES	Futures	2050.51	2050.77	2049.47	2049.47	1173.0
2014-07-02 01:00:00	ES	Futures	2049.73	2051.03	2049.47	2049.99	1747.0
2014-07-02 02:00:00	ES	Futures	2049.99	2050.77	2049.47	2049.99	3706.0
2014-07-02 03:00:00	ES	Futures	2049.99	2051.03	2048.69	2050.25	14398.0
2014-07-02 04:00:00	ES	Futures	2050.51	2051.29	2049.99	2050.77	9165.0
2014-07-02 05:00:00	ES	Futures	2050.51	2051.55	2049.99	2050.77	7105.0
2014-07-02 06:00:00	ES	Futures	2050.51	2051.03	2049.47	2050.51	7552.0
2014-07-02 07:00:00	ES	Futures	2050.25	2051.55	2049.99	2051.29	7640.0
2014-07-02 08:00:00	ES	Futures	2051.29	2053.64	2050.25	2051.03	36716.0
2014-07-02 09:00:00	ES	Futures	2050.77	2052.07	2047.9	2049.99	160358.0
2014-07-02 10:00:00	ES	Futures	2050.25	2052.34	2048.69	2051.55	141020.0
2014-07-02 11:00:00	ES	Futures	2051.55	2053.64	2049.73	2050.51	131185.0
2014-07-02 12:00:00	ES	Futures	2050.51	2052.07	2049.21	2050.77	59713.0
2014-07-02 13:00:00	ES	Futures	2051.03	2051.29	2048.95	2050.25	61616.0
2014-07-02 14:00:00	ES	Futures	2050.25	2051.29	2048.69	2049.73	63981.0
2014-07-02 15:00:00	ES	Futures	2049.73	2051.29	2049.47	2051.29	132334.0
2014-07-02 16:00:00	ES	Futures	2051.29	2052.07	2050.51	2051.55	61903.0
2014-07-02 17:00:00	ES	Futures	2051.55	2052.34	2051.55	2051.81	1938.0
2014-07-02 18:00:00	ES	Futures	2051.55	2051.81	2050.77	2051.03	2330.0
2014-07-02 19:00:00	ES	Futures	2050.77	2051.29	2050.51	2050.51	3099.0
2014-07-02 20:00:00	ES	Futures	2050.77	2051.03	2049.73	2050.77	4178.0
2014-07-02 21:00:00	ES	Futures	2050.51	2050.77	2049.73	2049.99	1830.0
2014-07-02 22:00:00	ES	Futures	2049.99	2050.51	2049.73	2049.99	1169.0
2014-07-02 23:00:00	ES	Futures	2049.73	2050.51	2049.73	2050.25	1126.0
2014-07-02 00:00:00	NQ	Futures	4541.7	4541.7	4539.37	4539.37	152.0
2014-07-02 01:00:00	NQ	Futures	4539.37	4543.46	4539.37	4541.12	370.0
2014-07-02 02:00:00	NQ	Futures	4541.41	4542.29	4539.66	4540.54	429.0
2014-07-02 03:00:00	NQ	Futures	4541.12	4542.58	4538.2	4540.54	1971.0
2014-07-02 04:00:00	NQ	Futures	4540.54	4543.16	4540.24	4542.29	1381.0
2014-07-02 05:00:00	NQ	Futures	4542.29	4544.04	4540.54	4542.58	788.0
2014-07-02 06:00:00	NQ	Futures	4542.58	4542.58	4539.37	4541.41	716.0
2014-07-02 07:00:00	NQ	Futures	4541.41	4542.0	4540.54	4541.12	1265.0
2014-07-02 08:00:00	NQ	Futures	4541.12	4544.92	4539.95	4540.83	6319.0
2014-07-02 09:00:00	NQ	Futures	4540.83	4547.25	4537.03	4545.79	25910.0
2014-07-02 10:00:00	NQ	Futures	4545.79	4549.3	4539.66	4546.08	23865.0
2014-07-02 11:00:00	NQ	Futures	4545.79	4548.13	4537.32	4545.21	24844.0
2014-07-02 12:00:00	NQ	Futures	4545.21	4551.34	4544.33	4547.54	14646.0
2014-07-02 13:00:00	NQ	Futures	4547.54	4548.42	4541.7	4545.21	9874.0
2014-07-02 14:00:00	NQ	Futures	4545.21	4545.5	4535.57	4539.08	12238.0
2014-07-02 15:00:00	NQ	Futures	4539.08	4545.21	4539.08	4544.92	18825.0
2014-07-02 16:00:00	NQ	Futures	4544.92	4546.67	4543.46	4545.21	4265.0
2014-07-02 17:00:00	NQ	Futures	4545.5	4546.67	4544.92	4546.38	146.0
2014-07-02 18:00:00	NQ	Futures	4544.33	4544.92	4543.75	4544.62	310.0
2014-07-02 19:00:00	NQ	Futures	4544.62	4544.92	4543.16	4543.46	224.0
2014-07-02 20:00:00	NQ	Futures	4543.46	4544.04	4541.7	4542.87	477.0
2014-07-02 21:00:00	NQ	Futures	4542.87	4543.46	4541.7	4542.29	277.0
2014-07-02 22:00:00	NQ	Futures	4542.29	4543.16	4542.0	4542.29	149.0
2014-07-02 23:00:00	NQ	Futures	4542.29	4543.46	4542.29	4542.58	247.0
2014-07-02 00:00:00	YM	Futures	17469.7	17469.7	17460.4	17461.4	198.0
2014-07-02 01:00:00	YM	Futures	17461.4	17473.8	17461.4	17468.7	478.0

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

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