PREVIEW / futures_1hour / 2017-11-03

all futures 1-hour files

  file:    by_date/futures_1hour/2017/2017-11-03.parquet
  size:    44 KB
  rows:    1,326

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-11-03 00:00:00	ES	Futures	2820.66	2821.21	2820.39	2820.66	920.0
2017-11-03 01:00:00	ES	Futures	2820.66	2821.48	2820.66	2821.21	981.0
2017-11-03 02:00:00	ES	Futures	2820.94	2822.3	2820.66	2822.3	1208.0
2017-11-03 03:00:00	ES	Futures	2822.03	2822.3	2820.39	2820.94	6085.0
2017-11-03 04:00:00	ES	Futures	2820.66	2821.48	2818.75	2821.21	22256.0
2017-11-03 05:00:00	ES	Futures	2821.21	2822.03	2820.66	2821.21	9364.0
2017-11-03 06:00:00	ES	Futures	2821.21	2822.58	2820.94	2822.3	9296.0
2017-11-03 07:00:00	ES	Futures	2822.03	2822.03	2821.21	2821.48	9946.0
2017-11-03 08:00:00	ES	Futures	2821.48	2824.49	2819.84	2821.21	46111.0
2017-11-03 09:00:00	ES	Futures	2821.48	2822.58	2816.01	2818.2	158953.0
2017-11-03 10:00:00	ES	Futures	2817.93	2820.66	2816.56	2819.57	133243.0
2017-11-03 11:00:00	ES	Futures	2819.29	2823.67	2818.75	2822.85	101264.0
2017-11-03 12:00:00	ES	Futures	2823.12	2825.86	2822.58	2825.04	103438.0
2017-11-03 13:00:00	ES	Futures	2825.04	2827.78	2824.77	2827.5	59827.0
2017-11-03 14:00:00	ES	Futures	2827.5	2829.14	2826.41	2827.78	77969.0
2017-11-03 15:00:00	ES	Futures	2828.05	2828.6	2825.86	2828.6	123877.0
2017-11-03 16:00:00	ES	Futures	2828.32	2828.6	2824.22	2824.49	89125.0
2017-11-03 00:00:00	NQ	Futures	7439.87	7440.47	7438.39	7439.28	342.0
2017-11-03 01:00:00	NQ	Futures	7439.57	7442.25	7438.98	7442.25	437.0
2017-11-03 02:00:00	NQ	Futures	7442.25	7444.93	7440.76	7444.33	587.0
2017-11-03 03:00:00	NQ	Futures	7444.33	7444.93	7438.98	7440.47	1253.0
2017-11-03 04:00:00	NQ	Futures	7440.17	7440.47	7428.87	7439.87	4273.0
2017-11-03 05:00:00	NQ	Futures	7440.17	7443.74	7439.28	7441.36	1730.0
2017-11-03 06:00:00	NQ	Futures	7441.06	7446.71	7441.06	7446.42	1281.0
2017-11-03 07:00:00	NQ	Futures	7446.12	7448.2	7444.63	7445.82	1811.0
2017-11-03 08:00:00	NQ	Futures	7446.12	7465.15	7441.06	7452.36	13470.0
2017-11-03 09:00:00	NQ	Futures	7452.36	7455.04	7421.43	7427.98	51872.0
2017-11-03 10:00:00	NQ	Futures	7428.57	7442.55	7418.76	7441.66	53636.0
2017-11-03 11:00:00	NQ	Futures	7441.66	7456.23	7435.71	7454.74	41703.0
2017-11-03 12:00:00	NQ	Futures	7454.74	7463.37	7453.85	7459.8	24603.0
2017-11-03 13:00:00	NQ	Futures	7460.1	7479.73	7459.5	7477.05	28701.0
2017-11-03 14:00:00	NQ	Futures	7477.05	7489.84	7476.16	7484.48	28243.0
2017-11-03 15:00:00	NQ	Futures	7484.48	7488.95	7477.05	7487.46	29359.0
2017-11-03 16:00:00	NQ	Futures	7487.16	7491.03	7479.73	7481.21	8858.0
2017-11-03 00:00:00	YM	Futures	25524.7	25525.8	25519.2	25524.7	297.0
2017-11-03 01:00:00	YM	Futures	25524.7	25536.7	25524.7	25534.5	468.0
2017-11-03 02:00:00	YM	Futures	25534.5	25547.5	25531.2	25546.4	598.0
2017-11-03 03:00:00	YM	Futures	25546.4	25546.4	25519.2	25524.7	1830.0
2017-11-03 04:00:00	YM	Futures	25523.6	25532.3	25512.7	25526.9	2301.0
2017-11-03 05:00:00	YM	Futures	25526.9	25546.4	25524.7	25541.0	1895.0
2017-11-03 06:00:00	YM	Futures	25539.9	25554.1	25538.8	25550.8	1040.0
2017-11-03 07:00:00	YM	Futures	25549.7	25549.7	25541.0	25543.2	898.0
2017-11-03 08:00:00	YM	Futures	25543.2	25553.0	25521.4	25531.2	5920.0
2017-11-03 09:00:00	YM	Futures	25532.3	25544.3	25469.2	25487.7	18473.0
2017-11-03 10:00:00	YM	Futures	25487.7	25512.7	25477.9	25500.8	13935.0
2017-11-03 11:00:00	YM	Futures	25499.7	25526.9	25497.5	25521.4	9714.0
2017-11-03 12:00:00	YM	Futures	25522.5	25547.5	25519.2	25535.6	9219.0
2017-11-03 13:00:00	YM	Futures	25534.5	25549.7	25529.0	25542.1	6593.0
2017-11-03 14:00:00	YM	Futures	25542.1	25545.4	25513.8	25523.6	6719.0
2017-11-03 15:00:00	YM	Futures	25523.6	25530.1	25507.3	25529.0	8722.0

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

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