PREVIEW / futures_1hour / 2018-10-01

all futures 1-hour files

  file:    by_date/futures_1hour/2018/2018-10-01.parquet
  size:    54 KB
  rows:    1,705

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-10-01 00:00:00	ES	Futures	3193.26	3194.08	3191.9	3193.8	3786.0
2018-10-01 01:00:00	ES	Futures	3193.53	3193.53	3191.9	3192.17	4040.0
2018-10-01 02:00:00	ES	Futures	3192.17	3193.53	3191.08	3191.63	8341.0
2018-10-01 03:00:00	ES	Futures	3191.63	3195.71	3190.0	3195.16	23125.0
2018-10-01 04:00:00	ES	Futures	3195.16	3196.25	3194.35	3195.98	11589.0
2018-10-01 05:00:00	ES	Futures	3195.71	3196.25	3193.8	3195.98	15034.0
2018-10-01 06:00:00	ES	Futures	3195.98	3196.25	3194.08	3194.89	11994.0
2018-10-01 07:00:00	ES	Futures	3194.89	3195.98	3192.44	3193.8	15406.0
2018-10-01 08:00:00	ES	Futures	3193.53	3194.62	3189.72	3191.36	30029.0
2018-10-01 09:00:00	ES	Futures	3191.36	3198.16	3190.54	3197.07	146840.0
2018-10-01 10:00:00	ES	Futures	3197.07	3200.88	3195.98	3197.88	156372.0
2018-10-01 11:00:00	ES	Futures	3198.16	3198.97	3194.62	3196.25	98496.0
2018-10-01 12:00:00	ES	Futures	3196.52	3196.52	3189.18	3190.54	112575.0
2018-10-01 13:00:00	ES	Futures	3190.54	3193.53	3189.72	3191.08	67780.0
2018-10-01 14:00:00	ES	Futures	3191.08	3191.36	3187.28	3190.54	98197.0
2018-10-01 15:00:00	ES	Futures	3190.54	3191.36	3179.66	3187.0	270162.0
2018-10-01 16:00:00	ES	Futures	3187.0	3188.64	3185.1	3187.0	71245.0
2018-10-01 18:00:00	ES	Futures	3187.0	3187.82	3185.92	3187.0	8407.0
2018-10-01 19:00:00	ES	Futures	3187.0	3187.82	3186.46	3187.0	2953.0
2018-10-01 20:00:00	ES	Futures	3186.73	3187.28	3184.56	3186.19	6076.0
2018-10-01 21:00:00	ES	Futures	3186.19	3186.46	3182.11	3183.74	8929.0
2018-10-01 22:00:00	ES	Futures	3183.47	3183.47	3181.29	3182.92	6196.0
2018-10-01 23:00:00	ES	Futures	3182.92	3184.28	3182.65	3183.74	2354.0
2018-10-01 00:00:00	NQ	Futures	9043.46	9048.74	9039.06	9047.86	1502.0
2018-10-01 01:00:00	NQ	Futures	9047.86	9047.86	9039.65	9042.0	1620.0
2018-10-01 02:00:00	NQ	Futures	9042.29	9043.76	9034.96	9038.77	2856.0
2018-10-01 03:00:00	NQ	Futures	9038.48	9053.73	9032.02	9049.91	6433.0
2018-10-01 04:00:00	NQ	Futures	9049.62	9053.73	9047.57	9052.26	4281.0
2018-10-01 05:00:00	NQ	Futures	9052.26	9057.25	9050.21	9055.49	5385.0
2018-10-01 06:00:00	NQ	Futures	9055.19	9056.37	9046.98	9047.27	3864.0
2018-10-01 07:00:00	NQ	Futures	9046.98	9048.74	9038.18	9040.24	5637.0
2018-10-01 08:00:00	NQ	Futures	9039.94	9043.76	9026.74	9032.61	10426.0
2018-10-01 09:00:00	NQ	Futures	9032.9	9063.99	9023.81	9057.25	53392.0
2018-10-01 10:00:00	NQ	Futures	9057.25	9067.81	9046.98	9056.95	50479.0
2018-10-01 11:00:00	NQ	Futures	9056.66	9057.54	9035.54	9043.76	31673.0
2018-10-01 12:00:00	NQ	Futures	9043.76	9046.39	9013.54	9017.36	37574.0
2018-10-01 13:00:00	NQ	Futures	9017.36	9029.97	9014.13	9022.34	25444.0
2018-10-01 14:00:00	NQ	Futures	9022.93	9022.93	8992.13	9009.73	32048.0
2018-10-01 15:00:00	NQ	Futures	9010.02	9012.08	8977.76	8999.76	51844.0
2018-10-01 16:00:00	NQ	Futures	8999.76	9008.56	8993.31	9004.45	9259.0
2018-10-01 18:00:00	NQ	Futures	9004.74	9005.92	8999.46	9003.86	1293.0
2018-10-01 19:00:00	NQ	Futures	9003.86	9007.97	9002.1	9005.92	972.0
2018-10-01 20:00:00	NQ	Futures	9005.92	9006.5	8995.65	9002.98	2029.0
2018-10-01 21:00:00	NQ	Futures	9002.69	9002.69	8985.09	8990.37	3797.0
2018-10-01 22:00:00	NQ	Futures	8989.79	8990.96	8981.28	8988.03	4312.0
2018-10-01 23:00:00	NQ	Futures	8988.03	8996.24	8987.73	8994.18	1684.0
2018-10-01 00:00:00	YM	Futures	28956.6	28965.3	28943.6	28958.8	950.0
2018-10-01 01:00:00	YM	Futures	28958.8	28958.8	28945.8	28952.3	877.0
2018-10-01 02:00:00	YM	Futures	28952.3	28962.1	28942.5	28949.0	1694.0
2018-10-01 03:00:00	YM	Futures	28950.1	28992.5	28936.0	28986.0	3969.0

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

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