PREVIEW / futures_1hour / 2022-03-28

all futures 1-hour files

  file:    by_date/futures_1hour/2022/2022-03-28.parquet
  size:    69 KB
  rows:    2,053

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-03-28 00:00:00	ES	Futures	5126.87	5131.12	5125.73	5127.15	3066.0
2022-03-28 01:00:00	ES	Futures	5127.15	5128.85	5119.5	5122.05	6568.0
2022-03-28 02:00:00	ES	Futures	5122.05	5124.88	5117.8	5121.2	9016.0
2022-03-28 03:00:00	ES	Futures	5121.2	5138.77	5119.5	5133.67	15184.0
2022-03-28 04:00:00	ES	Futures	5133.39	5146.14	5126.02	5145.29	15152.0
2022-03-28 05:00:00	ES	Futures	5145.29	5145.57	5132.54	5138.49	10004.0
2022-03-28 06:00:00	ES	Futures	5138.49	5146.42	5135.94	5143.59	10566.0
2022-03-28 07:00:00	ES	Futures	5143.87	5156.91	5143.87	5155.49	25379.0
2022-03-28 08:00:00	ES	Futures	5155.49	5156.34	5137.64	5139.34	21832.0
2022-03-28 09:00:00	ES	Futures	5139.62	5154.08	5131.12	5152.94	135044.0
2022-03-28 10:00:00	ES	Futures	5152.66	5153.51	5135.37	5150.11	153692.0
2022-03-28 11:00:00	ES	Futures	5149.83	5151.53	5115.53	5117.8	156101.0
2022-03-28 12:00:00	ES	Futures	5117.51	5132.54	5112.98	5131.12	99077.0
2022-03-28 13:00:00	ES	Futures	5131.4	5141.32	5128.57	5139.9	70970.0
2022-03-28 14:00:00	ES	Futures	5140.19	5162.86	5137.35	5162.58	105214.0
2022-03-28 15:00:00	ES	Futures	5162.58	5180.15	5156.91	5180.15	200815.0
2022-03-28 16:00:00	ES	Futures	5180.15	5183.84	5178.17	5181.29	61838.0
2022-03-28 18:00:00	ES	Futures	5181.57	5181.85	5176.47	5180.15	4471.0
2022-03-28 19:00:00	ES	Futures	5180.15	5182.99	5178.45	5178.74	4520.0
2022-03-28 20:00:00	ES	Futures	5179.02	5180.72	5175.9	5177.04	6832.0
2022-03-28 21:00:00	ES	Futures	5177.04	5186.67	5176.75	5184.4	6579.0
2022-03-28 22:00:00	ES	Futures	5184.4	5184.97	5179.3	5180.72	4041.0
2022-03-28 23:00:00	ES	Futures	5180.72	5182.42	5179.87	5181.0	2529.0
2022-03-28 00:00:00	NQ	Futures	17042.99	17056.33	17035.16	17046.18	1793.0
2022-03-28 01:00:00	NQ	Futures	17045.02	17052.27	17009.36	17020.38	4050.0
2022-03-28 02:00:00	NQ	Futures	17019.8	17051.11	17002.69	17028.49	5974.0
2022-03-28 03:00:00	NQ	Futures	17027.91	17095.19	17021.54	17067.64	9264.0
2022-03-28 04:00:00	NQ	Futures	17069.09	17091.13	17032.84	17089.1	8483.0
2022-03-28 05:00:00	NQ	Futures	17088.23	17089.97	17028.49	17063.87	5863.0
2022-03-28 06:00:00	NQ	Futures	17064.74	17107.37	17053.72	17094.9	7482.0
2022-03-28 07:00:00	NQ	Futures	17094.61	17175.8	17094.61	17174.06	10575.0
2022-03-28 08:00:00	NQ	Futures	17173.77	17181.02	17105.05	17117.23	11533.0
2022-03-28 09:00:00	NQ	Futures	17117.81	17296.72	17092.0	17268.01	78937.0
2022-03-28 10:00:00	NQ	Futures	17267.43	17271.78	17142.74	17252.94	87352.0
2022-03-28 11:00:00	NQ	Futures	17252.94	17265.69	17071.41	17089.97	76237.0
2022-03-28 12:00:00	NQ	Futures	17091.42	17155.5	17051.69	17149.12	46733.0
2022-03-28 13:00:00	NQ	Futures	17149.41	17226.84	17145.35	17217.56	35672.0
2022-03-28 14:00:00	NQ	Futures	17218.43	17328.91	17201.32	17328.04	41552.0
2022-03-28 15:00:00	NQ	Futures	17328.04	17384.58	17303.97	17383.71	58119.0
2022-03-28 16:00:00	NQ	Futures	17383.42	17395.02	17374.43	17376.46	15217.0
2022-03-28 18:00:00	NQ	Futures	17376.46	17378.2	17355.59	17368.06	2431.0
2022-03-28 19:00:00	NQ	Futures	17368.64	17384.29	17362.84	17366.9	2517.0
2022-03-28 20:00:00	NQ	Futures	17368.06	17370.96	17348.05	17351.82	2887.0
2022-03-28 21:00:00	NQ	Futures	17352.11	17388.93	17349.5	17380.23	2851.0
2022-03-28 22:00:00	NQ	Futures	17381.97	17382.55	17357.62	17363.71	1911.0
2022-03-28 23:00:00	NQ	Futures	17363.71	17370.67	17356.75	17362.26	1356.0
2022-03-28 00:00:00	YM	Futures	39068.8	39091.3	39065.4	39072.2	533.0
2022-03-28 01:00:00	YM	Futures	39071.0	39082.3	39023.7	39046.2	1159.0
2022-03-28 02:00:00	YM	Futures	39044.0	39051.9	39012.4	39031.6	1526.0
2022-03-28 03:00:00	YM	Futures	39029.3	39149.9	39019.2	39120.6	3045.0

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

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