PREVIEW / futures_1hour / 2021-08-30

all futures 1-hour files

  file:    by_date/futures_1hour/2021/2021-08-30.parquet
  size:    57 KB
  rows:    1,832

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-08-30 00:00:00	ES	Futures	5078.9	5079.18	5077.21	5077.49	2251.0
2021-08-30 01:00:00	ES	Futures	5077.21	5079.46	5076.36	5077.49	4750.0
2021-08-30 02:00:00	ES	Futures	5077.77	5078.62	5076.36	5077.21	5476.0
2021-08-30 03:00:00	ES	Futures	5077.21	5078.34	5075.52	5077.77	10619.0
2021-08-30 04:00:00	ES	Futures	5077.77	5079.46	5076.65	5078.62	6529.0
2021-08-30 05:00:00	ES	Futures	5078.62	5079.46	5076.93	5078.34	4340.0
2021-08-30 06:00:00	ES	Futures	5078.62	5081.15	5078.05	5079.18	5564.0
2021-08-30 07:00:00	ES	Futures	5078.9	5079.74	5078.05	5079.18	5020.0
2021-08-30 08:00:00	ES	Futures	5079.46	5082.28	5078.05	5081.43	18605.0
2021-08-30 09:00:00	ES	Futures	5081.15	5089.04	5080.31	5088.47	141885.0
2021-08-30 10:00:00	ES	Futures	5088.75	5104.24	5086.5	5104.24	171227.0
2021-08-30 11:00:00	ES	Futures	5104.24	5107.34	5101.71	5105.09	108941.0
2021-08-30 12:00:00	ES	Futures	5105.37	5105.93	5099.17	5103.4	67231.0
2021-08-30 13:00:00	ES	Futures	5103.4	5105.93	5101.99	5105.93	48078.0
2021-08-30 14:00:00	ES	Futures	5105.93	5107.34	5101.99	5105.09	60950.0
2021-08-30 15:00:00	ES	Futures	5105.09	5106.21	5095.79	5097.48	173754.0
2021-08-30 16:00:00	ES	Futures	5097.2	5102.83	5095.51	5102.27	60050.0
2021-08-30 18:00:00	ES	Futures	5101.71	5103.96	5100.86	5102.55	3479.0
2021-08-30 19:00:00	ES	Futures	5102.55	5102.83	5098.33	5099.45	4359.0
2021-08-30 20:00:00	ES	Futures	5099.45	5100.86	5097.48	5098.05	7210.0
2021-08-30 21:00:00	ES	Futures	5098.05	5099.74	5097.2	5097.48	4863.0
2021-08-30 22:00:00	ES	Futures	5097.76	5098.89	5096.64	5098.33	3685.0
2021-08-30 23:00:00	ES	Futures	5098.33	5104.24	5098.05	5102.83	5643.0
2021-08-30 00:00:00	NQ	Futures	17891.0	17891.87	17881.73	17884.63	1207.0
2021-08-30 01:00:00	NQ	Futures	17884.34	17895.93	17881.44	17888.4	2006.0
2021-08-30 02:00:00	NQ	Futures	17888.98	17891.0	17881.73	17886.95	2189.0
2021-08-30 03:00:00	NQ	Futures	17887.24	17897.96	17880.29	17893.9	5351.0
2021-08-30 04:00:00	NQ	Futures	17893.32	17903.46	17892.74	17901.43	4231.0
2021-08-30 05:00:00	NQ	Futures	17901.72	17904.62	17895.06	17899.12	2304.0
2021-08-30 06:00:00	NQ	Futures	17899.12	17908.1	17896.8	17899.4	3108.0
2021-08-30 07:00:00	NQ	Futures	17899.12	17899.69	17890.14	17895.93	2826.0
2021-08-30 08:00:00	NQ	Futures	17895.64	17904.33	17887.24	17901.43	6928.0
2021-08-30 09:00:00	NQ	Futures	17901.72	17995.0	17896.51	17994.13	67265.0
2021-08-30 10:00:00	NQ	Futures	17994.13	18061.63	17982.83	18057.86	79505.0
2021-08-30 11:00:00	NQ	Futures	18057.28	18073.21	18029.47	18066.84	48378.0
2021-08-30 12:00:00	NQ	Futures	18066.84	18070.03	18037.29	18060.18	37839.0
2021-08-30 13:00:00	NQ	Futures	18060.18	18091.17	18054.38	18090.59	31030.0
2021-08-30 14:00:00	NQ	Futures	18090.88	18096.68	18080.46	18096.1	28637.0
2021-08-30 15:00:00	NQ	Futures	18095.81	18096.1	18068.58	18075.24	56358.0
2021-08-30 16:00:00	NQ	Futures	18074.95	18089.15	18070.32	18083.64	12991.0
2021-08-30 18:00:00	NQ	Futures	18082.48	18090.02	18077.56	18082.48	1947.0
2021-08-30 19:00:00	NQ	Futures	18082.77	18084.51	18071.77	18074.66	2276.0
2021-08-30 20:00:00	NQ	Futures	18074.66	18079.3	18064.52	18067.42	3726.0
2021-08-30 21:00:00	NQ	Futures	18067.71	18074.08	18067.13	18069.74	3117.0
2021-08-30 22:00:00	NQ	Futures	18069.45	18075.53	18063.94	18070.61	2562.0
2021-08-30 23:00:00	NQ	Futures	18070.9	18090.59	18070.03	18087.12	3132.0
2021-08-30 00:00:00	YM	Futures	39583.1	39588.7	39570.8	39576.4	389.0
2021-08-30 01:00:00	YM	Futures	39574.2	39588.7	39568.6	39573.1	836.0
2021-08-30 02:00:00	YM	Futures	39574.2	39582.0	39556.3	39573.1	1139.0
2021-08-30 03:00:00	YM	Futures	39571.9	39583.1	39553.0	39576.4	2007.0

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

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