PREVIEW / futures_1hour / 2014-02-12

all futures 1-hour files

  file:    by_date/futures_1hour/2014/2014-02-12.parquet
  size:    51 KB
  rows:    1,567

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-02-12 00:00:00	ES	Futures	1876.79	1880.67	1876.53	1880.67	10265.0
2014-02-12 01:00:00	ES	Futures	1880.41	1880.93	1878.6	1879.12	3871.0
2014-02-12 02:00:00	ES	Futures	1879.37	1880.41	1878.34	1879.63	6796.0
2014-02-12 03:00:00	ES	Futures	1879.89	1880.15	1878.08	1879.63	21450.0
2014-02-12 04:00:00	ES	Futures	1879.37	1881.44	1878.86	1881.44	18518.0
2014-02-12 05:00:00	ES	Futures	1881.19	1881.96	1879.12	1879.37	16979.0
2014-02-12 06:00:00	ES	Futures	1879.37	1879.89	1875.75	1876.01	22782.0
2014-02-12 07:00:00	ES	Futures	1876.01	1877.56	1874.98	1876.01	22068.0
2014-02-12 08:00:00	ES	Futures	1876.27	1877.56	1874.72	1877.56	28583.0
2014-02-12 09:00:00	ES	Futures	1877.56	1886.36	1877.31	1885.58	216105.0
2014-02-12 10:00:00	ES	Futures	1885.84	1886.36	1877.05	1878.34	276779.0
2014-02-12 11:00:00	ES	Futures	1878.6	1881.19	1874.72	1876.79	164070.0
2014-02-12 12:00:00	ES	Futures	1877.05	1880.41	1875.75	1879.63	86127.0
2014-02-12 13:00:00	ES	Futures	1879.63	1881.96	1878.34	1880.41	88988.0
2014-02-12 14:00:00	ES	Futures	1880.41	1881.19	1875.24	1876.53	123361.0
2014-02-12 15:00:00	ES	Futures	1876.53	1879.37	1875.49	1878.86	147417.0
2014-02-12 16:00:00	ES	Futures	1878.86	1880.41	1878.6	1879.63	74060.0
2014-02-12 17:00:00	ES	Futures	1879.63	1879.89	1879.37	1879.63	935.0
2014-02-12 18:00:00	ES	Futures	1879.63	1879.63	1877.56	1878.08	3827.0
2014-02-12 19:00:00	ES	Futures	1878.08	1879.37	1877.05	1877.82	4129.0
2014-02-12 20:00:00	ES	Futures	1877.82	1878.34	1875.49	1875.75	5903.0
2014-02-12 21:00:00	ES	Futures	1875.75	1878.34	1875.49	1878.08	4762.0
2014-02-12 22:00:00	ES	Futures	1878.08	1878.08	1875.49	1875.75	5224.0
2014-02-12 23:00:00	ES	Futures	1875.75	1876.01	1874.72	1875.24	4219.0
2014-02-12 00:00:00	NQ	Futures	4204.46	4210.28	4204.17	4209.99	727.0
2014-02-12 01:00:00	NQ	Futures	4209.99	4210.57	4205.63	4206.79	444.0
2014-02-12 02:00:00	NQ	Futures	4207.08	4209.99	4205.05	4208.24	820.0
2014-02-12 03:00:00	NQ	Futures	4208.53	4210.57	4205.05	4209.99	2195.0
2014-02-12 04:00:00	NQ	Futures	4209.99	4214.06	4209.41	4213.77	2265.0
2014-02-12 05:00:00	NQ	Futures	4213.48	4214.93	4209.7	4210.57	1849.0
2014-02-12 06:00:00	NQ	Futures	4210.57	4211.44	4201.85	4202.14	3134.0
2014-02-12 07:00:00	NQ	Futures	4202.14	4205.92	4201.56	4203.01	2606.0
2014-02-12 08:00:00	NQ	Futures	4203.3	4207.95	4201.56	4207.95	4640.0
2014-02-12 09:00:00	NQ	Futures	4207.66	4223.94	4207.66	4223.65	41941.0
2014-02-12 10:00:00	NQ	Futures	4223.65	4224.81	4206.79	4207.95	43436.0
2014-02-12 11:00:00	NQ	Futures	4207.95	4217.54	4203.01	4207.66	26048.0
2014-02-12 12:00:00	NQ	Futures	4207.37	4216.96	4205.05	4214.93	21717.0
2014-02-12 13:00:00	NQ	Futures	4215.22	4221.61	4213.48	4218.71	23695.0
2014-02-12 14:00:00	NQ	Futures	4218.71	4221.03	4209.11	4212.02	32493.0
2014-02-12 15:00:00	NQ	Futures	4212.02	4215.22	4207.37	4214.64	31862.0
2014-02-12 16:00:00	NQ	Futures	4214.64	4219.29	4211.15	4211.44	7360.0
2014-02-12 17:00:00	NQ	Futures	4211.44	4212.6	4211.15	4212.02	220.0
2014-02-12 18:00:00	NQ	Futures	4212.89	4213.18	4207.37	4209.7	564.0
2014-02-12 19:00:00	NQ	Futures	4209.41	4212.31	4207.08	4208.24	547.0
2014-02-12 20:00:00	NQ	Futures	4208.53	4209.41	4203.88	4204.17	714.0
2014-02-12 21:00:00	NQ	Futures	4204.46	4209.7	4204.46	4209.41	622.0
2014-02-12 22:00:00	NQ	Futures	4209.41	4209.41	4203.88	4204.75	813.0
2014-02-12 23:00:00	NQ	Futures	4204.17	4205.34	4202.43	4202.43	527.0
2014-02-12 00:00:00	YM	Futures	16338.8	16370.6	16338.8	16370.6	1062.0
2014-02-12 01:00:00	YM	Futures	16368.5	16371.6	16353.1	16357.2	771.0

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

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