PREVIEW / futures_1hour / 2021-12-31

all futures 1-hour files

  file:    by_date/futures_1hour/2021/2021-12-31.parquet
  size:    44 KB
  rows:    1,248

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-12-31 00:00:00	ES	Futures	5388.23	5393.32	5385.97	5391.9	2765.0
2021-12-31 01:00:00	ES	Futures	5391.9	5393.88	5389.08	5389.93	1977.0
2021-12-31 02:00:00	ES	Futures	5389.93	5393.88	5389.93	5392.47	2573.0
2021-12-31 03:00:00	ES	Futures	5392.47	5397.28	5392.19	5394.45	4712.0
2021-12-31 04:00:00	ES	Futures	5394.45	5396.71	5390.21	5394.45	3800.0
2021-12-31 05:00:00	ES	Futures	5394.45	5394.73	5389.08	5389.93	2525.0
2021-12-31 06:00:00	ES	Futures	5389.93	5390.77	5383.42	5385.12	4812.0
2021-12-31 07:00:00	ES	Futures	5385.12	5394.17	5380.03	5392.47	11163.0
2021-12-31 08:00:00	ES	Futures	5392.47	5395.58	5390.21	5391.9	9611.0
2021-12-31 09:00:00	ES	Futures	5391.9	5405.48	5389.36	5392.47	106350.0
2021-12-31 10:00:00	ES	Futures	5392.19	5398.69	5382.29	5393.32	129509.0
2021-12-31 11:00:00	ES	Futures	5393.32	5395.3	5387.1	5387.95	57355.0
2021-12-31 12:00:00	ES	Futures	5387.95	5397.56	5383.7	5397.0	62579.0
2021-12-31 13:00:00	ES	Futures	5397.0	5401.52	5394.45	5399.54	47016.0
2021-12-31 14:00:00	ES	Futures	5399.54	5403.5	5393.04	5395.02	56803.0
2021-12-31 15:00:00	ES	Futures	5395.3	5405.2	5381.44	5383.99	254218.0
2021-12-31 16:00:00	ES	Futures	5383.99	5391.9	5383.7	5386.25	56759.0
2021-12-31 00:00:00	NQ	Futures	19021.86	19036.93	19013.45	19029.68	2007.0
2021-12-31 01:00:00	NQ	Futures	19031.13	19036.93	19016.93	19023.6	1766.0
2021-12-31 02:00:00	NQ	Futures	19023.6	19036.93	19022.73	19035.48	1685.0
2021-12-31 03:00:00	NQ	Futures	19035.48	19050.26	19029.68	19034.61	3128.0
2021-12-31 04:00:00	NQ	Futures	19034.32	19043.31	19008.53	19025.05	3557.0
2021-12-31 05:00:00	NQ	Futures	19025.92	19027.95	19010.56	19013.74	1601.0
2021-12-31 06:00:00	NQ	Futures	19012.87	19017.8	18983.6	18994.33	3413.0
2021-12-31 07:00:00	NQ	Futures	18993.46	19034.9	18977.52	19031.42	4676.0
2021-12-31 08:00:00	NQ	Futures	19032.58	19056.35	19021.57	19044.17	6145.0
2021-12-31 09:00:00	NQ	Futures	19043.89	19086.2	18993.46	19007.08	61200.0
2021-12-31 10:00:00	NQ	Futures	19006.79	19035.77	18958.68	18996.93	60953.0
2021-12-31 11:00:00	NQ	Futures	18997.51	19018.38	18961.58	18980.71	31852.0
2021-12-31 12:00:00	NQ	Futures	18980.99	18998.96	18950.85	18997.51	30941.0
2021-12-31 13:00:00	NQ	Futures	18997.22	19008.82	18966.79	18982.44	21489.0
2021-12-31 14:00:00	NQ	Futures	18982.73	18992.88	18961.29	18969.69	22519.0
2021-12-31 15:00:00	NQ	Futures	18970.27	18999.83	18912.02	18925.06	60828.0
2021-12-31 16:00:00	NQ	Futures	18925.35	18960.13	18924.19	18932.6	11327.0
2021-12-31 00:00:00	YM	Futures	40705.2	40743.4	40693.9	40735.5	773.0
2021-12-31 01:00:00	YM	Futures	40736.6	40746.7	40716.4	40716.4	548.0
2021-12-31 02:00:00	YM	Futures	40720.9	40750.1	40718.7	40731.0	924.0
2021-12-31 03:00:00	YM	Futures	40729.9	40783.8	40729.9	40755.7	1126.0
2021-12-31 04:00:00	YM	Futures	40754.6	40771.5	40735.5	40760.2	919.0
2021-12-31 05:00:00	YM	Futures	40760.2	40762.5	40707.4	40719.8	822.0
2021-12-31 06:00:00	YM	Futures	40720.9	40726.5	40661.3	40682.7	1575.0
2021-12-31 07:00:00	YM	Futures	40682.7	40733.3	40635.5	40719.8	1937.0
2021-12-31 08:00:00	YM	Futures	40720.9	40734.4	40696.2	40713.0	1681.0
2021-12-31 09:00:00	YM	Futures	40711.9	40831.0	40704.0	40726.5	11223.0
2021-12-31 10:00:00	YM	Futures	40729.9	40769.2	40674.8	40740.0	9414.0
2021-12-31 11:00:00	YM	Futures	40741.1	40771.5	40688.3	40690.6	6135.0
2021-12-31 12:00:00	YM	Futures	40692.8	40785.0	40665.8	40779.3	4747.0
2021-12-31 13:00:00	YM	Futures	40780.5	40850.1	40773.7	40850.1	4539.0
2021-12-31 14:00:00	YM	Futures	40850.1	40873.7	40798.4	40810.8	4850.0
2021-12-31 15:00:00	YM	Futures	40811.9	40855.8	40699.5	40715.3	11652.0

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

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