PREVIEW / futures_1hour / 2017-05-11

all futures 1-hour files

  file:    by_date/futures_1hour/2017/2017-05-11.parquet
  size:    53 KB
  rows:    1,647

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-05-11 00:00:00	ES	Futures	2615.62	2616.16	2615.34	2615.34	2882.0
2017-05-11 01:00:00	ES	Futures	2615.62	2615.89	2615.07	2615.89	2148.0
2017-05-11 02:00:00	ES	Futures	2615.62	2616.44	2615.34	2615.62	6132.0
2017-05-11 03:00:00	ES	Futures	2615.89	2615.89	2614.25	2614.52	13473.0
2017-05-11 04:00:00	ES	Futures	2614.52	2615.34	2614.25	2614.25	6353.0
2017-05-11 05:00:00	ES	Futures	2614.25	2614.8	2612.34	2613.16	9317.0
2017-05-11 06:00:00	ES	Futures	2613.16	2613.43	2612.07	2613.16	9910.0
2017-05-11 07:00:00	ES	Futures	2612.89	2613.71	2609.33	2610.43	29237.0
2017-05-11 08:00:00	ES	Futures	2610.15	2612.61	2609.06	2612.34	33794.0
2017-05-11 09:00:00	ES	Futures	2612.07	2613.71	2601.14	2603.6	250475.0
2017-05-11 10:00:00	ES	Futures	2603.6	2605.24	2599.23	2604.15	304344.0
2017-05-11 11:00:00	ES	Futures	2604.15	2606.88	2603.87	2604.96	128764.0
2017-05-11 12:00:00	ES	Futures	2604.96	2610.15	2604.96	2608.52	107238.0
2017-05-11 13:00:00	ES	Futures	2608.52	2612.07	2607.97	2612.07	93678.0
2017-05-11 14:00:00	ES	Futures	2611.79	2615.07	2609.61	2612.07	131594.0
2017-05-11 15:00:00	ES	Futures	2612.07	2614.25	2611.25	2613.16	138154.0
2017-05-11 16:00:00	ES	Futures	2613.16	2614.52	2611.52	2611.79	61645.0
2017-05-11 17:00:00	ES	Futures	2611.79	2611.79	2611.79	2611.79	1.0
2017-05-11 18:00:00	ES	Futures	2611.52	2612.61	2611.25	2611.79	3195.0
2017-05-11 19:00:00	ES	Futures	2611.79	2612.34	2610.97	2612.07	2561.0
2017-05-11 20:00:00	ES	Futures	2612.07	2612.34	2609.61	2610.15	5957.0
2017-05-11 21:00:00	ES	Futures	2610.43	2610.43	2608.79	2609.06	8013.0
2017-05-11 22:00:00	ES	Futures	2608.79	2609.06	2607.15	2607.42	9542.0
2017-05-11 23:00:00	ES	Futures	2607.42	2608.52	2607.42	2607.97	5531.0
2017-05-11 00:00:00	NQ	Futures	6765.4	6765.99	6764.2	6764.8	566.0
2017-05-11 01:00:00	NQ	Futures	6765.1	6765.7	6764.2	6764.8	671.0
2017-05-11 02:00:00	NQ	Futures	6765.1	6766.29	6763.01	6763.31	1166.0
2017-05-11 03:00:00	NQ	Futures	6763.61	6763.91	6759.73	6761.52	2351.0
2017-05-11 04:00:00	NQ	Futures	6761.52	6763.01	6760.63	6761.22	881.0
2017-05-11 05:00:00	NQ	Futures	6761.22	6762.42	6756.45	6758.24	1507.0
2017-05-11 06:00:00	NQ	Futures	6757.94	6757.94	6753.77	6755.56	2460.0
2017-05-11 07:00:00	NQ	Futures	6755.86	6755.86	6743.93	6745.72	5444.0
2017-05-11 08:00:00	NQ	Futures	6745.42	6753.47	6744.23	6752.88	6279.0
2017-05-11 09:00:00	NQ	Futures	6752.88	6759.73	6728.43	6734.39	48093.0
2017-05-11 10:00:00	NQ	Futures	6734.69	6736.78	6721.57	6728.73	50236.0
2017-05-11 11:00:00	NQ	Futures	6728.43	6740.95	6727.24	6735.58	23025.0
2017-05-11 12:00:00	NQ	Futures	6735.58	6746.61	6734.99	6743.33	20140.0
2017-05-11 13:00:00	NQ	Futures	6742.74	6760.93	6742.14	6760.63	18340.0
2017-05-11 14:00:00	NQ	Futures	6760.33	6765.99	6755.26	6757.94	23633.0
2017-05-11 15:00:00	NQ	Futures	6758.24	6767.48	6756.75	6765.99	21872.0
2017-05-11 16:00:00	NQ	Futures	6765.7	6766.89	6761.52	6762.71	4374.0
2017-05-11 18:00:00	NQ	Futures	6761.82	6764.8	6760.93	6763.01	677.0
2017-05-11 19:00:00	NQ	Futures	6763.01	6763.91	6760.93	6761.82	543.0
2017-05-11 20:00:00	NQ	Futures	6761.82	6762.71	6755.56	6756.75	915.0
2017-05-11 21:00:00	NQ	Futures	6756.45	6757.65	6753.47	6753.47	1429.0
2017-05-11 22:00:00	NQ	Futures	6753.47	6754.07	6748.4	6748.4	1591.0
2017-05-11 23:00:00	NQ	Futures	6748.4	6749.89	6746.32	6749.0	1483.0
2017-05-11 00:00:00	YM	Futures	22696.5	22704.2	22693.3	22693.3	469.0
2017-05-11 01:00:00	YM	Futures	22694.4	22699.8	22693.3	22698.7	319.0
2017-05-11 02:00:00	YM	Futures	22699.8	22708.5	22694.4	22700.9	1091.0

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

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