PREVIEW / etf_1hour / 2023-05-16

all etf 1-hour files

  file:    by_date/etf_1hour/2023/2023-05-16.parquet
  size:    457 KB
  rows:    16,780

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-05-16 04:00:00	SPY	ETF	412.83	412.94	412.53	412.67	24840.0
2023-05-16 05:00:00	SPY	ETF	412.7	412.89	412.4	412.58	24457.0
2023-05-16 06:00:00	SPY	ETF	412.37	412.7	412.07	412.64	64201.0
2023-05-16 07:00:00	SPY	ETF	412.62	412.79	412.22	412.27	126619.0
2023-05-16 08:00:00	SPY	ETF	412.26	413.17	411.7	411.86	506616.0
2023-05-16 09:00:00	SPY	ETF	411.86	412.815	410.89	411.62	5812163.0
2023-05-16 10:00:00	SPY	ETF	411.6001	412.11	410.7	411.47	8126963.0
2023-05-16 11:00:00	SPY	ETF	411.47	412.0623	411.02	411.91	5356307.0
2023-05-16 12:00:00	SPY	ETF	411.92	412.32	411.56	412.05	3993732.0
2023-05-16 13:00:00	SPY	ETF	412.06	412.14	411.37	411.88	3726186.0
2023-05-16 14:00:00	SPY	ETF	411.89	411.97	411.01	411.69	4661197.0
2023-05-16 15:00:00	SPY	ETF	411.69	411.85	410.24	410.25	10129834.0
2023-05-16 16:00:00	SPY	ETF	410.25	411.11	409.97	410.74	3083306.0
2023-05-16 17:00:00	SPY	ETF	410.83	410.83	410.34	410.47	254761.0
2023-05-16 18:00:00	SPY	ETF	410.47	410.81	410.38	410.6	165234.0
2023-05-16 19:00:00	SPY	ETF	410.66	410.9	410.63	410.83	40263.0
2023-05-16 04:00:00	QQQ	ETF	327.0	327.25	326.86	326.99	38027.0
2023-05-16 05:00:00	QQQ	ETF	327.11	327.11	326.68	326.68	10647.0
2023-05-16 06:00:00	QQQ	ETF	326.65	326.98	326.5	326.98	44310.0
2023-05-16 07:00:00	QQQ	ETF	326.92	327.01	326.54	326.68	163473.0
2023-05-16 08:00:00	QQQ	ETF	326.9619	327.17	325.9	326.0	362070.0
2023-05-16 09:00:00	QQQ	ETF	325.98	327.98	325.83	327.25	5117451.0
2023-05-16 10:00:00	QQQ	ETF	327.26	328.39	326.44	328.05	5600138.0
2023-05-16 11:00:00	QQQ	ETF	328.06	328.74	327.63	328.68	3880890.0
2023-05-16 12:00:00	QQQ	ETF	328.69	328.9025	328.275	328.78	3082022.0
2023-05-16 13:00:00	QQQ	ETF	328.79	328.895	328.17	328.67	2482692.0
2023-05-16 14:00:00	QQQ	ETF	328.68	328.76	327.7699	328.47	3101624.0
2023-05-16 15:00:00	QQQ	ETF	328.4675	328.61	327.13	327.14	5844512.0
2023-05-16 16:00:00	QQQ	ETF	327.16	327.78	327.04	327.62	1039509.0
2023-05-16 17:00:00	QQQ	ETF	327.65	327.65	327.48	327.48	32049.0
2023-05-16 18:00:00	QQQ	ETF	327.48	327.7	327.29	327.46	74533.0
2023-05-16 19:00:00	QQQ	ETF	327.48	327.6	327.45	327.6	66307.0
2023-05-16 04:00:00	IWM	ETF	174.68	174.68	174.47	174.47	17310.0
2023-05-16 05:00:00	IWM	ETF	174.66	174.66	174.28	174.48	25051.0
2023-05-16 06:00:00	IWM	ETF	174.45	174.45	174.17	174.22	26124.0
2023-05-16 07:00:00	IWM	ETF	174.38	174.47	173.97	174.06	99417.0
2023-05-16 08:00:00	IWM	ETF	174.47	174.47	173.74	173.82	203751.0
2023-05-16 09:00:00	IWM	ETF	173.8	173.85	172.605	172.85	3187172.0
2023-05-16 10:00:00	IWM	ETF	172.86	173.1559	172.25	172.96	3654650.0
2023-05-16 11:00:00	IWM	ETF	172.96	173.38	172.52	173.11	2262651.0
2023-05-16 12:00:00	IWM	ETF	173.115	173.19	172.75	173.08	1638086.0
2023-05-16 13:00:00	IWM	ETF	173.1	173.19	172.58	172.83	1168363.0
2023-05-16 14:00:00	IWM	ETF	172.84	173.01	172.505	172.915	1452841.0
2023-05-16 15:00:00	IWM	ETF	172.915	173.015	172.23	172.27	3878617.0
2023-05-16 16:00:00	IWM	ETF	172.28	173.02	172.16	172.82	932904.0
2023-05-16 17:00:00	IWM	ETF	172.8799	172.8799	172.41	172.56	23566.0
2023-05-16 18:00:00	IWM	ETF	172.71	172.82	172.55	172.55	11931.0
2023-05-16 19:00:00	IWM	ETF	172.67	172.84	172.59	172.62	37239.0
2023-05-16 04:00:00	DIA	ETF	333.51	333.52	333.51	333.52	600.0
2023-05-16 05:00:00	DIA	ETF	333.36	333.48	333.36	333.48	1450.0

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

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