PREVIEW / futures_1hour / 2017-03-03

all futures 1-hour files

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

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-03-03 00:00:00	ES	Futures	2591.58	2592.67	2589.94	2591.58	7325.0
2017-03-03 01:00:00	ES	Futures	2591.85	2592.94	2591.03	2592.4	4185.0
2017-03-03 02:00:00	ES	Futures	2592.4	2592.94	2590.49	2591.3	7960.0
2017-03-03 03:00:00	ES	Futures	2591.58	2592.4	2590.21	2590.76	17743.0
2017-03-03 04:00:00	ES	Futures	2591.03	2591.85	2589.94	2590.21	14358.0
2017-03-03 05:00:00	ES	Futures	2590.21	2595.12	2590.21	2594.85	19595.0
2017-03-03 06:00:00	ES	Futures	2595.12	2596.76	2594.03	2595.4	17497.0
2017-03-03 07:00:00	ES	Futures	2595.12	2596.21	2593.49	2593.49	16546.0
2017-03-03 08:00:00	ES	Futures	2593.49	2595.94	2593.49	2595.67	32397.0
2017-03-03 09:00:00	ES	Futures	2595.67	2598.94	2593.76	2594.31	147463.0
2017-03-03 10:00:00	ES	Futures	2594.31	2596.76	2590.49	2592.4	206549.0
2017-03-03 11:00:00	ES	Futures	2592.4	2594.31	2591.03	2594.31	135618.0
2017-03-03 12:00:00	ES	Futures	2594.31	2596.76	2592.94	2595.67	57514.0
2017-03-03 13:00:00	ES	Futures	2595.4	2597.85	2592.4	2596.49	126467.0
2017-03-03 14:00:00	ES	Futures	2596.49	2598.12	2594.85	2597.58	87692.0
2017-03-03 15:00:00	ES	Futures	2597.31	2600.31	2595.94	2598.67	274720.0
2017-03-03 16:00:00	ES	Futures	2598.67	2598.67	2595.94	2597.31	102195.0
2017-03-03 00:00:00	NQ	Futures	6380.76	6384.34	6379.27	6383.15	1606.0
2017-03-03 01:00:00	NQ	Futures	6383.45	6386.13	6381.66	6384.94	869.0
2017-03-03 02:00:00	NQ	Futures	6384.94	6387.33	6382.25	6385.24	1504.0
2017-03-03 03:00:00	NQ	Futures	6385.24	6387.03	6381.36	6383.75	3178.0
2017-03-03 04:00:00	NQ	Futures	6383.75	6385.54	6380.76	6381.66	2254.0
2017-03-03 05:00:00	NQ	Futures	6381.66	6392.4	6381.66	6391.8	3018.0
2017-03-03 06:00:00	NQ	Futures	6391.8	6395.08	6389.12	6392.1	2403.0
2017-03-03 07:00:00	NQ	Futures	6392.1	6393.29	6388.22	6388.22	2506.0
2017-03-03 08:00:00	NQ	Futures	6388.22	6393.29	6386.73	6392.99	4178.0
2017-03-03 09:00:00	NQ	Futures	6392.7	6401.35	6390.01	6392.99	23564.0
2017-03-03 10:00:00	NQ	Futures	6393.29	6398.96	6377.18	6385.54	30046.0
2017-03-03 11:00:00	NQ	Futures	6385.54	6394.19	6381.06	6393.29	16716.0
2017-03-03 12:00:00	NQ	Futures	6393.59	6401.94	6391.5	6399.86	11428.0
2017-03-03 13:00:00	NQ	Futures	6399.86	6407.01	6391.2	6401.94	21915.0
2017-03-03 14:00:00	NQ	Futures	6402.24	6407.91	6398.66	6404.63	12032.0
2017-03-03 15:00:00	NQ	Futures	6404.33	6412.09	6401.94	6411.19	22980.0
2017-03-03 16:00:00	NQ	Futures	6411.19	6411.79	6407.61	6411.19	6772.0
2017-03-03 00:00:00	YM	Futures	22711.7	22724.8	22699.8	22719.3	1808.0
2017-03-03 01:00:00	YM	Futures	22720.4	22729.1	22715.0	22726.9	886.0
2017-03-03 02:00:00	YM	Futures	22726.9	22738.9	22717.2	22730.2	1942.0
2017-03-03 03:00:00	YM	Futures	22731.3	22743.2	22718.3	22729.1	3613.0
2017-03-03 04:00:00	YM	Futures	22729.1	22736.7	22721.5	22724.8	1697.0
2017-03-03 05:00:00	YM	Futures	22724.8	22779.0	22724.8	22776.8	3817.0
2017-03-03 06:00:00	YM	Futures	22776.8	22794.2	22766.0	22774.7	3840.0
2017-03-03 07:00:00	YM	Futures	22775.7	22790.9	22772.5	22776.8	3533.0
2017-03-03 08:00:00	YM	Futures	22776.8	22808.3	22775.7	22794.2	5063.0
2017-03-03 09:00:00	YM	Futures	22795.3	22820.2	22761.6	22764.9	17806.0
2017-03-03 10:00:00	YM	Futures	22764.9	22779.0	22725.8	22729.1	19632.0
2017-03-03 11:00:00	YM	Futures	22729.1	22754.0	22717.2	22748.6	11458.0
2017-03-03 12:00:00	YM	Futures	22747.5	22772.5	22737.8	22758.4	6772.0
2017-03-03 13:00:00	YM	Futures	22757.3	22777.9	22736.7	22768.2	14686.0
2017-03-03 14:00:00	YM	Futures	22766.0	22785.5	22754.0	22780.1	9873.0
2017-03-03 15:00:00	YM	Futures	22780.1	22787.7	22750.8	22768.2	14801.0

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

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