PREVIEW / futures_1hour / 2021-07-01

all futures 1-hour files

  file:    by_date/futures_1hour/2021/2021-07-01.parquet
  size:    62 KB
  rows:    1,930

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-07-01 00:00:00	ES	Futures	4838.71	4839.84	4836.74	4837.86	3257.0
2021-07-01 01:00:00	ES	Futures	4837.58	4839.55	4837.02	4838.71	3014.0
2021-07-01 02:00:00	ES	Futures	4838.99	4839.84	4837.3	4838.43	6871.0
2021-07-01 03:00:00	ES	Futures	4838.71	4849.41	4837.3	4846.87	34408.0
2021-07-01 04:00:00	ES	Futures	4847.16	4849.69	4841.52	4841.81	24247.0
2021-07-01 05:00:00	ES	Futures	4842.09	4842.09	4833.36	4837.02	18250.0
2021-07-01 06:00:00	ES	Futures	4837.02	4837.02	4827.45	4829.42	28348.0
2021-07-01 07:00:00	ES	Futures	4829.7	4838.15	4827.73	4837.86	29783.0
2021-07-01 08:00:00	ES	Futures	4837.86	4839.84	4834.2	4835.89	24123.0
2021-07-01 09:00:00	ES	Futures	4835.61	4843.5	4834.49	4841.81	120137.0
2021-07-01 10:00:00	ES	Futures	4842.09	4846.59	4838.99	4843.5	131938.0
2021-07-01 11:00:00	ES	Futures	4843.5	4846.31	4836.46	4844.06	111528.0
2021-07-01 12:00:00	ES	Futures	4844.34	4845.47	4842.65	4843.78	50993.0
2021-07-01 13:00:00	ES	Futures	4843.78	4851.94	4842.93	4848.56	70495.0
2021-07-01 14:00:00	ES	Futures	4848.85	4854.2	4847.44	4853.91	68304.0
2021-07-01 15:00:00	ES	Futures	4853.91	4856.73	4850.25	4855.04	164423.0
2021-07-01 16:00:00	ES	Futures	4855.32	4856.17	4851.94	4853.91	38880.0
2021-07-01 18:00:00	ES	Futures	4854.2	4855.6	4852.22	4855.32	4773.0
2021-07-01 19:00:00	ES	Futures	4855.32	4856.45	4853.63	4853.91	3030.0
2021-07-01 20:00:00	ES	Futures	4853.91	4859.55	4853.63	4858.98	6730.0
2021-07-01 21:00:00	ES	Futures	4859.26	4860.11	4855.32	4855.6	8182.0
2021-07-01 22:00:00	ES	Futures	4855.6	4858.14	4855.04	4856.17	4496.0
2021-07-01 23:00:00	ES	Futures	4856.17	4858.42	4855.6	4857.29	3862.0
2021-07-01 00:00:00	NQ	Futures	16869.88	16872.77	16851.92	16858.29	2174.0
2021-07-01 01:00:00	NQ	Futures	16858.29	16870.46	16858.0	16867.27	1783.0
2021-07-01 02:00:00	NQ	Futures	16868.43	16871.62	16853.66	16861.19	2864.0
2021-07-01 03:00:00	NQ	Futures	16861.48	16924.63	16852.5	16905.8	11115.0
2021-07-01 04:00:00	NQ	Futures	16906.09	16907.25	16876.54	16879.73	6220.0
2021-07-01 05:00:00	NQ	Futures	16880.31	16880.31	16836.85	16853.95	8809.0
2021-07-01 06:00:00	NQ	Futures	16853.08	16853.08	16799.49	16811.36	10423.0
2021-07-01 07:00:00	NQ	Futures	16811.94	16858.0	16809.33	16853.08	10310.0
2021-07-01 08:00:00	NQ	Futures	16853.08	16866.11	16834.54	16837.43	10415.0
2021-07-01 09:00:00	NQ	Futures	16837.72	16882.62	16819.18	16853.95	66489.0
2021-07-01 10:00:00	NQ	Futures	16850.76	16865.53	16810.78	16841.2	68919.0
2021-07-01 11:00:00	NQ	Futures	16841.2	16848.44	16767.91	16821.21	63872.0
2021-07-01 12:00:00	NQ	Futures	16821.5	16829.32	16787.61	16796.59	34876.0
2021-07-01 13:00:00	NQ	Futures	16796.3	16839.17	16788.48	16818.02	32860.0
2021-07-01 14:00:00	NQ	Futures	16818.31	16857.71	16813.97	16850.76	34009.0
2021-07-01 15:00:00	NQ	Futures	16851.05	16863.22	16833.96	16856.84	46559.0
2021-07-01 16:00:00	NQ	Futures	16857.13	16859.45	16840.33	16847.86	7673.0
2021-07-01 18:00:00	NQ	Futures	16852.21	16852.21	16838.59	16845.25	1463.0
2021-07-01 19:00:00	NQ	Futures	16844.39	16849.02	16838.59	16839.75	998.0
2021-07-01 20:00:00	NQ	Futures	16839.75	16855.97	16838.59	16849.31	2102.0
2021-07-01 21:00:00	NQ	Futures	16849.31	16855.39	16828.45	16831.93	3258.0
2021-07-01 22:00:00	NQ	Futures	16831.64	16840.04	16823.82	16826.14	2346.0
2021-07-01 23:00:00	NQ	Futures	16825.85	16831.64	16823.24	16829.61	1816.0
2021-07-01 00:00:00	YM	Futures	38501.6	38509.4	38493.8	38500.5	681.0
2021-07-01 01:00:00	YM	Futures	38500.5	38517.3	38492.7	38511.7	800.0
2021-07-01 02:00:00	YM	Futures	38512.8	38521.7	38497.2	38512.8	1623.0
2021-07-01 03:00:00	YM	Futures	38511.7	38587.7	38500.5	38563.1	5636.0

> showing 50 of 1,930 rows — these rows as CSV

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