PREVIEW / futures_1hour / 2022-08-19

all futures 1-hour files

  file:    by_date/futures_1hour/2022/2022-08-19.parquet
  size:    56 KB
  rows:    1,625

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-08-19 00:00:00	ES	Futures	4848.19	4849.61	4846.21	4847.06	3071.0
2022-08-19 01:00:00	ES	Futures	4847.06	4847.63	4840.83	4844.51	6539.0
2022-08-19 02:00:00	ES	Futures	4844.51	4844.79	4828.08	4829.5	13465.0
2022-08-19 03:00:00	ES	Futures	4829.5	4837.43	4827.51	4834.03	15002.0
2022-08-19 04:00:00	ES	Futures	4833.74	4836.58	4815.62	4821.0	22328.0
2022-08-19 05:00:00	ES	Futures	4820.71	4826.38	4817.88	4818.73	18054.0
2022-08-19 06:00:00	ES	Futures	4818.73	4821.28	4805.42	4808.82	20293.0
2022-08-19 07:00:00	ES	Futures	4808.82	4815.33	4806.27	4815.33	21403.0
2022-08-19 08:00:00	ES	Futures	4815.05	4819.3	4807.97	4815.33	35211.0
2022-08-19 09:00:00	ES	Futures	4815.33	4828.93	4800.32	4804.57	266705.0
2022-08-19 10:00:00	ES	Futures	4804.57	4808.82	4796.07	4796.64	247666.0
2022-08-19 11:00:00	ES	Futures	4796.92	4803.72	4787.85	4796.92	204872.0
2022-08-19 12:00:00	ES	Futures	4797.2	4810.8	4792.95	4805.98	131893.0
2022-08-19 13:00:00	ES	Futures	4806.27	4810.23	4791.54	4801.17	127076.0
2022-08-19 14:00:00	ES	Futures	4801.17	4802.3	4786.16	4789.27	129472.0
2022-08-19 15:00:00	ES	Futures	4789.27	4800.6	4782.47	4792.95	278524.0
2022-08-19 16:00:00	ES	Futures	4792.95	4794.65	4790.69	4791.25	52106.0
2022-08-19 00:00:00	NQ	Futures	15618.62	15622.96	15606.76	15610.52	1531.0
2022-08-19 01:00:00	NQ	Futures	15610.81	15612.83	15582.46	15597.22	3608.0
2022-08-19 02:00:00	NQ	Futures	15598.37	15600.69	15534.16	15539.37	7535.0
2022-08-19 03:00:00	NQ	Futures	15538.5	15569.74	15532.14	15552.96	8110.0
2022-08-19 04:00:00	NQ	Futures	15553.25	15565.4	15469.95	15500.03	13450.0
2022-08-19 05:00:00	NQ	Futures	15499.45	15528.67	15492.22	15497.43	7707.0
2022-08-19 06:00:00	NQ	Futures	15495.98	15513.63	15454.91	15472.26	9760.0
2022-08-19 07:00:00	NQ	Futures	15471.69	15495.11	15460.12	15493.09	9573.0
2022-08-19 08:00:00	NQ	Futures	15493.38	15499.16	15459.83	15481.23	14860.0
2022-08-19 09:00:00	NQ	Futures	15481.23	15532.43	15387.81	15397.35	97314.0
2022-08-19 10:00:00	NQ	Futures	15397.35	15418.47	15344.13	15345.87	104840.0
2022-08-19 11:00:00	NQ	Futures	15346.16	15385.49	15325.04	15349.92	76328.0
2022-08-19 12:00:00	NQ	Futures	15350.21	15400.53	15335.45	15383.18	50916.0
2022-08-19 13:00:00	NQ	Futures	15383.18	15398.8	15306.82	15357.73	48715.0
2022-08-19 14:00:00	NQ	Futures	15357.73	15361.49	15321.86	15330.83	47178.0
2022-08-19 15:00:00	NQ	Futures	15331.12	15373.06	15305.08	15345.0	81962.0
2022-08-19 16:00:00	NQ	Futures	15344.71	15348.18	15326.2	15329.67	13002.0
2022-08-19 00:00:00	YM	Futures	38294.9	38305.0	38283.6	38288.1	587.0
2022-08-19 01:00:00	YM	Futures	38291.5	38294.9	38256.5	38280.2	962.0
2022-08-19 02:00:00	YM	Futures	38280.2	38281.3	38168.5	38178.6	2714.0
2022-08-19 03:00:00	YM	Futures	38176.4	38237.3	38166.2	38215.9	3053.0
2022-08-19 04:00:00	YM	Futures	38212.5	38230.5	38094.0	38129.0	5428.0
2022-08-19 05:00:00	YM	Futures	38129.0	38167.3	38101.9	38113.2	4968.0
2022-08-19 06:00:00	YM	Futures	38114.3	38127.9	38018.4	38041.0	4824.0
2022-08-19 07:00:00	YM	Futures	38039.8	38079.3	38013.9	38078.2	5246.0
2022-08-19 08:00:00	YM	Futures	38078.2	38122.2	38037.6	38097.4	5807.0
2022-08-19 09:00:00	YM	Futures	38097.4	38210.2	38022.9	38066.9	23365.0
2022-08-19 10:00:00	YM	Futures	38066.9	38127.9	38019.5	38062.4	16301.0
2022-08-19 11:00:00	YM	Futures	38063.5	38082.7	37989.1	38037.6	13026.0
2022-08-19 12:00:00	YM	Futures	38036.5	38161.7	38015.0	38131.2	10283.0
2022-08-19 13:00:00	YM	Futures	38130.1	38149.3	38047.7	38097.4	8028.0
2022-08-19 14:00:00	YM	Futures	38097.4	38098.5	37960.9	37981.2	9203.0
2022-08-19 15:00:00	YM	Futures	37982.3	38068.1	37930.4	38018.4	16629.0

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

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