PREVIEW / futures_1hour / 2020-07-09

all futures 1-hour files

  file:    by_date/futures_1hour/2020/2020-07-09.parquet
  size:    60 KB
  rows:    1,830

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
2020-07-09 00:00:00	ES	Futures	3534.39	3538.02	3532.43	3533.83	6793.0
2020-07-09 01:00:00	ES	Futures	3533.83	3533.83	3524.33	3528.8	11475.0
2020-07-09 02:00:00	ES	Futures	3528.52	3531.03	3520.98	3529.36	15779.0
2020-07-09 03:00:00	ES	Futures	3529.08	3531.87	3521.54	3529.36	26544.0
2020-07-09 04:00:00	ES	Futures	3529.36	3534.66	3527.96	3529.64	18350.0
2020-07-09 05:00:00	ES	Futures	3529.64	3533.27	3524.33	3531.03	18003.0
2020-07-09 06:00:00	ES	Futures	3531.31	3533.27	3526.29	3527.68	14046.0
2020-07-09 07:00:00	ES	Futures	3527.96	3536.62	3527.68	3534.39	17378.0
2020-07-09 08:00:00	ES	Futures	3534.39	3541.65	3531.31	3539.13	36623.0
2020-07-09 09:00:00	ES	Futures	3538.85	3540.81	3520.98	3529.64	174854.0
2020-07-09 10:00:00	ES	Futures	3529.36	3532.99	3481.61	3483.0	364627.0
2020-07-09 11:00:00	ES	Futures	3482.73	3489.99	3468.48	3485.8	364758.0
2020-07-09 12:00:00	ES	Futures	3485.8	3501.43	3483.84	3500.04	147244.0
2020-07-09 13:00:00	ES	Futures	3500.04	3510.09	3496.97	3498.92	128916.0
2020-07-09 14:00:00	ES	Futures	3498.92	3515.96	3496.41	3515.4	124604.0
2020-07-09 15:00:00	ES	Futures	3515.4	3523.49	3497.53	3510.93	277469.0
2020-07-09 16:00:00	ES	Futures	3510.65	3515.68	3507.02	3509.25	50429.0
2020-07-09 18:00:00	ES	Futures	3509.81	3514.56	3509.25	3512.05	4768.0
2020-07-09 19:00:00	ES	Futures	3512.05	3523.22	3511.21	3519.59	10530.0
2020-07-09 20:00:00	ES	Futures	3519.86	3522.38	3504.23	3508.97	16922.0
2020-07-09 21:00:00	ES	Futures	3508.69	3512.6	3500.32	3507.58	19136.0
2020-07-09 22:00:00	ES	Futures	3507.58	3508.97	3498.92	3500.88	11956.0
2020-07-09 23:00:00	ES	Futures	3500.88	3503.67	3497.25	3501.99	7399.0
2020-07-09 00:00:00	NQ	Futures	12343.59	12357.47	12340.69	12344.45	3740.0
2020-07-09 01:00:00	NQ	Futures	12344.45	12345.9	12321.61	12335.49	5745.0
2020-07-09 02:00:00	NQ	Futures	12334.62	12342.72	12314.96	12337.51	5867.0
2020-07-09 03:00:00	NQ	Futures	12337.22	12346.77	12317.85	12343.88	8848.0
2020-07-09 04:00:00	NQ	Futures	12344.74	12363.25	12340.98	12356.89	6760.0
2020-07-09 05:00:00	NQ	Futures	12356.6	12393.32	12347.92	12384.65	8165.0
2020-07-09 06:00:00	NQ	Futures	12385.23	12391.01	12363.25	12365.85	5843.0
2020-07-09 07:00:00	NQ	Futures	12366.43	12403.16	12365.56	12390.14	7954.0
2020-07-09 08:00:00	NQ	Futures	12391.3	12421.95	12381.76	12408.07	14060.0
2020-07-09 09:00:00	NQ	Futures	12408.07	12432.36	12364.12	12412.41	63971.0
2020-07-09 10:00:00	NQ	Futures	12412.99	12427.16	12248.16	12253.36	98004.0
2020-07-09 11:00:00	NQ	Futures	12253.65	12299.34	12214.9	12288.93	113224.0
2020-07-09 12:00:00	NQ	Futures	12289.22	12364.41	12278.23	12357.76	55878.0
2020-07-09 13:00:00	NQ	Futures	12357.47	12400.55	12343.59	12354.86	45498.0
2020-07-09 14:00:00	NQ	Futures	12354.29	12432.07	12344.74	12429.47	42505.0
2020-07-09 15:00:00	NQ	Futures	12429.47	12462.73	12364.7	12424.56	75927.0
2020-07-09 16:00:00	NQ	Futures	12423.98	12439.88	12400.84	12404.6	12304.0
2020-07-09 18:00:00	NQ	Futures	12408.07	12419.64	12405.76	12414.15	1938.0
2020-07-09 19:00:00	NQ	Futures	12413.57	12444.51	12411.54	12439.59	3365.0
2020-07-09 20:00:00	NQ	Futures	12439.88	12442.77	12378.0	12389.28	7583.0
2020-07-09 21:00:00	NQ	Futures	12389.85	12404.02	12367.88	12384.65	7666.0
2020-07-09 22:00:00	NQ	Futures	12384.36	12393.61	12362.96	12366.14	4748.0
2020-07-09 23:00:00	NQ	Futures	12366.14	12374.53	12353.71	12370.48	2949.0
2020-07-09 00:00:00	YM	Futures	28596.6	28631.8	28577.9	28597.7	1864.0
2020-07-09 01:00:00	YM	Futures	28595.5	28595.5	28505.2	28542.6	2403.0
2020-07-09 02:00:00	YM	Futures	28541.5	28565.8	28481.0	28552.6	3410.0
2020-07-09 03:00:00	YM	Futures	28550.4	28582.3	28462.3	28536.0	7756.0

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

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