PREVIEW / futures_1hour / 2021-08-26

all futures 1-hour files

  file:    by_date/futures_1hour/2021/2021-08-26.parquet
  size:    61 KB
  rows:    1,936

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-26 00:00:00	ES	Futures	5052.43	5054.4	5052.15	5053.27	2281.0
2021-08-26 01:00:00	ES	Futures	5052.99	5055.53	5052.71	5054.96	3598.0
2021-08-26 02:00:00	ES	Futures	5055.25	5055.81	5050.18	5051.3	9382.0
2021-08-26 03:00:00	ES	Futures	5051.3	5058.62	5046.23	5056.37	27705.0
2021-08-26 04:00:00	ES	Futures	5056.65	5059.19	5054.4	5054.68	9754.0
2021-08-26 05:00:00	ES	Futures	5054.4	5056.09	5050.74	5056.09	9704.0
2021-08-26 06:00:00	ES	Futures	5055.81	5058.06	5054.4	5056.65	8835.0
2021-08-26 07:00:00	ES	Futures	5056.37	5060.6	5055.81	5058.91	10712.0
2021-08-26 08:00:00	ES	Futures	5059.19	5060.6	5051.3	5055.25	35022.0
2021-08-26 09:00:00	ES	Futures	5055.25	5059.47	5051.87	5051.87	122689.0
2021-08-26 10:00:00	ES	Futures	5051.59	5056.65	5032.72	5037.51	276785.0
2021-08-26 11:00:00	ES	Futures	5037.51	5048.77	5029.34	5043.98	203988.0
2021-08-26 12:00:00	ES	Futures	5043.98	5050.74	5043.98	5046.52	80609.0
2021-08-26 13:00:00	ES	Futures	5046.52	5048.77	5040.32	5043.7	68742.0
2021-08-26 14:00:00	ES	Futures	5043.7	5043.98	5034.69	5035.53	112850.0
2021-08-26 15:00:00	ES	Futures	5035.25	5038.07	5029.06	5030.18	220153.0
2021-08-26 16:00:00	ES	Futures	5030.18	5035.53	5030.18	5034.69	46347.0
2021-08-26 18:00:00	ES	Futures	5034.69	5036.94	5033.56	5034.13	4975.0
2021-08-26 19:00:00	ES	Futures	5034.13	5034.13	5028.21	5030.18	5453.0
2021-08-26 20:00:00	ES	Futures	5030.18	5031.31	5025.96	5031.03	11705.0
2021-08-26 21:00:00	ES	Futures	5030.75	5036.38	5029.9	5034.97	8104.0
2021-08-26 22:00:00	ES	Futures	5035.25	5043.7	5034.97	5040.6	9484.0
2021-08-26 23:00:00	ES	Futures	5040.6	5041.73	5039.76	5040.6	2933.0
2021-08-26 00:00:00	NQ	Futures	17758.91	17765.57	17754.27	17760.36	1520.0
2021-08-26 01:00:00	NQ	Futures	17760.07	17775.13	17757.75	17772.81	2475.0
2021-08-26 02:00:00	NQ	Futures	17773.1	17776.58	17742.98	17744.43	4855.0
2021-08-26 03:00:00	NQ	Futures	17744.14	17775.13	17723.28	17771.08	9973.0
2021-08-26 04:00:00	NQ	Futures	17771.37	17782.95	17763.25	17763.83	4119.0
2021-08-26 05:00:00	NQ	Futures	17764.12	17766.15	17748.48	17761.52	4090.0
2021-08-26 06:00:00	NQ	Futures	17761.52	17778.03	17758.62	17771.37	3709.0
2021-08-26 07:00:00	NQ	Futures	17771.95	17792.22	17768.18	17775.71	5808.0
2021-08-26 08:00:00	NQ	Futures	17776.0	17784.11	17747.32	17760.07	14359.0
2021-08-26 09:00:00	NQ	Futures	17760.36	17800.62	17755.14	17769.05	71507.0
2021-08-26 10:00:00	NQ	Futures	17768.76	17803.81	17691.7	17724.44	114307.0
2021-08-26 11:00:00	NQ	Futures	17724.44	17764.12	17676.64	17751.38	91175.0
2021-08-26 12:00:00	NQ	Futures	17751.09	17787.88	17749.93	17766.73	47281.0
2021-08-26 13:00:00	NQ	Futures	17767.02	17771.37	17737.47	17759.49	32893.0
2021-08-26 14:00:00	NQ	Futures	17759.78	17762.1	17719.51	17721.54	43356.0
2021-08-26 15:00:00	NQ	Futures	17721.54	17729.07	17688.81	17698.08	81369.0
2021-08-26 16:00:00	NQ	Futures	17698.66	17714.59	17685.91	17713.72	11465.0
2021-08-26 18:00:00	NQ	Futures	17712.27	17718.93	17705.9	17713.72	2142.0
2021-08-26 19:00:00	NQ	Futures	17713.72	17714.01	17697.5	17703.29	2431.0
2021-08-26 20:00:00	NQ	Futures	17702.71	17705.9	17688.52	17704.45	3731.0
2021-08-26 21:00:00	NQ	Futures	17703.87	17727.91	17702.13	17719.51	3489.0
2021-08-26 22:00:00	NQ	Futures	17720.38	17761.52	17720.09	17751.96	5048.0
2021-08-26 23:00:00	NQ	Futures	17752.25	17757.75	17749.35	17753.7	1666.0
2021-08-26 00:00:00	YM	Futures	39469.2	39488.2	39463.6	39472.5	662.0
2021-08-26 01:00:00	YM	Futures	39473.6	39487.0	39470.3	39483.7	641.0
2021-08-26 02:00:00	YM	Futures	39483.7	39488.2	39458.0	39469.2	1805.0
2021-08-26 03:00:00	YM	Futures	39469.2	39523.9	39425.6	39508.3	4736.0

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

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