PREVIEW / futures_1hour / 2017-09-22

all futures 1-hour files

  file:    by_date/futures_1hour/2017/2017-09-22.parquet
  size:    43 KB
  rows:    1,318

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-09-22 00:00:00	ES	Futures	2729.29	2729.57	2728.47	2729.57	3021.0
2017-09-22 01:00:00	ES	Futures	2729.29	2730.94	2729.29	2730.11	7687.0
2017-09-22 02:00:00	ES	Futures	2730.11	2731.21	2729.57	2730.94	7696.0
2017-09-22 03:00:00	ES	Futures	2730.94	2732.3	2730.39	2731.76	17153.0
2017-09-22 04:00:00	ES	Futures	2731.76	2733.12	2730.94	2732.3	16262.0
2017-09-22 05:00:00	ES	Futures	2732.3	2733.94	2730.66	2733.67	17784.0
2017-09-22 06:00:00	ES	Futures	2733.67	2734.77	2732.85	2734.49	16462.0
2017-09-22 07:00:00	ES	Futures	2734.49	2734.49	2730.94	2731.21	17796.0
2017-09-22 08:00:00	ES	Futures	2731.48	2731.76	2730.11	2730.11	18490.0
2017-09-22 09:00:00	ES	Futures	2730.11	2733.12	2729.29	2731.21	154784.0
2017-09-22 10:00:00	ES	Futures	2731.21	2734.49	2730.94	2731.21	114145.0
2017-09-22 11:00:00	ES	Futures	2730.94	2733.12	2730.39	2732.85	81878.0
2017-09-22 12:00:00	ES	Futures	2732.85	2733.67	2731.48	2731.48	82840.0
2017-09-22 13:00:00	ES	Futures	2731.48	2732.85	2730.39	2732.58	67724.0
2017-09-22 14:00:00	ES	Futures	2732.3	2733.12	2731.48	2732.85	72432.0
2017-09-22 15:00:00	ES	Futures	2732.85	2736.68	2732.58	2734.49	151512.0
2017-09-22 16:00:00	ES	Futures	2734.22	2736.13	2732.58	2735.31	99659.0
2017-09-22 00:00:00	NQ	Futures	7041.93	7044.9	7038.95	7044.9	843.0
2017-09-22 01:00:00	NQ	Futures	7044.61	7050.85	7044.01	7048.47	2234.0
2017-09-22 02:00:00	NQ	Futures	7048.17	7051.45	7045.5	7049.36	1359.0
2017-09-22 03:00:00	NQ	Futures	7049.36	7054.72	7048.77	7052.93	3180.0
2017-09-22 04:00:00	NQ	Futures	7052.64	7057.39	7051.15	7053.53	2553.0
2017-09-22 05:00:00	NQ	Futures	7054.12	7061.56	7049.66	7059.77	3061.0
2017-09-22 06:00:00	NQ	Futures	7060.07	7062.75	7056.5	7061.26	2171.0
2017-09-22 07:00:00	NQ	Futures	7061.26	7061.86	7046.99	7047.88	3489.0
2017-09-22 08:00:00	NQ	Futures	7047.88	7052.34	7045.5	7048.47	4816.0
2017-09-22 09:00:00	NQ	Futures	7048.17	7067.21	7039.85	7051.45	48323.0
2017-09-22 10:00:00	NQ	Futures	7051.74	7070.48	7045.5	7046.09	52220.0
2017-09-22 11:00:00	NQ	Futures	7046.09	7055.02	7045.2	7053.83	30392.0
2017-09-22 12:00:00	NQ	Futures	7053.53	7059.48	7047.58	7049.66	20639.0
2017-09-22 13:00:00	NQ	Futures	7049.66	7055.31	7037.47	7052.64	23296.0
2017-09-22 14:00:00	NQ	Futures	7052.64	7060.37	7049.07	7058.29	17159.0
2017-09-22 15:00:00	NQ	Futures	7058.58	7067.21	7052.93	7061.56	28288.0
2017-09-22 16:00:00	NQ	Futures	7061.86	7064.53	7057.39	7062.15	7985.0
2017-09-22 00:00:00	YM	Futures	24227.1	24231.4	24221.6	24231.4	702.0
2017-09-22 01:00:00	YM	Futures	24231.4	24241.2	24231.4	24239.0	1356.0
2017-09-22 02:00:00	YM	Futures	24239.0	24251.0	24233.6	24248.8	1743.0
2017-09-22 03:00:00	YM	Futures	24248.8	24263.0	24242.3	24256.4	2182.0
2017-09-22 04:00:00	YM	Futures	24256.4	24267.3	24248.8	24260.8	1399.0
2017-09-22 05:00:00	YM	Futures	24260.8	24278.2	24246.7	24278.2	2113.0
2017-09-22 06:00:00	YM	Futures	24278.2	24282.6	24264.1	24281.5	2386.0
2017-09-22 07:00:00	YM	Futures	24281.5	24281.5	24258.6	24260.8	1696.0
2017-09-22 08:00:00	YM	Futures	24260.8	24264.1	24248.8	24249.9	2344.0
2017-09-22 09:00:00	YM	Futures	24249.9	24276.0	24241.2	24260.8	25349.0
2017-09-22 10:00:00	YM	Futures	24261.9	24281.5	24232.5	24242.3	15142.0
2017-09-22 11:00:00	YM	Futures	24242.3	24252.1	24235.8	24251.0	7248.0
2017-09-22 12:00:00	YM	Futures	24251.0	24261.9	24233.6	24234.7	8086.0
2017-09-22 13:00:00	YM	Futures	24234.7	24246.7	24211.9	24241.2	10431.0
2017-09-22 14:00:00	YM	Futures	24240.1	24252.1	24234.7	24240.1	6422.0
2017-09-22 15:00:00	YM	Futures	24240.1	24277.1	24239.0	24259.7	8660.0

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

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