PREVIEW / futures_1hour / 2022-01-19

all futures 1-hour files

  file:    by_date/futures_1hour/2022/2022-01-19.parquet
  size:    67 KB
  rows:    2,034

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-01-19 00:00:00	ES	Futures	5137.95	5140.78	5134.27	5139.08	15437.0
2022-01-19 01:00:00	ES	Futures	5139.36	5146.15	5135.69	5139.36	11210.0
2022-01-19 02:00:00	ES	Futures	5139.36	5141.06	5130.6	5137.38	21654.0
2022-01-19 03:00:00	ES	Futures	5137.38	5167.64	5130.6	5166.23	40484.0
2022-01-19 04:00:00	ES	Futures	5166.23	5182.91	5158.31	5180.65	28455.0
2022-01-19 05:00:00	ES	Futures	5180.93	5184.05	5175.84	5183.76	16352.0
2022-01-19 06:00:00	ES	Futures	5183.76	5188.85	5173.3	5185.18	25624.0
2022-01-19 07:00:00	ES	Futures	5185.46	5187.44	5178.67	5185.46	26893.0
2022-01-19 08:00:00	ES	Futures	5185.46	5197.34	5184.89	5195.64	65692.0
2022-01-19 09:00:00	ES	Futures	5195.92	5206.95	5185.46	5205.54	227619.0
2022-01-19 10:00:00	ES	Futures	5205.26	5206.1	5160.29	5169.34	293031.0
2022-01-19 11:00:00	ES	Futures	5169.34	5176.13	5151.81	5174.43	215180.0
2022-01-19 12:00:00	ES	Futures	5174.43	5191.68	5173.86	5189.98	137128.0
2022-01-19 13:00:00	ES	Futures	5189.7	5190.83	5167.08	5170.75	120137.0
2022-01-19 14:00:00	ES	Futures	5170.75	5173.3	5146.15	5158.59	158950.0
2022-01-19 15:00:00	ES	Futures	5158.88	5167.36	5114.48	5118.44	333969.0
2022-01-19 16:00:00	ES	Futures	5118.72	5124.37	5109.95	5118.15	83514.0
2022-01-19 18:00:00	ES	Futures	5119.85	5123.53	5106.84	5108.54	15536.0
2022-01-19 19:00:00	ES	Futures	5108.25	5127.2	5108.25	5121.83	17394.0
2022-01-19 20:00:00	ES	Futures	5122.11	5127.48	5108.82	5121.55	19755.0
2022-01-19 21:00:00	ES	Futures	5121.83	5129.75	5121.55	5124.09	10097.0
2022-01-19 22:00:00	ES	Futures	5124.37	5141.62	5122.68	5139.36	12968.0
2022-01-19 23:00:00	ES	Futures	5139.65	5143.6	5138.23	5139.36	8988.0
2022-01-19 00:00:00	NQ	Futures	17464.96	17484.09	17447.86	17479.45	9567.0
2022-01-19 01:00:00	NQ	Futures	17479.45	17525.82	17469.02	17494.81	6961.0
2022-01-19 02:00:00	NQ	Futures	17495.68	17498.29	17453.66	17488.44	9257.0
2022-01-19 03:00:00	NQ	Futures	17487.28	17617.98	17460.9	17613.06	20433.0
2022-01-19 04:00:00	NQ	Futures	17613.06	17698.84	17589.0	17691.6	17641.0
2022-01-19 05:00:00	NQ	Futures	17692.47	17700.87	17658.27	17696.82	9048.0
2022-01-19 06:00:00	NQ	Futures	17696.53	17708.99	17646.68	17701.45	10958.0
2022-01-19 07:00:00	NQ	Futures	17702.61	17710.73	17657.69	17695.08	10402.0
2022-01-19 08:00:00	NQ	Futures	17695.08	17763.18	17689.86	17752.17	24325.0
2022-01-19 09:00:00	NQ	Futures	17753.04	17815.64	17680.3	17807.82	98771.0
2022-01-19 10:00:00	NQ	Futures	17807.24	17820.28	17571.9	17622.91	123711.0
2022-01-19 11:00:00	NQ	Futures	17621.46	17652.18	17510.17	17614.22	94885.0
2022-01-19 12:00:00	NQ	Futures	17614.8	17756.81	17612.77	17750.14	63545.0
2022-01-19 13:00:00	NQ	Futures	17749.85	17755.65	17654.21	17681.45	46769.0
2022-01-19 14:00:00	NQ	Futures	17680.59	17695.37	17555.96	17603.78	58454.0
2022-01-19 15:00:00	NQ	Futures	17604.07	17639.14	17417.43	17431.92	83177.0
2022-01-19 16:00:00	NQ	Futures	17431.92	17449.31	17402.07	17431.92	21048.0
2022-01-19 18:00:00	NQ	Futures	17438.01	17455.11	17381.78	17395.12	9629.0
2022-01-19 19:00:00	NQ	Futures	17393.96	17470.18	17393.67	17449.89	10440.0
2022-01-19 20:00:00	NQ	Futures	17450.76	17473.95	17402.07	17452.79	10496.0
2022-01-19 21:00:00	NQ	Futures	17453.37	17485.25	17451.34	17462.93	6804.0
2022-01-19 22:00:00	NQ	Futures	17462.93	17538.57	17456.85	17526.69	7227.0
2022-01-19 23:00:00	NQ	Futures	17527.27	17542.34	17514.81	17520.61	3890.0
2022-01-19 00:00:00	YM	Futures	39420.7	39440.9	39390.3	39416.2	2924.0
2022-01-19 01:00:00	YM	Futures	39419.5	39461.1	39394.8	39416.2	2605.0
2022-01-19 02:00:00	YM	Futures	39419.5	39429.7	39370.1	39404.9	6106.0
2022-01-19 03:00:00	YM	Futures	39403.8	39602.7	39351.0	39583.6	10511.0

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

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