PREVIEW / futures_1hour / 2021-08-25

all futures 1-hour files

  file:    by_date/futures_1hour/2021/2021-08-25.parquet
  size:    62 KB
  rows:    1,917

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-25 00:00:00	ES	Futures	5043.98	5044.83	5042.29	5042.29	2628.0
2021-08-25 01:00:00	ES	Futures	5042.29	5048.49	5042.29	5047.92	4270.0
2021-08-25 02:00:00	ES	Futures	5048.21	5049.9	5046.52	5048.49	4696.0
2021-08-25 03:00:00	ES	Futures	5048.49	5051.59	5047.64	5049.05	10264.0
2021-08-25 04:00:00	ES	Futures	5049.05	5054.4	5047.36	5051.3	12530.0
2021-08-25 05:00:00	ES	Futures	5051.3	5052.99	5049.9	5051.87	7404.0
2021-08-25 06:00:00	ES	Futures	5051.59	5052.43	5049.33	5051.02	5262.0
2021-08-25 07:00:00	ES	Futures	5051.02	5051.3	5043.98	5047.92	13689.0
2021-08-25 08:00:00	ES	Futures	5048.21	5051.87	5046.23	5051.59	16326.0
2021-08-25 09:00:00	ES	Futures	5051.3	5053.27	5046.8	5053.27	110154.0
2021-08-25 10:00:00	ES	Futures	5053.27	5056.09	5050.46	5054.68	113556.0
2021-08-25 11:00:00	ES	Futures	5054.4	5063.69	5053.84	5062.0	82467.0
2021-08-25 12:00:00	ES	Futures	5062.0	5065.38	5061.44	5064.26	64510.0
2021-08-25 13:00:00	ES	Futures	5064.26	5064.26	5061.44	5062.0	46551.0
2021-08-25 14:00:00	ES	Futures	5062.0	5064.54	5059.47	5062.0	56599.0
2021-08-25 15:00:00	ES	Futures	5062.0	5066.23	5058.62	5060.03	135023.0
2021-08-25 16:00:00	ES	Futures	5060.03	5061.72	5058.91	5061.16	43177.0
2021-08-25 18:00:00	ES	Futures	5061.44	5062.0	5059.47	5060.88	3313.0
2021-08-25 19:00:00	ES	Futures	5060.88	5061.44	5059.47	5060.03	2217.0
2021-08-25 20:00:00	ES	Futures	5060.03	5060.03	5054.12	5056.09	7609.0
2021-08-25 21:00:00	ES	Futures	5055.81	5056.09	5051.02	5053.56	8327.0
2021-08-25 22:00:00	ES	Futures	5053.84	5054.68	5049.61	5052.43	6798.0
2021-08-25 23:00:00	ES	Futures	5052.43	5053.56	5049.9	5052.43	3507.0
2021-08-25 00:00:00	NQ	Futures	17786.14	17788.17	17782.95	17783.53	1018.0
2021-08-25 01:00:00	NQ	Futures	17783.82	17804.97	17782.37	17799.18	2291.0
2021-08-25 02:00:00	NQ	Futures	17799.18	17810.76	17798.02	17803.81	2556.0
2021-08-25 03:00:00	NQ	Futures	17803.52	17820.61	17801.78	17814.53	5127.0
2021-08-25 04:00:00	NQ	Futures	17814.24	17832.2	17802.07	17821.48	5877.0
2021-08-25 05:00:00	NQ	Futures	17821.48	17822.06	17805.26	17810.76	4578.0
2021-08-25 06:00:00	NQ	Futures	17810.18	17815.4	17793.96	17796.86	3661.0
2021-08-25 07:00:00	NQ	Futures	17796.86	17797.15	17767.31	17787.88	8082.0
2021-08-25 08:00:00	NQ	Futures	17787.59	17808.45	17775.71	17804.97	9519.0
2021-08-25 09:00:00	NQ	Futures	17804.68	17840.89	17798.89	17817.71	69629.0
2021-08-25 10:00:00	NQ	Futures	17818.0	17827.85	17766.73	17780.93	83352.0
2021-08-25 11:00:00	NQ	Futures	17780.64	17805.84	17778.61	17790.48	41769.0
2021-08-25 12:00:00	NQ	Futures	17790.77	17811.05	17773.1	17809.31	34850.0
2021-08-25 13:00:00	NQ	Futures	17809.02	17809.89	17781.79	17788.46	25892.0
2021-08-25 14:00:00	NQ	Futures	17788.46	17808.45	17782.95	17801.49	31261.0
2021-08-25 15:00:00	NQ	Futures	17801.49	17825.25	17792.8	17800.91	51192.0
2021-08-25 16:00:00	NQ	Futures	17800.62	17806.71	17797.44	17806.42	9385.0
2021-08-25 18:00:00	NQ	Futures	17806.42	17807.58	17798.02	17804.97	1727.0
2021-08-25 19:00:00	NQ	Futures	17804.97	17805.84	17798.31	17800.04	1145.0
2021-08-25 20:00:00	NQ	Futures	17800.04	17800.62	17775.13	17784.4	3617.0
2021-08-25 21:00:00	NQ	Futures	17784.11	17784.69	17767.89	17776.29	3987.0
2021-08-25 22:00:00	NQ	Futures	17776.87	17778.9	17749.35	17762.1	4922.0
2021-08-25 23:00:00	NQ	Futures	17762.39	17762.97	17754.27	17759.2	1999.0
2021-08-25 00:00:00	YM	Futures	39406.6	39413.3	39391.0	39393.2	463.0
2021-08-25 01:00:00	YM	Futures	39391.0	39440.1	39389.8	39433.4	1098.0
2021-08-25 02:00:00	YM	Futures	39434.5	39456.9	39417.8	39444.6	1251.0
2021-08-25 03:00:00	YM	Futures	39444.6	39473.6	39436.8	39449.1	1786.0

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

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