PREVIEW / futures_1hour / 2021-05-11

all futures 1-hour files

  file:    by_date/futures_1hour/2021/2021-05-11.parquet
  size:    65 KB
  rows:    1,989

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
2021-05-11 00:00:00	ES	Futures	4677.58	4678.98	4669.71	4672.24	6931.0
2021-05-11 01:00:00	ES	Futures	4672.24	4683.76	4671.4	4682.63	10718.0
2021-05-11 02:00:00	ES	Futures	4682.92	4686.01	4678.7	4683.2	14691.0
2021-05-11 03:00:00	ES	Futures	4683.2	4686.29	4661.84	4670.55	52069.0
2021-05-11 04:00:00	ES	Futures	4670.55	4671.68	4658.19	4665.21	37773.0
2021-05-11 05:00:00	ES	Futures	4665.21	4676.73	4664.37	4668.59	20837.0
2021-05-11 06:00:00	ES	Futures	4668.59	4670.83	4658.75	4666.06	29809.0
2021-05-11 07:00:00	ES	Futures	4666.06	4667.74	4656.79	4657.07	31781.0
2021-05-11 08:00:00	ES	Futures	4657.35	4662.41	4638.8	4640.21	88902.0
2021-05-11 09:00:00	ES	Futures	4640.21	4666.9	4634.03	4666.9	353664.0
2021-05-11 10:00:00	ES	Futures	4666.9	4671.12	4612.11	4632.34	526925.0
2021-05-11 11:00:00	ES	Futures	4632.34	4661.0	4620.26	4657.07	297381.0
2021-05-11 12:00:00	ES	Futures	4657.07	4661.84	4634.59	4640.21	162018.0
2021-05-11 13:00:00	ES	Futures	4639.93	4664.93	4638.24	4659.31	166287.0
2021-05-11 14:00:00	ES	Futures	4659.31	4665.5	4646.67	4657.91	191205.0
2021-05-11 15:00:00	ES	Futures	4657.63	4668.31	4641.33	4659.88	313266.0
2021-05-11 16:00:00	ES	Futures	4659.88	4664.65	4650.04	4652.85	62784.0
2021-05-11 18:00:00	ES	Futures	4652.85	4656.5	4650.6	4654.54	4906.0
2021-05-11 19:00:00	ES	Futures	4654.54	4660.16	4648.92	4659.88	8078.0
2021-05-11 20:00:00	ES	Futures	4660.16	4664.65	4637.96	4641.33	25467.0
2021-05-11 21:00:00	ES	Futures	4641.05	4650.04	4638.52	4642.46	22892.0
2021-05-11 22:00:00	ES	Futures	4642.46	4651.73	4641.89	4645.27	15430.0
2021-05-11 23:00:00	ES	Futures	4644.98	4648.92	4625.88	4628.69	20871.0
2021-05-11 00:00:00	NQ	Futures	15323.27	15328.2	15285.64	15303.3	3859.0
2021-05-11 01:00:00	NQ	Futures	15304.17	15372.2	15303.3	15360.62	7331.0
2021-05-11 02:00:00	NQ	Futures	15360.62	15373.94	15342.09	15358.01	5326.0
2021-05-11 03:00:00	NQ	Futures	15359.17	15366.7	15215.87	15279.27	23112.0
2021-05-11 04:00:00	NQ	Futures	15278.98	15293.46	15228.61	15272.03	13805.0
2021-05-11 05:00:00	NQ	Futures	15271.74	15298.96	15253.8	15265.95	9074.0
2021-05-11 06:00:00	NQ	Futures	15266.53	15279.27	15232.95	15265.95	9279.0
2021-05-11 07:00:00	NQ	Futures	15265.67	15272.9	15189.82	15193.0	14202.0
2021-05-11 08:00:00	NQ	Futures	15192.71	15217.03	15145.52	15152.47	27816.0
2021-05-11 09:00:00	NQ	Futures	15152.47	15368.44	15129.31	15367.28	114534.0
2021-05-11 10:00:00	NQ	Futures	15367.57	15376.83	15199.66	15300.69	143842.0
2021-05-11 11:00:00	NQ	Futures	15300.69	15431.26	15245.4	15409.54	92824.0
2021-05-11 12:00:00	NQ	Futures	15409.83	15446.6	15340.64	15371.04	60304.0
2021-05-11 13:00:00	NQ	Futures	15370.46	15482.21	15363.51	15441.97	54948.0
2021-05-11 14:00:00	NQ	Futures	15441.97	15488.87	15399.12	15436.47	59290.0
2021-05-11 15:00:00	NQ	Futures	15435.89	15488.0	15390.15	15452.1	77728.0
2021-05-11 16:00:00	NQ	Futures	15452.1	15461.94	15412.73	15420.83	9894.0
2021-05-11 18:00:00	NQ	Futures	15425.76	15441.97	15417.65	15432.13	2886.0
2021-05-11 19:00:00	NQ	Futures	15433.57	15446.6	15407.52	15444.57	3514.0
2021-05-11 20:00:00	NQ	Futures	15446.02	15461.07	15359.17	15373.65	8558.0
2021-05-11 21:00:00	NQ	Futures	15373.36	15417.07	15367.57	15380.59	7253.0
2021-05-11 22:00:00	NQ	Futures	15380.59	15420.26	15379.15	15391.02	4657.0
2021-05-11 23:00:00	NQ	Futures	15391.02	15396.52	15310.25	15324.72	8688.0
2021-05-11 00:00:00	YM	Futures	38515.8	38530.3	38459.0	38476.9	1826.0
2021-05-11 01:00:00	YM	Futures	38476.9	38551.5	38471.3	38547.0	2514.0
2021-05-11 02:00:00	YM	Futures	38545.9	38572.6	38499.1	38540.3	4205.0
2021-05-11 03:00:00	YM	Futures	38540.3	38572.6	38385.5	38452.4	11716.0

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

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