PREVIEW / futures_1hour / 2017-05-01

all futures 1-hour files

  file:    by_date/futures_1hour/2017/2017-05-01.parquet
  size:    43 KB
  rows:    1,314

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-01 00:00:00	ES	Futures	2602.23	2602.78	2602.23	2602.51	584.0
2017-05-01 01:00:00	ES	Futures	2602.51	2603.33	2602.23	2603.33	1013.0
2017-05-01 02:00:00	ES	Futures	2603.33	2605.51	2603.05	2604.69	4411.0
2017-05-01 03:00:00	ES	Futures	2604.69	2604.69	2603.33	2604.15	1787.0
2017-05-01 04:00:00	ES	Futures	2604.42	2605.24	2603.87	2604.15	1173.0
2017-05-01 05:00:00	ES	Futures	2604.15	2605.24	2604.15	2604.69	952.0
2017-05-01 06:00:00	ES	Futures	2604.69	2606.6	2604.69	2605.51	4644.0
2017-05-01 07:00:00	ES	Futures	2605.78	2606.06	2605.24	2605.78	3324.0
2017-05-01 08:00:00	ES	Futures	2606.06	2608.52	2605.78	2606.6	15920.0
2017-05-01 09:00:00	ES	Futures	2606.6	2607.15	2603.87	2604.69	74522.0
2017-05-01 10:00:00	ES	Futures	2604.69	2608.52	2601.14	2607.42	132651.0
2017-05-01 11:00:00	ES	Futures	2607.42	2608.52	2605.51	2607.15	87258.0
2017-05-01 12:00:00	ES	Futures	2607.15	2608.52	2601.69	2605.24	117772.0
2017-05-01 13:00:00	ES	Futures	2605.24	2610.43	2604.42	2610.43	72579.0
2017-05-01 14:00:00	ES	Futures	2610.15	2612.07	2608.52	2609.33	117303.0
2017-05-01 15:00:00	ES	Futures	2609.33	2611.52	2605.78	2606.33	155201.0
2017-05-01 16:00:00	ES	Futures	2606.33	2608.24	2605.78	2607.7	79331.0
2017-05-01 18:00:00	ES	Futures	2607.15	2608.52	2606.33	2607.7	4623.0
2017-05-01 19:00:00	ES	Futures	2607.7	2607.97	2607.15	2607.15	1140.0
2017-05-01 20:00:00	ES	Futures	2607.15	2609.06	2606.88	2609.06	4828.0
2017-05-01 21:00:00	ES	Futures	2609.06	2609.33	2605.78	2606.06	6252.0
2017-05-01 22:00:00	ES	Futures	2606.06	2607.42	2606.06	2606.88	3501.0
2017-05-01 23:00:00	ES	Futures	2606.88	2607.15	2606.06	2606.6	1748.0
2017-05-01 00:00:00	NQ	Futures	6663.14	6664.33	6662.84	6663.73	271.0
2017-05-01 01:00:00	NQ	Futures	6663.73	6667.31	6663.43	6667.01	534.0
2017-05-01 02:00:00	NQ	Futures	6666.71	6671.48	6666.41	6669.99	779.0
2017-05-01 03:00:00	NQ	Futures	6669.4	6670.29	6667.61	6668.2	434.0
2017-05-01 04:00:00	NQ	Futures	6668.2	6671.78	6667.91	6668.8	518.0
2017-05-01 05:00:00	NQ	Futures	6668.8	6670.59	6668.2	6670.59	322.0
2017-05-01 06:00:00	NQ	Futures	6670.59	6673.27	6670.29	6670.29	749.0
2017-05-01 07:00:00	NQ	Futures	6670.59	6673.57	6669.69	6673.27	839.0
2017-05-01 08:00:00	NQ	Futures	6673.27	6680.43	6673.27	6679.23	3622.0
2017-05-01 09:00:00	NQ	Futures	6678.94	6688.48	6674.17	6686.09	21556.0
2017-05-01 10:00:00	NQ	Futures	6686.09	6700.1	6678.64	6697.72	26668.0
2017-05-01 11:00:00	NQ	Futures	6697.42	6704.28	6695.33	6701.3	16743.0
2017-05-01 12:00:00	NQ	Futures	6701.3	6707.56	6695.04	6702.49	19400.0
2017-05-01 13:00:00	NQ	Futures	6702.49	6715.91	6701.3	6715.61	15940.0
2017-05-01 14:00:00	NQ	Futures	6715.91	6718.59	6713.22	6715.31	18772.0
2017-05-01 15:00:00	NQ	Futures	6715.31	6722.76	6711.14	6711.73	25115.0
2017-05-01 16:00:00	NQ	Futures	6711.73	6717.99	6709.65	6716.5	5816.0
2017-05-01 18:00:00	NQ	Futures	6712.92	6717.1	6712.33	6713.82	1285.0
2017-05-01 19:00:00	NQ	Futures	6714.12	6715.61	6713.52	6715.61	339.0
2017-05-01 20:00:00	NQ	Futures	6715.01	6721.27	6714.12	6721.27	1221.0
2017-05-01 21:00:00	NQ	Futures	6720.97	6721.27	6714.12	6714.71	1209.0
2017-05-01 22:00:00	NQ	Futures	6715.01	6718.59	6714.71	6717.69	853.0
2017-05-01 23:00:00	NQ	Futures	6717.4	6717.99	6716.2	6717.4	390.0
2017-05-01 00:00:00	YM	Futures	22706.3	22707.4	22703.1	22704.2	77.0
2017-05-01 01:00:00	YM	Futures	22704.2	22711.8	22703.1	22711.8	266.0
2017-05-01 02:00:00	YM	Futures	22711.8	22722.6	22711.8	22721.5	844.0
2017-05-01 03:00:00	YM	Futures	22719.4	22720.5	22707.4	22710.7	637.0

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

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