PREVIEW / futures_1hour / 2022-04-20

all futures 1-hour files

  file:    by_date/futures_1hour/2022/2022-04-20.parquet
  size:    68 KB
  rows:    2,045

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
2022-04-20 00:00:00	ES	Futures	5040.13	5040.7	5036.17	5037.58	3467.0
2022-04-20 01:00:00	ES	Futures	5037.58	5039.0	5030.78	5037.58	7549.0
2022-04-20 02:00:00	ES	Futures	5037.58	5038.43	5027.95	5033.33	9665.0
2022-04-20 03:00:00	ES	Futures	5033.05	5042.97	5026.53	5035.03	18494.0
2022-04-20 04:00:00	ES	Futures	5035.32	5042.97	5028.8	5040.98	13777.0
2022-04-20 05:00:00	ES	Futures	5041.27	5057.14	5040.42	5055.44	21988.0
2022-04-20 06:00:00	ES	Futures	5055.44	5062.24	5051.47	5059.97	15480.0
2022-04-20 07:00:00	ES	Futures	5059.97	5077.26	5054.59	5076.13	26883.0
2022-04-20 08:00:00	ES	Futures	5076.41	5079.82	5071.03	5078.97	33032.0
2022-04-20 09:00:00	ES	Futures	5078.97	5084.07	5048.35	5055.72	199833.0
2022-04-20 10:00:00	ES	Futures	5055.72	5081.23	5048.07	5077.55	196239.0
2022-04-20 11:00:00	ES	Futures	5077.55	5078.11	5056.01	5066.78	138963.0
2022-04-20 12:00:00	ES	Futures	5066.78	5074.43	5052.89	5069.89	116468.0
2022-04-20 13:00:00	ES	Futures	5069.61	5080.38	5065.08	5073.58	117190.0
2022-04-20 14:00:00	ES	Futures	5073.58	5076.98	5037.87	5044.1	130969.0
2022-04-20 15:00:00	ES	Futures	5044.1	5071.03	5042.68	5051.75	231112.0
2022-04-20 16:00:00	ES	Futures	5051.75	5069.33	5049.77	5067.06	59079.0
2022-04-20 18:00:00	ES	Futures	5065.64	5072.16	5065.08	5066.49	6514.0
2022-04-20 19:00:00	ES	Futures	5066.78	5072.45	5065.93	5069.04	3213.0
2022-04-20 20:00:00	ES	Futures	5068.76	5073.58	5068.48	5070.46	6227.0
2022-04-20 21:00:00	ES	Futures	5070.46	5076.98	5067.34	5075.85	6734.0
2022-04-20 22:00:00	ES	Futures	5075.56	5078.4	5073.58	5075.0	4794.0
2022-04-20 23:00:00	ES	Futures	5075.28	5076.41	5068.48	5069.04	3950.0
2022-04-20 00:00:00	NQ	Futures	16380.4	16384.17	16355.46	16361.55	2338.0
2022-04-20 01:00:00	NQ	Futures	16362.42	16371.41	16331.68	16359.52	4360.0
2022-04-20 02:00:00	NQ	Futures	16358.65	16366.19	16317.19	16348.5	5277.0
2022-04-20 03:00:00	NQ	Futures	16347.05	16400.41	16315.45	16360.1	10359.0
2022-04-20 04:00:00	NQ	Futures	16360.1	16416.94	16334.58	16407.37	7315.0
2022-04-20 05:00:00	NQ	Futures	16408.24	16488.27	16405.05	16477.83	11382.0
2022-04-20 06:00:00	NQ	Futures	16478.12	16487.69	16448.25	16468.55	7309.0
2022-04-20 07:00:00	NQ	Futures	16469.13	16584.25	16451.15	16575.84	15373.0
2022-04-20 08:00:00	NQ	Futures	16575.55	16580.48	16540.76	16575.55	17876.0
2022-04-20 09:00:00	NQ	Futures	16575.26	16577.87	16312.55	16339.22	90752.0
2022-04-20 10:00:00	NQ	Futures	16339.22	16411.14	16281.81	16386.78	96889.0
2022-04-20 11:00:00	NQ	Futures	16385.91	16390.26	16263.54	16290.22	60391.0
2022-04-20 12:00:00	NQ	Futures	16290.51	16322.7	16214.82	16301.24	52545.0
2022-04-20 13:00:00	NQ	Futures	16300.37	16373.15	16280.65	16330.81	44411.0
2022-04-20 14:00:00	NQ	Futures	16330.52	16345.6	16188.15	16225.55	46868.0
2022-04-20 15:00:00	NQ	Futures	16224.68	16328.78	16218.88	16242.66	71042.0
2022-04-20 16:00:00	NQ	Futures	16242.95	16345.6	16228.45	16319.8	28846.0
2022-04-20 18:00:00	NQ	Futures	16319.8	16345.02	16311.97	16320.67	3838.0
2022-04-20 19:00:00	NQ	Futures	16320.38	16342.41	16318.35	16335.45	1953.0
2022-04-20 20:00:00	NQ	Futures	16334.87	16359.52	16329.07	16344.15	3958.0
2022-04-20 21:00:00	NQ	Futures	16344.73	16383.59	16326.46	16369.09	4183.0
2022-04-20 22:00:00	NQ	Futures	16369.96	16379.82	16347.92	16356.62	3167.0
2022-04-20 23:00:00	NQ	Futures	16357.78	16366.48	16327.91	16334.58	3507.0
2022-04-20 00:00:00	YM	Futures	39241.3	39243.5	39216.5	39234.5	557.0
2022-04-20 01:00:00	YM	Futures	39234.5	39243.5	39189.4	39234.5	1540.0
2022-04-20 02:00:00	YM	Futures	39233.4	39239.0	39170.2	39199.5	2944.0
2022-04-20 03:00:00	YM	Futures	39199.5	39266.1	39151.1	39213.1	5387.0

> showing 50 of 2,045 rows — these rows as CSV

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