PREVIEW / futures_1hour / 2020-06-25

all futures 1-hour files

  file:    by_date/futures_1hour/2020/2020-06-25.parquet
  size:    58 KB
  rows:    1,814

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-06-25 00:00:00	ES	Futures	3390.57	3394.76	3381.92	3387.5	9421.0
2020-06-25 01:00:00	ES	Futures	3387.5	3397.28	3384.99	3392.25	10492.0
2020-06-25 02:00:00	ES	Futures	3392.25	3398.39	3379.68	3383.04	20073.0
2020-06-25 03:00:00	ES	Futures	3383.04	3385.55	3356.51	3365.72	56694.0
2020-06-25 04:00:00	ES	Futures	3366.0	3403.98	3365.44	3398.67	51226.0
2020-06-25 05:00:00	ES	Futures	3398.95	3409.28	3391.97	3395.32	41259.0
2020-06-25 06:00:00	ES	Futures	3395.32	3400.35	3390.57	3399.79	27215.0
2020-06-25 07:00:00	ES	Futures	3399.51	3399.79	3375.22	3376.61	35882.0
2020-06-25 08:00:00	ES	Futures	3376.89	3391.69	3371.59	3382.48	73077.0
2020-06-25 09:00:00	ES	Futures	3382.2	3395.6	3363.77	3383.04	229514.0
2020-06-25 10:00:00	ES	Futures	3382.76	3405.37	3381.36	3394.2	305374.0
2020-06-25 11:00:00	ES	Futures	3393.93	3398.67	3377.73	3392.81	214835.0
2020-06-25 12:00:00	ES	Futures	3393.09	3408.73	3392.81	3402.02	144086.0
2020-06-25 13:00:00	ES	Futures	3402.02	3406.21	3395.32	3400.91	90778.0
2020-06-25 14:00:00	ES	Futures	3401.19	3404.26	3389.18	3397.56	109499.0
2020-06-25 15:00:00	ES	Futures	3397.56	3435.81	3394.76	3431.9	312698.0
2020-06-25 16:00:00	ES	Futures	3431.62	3439.72	3422.97	3433.02	82243.0
2020-06-25 18:00:00	ES	Futures	3430.51	3433.58	3427.43	3432.74	8227.0
2020-06-25 19:00:00	ES	Futures	3432.46	3440.28	3429.67	3432.46	10891.0
2020-06-25 20:00:00	ES	Futures	3432.46	3433.3	3421.85	3432.74	18675.0
2020-06-25 21:00:00	ES	Futures	3433.02	3436.09	3428.55	3433.86	11825.0
2020-06-25 22:00:00	ES	Futures	3434.14	3435.25	3425.2	3426.88	8166.0
2020-06-25 23:00:00	ES	Futures	3426.88	3433.02	3424.36	3431.34	7609.0
2020-06-25 00:00:00	NQ	Futures	11550.95	11562.51	11533.31	11552.68	2950.0
2020-06-25 01:00:00	NQ	Futures	11552.97	11580.73	11544.87	11559.33	3736.0
2020-06-25 02:00:00	NQ	Futures	11558.76	11575.82	11529.84	11544.87	6199.0
2020-06-25 03:00:00	NQ	Futures	11545.45	11549.21	11444.24	11489.06	16201.0
2020-06-25 04:00:00	NQ	Futures	11489.64	11596.06	11485.3	11581.89	15627.0
2020-06-25 05:00:00	NQ	Futures	11583.05	11623.24	11561.36	11567.43	10704.0
2020-06-25 06:00:00	NQ	Futures	11567.14	11595.48	11556.73	11594.9	5465.0
2020-06-25 07:00:00	NQ	Futures	11593.75	11594.9	11530.42	11534.18	7506.0
2020-06-25 08:00:00	NQ	Futures	11534.18	11577.55	11522.9	11559.91	17358.0
2020-06-25 09:00:00	NQ	Futures	11559.62	11587.09	11434.7	11505.26	73790.0
2020-06-25 10:00:00	NQ	Futures	11504.97	11582.18	11482.7	11557.89	83756.0
2020-06-25 11:00:00	NQ	Futures	11557.89	11570.9	11502.65	11564.54	61350.0
2020-06-25 12:00:00	NQ	Futures	11564.54	11614.57	11563.67	11581.31	44907.0
2020-06-25 13:00:00	NQ	Futures	11580.73	11600.69	11559.91	11583.34	25832.0
2020-06-25 14:00:00	NQ	Futures	11583.05	11586.81	11527.52	11559.91	35247.0
2020-06-25 15:00:00	NQ	Futures	11559.62	11680.79	11549.5	11667.78	55985.0
2020-06-25 16:00:00	NQ	Futures	11668.35	11690.91	11657.37	11679.92	12394.0
2020-06-25 18:00:00	NQ	Futures	11667.78	11685.7	11664.88	11683.97	2365.0
2020-06-25 19:00:00	NQ	Futures	11681.95	11706.53	11675.01	11689.46	2369.0
2020-06-25 20:00:00	NQ	Futures	11689.17	11693.8	11652.74	11685.13	4697.0
2020-06-25 21:00:00	NQ	Futures	11685.42	11697.27	11672.98	11690.62	2693.0
2020-06-25 22:00:00	NQ	Futures	11691.49	11694.67	11667.49	11670.38	2545.0
2020-06-25 23:00:00	NQ	Futures	11670.67	11681.66	11661.7	11674.14	2205.0
2020-06-25 00:00:00	YM	Futures	27809.3	27847.8	27727.8	27776.3	3384.0
2020-06-25 01:00:00	YM	Futures	27777.4	27858.8	27749.8	27819.2	3997.0
2020-06-25 02:00:00	YM	Futures	27817.0	27879.8	27736.6	27771.9	6487.0
2020-06-25 03:00:00	YM	Futures	27773.0	27795.0	27531.8	27608.9	15427.0

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

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