PREVIEW / futures_1hour / 2020-01-15

all futures 1-hour files

  file:    by_date/futures_1hour/2020/2020-01-15.parquet
  size:    57 KB
  rows:    1,863

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-01-15 00:00:00	ES	Futures	3556.2	3558.4	3554.3	3557.6	6408.0
2020-01-15 01:00:00	ES	Futures	3557.6	3559.5	3556.5	3558.4	5506.0
2020-01-15 02:00:00	ES	Futures	3558.6	3561.6	3557.8	3560.5	8406.0
2020-01-15 03:00:00	ES	Futures	3560.3	3562.4	3556.2	3558.9	22843.0
2020-01-15 04:00:00	ES	Futures	3558.9	3560.3	3557.8	3558.6	10757.0
2020-01-15 05:00:00	ES	Futures	3558.6	3561.6	3558.6	3561.1	9232.0
2020-01-15 06:00:00	ES	Futures	3560.8	3563.5	3560.8	3562.7	13021.0
2020-01-15 07:00:00	ES	Futures	3562.7	3564.6	3560.3	3563.3	20013.0
2020-01-15 08:00:00	ES	Futures	3563.3	3563.8	3554.3	3555.4	33889.0
2020-01-15 09:00:00	ES	Futures	3555.4	3572.2	3554.3	3571.4	196001.0
2020-01-15 10:00:00	ES	Futures	3571.7	3574.9	3568.1	3574.6	200953.0
2020-01-15 11:00:00	ES	Futures	3574.6	3576.0	3568.4	3571.9	160973.0
2020-01-15 12:00:00	ES	Futures	3572.2	3574.4	3566.0	3566.8	107822.0
2020-01-15 13:00:00	ES	Futures	3566.8	3568.1	3562.2	3564.3	130146.0
2020-01-15 14:00:00	ES	Futures	3564.3	3572.2	3563.8	3567.9	89325.0
2020-01-15 15:00:00	ES	Futures	3568.1	3568.4	3556.7	3567.3	275275.0
2020-01-15 16:00:00	ES	Futures	3567.3	3570.8	3566.8	3570.8	59759.0
2020-01-15 18:00:00	ES	Futures	3570.8	3577.1	3570.6	3573.8	15039.0
2020-01-15 19:00:00	ES	Futures	3573.8	3574.9	3571.9	3571.9	9347.0
2020-01-15 20:00:00	ES	Futures	3571.9	3574.1	3571.1	3573.8	9110.0
2020-01-15 21:00:00	ES	Futures	3573.5	3574.6	3571.9	3573.0	6507.0
2020-01-15 22:00:00	ES	Futures	3573.3	3573.5	3571.4	3573.3	6988.0
2020-01-15 23:00:00	ES	Futures	3573.3	3575.4	3573.0	3575.2	5043.0
2020-01-15 00:00:00	NQ	Futures	10454.48	10461.71	10446.67	10459.11	3066.0
2020-01-15 01:00:00	NQ	Futures	10458.82	10467.49	10455.93	10463.73	2860.0
2020-01-15 02:00:00	NQ	Futures	10463.73	10476.17	10461.71	10471.25	4200.0
2020-01-15 03:00:00	NQ	Futures	10470.96	10479.06	10457.95	10466.92	10919.0
2020-01-15 04:00:00	NQ	Futures	10466.92	10469.81	10461.13	10467.2	5608.0
2020-01-15 05:00:00	NQ	Futures	10467.2	10477.62	10466.92	10473.28	4338.0
2020-01-15 06:00:00	NQ	Futures	10473.57	10482.24	10470.1	10479.35	5940.0
2020-01-15 07:00:00	NQ	Futures	10479.06	10496.7	10475.88	10491.21	10124.0
2020-01-15 08:00:00	NQ	Futures	10491.5	10494.68	10460.26	10464.89	17672.0
2020-01-15 09:00:00	NQ	Futures	10464.89	10510.58	10461.71	10507.4	68834.0
2020-01-15 10:00:00	NQ	Futures	10507.4	10521.28	10493.81	10519.55	67571.0
2020-01-15 11:00:00	NQ	Futures	10519.55	10520.12	10491.5	10499.3	52004.0
2020-01-15 12:00:00	NQ	Futures	10499.59	10512.61	10483.4	10486.29	39330.0
2020-01-15 13:00:00	NQ	Futures	10486.29	10491.5	10460.55	10470.1	47613.0
2020-01-15 14:00:00	NQ	Futures	10470.39	10496.41	10466.92	10481.09	33100.0
2020-01-15 15:00:00	NQ	Futures	10481.09	10482.24	10436.84	10471.25	75408.0
2020-01-15 16:00:00	NQ	Futures	10471.25	10482.24	10470.67	10481.95	9423.0
2020-01-15 18:00:00	NQ	Futures	10481.66	10506.53	10481.37	10495.83	6490.0
2020-01-15 19:00:00	NQ	Futures	10495.83	10498.44	10487.74	10488.03	4264.0
2020-01-15 20:00:00	NQ	Futures	10488.03	10496.12	10483.98	10494.39	4037.0
2020-01-15 21:00:00	NQ	Futures	10494.39	10497.86	10487.16	10492.36	2981.0
2020-01-15 22:00:00	NQ	Futures	10492.36	10492.65	10484.56	10489.76	2387.0
2020-01-15 23:00:00	NQ	Futures	10489.76	10497.28	10489.18	10496.41	2359.0
2020-01-15 00:00:00	YM	Futures	31421.1	31441.8	31408.0	31433.1	1509.0
2020-01-15 01:00:00	YM	Futures	31433.1	31450.5	31423.3	31444.0	1402.0
2020-01-15 02:00:00	YM	Futures	31444.0	31469.0	31440.7	31461.4	2024.0
2020-01-15 03:00:00	YM	Futures	31460.3	31476.6	31417.8	31446.1	5733.0

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

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