PREVIEW / futures_1hour / 2020-05-21

all futures 1-hour files

  file:    by_date/futures_1hour/2020/2020-05-21.parquet
  size:    60 KB
  rows:    1,872

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-21 00:00:00	ES	Futures	3239.74	3244.67	3236.17	3243.58	6170.0
2020-05-21 01:00:00	ES	Futures	3243.85	3246.32	3238.36	3239.46	7098.0
2020-05-21 02:00:00	ES	Futures	3239.74	3241.93	3234.8	3235.89	10428.0
2020-05-21 03:00:00	ES	Futures	3236.17	3244.13	3230.13	3237.81	22828.0
2020-05-21 04:00:00	ES	Futures	3237.54	3241.93	3228.76	3240.28	19845.0
2020-05-21 05:00:00	ES	Futures	3240.28	3243.03	3232.87	3233.7	23663.0
2020-05-21 06:00:00	ES	Futures	3233.42	3241.38	3230.95	3238.36	19451.0
2020-05-21 07:00:00	ES	Futures	3238.09	3247.42	3238.09	3241.11	26628.0
2020-05-21 08:00:00	ES	Futures	3241.38	3253.46	3238.91	3249.61	44525.0
2020-05-21 09:00:00	ES	Futures	3249.61	3263.33	3247.14	3257.3	157643.0
2020-05-21 10:00:00	ES	Futures	3257.3	3260.87	3237.27	3243.03	253937.0
2020-05-21 11:00:00	ES	Futures	3243.03	3243.03	3219.43	3232.33	242672.0
2020-05-21 12:00:00	ES	Futures	3232.6	3244.13	3229.31	3233.42	149344.0
2020-05-21 13:00:00	ES	Futures	3233.42	3243.3	3230.95	3235.89	126409.0
2020-05-21 14:00:00	ES	Futures	3235.89	3243.03	3227.11	3230.68	111355.0
2020-05-21 15:00:00	ES	Futures	3230.68	3241.11	3228.21	3231.5	228957.0
2020-05-21 16:00:00	ES	Futures	3231.78	3233.15	3223.0	3223.27	56285.0
2020-05-21 18:00:00	ES	Futures	3223.54	3233.97	3220.53	3232.05	11814.0
2020-05-21 19:00:00	ES	Futures	3231.78	3238.09	3231.5	3237.27	7714.0
2020-05-21 20:00:00	ES	Futures	3237.54	3240.83	3233.7	3234.52	9993.0
2020-05-21 21:00:00	ES	Futures	3234.25	3236.99	3219.98	3226.01	23080.0
2020-05-21 22:00:00	ES	Futures	3226.01	3226.01	3208.45	3210.65	22909.0
2020-05-21 23:00:00	ES	Futures	3210.92	3212.84	3200.22	3204.61	19077.0
2020-05-21 00:00:00	NQ	Futures	10790.65	10808.64	10780.93	10804.07	2895.0
2020-05-21 01:00:00	NQ	Futures	10804.07	10812.07	10784.36	10789.22	3169.0
2020-05-21 02:00:00	NQ	Futures	10789.79	10796.36	10773.51	10778.65	4487.0
2020-05-21 03:00:00	NQ	Futures	10778.65	10800.64	10755.8	10782.36	8554.0
2020-05-21 04:00:00	NQ	Futures	10781.51	10796.64	10752.37	10783.79	7591.0
2020-05-21 05:00:00	NQ	Futures	10784.65	10792.07	10765.51	10767.51	7330.0
2020-05-21 06:00:00	NQ	Futures	10767.22	10784.36	10758.65	10778.36	5922.0
2020-05-21 07:00:00	NQ	Futures	10778.36	10811.5	10778.36	10796.93	8604.0
2020-05-21 08:00:00	NQ	Futures	10797.5	10830.35	10785.22	10822.07	15734.0
2020-05-21 09:00:00	NQ	Futures	10822.35	10866.63	10803.21	10826.35	46685.0
2020-05-21 10:00:00	NQ	Futures	10826.07	10833.49	10726.95	10765.51	72432.0
2020-05-21 11:00:00	NQ	Futures	10765.22	10765.51	10688.67	10737.23	54264.0
2020-05-21 12:00:00	NQ	Futures	10737.52	10782.08	10733.52	10740.66	40099.0
2020-05-21 13:00:00	NQ	Futures	10740.37	10772.37	10727.52	10741.23	32355.0
2020-05-21 14:00:00	NQ	Futures	10741.23	10768.94	10703.53	10722.38	41190.0
2020-05-21 15:00:00	NQ	Futures	10722.38	10754.37	10703.24	10715.24	43852.0
2020-05-21 16:00:00	NQ	Futures	10715.52	10720.09	10685.25	10693.53	8044.0
2020-05-21 18:00:00	NQ	Futures	10694.96	10724.66	10680.96	10721.24	3122.0
2020-05-21 19:00:00	NQ	Futures	10722.09	10745.52	10722.09	10743.23	2812.0
2020-05-21 20:00:00	NQ	Futures	10743.8	10749.23	10725.52	10728.09	4958.0
2020-05-21 21:00:00	NQ	Futures	10727.23	10734.38	10684.1	10701.81	8533.0
2020-05-21 22:00:00	NQ	Futures	10701.53	10701.53	10634.97	10641.83	8362.0
2020-05-21 23:00:00	NQ	Futures	10642.4	10648.68	10606.41	10626.97	6690.0
2020-05-21 00:00:00	YM	Futures	26698.4	26734.5	26668.8	26725.7	1640.0
2020-05-21 01:00:00	YM	Futures	26726.8	26753.1	26685.2	26691.8	2057.0
2020-05-21 02:00:00	YM	Futures	26694.0	26712.6	26660.0	26672.1	2994.0
2020-05-21 03:00:00	YM	Futures	26673.2	26737.8	26616.2	26686.3	7384.0

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

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