PREVIEW / etf_1hour / 2023-04-18

all etf 1-hour files

  file:    by_date/etf_1hour/2023/2023-04-18.parquet
  size:    473 KB
  rows:    17,013

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-04-18 04:00:00	SPY	ETF	414.2	415.0	414.2	414.83	26694.0
2023-04-18 05:00:00	SPY	ETF	414.73	415.57	414.73	415.37	30486.0
2023-04-18 06:00:00	SPY	ETF	415.33	415.85	415.25	415.75	51451.0
2023-04-18 07:00:00	SPY	ETF	415.77	415.81	415.22	415.52	277102.0
2023-04-18 08:00:00	SPY	ETF	415.72	416.06	413.68	415.8	234131.0
2023-04-18 09:00:00	SPY	ETF	415.79	415.81	414.49	414.675	5729247.0
2023-04-18 10:00:00	SPY	ETF	414.68	414.705	412.93	413.315	8802654.0
2023-04-18 11:00:00	SPY	ETF	413.31	413.835	412.7802	413.22	5292848.0
2023-04-18 12:00:00	SPY	ETF	413.24	414.25	413.11	413.79	4279822.0
2023-04-18 13:00:00	SPY	ETF	413.7915	414.46	413.56	413.9512	4933038.0
2023-04-18 14:00:00	SPY	ETF	413.955	414.49	413.08	413.8313	6447222.0
2023-04-18 15:00:00	SPY	ETF	413.8301	414.595	413.82	414.22	11836673.0
2023-04-18 16:00:00	SPY	ETF	414.215	415.0	413.8	414.14	2500409.0
2023-04-18 17:00:00	SPY	ETF	414.2	414.29	414.1	414.12	38028.0
2023-04-18 18:00:00	SPY	ETF	414.12	414.1299	413.95	414.1	49971.0
2023-04-18 19:00:00	SPY	ETF	414.13	414.13	413.88	413.9	32848.0
2023-04-18 04:00:00	QQQ	ETF	318.93	320.25	318.93	320.15	31040.0
2023-04-18 05:00:00	QQQ	ETF	320.13	321.07	320.0	320.85	39143.0
2023-04-18 06:00:00	QQQ	ETF	320.85	320.95	320.65	320.65	51655.0
2023-04-18 07:00:00	QQQ	ETF	320.66	321.32	320.45	321.0	119477.0
2023-04-18 08:00:00	QQQ	ETF	320.6806	321.46	318.84	321.22	396709.0
2023-04-18 09:00:00	QQQ	ETF	321.2	321.42	320.08	320.31	4775628.0
2023-04-18 10:00:00	QQQ	ETF	320.32	320.36	318.06	318.57	7110568.0
2023-04-18 11:00:00	QQQ	ETF	318.57	319.0414	317.96	318.32	4153101.0
2023-04-18 12:00:00	QQQ	ETF	318.33	319.18	318.2	318.55	3153466.0
2023-04-18 13:00:00	QQQ	ETF	318.565	319.1099	318.27	318.5387	2974332.0
2023-04-18 14:00:00	QQQ	ETF	318.52	318.96	317.64	318.13	4542563.0
2023-04-18 15:00:00	QQQ	ETF	318.14	319.12	318.01	318.84	5407903.0
2023-04-18 16:00:00	QQQ	ETF	318.835	318.96	317.82	318.81	2932983.0
2023-04-18 17:00:00	QQQ	ETF	318.8	318.86	318.52	318.57	85834.0
2023-04-18 18:00:00	QQQ	ETF	318.56	318.67	318.43	318.65	56811.0
2023-04-18 19:00:00	QQQ	ETF	318.66	318.66	318.49	318.54	81656.0
2023-04-18 04:00:00	IWM	ETF	178.92	179.16	178.92	179.16	1837.0
2023-04-18 05:00:00	IWM	ETF	179.16	179.5	179.16	179.41	2500.0
2023-04-18 06:00:00	IWM	ETF	179.38	179.9	179.38	179.85	3810.0
2023-04-18 07:00:00	IWM	ETF	179.81	179.82	179.6	179.67	48350.0
2023-04-18 08:00:00	IWM	ETF	179.6001	179.9	178.81	179.74	104246.0
2023-04-18 09:00:00	IWM	ETF	179.75	179.8	178.095	178.155	2821222.0
2023-04-18 10:00:00	IWM	ETF	178.16	178.68	177.52	177.81	2580501.0
2023-04-18 11:00:00	IWM	ETF	177.8	177.97	177.2	177.48	1889338.0
2023-04-18 12:00:00	IWM	ETF	177.47	177.865	177.36	177.5	1550624.0
2023-04-18 13:00:00	IWM	ETF	177.5	177.71	177.16	177.37	1107016.0
2023-04-18 14:00:00	IWM	ETF	177.36	177.65	176.94	177.36	1578294.0
2023-04-18 15:00:00	IWM	ETF	177.36	178.11	177.33	177.98	3121065.0
2023-04-18 16:00:00	IWM	ETF	178.02	178.7466	177.84	178.11	1590884.0
2023-04-18 17:00:00	IWM	ETF	177.85	178.21	177.85	178.08	4845.0
2023-04-18 18:00:00	IWM	ETF	178.07	178.2	178.05	178.14	13828.0
2023-04-18 19:00:00	IWM	ETF	178.1	178.1	177.94	177.99	13299.0
2023-04-18 05:00:00	DIA	ETF	340.55	340.55	340.55	340.55	100.0
2023-04-18 06:00:00	DIA	ETF	341.38	341.38	341.38	341.38	127.0

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

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