PREVIEW / etf_1hour / 2023-03-09

all etf 1-hour files

  file:    by_date/etf_1hour/2023/2023-03-09.parquet
  size:    472 KB
  rows:    17,263

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
2023-03-09 04:00:00	SPY	ETF	398.18	398.22	397.48	397.52	33379.0
2023-03-09 05:00:00	SPY	ETF	397.48	398.07	397.42	398.05	28644.0
2023-03-09 06:00:00	SPY	ETF	398.06	398.45	397.99	398.28	50462.0
2023-03-09 07:00:00	SPY	ETF	398.38	398.41	397.5	397.91	265981.0
2023-03-09 08:00:00	SPY	ETF	397.91	399.75	397.5296	399.7	1048755.0
2023-03-09 09:00:00	SPY	ETF	399.65	401.48	399.38	400.78	6596008.0
2023-03-09 10:00:00	SPY	ETF	400.77	401.275	399.4101	399.96	8879771.0
2023-03-09 11:00:00	SPY	ETF	399.96	400.05	399.04	399.09	7170604.0
2023-03-09 12:00:00	SPY	ETF	399.1	399.3	397.7299	397.92	7397549.0
2023-03-09 13:00:00	SPY	ETF	397.94	398.24	394.78	395.17	11457748.0
2023-03-09 14:00:00	SPY	ETF	395.18	395.43	393.3701	393.43	12787180.0
2023-03-09 15:00:00	SPY	ETF	393.43	393.72	390.53	391.59	30782536.0
2023-03-09 16:00:00	SPY	ETF	391.59	391.98	390.92	391.45	5390632.0
2023-03-09 17:00:00	SPY	ETF	391.48	391.48	391.0	391.37	293091.0
2023-03-09 18:00:00	SPY	ETF	391.37	391.4	390.22	390.74	309744.0
2023-03-09 19:00:00	SPY	ETF	390.73	390.89	390.0	390.11	202491.0
2023-03-09 04:00:00	QQQ	ETF	296.73	296.73	295.89	295.91	50432.0
2023-03-09 05:00:00	QQQ	ETF	295.9	296.26	295.7	296.17	68651.0
2023-03-09 06:00:00	QQQ	ETF	296.24	296.65	296.15	296.65	87597.0
2023-03-09 07:00:00	QQQ	ETF	296.62	296.7	296.169	296.42	263385.0
2023-03-09 08:00:00	QQQ	ETF	296.3182	298.62	296.08	298.56	1077109.0
2023-03-09 09:00:00	QQQ	ETF	298.58	300.61	297.96	300.305	5850337.0
2023-03-09 10:00:00	QQQ	ETF	300.32	300.98	299.22	299.68	6940527.0
2023-03-09 11:00:00	QQQ	ETF	299.69	300.03	299.195	299.31	4614652.0
2023-03-09 12:00:00	QQQ	ETF	299.32	299.46	297.65	298.0596	5476207.0
2023-03-09 13:00:00	QQQ	ETF	298.05	298.306	294.835	295.17	6966234.0
2023-03-09 14:00:00	QQQ	ETF	295.15	295.39	294.03	294.17	7587312.0
2023-03-09 15:00:00	QQQ	ETF	294.18	294.39	291.8299	292.49	15073025.0
2023-03-09 16:00:00	QQQ	ETF	292.53	292.9	292.15	292.58	1694403.0
2023-03-09 17:00:00	QQQ	ETF	292.61	292.66	292.0	292.32	176609.0
2023-03-09 18:00:00	QQQ	ETF	292.32	292.44	291.32	292.0	208423.0
2023-03-09 19:00:00	QQQ	ETF	291.95	292.16	291.37	291.51	149621.0
2023-03-09 04:00:00	IWM	ETF	186.3	186.3	185.85	185.87	22395.0
2023-03-09 05:00:00	IWM	ETF	185.9	186.23	185.85	186.2	5226.0
2023-03-09 06:00:00	IWM	ETF	186.22	186.45	186.22	186.32	20125.0
2023-03-09 07:00:00	IWM	ETF	186.37	186.37	185.96	186.09	44409.0
2023-03-09 08:00:00	IWM	ETF	186.02	186.8	185.92	186.67	111404.0
2023-03-09 09:00:00	IWM	ETF	186.72	187.27	186.1	186.11	2336634.0
2023-03-09 10:00:00	IWM	ETF	186.13	186.84	185.38	185.53	2674790.0
2023-03-09 11:00:00	IWM	ETF	185.53	185.57	184.62	184.66	3404983.0
2023-03-09 12:00:00	IWM	ETF	184.67	184.83	184.005	184.04	2674019.0
2023-03-09 13:00:00	IWM	ETF	184.04	184.28	182.755	183.05	3111987.0
2023-03-09 14:00:00	IWM	ETF	183.05	183.38	182.41	182.49	2997194.0
2023-03-09 15:00:00	IWM	ETF	182.49	182.62	181.28	181.41	5997121.0
2023-03-09 16:00:00	IWM	ETF	181.42	181.52	181.1	181.49	2241152.0
2023-03-09 17:00:00	IWM	ETF	181.4	181.48	181.11	181.3	25189.0
2023-03-09 18:00:00	IWM	ETF	181.35	181.35	180.76	180.96	230195.0
2023-03-09 19:00:00	IWM	ETF	180.91	181.02	180.5	180.5	87474.0
2023-03-09 04:00:00	DIA	ETF	328.28	328.28	327.88	327.88	353.0
2023-03-09 06:00:00	DIA	ETF	328.61	328.63	328.61	328.63	1900.0

> showing 50 of 17,263 rows — these rows as CSV

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