PREVIEW / futures_1hour / 2020-05-22

all futures 1-hour files

  file:    by_date/futures_1hour/2020/2020-05-22.parquet
  size:    51 KB
  rows:    1,522

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-05-22 00:00:00	ES	Futures	3204.61	3209.0	3201.32	3202.96	11401.0
2020-05-22 01:00:00	ES	Futures	3202.96	3203.51	3194.46	3199.67	18658.0
2020-05-22 02:00:00	ES	Futures	3199.67	3208.73	3198.85	3200.49	18831.0
2020-05-22 03:00:00	ES	Futures	3200.49	3202.96	3187.32	3191.16	42457.0
2020-05-22 04:00:00	ES	Futures	3191.44	3207.35	3191.16	3206.81	28346.0
2020-05-22 05:00:00	ES	Futures	3206.53	3212.84	3203.79	3204.88	22560.0
2020-05-22 06:00:00	ES	Futures	3204.88	3214.76	3204.61	3212.02	21499.0
2020-05-22 07:00:00	ES	Futures	3212.29	3230.41	3211.47	3228.21	44858.0
2020-05-22 08:00:00	ES	Futures	3228.21	3233.42	3224.09	3227.11	54548.0
2020-05-22 09:00:00	ES	Futures	3227.11	3233.15	3216.14	3225.74	165100.0
2020-05-22 10:00:00	ES	Futures	3225.74	3229.03	3214.21	3216.68	202920.0
2020-05-22 11:00:00	ES	Futures	3216.41	3224.92	3214.76	3222.45	114272.0
2020-05-22 12:00:00	ES	Futures	3222.45	3230.95	3219.15	3227.66	78621.0
2020-05-22 13:00:00	ES	Futures	3227.39	3232.05	3226.01	3231.23	70326.0
2020-05-22 14:00:00	ES	Futures	3231.5	3238.64	3230.68	3234.52	92358.0
2020-05-22 15:00:00	ES	Futures	3234.25	3241.11	3225.74	3238.36	206848.0
2020-05-22 16:00:00	ES	Futures	3238.36	3246.32	3237.81	3244.95	52498.0
2020-05-22 00:00:00	NQ	Futures	10627.55	10637.83	10608.12	10615.83	5019.0
2020-05-22 01:00:00	NQ	Futures	10615.26	10618.41	10586.98	10609.55	6550.0
2020-05-22 02:00:00	NQ	Futures	10609.26	10632.97	10598.7	10602.12	6731.0
2020-05-22 03:00:00	NQ	Futures	10602.12	10612.69	10558.99	10575.27	13345.0
2020-05-22 04:00:00	NQ	Futures	10575.56	10623.55	10575.56	10621.83	8586.0
2020-05-22 05:00:00	NQ	Futures	10621.83	10638.11	10609.84	10612.12	7303.0
2020-05-22 06:00:00	NQ	Futures	10612.41	10644.97	10612.12	10634.12	6910.0
2020-05-22 07:00:00	NQ	Futures	10635.26	10693.24	10635.26	10687.53	12420.0
2020-05-22 08:00:00	NQ	Futures	10688.39	10700.1	10669.82	10682.39	17357.0
2020-05-22 09:00:00	NQ	Futures	10681.82	10738.66	10648.4	10732.95	54957.0
2020-05-22 10:00:00	NQ	Futures	10733.23	10736.09	10671.82	10680.67	50615.0
2020-05-22 11:00:00	NQ	Futures	10680.1	10705.24	10667.25	10698.38	31355.0
2020-05-22 12:00:00	NQ	Futures	10698.38	10733.23	10687.53	10718.09	20713.0
2020-05-22 13:00:00	NQ	Futures	10718.09	10747.8	10717.81	10736.95	22570.0
2020-05-22 14:00:00	NQ	Futures	10737.52	10760.37	10732.95	10743.23	20118.0
2020-05-22 15:00:00	NQ	Futures	10743.52	10756.66	10710.95	10747.23	33861.0
2020-05-22 16:00:00	NQ	Futures	10747.23	10765.8	10742.94	10764.65	8268.0
2020-05-22 00:00:00	YM	Futures	26535.2	26562.5	26508.9	26527.5	3206.0
2020-05-22 01:00:00	YM	Futures	26529.7	26530.8	26453.0	26499.0	4015.0
2020-05-22 02:00:00	YM	Futures	26500.1	26571.3	26490.3	26506.7	4904.0
2020-05-22 03:00:00	YM	Futures	26505.6	26523.1	26398.2	26430.0	9888.0
2020-05-22 04:00:00	YM	Futures	26431.1	26559.3	26430.0	26557.1	6495.0
2020-05-22 05:00:00	YM	Futures	26557.1	26606.4	26529.7	26538.4	5804.0
2020-05-22 06:00:00	YM	Futures	26538.4	26620.6	26535.2	26592.1	5593.0
2020-05-22 07:00:00	YM	Futures	26595.4	26731.2	26589.9	26717.0	7941.0
2020-05-22 08:00:00	YM	Futures	26717.0	26776.1	26708.2	26725.7	10722.0
2020-05-22 09:00:00	YM	Futures	26724.7	26771.8	26588.8	26638.1	24855.0
2020-05-22 10:00:00	YM	Futures	26638.1	26685.2	26547.2	26571.3	23072.0
2020-05-22 11:00:00	YM	Futures	26570.2	26635.9	26553.8	26609.6	13257.0
2020-05-22 12:00:00	YM	Futures	26611.8	26667.7	26575.7	26641.4	10547.0
2020-05-22 13:00:00	YM	Futures	26642.5	26677.6	26625.0	26668.8	7624.0
2020-05-22 14:00:00	YM	Futures	26669.9	26734.5	26665.5	26697.3	11705.0
2020-05-22 15:00:00	YM	Futures	26696.2	26763.0	26630.5	26736.7	20241.0

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

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