PREVIEW / futures_1hour / 2021-09-10

all futures 1-hour files

  file:    by_date/futures_1hour/2021/2021-09-10.parquet
  size:    52 KB
  rows:    1,530

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-09-10 00:00:00	ES	Futures	5068.76	5074.67	5067.64	5072.99	4211.0
2021-09-10 01:00:00	ES	Futures	5072.7	5076.08	5071.01	5074.11	5121.0
2021-09-10 02:00:00	ES	Futures	5074.11	5074.96	5070.17	5074.39	7259.0
2021-09-10 03:00:00	ES	Futures	5074.11	5079.74	5070.45	5078.62	14957.0
2021-09-10 04:00:00	ES	Futures	5078.62	5084.25	5077.77	5083.12	9626.0
2021-09-10 05:00:00	ES	Futures	5083.4	5083.4	5078.05	5078.34	8380.0
2021-09-10 06:00:00	ES	Futures	5078.34	5081.71	5078.34	5080.87	10057.0
2021-09-10 07:00:00	ES	Futures	5080.87	5082.84	5079.74	5081.15	7095.0
2021-09-10 08:00:00	ES	Futures	5081.43	5083.69	5078.9	5081.71	17645.0
2021-09-10 09:00:00	ES	Futures	5081.43	5089.04	5066.23	5068.48	110647.0
2021-09-10 10:00:00	ES	Futures	5068.76	5069.04	5042.86	5051.87	178907.0
2021-09-10 11:00:00	ES	Futures	5051.87	5053.56	5041.73	5048.49	105131.0
2021-09-10 12:00:00	ES	Futures	5048.49	5064.54	5045.95	5062.0	55457.0
2021-09-10 13:00:00	ES	Futures	5062.29	5065.1	5054.4	5056.65	45481.0
2021-09-10 14:00:00	ES	Futures	5056.65	5058.62	5047.64	5048.49	45660.0
2021-09-10 15:00:00	ES	Futures	5048.77	5048.77	5019.48	5022.02	188404.0
2021-09-10 16:00:00	ES	Futures	5022.02	5027.93	5020.33	5024.55	53473.0
2021-09-10 00:00:00	NQ	Futures	18054.96	18073.21	18052.36	18067.42	1668.0
2021-09-10 01:00:00	NQ	Futures	18068.58	18074.95	18059.02	18068.0	1729.0
2021-09-10 02:00:00	NQ	Futures	18068.0	18072.92	18058.44	18070.9	2172.0
2021-09-10 03:00:00	NQ	Futures	18070.61	18087.7	18062.79	18084.51	5162.0
2021-09-10 04:00:00	NQ	Futures	18084.22	18106.53	18083.06	18097.26	4311.0
2021-09-10 05:00:00	NQ	Futures	18098.13	18099.29	18087.12	18087.99	2590.0
2021-09-10 06:00:00	NQ	Futures	18088.28	18104.79	18086.54	18103.05	3131.0
2021-09-10 07:00:00	NQ	Futures	18102.76	18114.64	18099.86	18108.84	4165.0
2021-09-10 08:00:00	NQ	Futures	18109.13	18120.72	18103.63	18105.95	6640.0
2021-09-10 09:00:00	NQ	Futures	18105.95	18154.9	18101.02	18140.71	41406.0
2021-09-10 10:00:00	NQ	Futures	18140.71	18142.16	18028.6	18069.45	73755.0
2021-09-10 11:00:00	NQ	Futures	18069.74	18074.66	17992.97	18010.64	49589.0
2021-09-10 12:00:00	NQ	Futures	18011.22	18077.27	18004.27	18064.52	21923.0
2021-09-10 13:00:00	NQ	Futures	18065.1	18084.51	18042.51	18048.59	16424.0
2021-09-10 14:00:00	NQ	Futures	18048.59	18053.81	18000.79	18008.61	16161.0
2021-09-10 15:00:00	NQ	Futures	18008.61	18010.93	17883.18	17897.38	52015.0
2021-09-10 16:00:00	NQ	Futures	17897.38	17911.28	17895.06	17899.69	9973.0
2021-09-10 00:00:00	YM	Futures	39055.8	39099.5	39046.8	39086.0	652.0
2021-09-10 01:00:00	YM	Futures	39084.9	39114.1	39080.4	39100.6	807.0
2021-09-10 02:00:00	YM	Futures	39105.1	39114.1	39072.6	39114.1	1108.0
2021-09-10 03:00:00	YM	Futures	39114.1	39155.5	39071.5	39147.7	2615.0
2021-09-10 04:00:00	YM	Futures	39149.9	39194.8	39135.4	39188.0	1435.0
2021-09-10 05:00:00	YM	Futures	39189.2	39191.4	39133.1	39139.8	1274.0
2021-09-10 06:00:00	YM	Futures	39139.8	39170.1	39137.6	39157.8	1414.0
2021-09-10 07:00:00	YM	Futures	39158.9	39161.1	39130.9	39144.3	1089.0
2021-09-10 08:00:00	YM	Futures	39146.6	39162.3	39125.3	39149.9	2140.0
2021-09-10 09:00:00	YM	Futures	39151.1	39228.4	38957.1	38960.5	19011.0
2021-09-10 10:00:00	YM	Futures	38960.5	38962.7	38768.8	38835.0	26866.0
2021-09-10 11:00:00	YM	Futures	38832.7	38874.2	38781.2	38874.2	14836.0
2021-09-10 12:00:00	YM	Futures	38873.1	38981.8	38842.8	38967.2	7601.0
2021-09-10 13:00:00	YM	Futures	38968.3	38993.0	38882.0	38901.1	5545.0
2021-09-10 14:00:00	YM	Futures	38901.1	38912.3	38855.1	38858.5	4973.0
2021-09-10 15:00:00	YM	Futures	38858.5	38864.1	38650.0	38667.9	17084.0

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

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