PREVIEW / futures_1hour / 2022-01-11

all futures 1-hour files

  file:    by_date/futures_1hour/2022/2022-01-11.parquet
  size:    66 KB
  rows:    2,031

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-11 00:00:00	ES	Futures	5273.13	5276.52	5270.02	5272.28	6994.0
2022-01-11 01:00:00	ES	Futures	5272.56	5274.26	5263.8	5270.3	8117.0
2022-01-11 02:00:00	ES	Futures	5270.58	5278.5	5266.91	5277.65	10665.0
2022-01-11 03:00:00	ES	Futures	5277.37	5285.29	5266.91	5279.35	29471.0
2022-01-11 04:00:00	ES	Futures	5279.07	5301.97	5278.78	5297.73	29921.0
2022-01-11 05:00:00	ES	Futures	5297.73	5303.39	5294.34	5296.03	13259.0
2022-01-11 06:00:00	ES	Futures	5296.03	5296.32	5288.68	5289.25	19216.0
2022-01-11 07:00:00	ES	Futures	5289.25	5293.49	5282.18	5283.31	27102.0
2022-01-11 08:00:00	ES	Futures	5283.31	5288.12	5272.85	5273.41	35146.0
2022-01-11 09:00:00	ES	Futures	5273.41	5273.69	5234.38	5243.72	296858.0
2022-01-11 10:00:00	ES	Futures	5244.0	5267.75	5238.06	5250.5	305466.0
2022-01-11 11:00:00	ES	Futures	5250.5	5302.82	5249.09	5296.88	254011.0
2022-01-11 12:00:00	ES	Futures	5297.17	5301.41	5286.99	5299.43	113182.0
2022-01-11 13:00:00	ES	Futures	5299.43	5308.48	5290.66	5307.35	95255.0
2022-01-11 14:00:00	ES	Futures	5307.35	5317.81	5298.01	5312.15	107572.0
2022-01-11 15:00:00	ES	Futures	5312.15	5324.03	5308.48	5322.34	225797.0
2022-01-11 16:00:00	ES	Futures	5322.62	5325.16	5320.64	5321.49	50895.0
2022-01-11 18:00:00	ES	Futures	5321.2	5325.16	5319.79	5321.2	7024.0
2022-01-11 19:00:00	ES	Futures	5321.2	5327.71	5320.07	5324.03	9528.0
2022-01-11 20:00:00	ES	Futures	5323.75	5324.6	5315.83	5320.36	9592.0
2022-01-11 21:00:00	ES	Futures	5320.36	5325.73	5319.79	5324.03	5206.0
2022-01-11 22:00:00	ES	Futures	5324.03	5326.86	5323.47	5326.58	3430.0
2022-01-11 23:00:00	ES	Futures	5326.58	5327.43	5324.88	5326.29	3335.0
2022-01-11 00:00:00	NQ	Futures	18082.27	18101.69	18074.16	18085.46	3481.0
2022-01-11 01:00:00	NQ	Futures	18086.62	18094.44	18043.73	18073.87	4645.0
2022-01-11 02:00:00	NQ	Futures	18073.58	18132.99	18061.41	18128.35	6982.0
2022-01-11 03:00:00	NQ	Futures	18127.77	18136.76	18066.04	18097.63	13557.0
2022-01-11 04:00:00	NQ	Futures	18097.05	18230.66	18095.02	18212.4	16124.0
2022-01-11 05:00:00	NQ	Futures	18212.69	18239.93	18199.94	18215.88	7974.0
2022-01-11 06:00:00	NQ	Futures	18216.46	18217.33	18165.45	18171.83	10301.0
2022-01-11 07:00:00	NQ	Futures	18172.69	18196.75	18133.86	18139.95	9257.0
2022-01-11 08:00:00	NQ	Futures	18140.53	18168.35	18081.11	18083.43	17866.0
2022-01-11 09:00:00	NQ	Futures	18083.43	18084.01	17939.68	18024.31	134071.0
2022-01-11 10:00:00	NQ	Futures	18025.76	18145.74	17973.3	18042.57	129389.0
2022-01-11 11:00:00	NQ	Futures	18043.44	18345.43	18035.9	18339.63	113584.0
2022-01-11 12:00:00	NQ	Futures	18339.92	18351.51	18250.08	18281.96	50799.0
2022-01-11 13:00:00	NQ	Futures	18282.83	18330.36	18235.59	18321.08	39942.0
2022-01-11 14:00:00	NQ	Futures	18321.08	18359.92	18273.84	18328.91	38127.0
2022-01-11 15:00:00	NQ	Futures	18329.49	18360.5	18293.55	18353.83	58400.0
2022-01-11 16:00:00	NQ	Futures	18354.7	18362.24	18338.47	18344.85	10722.0
2022-01-11 18:00:00	NQ	Futures	18346.59	18364.55	18331.22	18340.5	4227.0
2022-01-11 19:00:00	NQ	Futures	18340.5	18370.35	18338.47	18353.54	4334.0
2022-01-11 20:00:00	NQ	Futures	18352.67	18356.15	18323.4	18337.6	4980.0
2022-01-11 21:00:00	NQ	Futures	18337.6	18360.5	18336.15	18348.03	3927.0
2022-01-11 22:00:00	NQ	Futures	18348.32	18359.34	18346.01	18354.7	1996.0
2022-01-11 23:00:00	NQ	Futures	18354.41	18359.05	18349.19	18354.99	1627.0
2022-01-11 00:00:00	YM	Futures	40401.7	40419.7	40374.8	40396.1	1245.0
2022-01-11 01:00:00	YM	Futures	40398.4	40407.4	40345.6	40382.6	1866.0
2022-01-11 02:00:00	YM	Futures	40381.5	40416.3	40352.3	40407.4	2870.0
2022-01-11 03:00:00	YM	Futures	40407.4	40486.0	40350.0	40450.1	7222.0

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

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