PREVIEW / futures_1hour / 2018-05-07

all futures 1-hour files

  file:    by_date/futures_1hour/2018/2018-05-07.parquet
  size:    51 KB
  rows:    1,638

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
2018-05-07 00:00:00	ES	Futures	2915.75	2918.75	2915.75	2918.21	5793.0
2018-05-07 01:00:00	ES	Futures	2918.21	2918.48	2915.48	2917.39	4876.0
2018-05-07 02:00:00	ES	Futures	2917.39	2917.66	2912.75	2913.57	6918.0
2018-05-07 03:00:00	ES	Futures	2913.29	2915.48	2911.11	2911.93	7899.0
2018-05-07 04:00:00	ES	Futures	2911.93	2916.57	2911.38	2914.39	6961.0
2018-05-07 05:00:00	ES	Futures	2914.11	2916.3	2913.57	2915.48	4490.0
2018-05-07 06:00:00	ES	Futures	2915.2	2917.39	2913.29	2916.57	7808.0
2018-05-07 07:00:00	ES	Futures	2916.3	2920.93	2915.2	2916.02	18105.0
2018-05-07 08:00:00	ES	Futures	2916.02	2917.11	2913.57	2916.57	14003.0
2018-05-07 09:00:00	ES	Futures	2916.84	2924.76	2912.2	2924.21	134182.0
2018-05-07 10:00:00	ES	Futures	2924.48	2924.76	2913.29	2920.66	154092.0
2018-05-07 11:00:00	ES	Futures	2920.93	2923.39	2917.11	2922.3	116358.0
2018-05-07 12:00:00	ES	Futures	2922.3	2924.21	2918.48	2920.12	82785.0
2018-05-07 13:00:00	ES	Futures	2919.84	2923.39	2917.11	2922.57	65775.0
2018-05-07 14:00:00	ES	Futures	2922.3	2927.21	2915.2	2916.57	125567.0
2018-05-07 15:00:00	ES	Futures	2916.57	2918.75	2906.47	2914.93	250672.0
2018-05-07 16:00:00	ES	Futures	2914.66	2916.57	2912.47	2913.29	50624.0
2018-05-07 18:00:00	ES	Futures	2912.47	2914.39	2908.93	2911.93	6868.0
2018-05-07 19:00:00	ES	Futures	2911.93	2912.47	2910.56	2911.66	2810.0
2018-05-07 20:00:00	ES	Futures	2911.66	2914.39	2910.84	2912.2	5988.0
2018-05-07 21:00:00	ES	Futures	2912.2	2915.48	2911.93	2914.93	5245.0
2018-05-07 22:00:00	ES	Futures	2914.93	2916.3	2913.84	2914.66	2837.0
2018-05-07 23:00:00	ES	Futures	2914.93	2915.2	2913.02	2913.29	1491.0
2018-05-07 00:00:00	NQ	Futures	8062.41	8076.01	8061.82	8074.82	3267.0
2018-05-07 01:00:00	NQ	Futures	8075.12	8077.48	8063.3	8068.91	3453.0
2018-05-07 02:00:00	NQ	Futures	8069.21	8069.21	8053.84	8054.14	2916.0
2018-05-07 03:00:00	NQ	Futures	8054.43	8061.53	8044.98	8047.64	4532.0
2018-05-07 04:00:00	NQ	Futures	8047.64	8063.0	8044.09	8055.32	3430.0
2018-05-07 05:00:00	NQ	Futures	8055.02	8061.53	8051.48	8056.21	2094.0
2018-05-07 06:00:00	NQ	Futures	8056.21	8060.64	8046.45	8054.43	3334.0
2018-05-07 07:00:00	NQ	Futures	8054.43	8066.25	8050.59	8053.55	3707.0
2018-05-07 08:00:00	NQ	Futures	8053.25	8055.02	8040.54	8051.48	4945.0
2018-05-07 09:00:00	NQ	Futures	8051.77	8087.83	8035.52	8080.74	47771.0
2018-05-07 10:00:00	NQ	Futures	8081.03	8090.49	8059.75	8082.51	49199.0
2018-05-07 11:00:00	NQ	Futures	8082.8	8096.1	8070.1	8091.67	33759.0
2018-05-07 12:00:00	NQ	Futures	8091.37	8093.44	8067.44	8073.94	22691.0
2018-05-07 13:00:00	NQ	Futures	8073.64	8085.76	8060.64	8083.1	22726.0
2018-05-07 14:00:00	NQ	Futures	8083.4	8099.06	8063.89	8072.16	32422.0
2018-05-07 15:00:00	NQ	Futures	8072.46	8083.1	8038.47	8068.91	52305.0
2018-05-07 16:00:00	NQ	Futures	8068.62	8074.53	8059.46	8060.34	7714.0
2018-05-07 18:00:00	NQ	Futures	8058.57	8071.28	8050.0	8063.3	2011.0
2018-05-07 19:00:00	NQ	Futures	8064.19	8065.37	8058.27	8060.34	1173.0
2018-05-07 20:00:00	NQ	Futures	8060.64	8068.91	8057.98	8064.19	1855.0
2018-05-07 21:00:00	NQ	Futures	8064.48	8078.08	8063.89	8073.94	2379.0
2018-05-07 22:00:00	NQ	Futures	8074.53	8079.26	8071.87	8074.82	2796.0
2018-05-07 23:00:00	NQ	Futures	8075.71	8077.48	8069.51	8070.1	1055.0
2018-05-07 00:00:00	YM	Futures	26396.9	26425.1	26395.8	26415.3	1470.0
2018-05-07 01:00:00	YM	Futures	26415.3	26418.6	26384.9	26404.5	1775.0
2018-05-07 02:00:00	YM	Futures	26404.5	26406.7	26356.7	26361.0	2282.0
2018-05-07 03:00:00	YM	Futures	26361.0	26383.8	26340.4	26345.8	2349.0

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

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