PREVIEW / futures_1hour / 2017-02-03

all futures 1-hour files

  file:    by_date/futures_1hour/2017/2017-02-03.parquet
  size:    46 KB
  rows:    1,354

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-02-03 00:00:00	ES	Futures	2478.92	2479.47	2478.11	2479.2	2584.0
2017-02-03 01:00:00	ES	Futures	2479.47	2480.56	2479.2	2480.29	2142.0
2017-02-03 02:00:00	ES	Futures	2480.29	2484.11	2480.29	2483.83	8306.0
2017-02-03 03:00:00	ES	Futures	2484.11	2487.38	2482.2	2486.02	19447.0
2017-02-03 04:00:00	ES	Futures	2486.02	2486.29	2484.38	2484.93	9587.0
2017-02-03 05:00:00	ES	Futures	2484.93	2486.02	2484.38	2485.2	9135.0
2017-02-03 06:00:00	ES	Futures	2484.93	2488.2	2484.65	2486.56	13130.0
2017-02-03 07:00:00	ES	Futures	2486.56	2487.38	2486.02	2486.29	11148.0
2017-02-03 08:00:00	ES	Futures	2486.29	2494.74	2485.74	2493.65	94068.0
2017-02-03 09:00:00	ES	Futures	2493.93	2495.84	2490.93	2493.93	188883.0
2017-02-03 10:00:00	ES	Futures	2493.65	2501.56	2493.38	2499.93	279263.0
2017-02-03 11:00:00	ES	Futures	2499.93	2502.66	2497.75	2499.38	182604.0
2017-02-03 12:00:00	ES	Futures	2499.65	2501.56	2499.38	2500.75	74576.0
2017-02-03 13:00:00	ES	Futures	2501.02	2501.84	2498.84	2499.38	84951.0
2017-02-03 14:00:00	ES	Futures	2499.11	2501.84	2499.11	2501.02	63690.0
2017-02-03 15:00:00	ES	Futures	2500.75	2502.93	2499.38	2500.75	228197.0
2017-02-03 16:00:00	ES	Futures	2500.75	2501.29	2498.56	2500.47	107609.0
2017-02-03 00:00:00	NQ	Futures	6114.66	6116.15	6112.87	6114.06	667.0
2017-02-03 01:00:00	NQ	Futures	6114.06	6119.43	6114.06	6119.43	520.0
2017-02-03 02:00:00	NQ	Futures	6119.14	6128.38	6118.54	6128.38	1822.0
2017-02-03 03:00:00	NQ	Futures	6128.09	6135.54	6123.01	6132.56	3613.0
2017-02-03 04:00:00	NQ	Futures	6132.56	6132.56	6125.7	6126.89	1859.0
2017-02-03 05:00:00	NQ	Futures	6126.59	6129.88	6125.4	6126.59	1371.0
2017-02-03 06:00:00	NQ	Futures	6126.59	6134.05	6126.0	6129.28	1862.0
2017-02-03 07:00:00	NQ	Futures	6128.98	6131.67	6126.0	6127.49	1781.0
2017-02-03 08:00:00	NQ	Futures	6127.49	6145.39	6123.61	6143.0	13957.0
2017-02-03 09:00:00	NQ	Futures	6143.3	6152.25	6138.83	6145.99	33670.0
2017-02-03 10:00:00	NQ	Futures	6145.69	6160.01	6141.51	6148.97	34075.0
2017-02-03 11:00:00	NQ	Futures	6148.97	6155.83	6136.14	6142.11	22293.0
2017-02-03 12:00:00	NQ	Futures	6142.11	6148.97	6141.21	6145.99	10245.0
2017-02-03 13:00:00	NQ	Futures	6145.99	6148.97	6141.81	6144.49	10103.0
2017-02-03 14:00:00	NQ	Futures	6144.2	6151.35	6144.2	6149.86	9329.0
2017-02-03 15:00:00	NQ	Futures	6149.56	6154.34	6148.37	6152.55	22148.0
2017-02-03 16:00:00	NQ	Futures	6152.55	6155.23	6149.86	6154.93	5769.0
2017-02-03 00:00:00	YM	Futures	21476.2	21486.0	21471.9	21480.5	861.0
2017-02-03 01:00:00	YM	Futures	21480.5	21490.3	21480.5	21490.3	481.0
2017-02-03 02:00:00	YM	Futures	21489.2	21514.2	21487.0	21513.1	1985.0
2017-02-03 03:00:00	YM	Futures	21514.2	21536.9	21500.1	21529.3	3434.0
2017-02-03 04:00:00	YM	Futures	21528.3	21529.3	21515.2	21519.6	1855.0
2017-02-03 05:00:00	YM	Futures	21519.6	21528.3	21517.4	21523.9	1308.0
2017-02-03 06:00:00	YM	Futures	21521.8	21550.0	21520.7	21536.9	2357.0
2017-02-03 07:00:00	YM	Futures	21538.0	21548.9	21536.9	21544.5	1520.0
2017-02-03 08:00:00	YM	Futures	21544.5	21610.7	21541.3	21596.6	14167.0
2017-02-03 09:00:00	YM	Futures	21596.6	21624.8	21584.7	21618.3	20530.0
2017-02-03 10:00:00	YM	Futures	21619.4	21673.6	21614.0	21663.9	25124.0
2017-02-03 11:00:00	YM	Futures	21663.9	21693.1	21650.8	21667.1	15438.0
2017-02-03 12:00:00	YM	Futures	21668.2	21682.3	21661.7	21680.1	6417.0
2017-02-03 13:00:00	YM	Futures	21681.2	21688.8	21664.9	21669.3	6778.0
2017-02-03 14:00:00	YM	Futures	21669.3	21691.0	21668.2	21683.4	6582.0
2017-02-03 15:00:00	YM	Futures	21682.3	21702.9	21673.6	21684.5	14555.0

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

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