PREVIEW / futures_1hour / 2018-05-03

all futures 1-hour files

  file:    by_date/futures_1hour/2018/2018-05-03.parquet
  size:    54 KB
  rows:    1,700

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-03 00:00:00	ES	Futures	2870.45	2870.99	2869.9	2870.72	2527.0
2018-05-03 01:00:00	ES	Futures	2870.72	2870.99	2867.17	2870.99	4536.0
2018-05-03 02:00:00	ES	Futures	2870.99	2872.08	2868.81	2871.27	8733.0
2018-05-03 03:00:00	ES	Futures	2871.27	2875.09	2869.63	2874.81	14579.0
2018-05-03 04:00:00	ES	Futures	2874.81	2875.9	2874.27	2875.63	9095.0
2018-05-03 05:00:00	ES	Futures	2875.63	2877.82	2872.08	2873.18	14708.0
2018-05-03 06:00:00	ES	Futures	2873.18	2875.9	2872.9	2873.45	6757.0
2018-05-03 07:00:00	ES	Futures	2873.45	2874.27	2857.89	2860.08	35436.0
2018-05-03 08:00:00	ES	Futures	2860.08	2863.62	2856.8	2859.8	42138.0
2018-05-03 09:00:00	ES	Futures	2859.8	2864.99	2851.62	2863.08	201214.0
2018-05-03 10:00:00	ES	Futures	2862.81	2863.08	2828.69	2834.15	421265.0
2018-05-03 11:00:00	ES	Futures	2834.42	2846.98	2832.24	2844.79	290405.0
2018-05-03 12:00:00	ES	Futures	2845.07	2868.81	2839.06	2867.72	256340.0
2018-05-03 13:00:00	ES	Futures	2867.72	2873.72	2858.98	2868.54	229076.0
2018-05-03 14:00:00	ES	Futures	2868.54	2876.18	2863.35	2866.08	227248.0
2018-05-03 15:00:00	ES	Futures	2865.81	2873.45	2861.99	2868.26	217998.0
2018-05-03 16:00:00	ES	Futures	2868.26	2873.99	2867.72	2872.63	57576.0
2018-05-03 18:00:00	ES	Futures	2872.9	2875.63	2872.63	2873.72	4251.0
2018-05-03 19:00:00	ES	Futures	2873.72	2873.99	2865.81	2867.17	5485.0
2018-05-03 20:00:00	ES	Futures	2867.44	2873.18	2866.63	2869.9	6374.0
2018-05-03 21:00:00	ES	Futures	2870.17	2874.54	2864.44	2866.08	8437.0
2018-05-03 22:00:00	ES	Futures	2865.81	2868.26	2863.08	2866.63	8848.0
2018-05-03 23:00:00	ES	Futures	2866.63	2868.81	2865.81	2868.54	3539.0
2018-05-03 00:00:00	NQ	Futures	7849.04	7850.22	7843.42	7844.31	978.0
2018-05-03 01:00:00	NQ	Futures	7844.31	7846.67	7833.37	7846.08	1665.0
2018-05-03 02:00:00	NQ	Futures	7846.38	7849.04	7839.88	7846.38	2076.0
2018-05-03 03:00:00	NQ	Futures	7846.38	7858.2	7840.17	7855.84	3381.0
2018-05-03 04:00:00	NQ	Futures	7855.84	7860.56	7850.22	7855.84	2392.0
2018-05-03 05:00:00	NQ	Futures	7856.13	7862.63	7847.86	7852.29	3032.0
2018-05-03 06:00:00	NQ	Futures	7852.88	7861.75	7849.92	7854.36	1759.0
2018-05-03 07:00:00	NQ	Futures	7854.06	7856.72	7805.0	7812.69	10000.0
2018-05-03 08:00:00	NQ	Futures	7812.98	7824.51	7802.34	7812.69	10153.0
2018-05-03 09:00:00	NQ	Futures	7812.69	7847.56	7790.23	7840.47	61365.0
2018-05-03 10:00:00	NQ	Futures	7839.88	7841.65	7728.76	7742.35	105445.0
2018-05-03 11:00:00	NQ	Futures	7742.35	7787.86	7731.12	7779.59	73595.0
2018-05-03 12:00:00	NQ	Futures	7779.59	7857.61	7758.01	7852.58	60676.0
2018-05-03 13:00:00	NQ	Futures	7852.88	7871.79	7830.42	7849.92	59735.0
2018-05-03 14:00:00	NQ	Futures	7850.52	7886.57	7833.37	7849.92	53870.0
2018-05-03 15:00:00	NQ	Futures	7849.04	7882.43	7839.29	7854.95	41782.0
2018-05-03 16:00:00	NQ	Futures	7854.95	7882.14	7854.65	7880.07	9408.0
2018-05-03 18:00:00	NQ	Futures	7880.66	7888.34	7879.77	7883.62	1318.0
2018-05-03 19:00:00	NQ	Futures	7883.62	7883.62	7854.06	7858.2	2332.0
2018-05-03 20:00:00	NQ	Futures	7858.2	7880.36	7857.02	7868.54	2319.0
2018-05-03 21:00:00	NQ	Futures	7868.54	7881.84	7849.63	7854.95	3240.0
2018-05-03 22:00:00	NQ	Futures	7854.36	7859.68	7840.47	7853.18	4353.0
2018-05-03 23:00:00	NQ	Futures	7853.18	7863.22	7850.52	7861.45	2075.0
2018-05-03 00:00:00	YM	Futures	25900.6	25903.8	25893.0	25896.2	777.0
2018-05-03 01:00:00	YM	Futures	25897.3	25906.0	25865.8	25904.9	1587.0
2018-05-03 02:00:00	YM	Futures	25904.9	25913.6	25881.0	25904.9	1718.0
2018-05-03 03:00:00	YM	Futures	25907.1	25940.8	25889.7	25928.8	3175.0

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

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