PREVIEW / futures_1hour / 2021-09-02

all futures 1-hour files

  file:    by_date/futures_1hour/2021/2021-09-02.parquet
  size:    61 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-09-02 00:00:00	ES	Futures	5089.6	5090.72	5089.04	5090.72	1984.0
2021-09-02 01:00:00	ES	Futures	5090.72	5093.26	5089.04	5092.13	5301.0
2021-09-02 02:00:00	ES	Futures	5092.13	5096.36	5091.01	5096.36	7184.0
2021-09-02 03:00:00	ES	Futures	5096.64	5100.3	5094.39	5100.02	15114.0
2021-09-02 04:00:00	ES	Futures	5100.02	5104.8	5100.02	5103.4	15530.0
2021-09-02 05:00:00	ES	Futures	5103.68	5103.96	5100.3	5100.86	10146.0
2021-09-02 06:00:00	ES	Futures	5101.14	5102.55	5099.74	5101.14	6850.0
2021-09-02 07:00:00	ES	Futures	5101.14	5103.11	5100.02	5101.99	9991.0
2021-09-02 08:00:00	ES	Futures	5102.27	5107.34	5101.43	5106.49	20041.0
2021-09-02 09:00:00	ES	Futures	5106.78	5118.04	5105.37	5110.72	148811.0
2021-09-02 10:00:00	ES	Futures	5111.0	5114.38	5106.78	5111.28	134920.0
2021-09-02 11:00:00	ES	Futures	5111.56	5114.94	5109.31	5111.56	84581.0
2021-09-02 12:00:00	ES	Futures	5111.56	5112.13	5107.34	5110.72	63066.0
2021-09-02 13:00:00	ES	Futures	5110.72	5111.56	5098.05	5099.45	83717.0
2021-09-02 14:00:00	ES	Futures	5099.17	5104.24	5094.1	5103.11	114193.0
2021-09-02 15:00:00	ES	Futures	5103.11	5109.31	5096.64	5109.03	175314.0
2021-09-02 16:00:00	ES	Futures	5108.75	5110.44	5105.65	5109.59	48186.0
2021-09-02 18:00:00	ES	Futures	5109.87	5111.0	5107.9	5109.87	4014.0
2021-09-02 19:00:00	ES	Futures	5110.15	5110.44	5106.78	5107.62	3059.0
2021-09-02 20:00:00	ES	Futures	5107.62	5112.69	5107.62	5111.28	6243.0
2021-09-02 21:00:00	ES	Futures	5111.28	5111.56	5107.9	5109.59	5657.0
2021-09-02 22:00:00	ES	Futures	5109.59	5119.45	5109.31	5118.88	10689.0
2021-09-02 23:00:00	ES	Futures	5119.16	5119.73	5115.5	5117.19	8803.0
2021-09-02 00:00:00	NQ	Futures	18090.02	18092.33	18085.67	18088.57	1043.0
2021-09-02 01:00:00	NQ	Futures	18088.57	18097.55	18081.04	18096.39	2245.0
2021-09-02 02:00:00	NQ	Futures	18095.81	18112.03	18094.07	18109.71	3424.0
2021-09-02 03:00:00	NQ	Futures	18109.42	18116.67	18098.71	18116.38	5589.0
2021-09-02 04:00:00	NQ	Futures	18116.09	18132.89	18115.51	18128.54	5790.0
2021-09-02 05:00:00	NQ	Futures	18128.83	18136.36	18117.25	18120.72	4868.0
2021-09-02 06:00:00	NQ	Futures	18120.72	18129.12	18118.98	18122.17	2342.0
2021-09-02 07:00:00	NQ	Futures	18121.88	18143.03	18121.88	18134.05	4889.0
2021-09-02 08:00:00	NQ	Futures	18134.05	18149.4	18132.31	18142.45	6798.0
2021-09-02 09:00:00	NQ	Futures	18142.74	18171.13	18125.94	18134.05	64591.0
2021-09-02 10:00:00	NQ	Futures	18133.76	18146.79	18093.78	18126.23	76421.0
2021-09-02 11:00:00	NQ	Futures	18126.23	18141.29	18098.42	18111.45	47276.0
2021-09-02 12:00:00	NQ	Futures	18111.45	18115.22	18079.01	18099.29	42189.0
2021-09-02 13:00:00	NQ	Futures	18099.0	18106.24	18042.22	18051.78	47064.0
2021-09-02 14:00:00	NQ	Futures	18052.07	18077.85	18020.2	18074.37	55594.0
2021-09-02 15:00:00	NQ	Futures	18074.37	18083.06	18050.33	18081.9	59761.0
2021-09-02 16:00:00	NQ	Futures	18081.9	18083.64	18058.15	18076.98	9970.0
2021-09-02 18:00:00	NQ	Futures	18077.27	18084.51	18070.9	18082.48	1939.0
2021-09-02 19:00:00	NQ	Futures	18083.06	18083.64	18072.34	18072.92	1637.0
2021-09-02 20:00:00	NQ	Futures	18072.63	18098.13	18072.34	18091.75	3456.0
2021-09-02 21:00:00	NQ	Futures	18092.04	18096.39	18075.24	18083.06	3378.0
2021-09-02 22:00:00	NQ	Futures	18083.35	18109.42	18081.32	18109.42	3799.0
2021-09-02 23:00:00	NQ	Futures	18109.71	18112.61	18097.55	18100.15	2741.0
2021-09-02 00:00:00	YM	Futures	39378.7	39391.0	39378.7	39389.8	348.0
2021-09-02 01:00:00	YM	Futures	39392.1	39412.2	39378.7	39405.5	1060.0
2021-09-02 02:00:00	YM	Futures	39404.4	39440.1	39388.7	39437.9	1284.0
2021-09-02 03:00:00	YM	Futures	39436.8	39482.6	39421.1	39480.3	3170.0

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

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