PREVIEW / futures_1hour / 2022-01-06

all futures 1-hour files

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

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-06 00:00:00	ES	Futures	5281.89	5290.38	5280.48	5288.12	12526.0
2022-01-06 01:00:00	ES	Futures	5288.12	5291.79	5281.05	5290.1	9718.0
2022-01-06 02:00:00	ES	Futures	5289.81	5313.0	5288.68	5302.26	23225.0
2022-01-06 03:00:00	ES	Futures	5302.54	5311.87	5293.21	5307.63	34829.0
2022-01-06 04:00:00	ES	Futures	5307.63	5309.61	5298.3	5305.37	18229.0
2022-01-06 05:00:00	ES	Futures	5305.65	5319.51	5303.67	5311.31	24433.0
2022-01-06 06:00:00	ES	Futures	5311.59	5316.4	5303.1	5306.22	15518.0
2022-01-06 07:00:00	ES	Futures	5305.93	5313.57	5301.69	5306.5	23534.0
2022-01-06 08:00:00	ES	Futures	5306.22	5314.13	5304.24	5308.76	32774.0
2022-01-06 09:00:00	ES	Futures	5308.48	5330.25	5289.25	5292.08	271239.0
2022-01-06 10:00:00	ES	Futures	5291.79	5322.34	5273.69	5311.02	381277.0
2022-01-06 11:00:00	ES	Futures	5311.02	5325.16	5303.1	5316.4	183893.0
2022-01-06 12:00:00	ES	Futures	5316.68	5334.5	5310.17	5320.07	139826.0
2022-01-06 13:00:00	ES	Futures	5320.36	5325.16	5307.35	5314.7	104555.0
2022-01-06 14:00:00	ES	Futures	5314.7	5321.77	5305.65	5318.66	124837.0
2022-01-06 15:00:00	ES	Futures	5318.38	5327.43	5292.64	5301.97	254498.0
2022-01-06 16:00:00	ES	Futures	5302.26	5311.02	5300.84	5309.61	52204.0
2022-01-06 18:00:00	ES	Futures	5311.02	5316.68	5311.02	5315.83	6935.0
2022-01-06 19:00:00	ES	Futures	5315.83	5322.05	5314.7	5320.92	7703.0
2022-01-06 20:00:00	ES	Futures	5320.92	5323.18	5316.4	5319.79	10054.0
2022-01-06 21:00:00	ES	Futures	5319.79	5319.79	5309.61	5315.27	8306.0
2022-01-06 22:00:00	ES	Futures	5315.55	5320.92	5312.72	5314.42	5859.0
2022-01-06 23:00:00	ES	Futures	5314.42	5315.27	5310.74	5314.42	4801.0
2022-01-06 00:00:00	NQ	Futures	18132.41	18190.08	18125.74	18177.04	8725.0
2022-01-06 01:00:00	NQ	Futures	18176.17	18186.9	18134.44	18180.23	5908.0
2022-01-06 02:00:00	NQ	Futures	18179.07	18296.16	18177.62	18243.99	12930.0
2022-01-06 03:00:00	NQ	Futures	18245.44	18284.85	18192.4	18263.12	14418.0
2022-01-06 04:00:00	NQ	Futures	18263.12	18266.31	18206.31	18240.8	10153.0
2022-01-06 05:00:00	NQ	Futures	18241.09	18279.64	18221.96	18228.34	9569.0
2022-01-06 06:00:00	NQ	Futures	18227.76	18254.71	18177.04	18190.37	9695.0
2022-01-06 07:00:00	NQ	Futures	18190.08	18225.73	18155.02	18177.33	12300.0
2022-01-06 08:00:00	NQ	Futures	18175.59	18223.99	18163.42	18194.14	16245.0
2022-01-06 09:00:00	NQ	Futures	18190.95	18374.99	18168.06	18221.96	126657.0
2022-01-06 10:00:00	NQ	Futures	18221.96	18399.91	18082.85	18364.55	179396.0
2022-01-06 11:00:00	NQ	Futures	18365.13	18427.44	18281.96	18355.86	94612.0
2022-01-06 12:00:00	NQ	Futures	18356.15	18416.14	18306.01	18341.37	53182.0
2022-01-06 13:00:00	NQ	Futures	18341.66	18360.21	18281.09	18343.11	45564.0
2022-01-06 14:00:00	NQ	Futures	18342.82	18378.46	18294.42	18337.6	42606.0
2022-01-06 15:00:00	NQ	Futures	18336.73	18394.12	18220.8	18267.75	77396.0
2022-01-06 16:00:00	NQ	Futures	18268.04	18310.07	18261.09	18309.49	13740.0
2022-01-06 18:00:00	NQ	Futures	18318.47	18339.05	18315.28	18337.02	3283.0
2022-01-06 19:00:00	NQ	Futures	18337.02	18371.22	18334.41	18368.03	4273.0
2022-01-06 20:00:00	NQ	Futures	18368.03	18377.6	18339.63	18350.06	5295.0
2022-01-06 21:00:00	NQ	Futures	18349.19	18349.19	18300.21	18329.2	5365.0
2022-01-06 22:00:00	NQ	Futures	18329.78	18348.03	18305.72	18314.13	3825.0
2022-01-06 23:00:00	NQ	Futures	18313.55	18316.15	18286.3	18302.53	4834.0
2022-01-06 00:00:00	YM	Futures	40655.7	40708.5	40642.2	40671.5	2288.0
2022-01-06 01:00:00	YM	Futures	40670.3	40710.8	40634.4	40687.2	1781.0
2022-01-06 02:00:00	YM	Futures	40687.2	40842.3	40679.3	40770.3	6620.0
2022-01-06 03:00:00	YM	Futures	40771.5	40832.2	40702.9	40813.1	10197.0

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

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