PREVIEW / futures_1hour / 2021-12-20

all futures 1-hour files

  file:    by_date/futures_1hour/2021/2021-12-20.parquet
  size:    66 KB
  rows:    2,015

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-20 00:00:00	ES	Futures	5167.93	5168.21	5152.94	5154.63	12021.0
2021-12-20 01:00:00	ES	Futures	5154.63	5159.44	5142.47	5151.81	19160.0
2021-12-20 02:00:00	ES	Futures	5152.09	5155.48	5131.44	5150.11	24155.0
2021-12-20 03:00:00	ES	Futures	5150.11	5152.09	5125.79	5131.73	41584.0
2021-12-20 04:00:00	ES	Futures	5131.73	5136.53	5120.13	5136.25	31619.0
2021-12-20 05:00:00	ES	Futures	5136.25	5155.48	5135.69	5151.81	28931.0
2021-12-20 06:00:00	ES	Futures	5152.09	5162.27	5145.02	5161.14	18053.0
2021-12-20 07:00:00	ES	Futures	5160.86	5167.36	5148.69	5148.98	26706.0
2021-12-20 08:00:00	ES	Futures	5149.26	5153.22	5143.32	5148.13	46543.0
2021-12-20 09:00:00	ES	Futures	5148.13	5156.9	5129.18	5146.72	339575.0
2021-12-20 10:00:00	ES	Futures	5146.72	5149.83	5118.72	5122.39	318050.0
2021-12-20 11:00:00	ES	Futures	5122.11	5133.42	5113.34	5132.86	208970.0
2021-12-20 12:00:00	ES	Futures	5132.86	5139.65	5120.13	5121.26	128006.0
2021-12-20 13:00:00	ES	Futures	5121.26	5146.72	5118.15	5139.08	136579.0
2021-12-20 14:00:00	ES	Futures	5138.8	5150.39	5133.42	5141.62	148155.0
2021-12-20 15:00:00	ES	Futures	5141.91	5162.27	5139.36	5157.18	309173.0
2021-12-20 16:00:00	ES	Futures	5156.9	5172.45	5152.94	5168.77	65011.0
2021-12-20 18:00:00	ES	Futures	5167.08	5182.07	5166.79	5179.52	12907.0
2021-12-20 19:00:00	ES	Futures	5179.52	5180.09	5169.62	5173.86	12082.0
2021-12-20 20:00:00	ES	Futures	5173.86	5189.14	5164.81	5186.87	18422.0
2021-12-20 21:00:00	ES	Futures	5187.16	5187.72	5177.26	5181.5	7235.0
2021-12-20 22:00:00	ES	Futures	5181.5	5192.25	5180.93	5188.57	7820.0
2021-12-20 23:00:00	ES	Futures	5188.57	5190.83	5185.74	5189.14	3490.0
2021-12-20 00:00:00	NQ	Futures	18119.08	18121.69	18049.81	18061.69	7081.0
2021-12-20 01:00:00	NQ	Futures	18060.25	18092.42	18040.83	18089.23	8665.0
2021-12-20 02:00:00	NQ	Futures	18090.1	18098.5	18007.21	18070.97	13055.0
2021-12-20 03:00:00	NQ	Futures	18072.13	18094.44	17991.56	18019.09	17906.0
2021-12-20 04:00:00	NQ	Futures	18019.38	18028.37	17972.14	18027.21	13931.0
2021-12-20 05:00:00	NQ	Futures	18026.92	18055.61	18002.86	18046.33	11056.0
2021-12-20 06:00:00	NQ	Futures	18046.91	18078.5	18023.73	18074.74	6816.0
2021-12-20 07:00:00	NQ	Futures	18073.87	18105.17	18041.7	18043.15	10451.0
2021-12-20 08:00:00	NQ	Futures	18043.73	18059.67	18008.08	18041.99	15685.0
2021-12-20 09:00:00	NQ	Futures	18042.28	18152.7	18018.51	18119.66	108609.0
2021-12-20 10:00:00	NQ	Futures	18118.79	18135.31	18001.41	18021.7	97741.0
2021-12-20 11:00:00	NQ	Futures	18020.83	18054.16	17959.39	18051.55	74276.0
2021-12-20 12:00:00	NQ	Futures	18051.26	18084.59	17985.76	17991.56	49811.0
2021-12-20 13:00:00	NQ	Futures	17991.27	18083.72	17977.07	18047.78	44912.0
2021-12-20 14:00:00	NQ	Futures	18047.2	18110.96	18034.16	18079.95	42098.0
2021-12-20 15:00:00	NQ	Futures	18080.82	18144.0	18055.61	18113.28	64479.0
2021-12-20 16:00:00	NQ	Futures	18114.15	18191.24	18096.18	18172.69	14104.0
2021-12-20 18:00:00	NQ	Futures	18170.67	18233.85	18165.74	18223.99	6549.0
2021-12-20 19:00:00	NQ	Futures	18223.7	18226.89	18188.06	18210.95	5426.0
2021-12-20 20:00:00	NQ	Futures	18211.24	18271.52	18172.12	18264.57	9366.0
2021-12-20 21:00:00	NQ	Futures	18264.86	18270.94	18223.7	18232.69	4342.0
2021-12-20 22:00:00	NQ	Futures	18232.11	18290.36	18230.37	18270.94	5404.0
2021-12-20 23:00:00	NQ	Futures	18270.36	18283.98	18262.83	18276.74	2175.0
2021-12-20 00:00:00	YM	Futures	39318.4	39328.5	39208.3	39239.7	2387.0
2021-12-20 01:00:00	YM	Futures	39237.5	39265.6	39083.5	39151.0	4804.0
2021-12-20 02:00:00	YM	Futures	39152.1	39186.9	38995.9	39146.5	7629.0
2021-12-20 03:00:00	YM	Futures	39148.7	39155.4	38973.4	39018.3	11833.0

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

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