PREVIEW / futures_1hour / 2019-06-24

all futures 1-hour files

  file:    by_date/futures_1hour/2019/2019-06-24.parquet
  size:    57 KB
  rows:    1,819

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
2019-06-24 00:00:00	ES	Futures	3205.69	3205.69	3204.61	3204.88	2902.0
2019-06-24 01:00:00	ES	Futures	3204.61	3205.42	3203.52	3203.79	5553.0
2019-06-24 02:00:00	ES	Futures	3203.79	3205.96	3203.52	3204.34	8782.0
2019-06-24 03:00:00	ES	Futures	3204.34	3207.04	3201.9	3201.9	16844.0
2019-06-24 04:00:00	ES	Futures	3201.9	3203.25	3201.09	3202.71	12159.0
2019-06-24 05:00:00	ES	Futures	3202.71	3203.25	3201.09	3202.71	8767.0
2019-06-24 06:00:00	ES	Futures	3202.44	3204.61	3201.36	3201.63	9372.0
2019-06-24 07:00:00	ES	Futures	3201.63	3202.71	3199.19	3201.09	13682.0
2019-06-24 08:00:00	ES	Futures	3201.09	3202.71	3199.73	3201.36	16819.0
2019-06-24 09:00:00	ES	Futures	3201.36	3204.07	3197.57	3197.84	135174.0
2019-06-24 10:00:00	ES	Futures	3197.84	3205.15	3197.3	3200.82	146650.0
2019-06-24 11:00:00	ES	Futures	3200.82	3204.34	3199.19	3201.63	94567.0
2019-06-24 12:00:00	ES	Futures	3201.36	3202.71	3199.73	3200.55	59757.0
2019-06-24 13:00:00	ES	Futures	3200.55	3201.09	3195.94	3197.3	63884.0
2019-06-24 14:00:00	ES	Futures	3197.3	3198.92	3195.67	3197.84	53405.0
2019-06-24 15:00:00	ES	Futures	3197.57	3198.65	3192.97	3195.4	143837.0
2019-06-24 16:00:00	ES	Futures	3195.13	3197.3	3194.86	3195.94	33613.0
2019-06-24 18:00:00	ES	Futures	3195.4	3197.3	3195.13	3196.76	2857.0
2019-06-24 19:00:00	ES	Futures	3196.76	3197.84	3195.94	3196.76	2674.0
2019-06-24 20:00:00	ES	Futures	3197.03	3201.63	3196.76	3201.63	10207.0
2019-06-24 21:00:00	ES	Futures	3201.63	3203.25	3198.92	3199.19	11198.0
2019-06-24 22:00:00	ES	Futures	3198.92	3199.46	3189.72	3190.8	15110.0
2019-06-24 23:00:00	ES	Futures	3190.8	3192.15	3188.64	3189.45	13921.0
2019-06-24 00:00:00	NQ	Futures	9039.97	9039.97	9033.58	9034.46	1280.0
2019-06-24 01:00:00	NQ	Futures	9034.17	9035.62	9028.07	9028.65	2110.0
2019-06-24 02:00:00	NQ	Futures	9028.65	9036.78	9026.33	9030.1	3237.0
2019-06-24 03:00:00	NQ	Futures	9030.1	9041.71	9021.11	9022.56	4382.0
2019-06-24 04:00:00	NQ	Futures	9022.85	9028.65	9018.5	9026.91	4584.0
2019-06-24 05:00:00	NQ	Futures	9026.91	9027.78	9020.24	9026.62	3476.0
2019-06-24 06:00:00	NQ	Futures	9026.62	9032.42	9018.79	9021.11	2877.0
2019-06-24 07:00:00	NQ	Futures	9021.11	9023.14	9010.08	9021.98	5153.0
2019-06-24 08:00:00	NQ	Futures	9021.98	9027.78	9014.73	9022.27	7071.0
2019-06-24 09:00:00	NQ	Futures	9021.98	9025.46	8993.84	8997.03	47452.0
2019-06-24 10:00:00	NQ	Futures	8997.03	9024.01	8994.71	9007.47	45550.0
2019-06-24 11:00:00	NQ	Futures	9007.18	9023.43	9004.57	9017.92	27588.0
2019-06-24 12:00:00	NQ	Futures	9018.5	9022.85	9008.63	9015.6	16405.0
2019-06-24 13:00:00	NQ	Futures	9015.6	9017.34	8999.35	9003.99	14586.0
2019-06-24 14:00:00	NQ	Futures	9004.28	9008.92	8998.48	9005.73	17127.0
2019-06-24 15:00:00	NQ	Futures	9005.73	9007.18	8993.55	8997.9	28106.0
2019-06-24 16:00:00	NQ	Futures	8998.19	9007.47	8997.9	9003.12	6103.0
2019-06-24 18:00:00	NQ	Futures	8997.9	9007.47	8997.9	9005.15	1387.0
2019-06-24 19:00:00	NQ	Futures	9005.44	9010.08	9003.41	9005.73	988.0
2019-06-24 20:00:00	NQ	Futures	9006.02	9025.46	9005.73	9023.72	3831.0
2019-06-24 21:00:00	NQ	Futures	9023.43	9028.65	9009.5	9010.37	5552.0
2019-06-24 22:00:00	NQ	Futures	9010.08	9012.11	8974.69	8975.27	7058.0
2019-06-24 23:00:00	NQ	Futures	8976.14	8980.2	8963.37	8970.04	7557.0
2019-06-24 00:00:00	YM	Futures	29111.3	29111.3	29101.5	29104.8	563.0
2019-06-24 01:00:00	YM	Futures	29102.6	29109.1	29091.7	29093.9	1108.0
2019-06-24 02:00:00	YM	Futures	29093.9	29117.8	29091.7	29109.1	1894.0
2019-06-24 03:00:00	YM	Futures	29108.0	29133.0	29077.6	29080.8	3070.0

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

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