PREVIEW / etf_1hour / 2023-06-09

all etf 1-hour files

  file:    by_date/etf_1hour/2023/2023-06-09.parquet
  size:    466 KB
  rows:    16,830

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-06-09 04:00:00	SPY	ETF	428.41	428.87	428.23	428.87	31389.0
2023-06-09 05:00:00	SPY	ETF	428.84	429.14	428.62	428.7	23076.0
2023-06-09 06:00:00	SPY	ETF	428.75	428.83	428.44	428.7	98007.0
2023-06-09 07:00:00	SPY	ETF	428.7	429.35	428.7	429.14	128614.0
2023-06-09 08:00:00	SPY	ETF	428.6703	429.6399	428.0	429.6399	328808.0
2023-06-09 09:00:00	SPY	ETF	429.66	431.3	429.43	430.94	7092693.0
2023-06-09 10:00:00	SPY	ETF	430.94	431.99	430.5	431.095	11216147.0
2023-06-09 11:00:00	SPY	ETF	431.11	431.63	429.3	429.4499	9939813.0
2023-06-09 12:00:00	SPY	ETF	429.46	429.92	428.87	429.8	5783099.0
2023-06-09 13:00:00	SPY	ETF	429.82	430.62	429.64	430.58	5341937.0
2023-06-09 14:00:00	SPY	ETF	430.59	430.78	429.87	430.25	4882015.0
2023-06-09 15:00:00	SPY	ETF	430.28	430.5	429.6	429.89	11418975.0
2023-06-09 16:00:00	SPY	ETF	429.89	430.33	429.88	429.91	2603313.0
2023-06-09 17:00:00	SPY	ETF	429.9	430.07	429.9	429.97	34286.0
2023-06-09 18:00:00	SPY	ETF	429.97	430.01	429.92	429.98	18589.0
2023-06-09 19:00:00	SPY	ETF	429.96	430.06	429.96	430.03	20734.0
2023-06-09 04:00:00	QQQ	ETF	352.66	353.21	352.54	353.15	23090.0
2023-06-09 05:00:00	QQQ	ETF	353.27	353.54	352.99	353.04	15403.0
2023-06-09 06:00:00	QQQ	ETF	353.12	353.43	352.75	353.02	27283.0
2023-06-09 07:00:00	QQQ	ETF	353.05	353.81	353.05	353.56	63846.0
2023-06-09 08:00:00	QQQ	ETF	353.0816	354.49	352.47	354.4	422535.0
2023-06-09 09:00:00	QQQ	ETF	354.36	357.21	354.14	356.84	6414868.0
2023-06-09 10:00:00	QQQ	ETF	356.87	357.66	354.59	355.3	8534247.0
2023-06-09 11:00:00	QQQ	ETF	355.31	356.61	353.8914	353.9	6551162.0
2023-06-09 12:00:00	QQQ	ETF	353.92	354.58	353.03	354.41	4195883.0
2023-06-09 13:00:00	QQQ	ETF	354.41	355.91	354.3	355.766	3604594.0
2023-06-09 14:00:00	QQQ	ETF	355.76	355.91	354.61	355.146	3066815.0
2023-06-09 15:00:00	QQQ	ETF	355.16	355.21	354.0501	354.49	5532522.0
2023-06-09 16:00:00	QQQ	ETF	354.47	354.84	354.44	354.69	1298757.0
2023-06-09 17:00:00	QQQ	ETF	354.67	354.79	354.58	354.6	38044.0
2023-06-09 18:00:00	QQQ	ETF	354.65	354.7	354.5232	354.55	19889.0
2023-06-09 19:00:00	QQQ	ETF	354.55	354.63	354.25	354.25	20280.0
2023-06-09 04:00:00	IWM	ETF	185.87	186.11	185.7	186.11	16210.0
2023-06-09 05:00:00	IWM	ETF	186.13	186.27	185.94	186.02	6838.0
2023-06-09 06:00:00	IWM	ETF	185.97	186.09	185.8	186.06	36414.0
2023-06-09 07:00:00	IWM	ETF	186.09	186.3	185.78	185.8	33664.0
2023-06-09 08:00:00	IWM	ETF	186.069	186.32	185.53	186.32	65381.0
2023-06-09 09:00:00	IWM	ETF	186.27	186.61	185.545	185.88	2576119.0
2023-06-09 10:00:00	IWM	ETF	185.89	186.61	185.77	185.95	3292541.0
2023-06-09 11:00:00	IWM	ETF	185.95	186.11	184.61	184.965	4049236.0
2023-06-09 12:00:00	IWM	ETF	184.95	185.19	184.64	185.0	1975499.0
2023-06-09 13:00:00	IWM	ETF	185.0	185.14	184.83	185.08	1998407.0
2023-06-09 14:00:00	IWM	ETF	185.095	185.18	184.56	184.815	2004309.0
2023-06-09 15:00:00	IWM	ETF	184.83	185.1	184.45	184.97	6093441.0
2023-06-09 16:00:00	IWM	ETF	185.03	185.08	184.79	184.93	1351652.0
2023-06-09 17:00:00	IWM	ETF	184.96	185.01	184.91	184.93	3841.0
2023-06-09 18:00:00	IWM	ETF	185.0	185.01	184.93	184.93	2813.0
2023-06-09 19:00:00	IWM	ETF	185.0	185.02	184.94	185.02	15703.0
2023-06-09 05:00:00	DIA	ETF	338.42	338.42	338.42	338.42	300.0
2023-06-09 06:00:00	DIA	ETF	338.0	338.16	338.0	338.16	1881.0

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

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