PREVIEW / futures_1hour / 2017-08-15

all futures 1-hour files

  file:    by_date/futures_1hour/2017/2017-08-15.parquet
  size:    52 KB
  rows:    1,608

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
2017-08-15 00:00:00	ES	Futures	2701.69	2701.69	2699.22	2699.77	3870.0
2017-08-15 01:00:00	ES	Futures	2699.77	2700.59	2698.95	2699.5	4384.0
2017-08-15 02:00:00	ES	Futures	2699.77	2700.04	2697.58	2699.5	11656.0
2017-08-15 03:00:00	ES	Futures	2699.5	2700.32	2696.22	2696.76	22766.0
2017-08-15 04:00:00	ES	Futures	2696.76	2698.68	2695.4	2697.31	17358.0
2017-08-15 05:00:00	ES	Futures	2697.58	2699.22	2697.31	2697.86	8729.0
2017-08-15 06:00:00	ES	Futures	2697.86	2699.5	2696.76	2699.5	14030.0
2017-08-15 07:00:00	ES	Futures	2699.22	2700.87	2698.95	2699.77	14487.0
2017-08-15 08:00:00	ES	Futures	2699.5	2701.41	2697.58	2699.5	34460.0
2017-08-15 09:00:00	ES	Futures	2699.5	2700.59	2692.39	2695.94	163422.0
2017-08-15 10:00:00	ES	Futures	2695.94	2696.76	2689.66	2692.39	185547.0
2017-08-15 11:00:00	ES	Futures	2692.39	2695.12	2691.84	2692.12	86243.0
2017-08-15 12:00:00	ES	Futures	2692.12	2695.12	2691.84	2693.76	51563.0
2017-08-15 13:00:00	ES	Futures	2694.03	2694.03	2690.2	2692.39	76927.0
2017-08-15 14:00:00	ES	Futures	2692.12	2695.67	2692.12	2694.85	59941.0
2017-08-15 15:00:00	ES	Futures	2694.85	2697.86	2692.94	2693.48	157929.0
2017-08-15 16:00:00	ES	Futures	2693.48	2695.12	2692.94	2694.85	71956.0
2017-08-15 18:00:00	ES	Futures	2694.58	2695.4	2691.57	2693.21	6678.0
2017-08-15 19:00:00	ES	Futures	2693.21	2693.21	2691.3	2692.39	2484.0
2017-08-15 20:00:00	ES	Futures	2692.39	2694.58	2691.57	2691.57	5847.0
2017-08-15 21:00:00	ES	Futures	2691.84	2693.21	2691.84	2692.66	4634.0
2017-08-15 22:00:00	ES	Futures	2692.66	2693.21	2691.84	2692.39	2326.0
2017-08-15 23:00:00	ES	Futures	2692.39	2692.94	2692.12	2692.94	1855.0
2017-08-15 00:00:00	NQ	Futures	7071.59	7071.59	7063.55	7064.45	714.0
2017-08-15 01:00:00	NQ	Futures	7064.74	7067.72	7063.26	7063.85	923.0
2017-08-15 02:00:00	NQ	Futures	7064.15	7064.45	7056.41	7060.28	2129.0
2017-08-15 03:00:00	NQ	Futures	7060.58	7065.64	7051.05	7051.94	2450.0
2017-08-15 04:00:00	NQ	Futures	7051.94	7058.19	7047.47	7054.02	2463.0
2017-08-15 05:00:00	NQ	Futures	7054.62	7058.79	7053.43	7054.92	1163.0
2017-08-15 06:00:00	NQ	Futures	7055.22	7057.6	7051.64	7057.3	3254.0
2017-08-15 07:00:00	NQ	Futures	7057.0	7062.06	7057.0	7062.06	3236.0
2017-08-15 08:00:00	NQ	Futures	7061.77	7063.55	7047.77	7054.32	6664.0
2017-08-15 09:00:00	NQ	Futures	7054.32	7056.11	7025.44	7039.43	45574.0
2017-08-15 10:00:00	NQ	Futures	7039.73	7043.9	7021.57	7034.08	48133.0
2017-08-15 11:00:00	NQ	Futures	7033.78	7047.18	7030.2	7032.29	27650.0
2017-08-15 12:00:00	NQ	Futures	7032.29	7049.86	7031.69	7045.69	17804.0
2017-08-15 13:00:00	NQ	Futures	7045.69	7045.99	7031.4	7035.27	23410.0
2017-08-15 14:00:00	NQ	Futures	7035.56	7044.2	7034.67	7041.52	16253.0
2017-08-15 15:00:00	NQ	Futures	7041.52	7052.54	7038.84	7040.63	26043.0
2017-08-15 16:00:00	NQ	Futures	7040.63	7044.79	7038.84	7043.31	5757.0
2017-08-15 18:00:00	NQ	Futures	7045.09	7045.69	7033.48	7037.05	1404.0
2017-08-15 19:00:00	NQ	Futures	7037.35	7037.35	7030.5	7033.78	689.0
2017-08-15 20:00:00	NQ	Futures	7033.78	7042.11	7031.4	7032.59	1599.0
2017-08-15 21:00:00	NQ	Futures	7032.88	7040.33	7031.99	7036.76	1961.0
2017-08-15 22:00:00	NQ	Futures	7036.76	7037.65	7032.29	7033.48	727.0
2017-08-15 23:00:00	NQ	Futures	7033.78	7037.65	7033.78	7037.35	429.0
2017-08-15 00:00:00	YM	Futures	23973.8	23973.8	23959.7	23961.8	563.0
2017-08-15 01:00:00	YM	Futures	23962.9	23966.2	23957.5	23960.8	706.0
2017-08-15 02:00:00	YM	Futures	23959.7	23961.8	23951.0	23956.4	1655.0
2017-08-15 03:00:00	YM	Futures	23957.5	23965.1	23934.6	23939.0	3126.0

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

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