PREVIEW / futures_1hour / 2020-06-29

all futures 1-hour files

  file:    by_date/futures_1hour/2020/2020-06-29.parquet
  size:    59 KB
  rows:    1,785

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-29 00:00:00	ES	Futures	3355.39	3361.53	3347.01	3349.53	13977.0
2020-06-29 01:00:00	ES	Futures	3349.53	3364.05	3349.25	3349.81	14383.0
2020-06-29 02:00:00	ES	Futures	3349.81	3363.77	3346.18	3358.74	22117.0
2020-06-29 03:00:00	ES	Futures	3359.02	3372.42	3357.62	3363.77	33159.0
2020-06-29 04:00:00	ES	Futures	3363.77	3366.0	3352.88	3365.44	20924.0
2020-06-29 05:00:00	ES	Futures	3365.16	3371.03	3358.18	3369.07	22318.0
2020-06-29 06:00:00	ES	Futures	3368.79	3371.59	3357.9	3366.84	19652.0
2020-06-29 07:00:00	ES	Futures	3367.12	3380.52	3362.93	3376.89	25438.0
2020-06-29 08:00:00	ES	Futures	3377.17	3378.85	3362.37	3366.28	40300.0
2020-06-29 09:00:00	ES	Futures	3366.56	3369.35	3338.08	3356.23	226139.0
2020-06-29 10:00:00	ES	Futures	3355.95	3388.62	3355.95	3378.85	268010.0
2020-06-29 11:00:00	ES	Futures	3378.85	3387.78	3372.42	3380.24	151275.0
2020-06-29 12:00:00	ES	Futures	3379.96	3392.53	3379.96	3387.78	91878.0
2020-06-29 13:00:00	ES	Futures	3387.5	3395.6	3386.11	3390.85	67064.0
2020-06-29 14:00:00	ES	Futures	3390.57	3393.09	3380.52	3383.04	85405.0
2020-06-29 15:00:00	ES	Futures	3382.76	3399.79	3374.66	3399.51	217195.0
2020-06-29 16:00:00	ES	Futures	3399.51	3408.17	3399.23	3402.3	87666.0
2020-06-29 18:00:00	ES	Futures	3402.3	3417.1	3400.35	3413.19	20218.0
2020-06-29 19:00:00	ES	Futures	3413.19	3417.1	3409.84	3411.52	8959.0
2020-06-29 20:00:00	ES	Futures	3411.24	3411.52	3402.3	3404.54	16010.0
2020-06-29 21:00:00	ES	Futures	3404.54	3415.99	3403.7	3409.56	13296.0
2020-06-29 22:00:00	ES	Futures	3409.56	3414.03	3407.33	3408.17	7042.0
2020-06-29 23:00:00	ES	Futures	3408.45	3412.91	3406.49	3410.12	6449.0
2020-06-29 00:00:00	NQ	Futures	11374.55	11392.48	11342.16	11350.26	6726.0
2020-06-29 01:00:00	NQ	Futures	11350.26	11393.63	11347.94	11349.39	6762.0
2020-06-29 02:00:00	NQ	Futures	11349.39	11390.74	11338.69	11377.44	7211.0
2020-06-29 03:00:00	NQ	Futures	11377.44	11427.76	11375.42	11402.89	9950.0
2020-06-29 04:00:00	NQ	Futures	11402.89	11403.76	11364.72	11399.13	6590.0
2020-06-29 05:00:00	NQ	Futures	11400.0	11409.83	11373.39	11400.0	5141.0
2020-06-29 06:00:00	NQ	Futures	11400.86	11409.83	11365.87	11395.37	6061.0
2020-06-29 07:00:00	NQ	Futures	11395.66	11437.59	11374.55	11425.44	7458.0
2020-06-29 08:00:00	NQ	Futures	11425.73	11428.05	11378.02	11390.16	14192.0
2020-06-29 09:00:00	NQ	Futures	11390.45	11395.95	11253.38	11326.83	82121.0
2020-06-29 10:00:00	NQ	Futures	11326.54	11439.32	11314.98	11403.76	84834.0
2020-06-29 11:00:00	NQ	Futures	11404.33	11455.52	11369.92	11443.66	52628.0
2020-06-29 12:00:00	NQ	Futures	11443.66	11484.15	11443.66	11473.45	32066.0
2020-06-29 13:00:00	NQ	Futures	11473.74	11496.87	11454.65	11482.41	22345.0
2020-06-29 14:00:00	NQ	Futures	11482.41	11488.77	11437.59	11445.69	26095.0
2020-06-29 15:00:00	NQ	Futures	11446.26	11511.91	11419.66	11510.17	46005.0
2020-06-29 16:00:00	NQ	Futures	11510.75	11563.67	11510.17	11550.95	18839.0
2020-06-29 18:00:00	NQ	Futures	11547.48	11576.97	11537.65	11565.41	4650.0
2020-06-29 19:00:00	NQ	Futures	11565.41	11574.95	11555.57	11560.2	2758.0
2020-06-29 20:00:00	NQ	Futures	11559.62	11566.56	11547.77	11556.73	4369.0
2020-06-29 21:00:00	NQ	Futures	11556.73	11593.46	11553.26	11572.64	5487.0
2020-06-29 22:00:00	NQ	Futures	11572.35	11583.62	11567.14	11570.9	3327.0
2020-06-29 23:00:00	NQ	Futures	11571.48	11585.07	11567.14	11576.97	2462.0
2020-06-29 00:00:00	YM	Futures	27430.5	27478.9	27355.6	27376.5	3544.0
2020-06-29 01:00:00	YM	Futures	27373.2	27508.7	27373.2	27390.9	3760.0
2020-06-29 02:00:00	YM	Futures	27392.0	27515.3	27351.2	27464.6	4671.0
2020-06-29 03:00:00	YM	Futures	27463.5	27591.3	27462.4	27526.3	7400.0

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

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