PREVIEW / etf_1hour / 2022-09-02

all etf 1-hour files

  file:    by_date/etf_1hour/2022/2022-09-02.parquet
  size:    441 KB
  rows:    16,065

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-09-02 04:00:00	SPY	ETF	395.88	397.12	395.81	397.0	33348.0
2022-09-02 05:00:00	SPY	ETF	396.75	396.86	396.36	396.7	7713.0
2022-09-02 06:00:00	SPY	ETF	396.8	396.92	395.8	396.25	56178.0
2022-09-02 07:00:00	SPY	ETF	396.28	396.73	395.74	396.48	111471.0
2022-09-02 08:00:00	SPY	ETF	395.8	399.88	395.5	399.23	2820261.0
2022-09-02 09:00:00	SPY	ETF	399.23	400.55	397.64	398.02	8278445.0
2022-09-02 10:00:00	SPY	ETF	398.03	401.555	397.0203	400.38	9837001.0
2022-09-02 11:00:00	SPY	ETF	400.38	401.3824	400.07	401.16	4882970.0
2022-09-02 12:00:00	SPY	ETF	401.17	401.4	395.81	396.5401	8226610.0
2022-09-02 13:00:00	SPY	ETF	396.56	396.56	392.22	392.37	11964202.0
2022-09-02 14:00:00	SPY	ETF	392.38	394.02	392.269	392.57	7140116.0
2022-09-02 15:00:00	SPY	ETF	392.57	394.03	390.33	392.27	18176604.0
2022-09-02 16:00:00	SPY	ETF	392.27	393.1	391.93	393.01	3938635.0
2022-09-02 17:00:00	SPY	ETF	392.91	393.07	392.6	392.75	91289.0
2022-09-02 18:00:00	SPY	ETF	392.75	392.78	392.7	392.7	17093.0
2022-09-02 19:00:00	SPY	ETF	392.7	392.76	392.46	392.76	29894.0
2022-09-02 04:00:00	QQQ	ETF	299.22	300.11	299.13	299.98	109294.0
2022-09-02 05:00:00	QQQ	ETF	299.83	300.0	299.18	299.54	89650.0
2022-09-02 06:00:00	QQQ	ETF	299.52	299.6	298.42	298.81	91721.0
2022-09-02 07:00:00	QQQ	ETF	298.87	299.46	298.38	299.18	235340.0
2022-09-02 08:00:00	QQQ	ETF	298.93	302.31	298.45	301.38	2139450.0
2022-09-02 09:00:00	QQQ	ETF	301.24	302.71	299.3822	300.0	6315398.0
2022-09-02 10:00:00	QQQ	ETF	300.02	303.75	299.14	302.19	7679205.0
2022-09-02 11:00:00	QQQ	ETF	302.2	303.11	301.77	302.7	3665982.0
2022-09-02 12:00:00	QQQ	ETF	302.72	302.86	297.37	298.26	6235786.0
2022-09-02 13:00:00	QQQ	ETF	298.2799	298.2799	294.6199	294.63	6957630.0
2022-09-02 14:00:00	QQQ	ETF	294.66	296.32	294.5301	295.145	5069731.0
2022-09-02 15:00:00	QQQ	ETF	295.13	296.42	293.52	295.21	9166063.0
2022-09-02 16:00:00	QQQ	ETF	295.21	295.86	295.06	295.7	2541395.0
2022-09-02 17:00:00	QQQ	ETF	295.69	295.74	295.17	295.54	116880.0
2022-09-02 18:00:00	QQQ	ETF	295.52	295.52	295.25	295.3	40438.0
2022-09-02 19:00:00	QQQ	ETF	295.26	295.88	295.15	295.4	45443.0
2022-09-02 04:00:00	IWM	ETF	181.17	181.87	181.17	181.8	35522.0
2022-09-02 05:00:00	IWM	ETF	181.75	181.75	181.51	181.65	10073.0
2022-09-02 06:00:00	IWM	ETF	181.7	181.82	181.29	181.49	9136.0
2022-09-02 07:00:00	IWM	ETF	181.43	181.74	181.2	181.74	26897.0
2022-09-02 08:00:00	IWM	ETF	181.72	183.34	181.27	182.9	210253.0
2022-09-02 09:00:00	IWM	ETF	182.92	183.66	181.32	181.35	2646320.0
2022-09-02 10:00:00	IWM	ETF	181.36	183.94	180.81	183.56	3158357.0
2022-09-02 11:00:00	IWM	ETF	183.57	183.93	183.21	183.84	1760198.0
2022-09-02 12:00:00	IWM	ETF	183.85	183.95	181.35	181.76	2143568.0
2022-09-02 13:00:00	IWM	ETF	181.69	181.69	179.77	179.96	2496829.0
2022-09-02 14:00:00	IWM	ETF	179.96	180.93	179.92	180.2519	1339719.0
2022-09-02 15:00:00	IWM	ETF	180.26	181.02	179.14	180.09	4366739.0
2022-09-02 16:00:00	IWM	ETF	180.1	180.55	179.9551	180.45	1631211.0
2022-09-02 17:00:00	IWM	ETF	180.46	180.4862	180.09	180.22	43154.0
2022-09-02 18:00:00	IWM	ETF	180.31	180.31	180.21	180.21	10416.0
2022-09-02 19:00:00	IWM	ETF	180.25	180.31	180.15	180.15	8219.0
2022-09-02 04:00:00	DIA	ETF	317.21	317.23	317.19	317.19	880.0
2022-09-02 05:00:00	DIA	ETF	317.29	317.29	317.29	317.29	100.0

> showing 50 of 16,065 rows — these rows as CSV

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