PREVIEW / futures_1hour / 2015-07-20

all futures 1-hour files

  file:    by_date/futures_1hour/2015/2015-07-20.parquet
  size:    48 KB
  rows:    1,520

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
2015-07-20 00:00:00	ES	Futures	2256.99	2257.25	2256.72	2256.99	450.0
2015-07-20 01:00:00	ES	Futures	2257.25	2257.79	2256.72	2257.25	1047.0
2015-07-20 02:00:00	ES	Futures	2257.25	2257.79	2256.99	2257.25	1501.0
2015-07-20 03:00:00	ES	Futures	2257.25	2258.58	2257.25	2258.32	3972.0
2015-07-20 04:00:00	ES	Futures	2258.58	2260.71	2258.05	2259.92	11581.0
2015-07-20 05:00:00	ES	Futures	2260.18	2260.45	2258.58	2259.65	7296.0
2015-07-20 06:00:00	ES	Futures	2259.38	2260.71	2258.32	2259.12	7949.0
2015-07-20 07:00:00	ES	Futures	2259.12	2259.65	2258.32	2259.65	7658.0
2015-07-20 08:00:00	ES	Futures	2259.92	2260.18	2257.79	2258.32	11296.0
2015-07-20 09:00:00	ES	Futures	2258.32	2260.18	2254.59	2255.66	174047.0
2015-07-20 10:00:00	ES	Futures	2255.92	2259.12	2254.06	2258.32	142323.0
2015-07-20 11:00:00	ES	Futures	2258.58	2261.51	2258.32	2260.18	98716.0
2015-07-20 12:00:00	ES	Futures	2260.18	2262.31	2259.92	2261.51	60973.0
2015-07-20 13:00:00	ES	Futures	2261.78	2262.84	2260.18	2260.45	73786.0
2015-07-20 14:00:00	ES	Futures	2260.71	2263.91	2260.45	2262.05	87765.0
2015-07-20 15:00:00	ES	Futures	2262.05	2264.44	2257.25	2258.32	176333.0
2015-07-20 16:00:00	ES	Futures	2258.32	2260.45	2256.99	2259.38	58980.0
2015-07-20 17:00:00	ES	Futures	2259.65	2260.45	2259.38	2260.45	1465.0
2015-07-20 18:00:00	ES	Futures	2259.12	2259.38	2257.52	2258.32	3389.0
2015-07-20 19:00:00	ES	Futures	2258.32	2259.12	2258.32	2259.12	1309.0
2015-07-20 20:00:00	ES	Futures	2258.85	2259.12	2257.79	2259.12	2078.0
2015-07-20 21:00:00	ES	Futures	2258.85	2259.12	2257.52	2258.58	2357.0
2015-07-20 22:00:00	ES	Futures	2258.58	2259.12	2258.05	2259.12	1431.0
2015-07-20 23:00:00	ES	Futures	2259.12	2260.45	2258.85	2259.38	1954.0
2015-07-20 00:00:00	NQ	Futures	5502.87	5502.87	5502.27	5502.87	94.0
2015-07-20 01:00:00	NQ	Futures	5502.87	5505.23	5502.57	5504.94	167.0
2015-07-20 02:00:00	NQ	Futures	5504.94	5505.23	5503.16	5504.35	204.0
2015-07-20 03:00:00	NQ	Futures	5504.64	5507.89	5504.64	5507.89	779.0
2015-07-20 04:00:00	NQ	Futures	5507.89	5512.04	5506.12	5509.37	1644.0
2015-07-20 05:00:00	NQ	Futures	5509.37	5509.97	5506.42	5509.67	938.0
2015-07-20 06:00:00	NQ	Futures	5509.37	5512.04	5507.6	5511.44	1741.0
2015-07-20 07:00:00	NQ	Futures	5511.44	5516.18	5510.56	5516.18	2032.0
2015-07-20 08:00:00	NQ	Futures	5516.47	5518.25	5514.11	5516.18	2464.0
2015-07-20 09:00:00	NQ	Futures	5516.47	5521.8	5501.98	5511.74	33930.0
2015-07-20 10:00:00	NQ	Futures	5512.04	5522.39	5499.91	5520.32	28247.0
2015-07-20 11:00:00	NQ	Futures	5520.32	5527.42	5518.84	5524.16	15365.0
2015-07-20 12:00:00	NQ	Futures	5523.87	5530.37	5520.61	5528.9	13411.0
2015-07-20 13:00:00	NQ	Futures	5528.9	5535.99	5527.71	5528.9	14181.0
2015-07-20 14:00:00	NQ	Futures	5528.9	5541.91	5528.3	5540.14	16745.0
2015-07-20 15:00:00	NQ	Futures	5540.14	5544.28	5521.21	5524.75	26632.0
2015-07-20 16:00:00	NQ	Futures	5524.75	5528.3	5521.8	5526.23	6018.0
2015-07-20 17:00:00	NQ	Futures	5526.23	5530.08	5525.64	5528.6	289.0
2015-07-20 18:00:00	NQ	Futures	5526.83	5527.71	5522.39	5524.16	662.0
2015-07-20 19:00:00	NQ	Futures	5524.46	5528.01	5524.46	5527.71	493.0
2015-07-20 20:00:00	NQ	Futures	5527.42	5528.01	5524.46	5527.71	507.0
2015-07-20 21:00:00	NQ	Futures	5527.42	5527.42	5523.57	5526.53	297.0
2015-07-20 22:00:00	NQ	Futures	5526.83	5528.6	5525.94	5528.6	256.0
2015-07-20 23:00:00	NQ	Futures	5528.6	5532.15	5528.01	5530.08	398.0
2015-07-20 00:00:00	YM	Futures	18970.7	18970.7	18968.6	18970.7	55.0
2015-07-20 01:00:00	YM	Futures	18970.7	18976.0	18968.6	18973.9	167.0

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

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