PREVIEW / etf_1hour / 2023-04-28

all etf 1-hour files

  file:    by_date/etf_1hour/2023/2023-04-28.parquet
  size:    465 KB
  rows:    16,864

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-28 04:00:00	SPY	ETF	411.51	411.51	410.46	410.58	100983.0
2023-04-28 05:00:00	SPY	ETF	410.53	411.1	410.22	411.02	380432.0
2023-04-28 06:00:00	SPY	ETF	411.0	411.17	410.75	410.75	34891.0
2023-04-28 07:00:00	SPY	ETF	410.77	411.29	410.73	410.82	564341.0
2023-04-28 08:00:00	SPY	ETF	411.0	413.0	410.3204	411.33	1074813.0
2023-04-28 09:00:00	SPY	ETF	411.34	412.77	411.31	412.54	6465683.0
2023-04-28 10:00:00	SPY	ETF	412.49	414.81	412.34	413.249	15516846.0
2023-04-28 11:00:00	SPY	ETF	413.23	414.87	412.31	414.7489	6923344.0
2023-04-28 12:00:00	SPY	ETF	414.745	415.54	414.365	415.46	5425111.0
2023-04-28 13:00:00	SPY	ETF	415.45	415.545	414.55	414.9475	5018135.0
2023-04-28 14:00:00	SPY	ETF	414.955	415.48	414.11	414.8	7016392.0
2023-04-28 15:00:00	SPY	ETF	414.8	415.94	414.64	415.93	15610459.0
2023-04-28 16:00:00	SPY	ETF	415.93	416.31	414.4723	416.0	5268175.0
2023-04-28 17:00:00	SPY	ETF	416.05	416.08	415.6	415.6	1113889.0
2023-04-28 18:00:00	SPY	ETF	415.6	416.24	415.51	416.13	77410.0
2023-04-28 19:00:00	SPY	ETF	416.1	416.18	416.04	416.17	24459.0
2023-04-28 04:00:00	QQQ	ETF	319.55	319.85	319.19	319.38	107399.0
2023-04-28 05:00:00	QQQ	ETF	319.3	319.59	319.02	319.36	57821.0
2023-04-28 06:00:00	QQQ	ETF	319.32	319.6	319.19	319.41	58090.0
2023-04-28 07:00:00	QQQ	ETF	319.46	319.83	319.31	319.32	333707.0
2023-04-28 08:00:00	QQQ	ETF	319.5687	320.59	318.92	319.85	836512.0
2023-04-28 09:00:00	QQQ	ETF	319.86	320.705	318.96	319.85	7266602.0
2023-04-28 10:00:00	QQQ	ETF	319.83	321.87	319.38	319.828	10275309.0
2023-04-28 11:00:00	QQQ	ETF	319.84	321.03	319.22	320.94	5831572.0
2023-04-28 12:00:00	QQQ	ETF	320.93	321.72	320.485	321.67	3779973.0
2023-04-28 13:00:00	QQQ	ETF	321.665	321.83	321.01	321.469	4050120.0
2023-04-28 14:00:00	QQQ	ETF	321.4569	321.88	321.09	321.6775	3672969.0
2023-04-28 15:00:00	QQQ	ETF	321.68	322.65	321.42	322.62	7568419.0
2023-04-28 16:00:00	QQQ	ETF	322.6	322.9	322.5	322.68	1140521.0
2023-04-28 17:00:00	QQQ	ETF	322.67	322.76	322.41	322.45	835441.0
2023-04-28 18:00:00	QQQ	ETF	322.44	322.69	322.43	322.56	31964.0
2023-04-28 19:00:00	QQQ	ETF	322.55	322.84	322.55	322.8	27717.0
2023-04-28 04:00:00	IWM	ETF	172.62	172.68	172.0	172.08	26463.0
2023-04-28 05:00:00	IWM	ETF	172.16	172.7	172.1	172.7	10087.0
2023-04-28 06:00:00	IWM	ETF	172.63	172.83	172.5	172.52	9345.0
2023-04-28 07:00:00	IWM	ETF	172.5	173.0	172.38	172.75	171999.0
2023-04-28 08:00:00	IWM	ETF	172.46	173.19	172.4501	172.94	173183.0
2023-04-28 09:00:00	IWM	ETF	172.96	174.58	172.95	174.15	3708481.0
2023-04-28 10:00:00	IWM	ETF	174.18	175.62	174.09	174.76	5348640.0
2023-04-28 11:00:00	IWM	ETF	174.77	175.605	174.09	175.47	2432520.0
2023-04-28 12:00:00	IWM	ETF	175.48	175.825	175.28	175.78	1494478.0
2023-04-28 13:00:00	IWM	ETF	175.78	175.81	175.17	175.28	1768284.0
2023-04-28 14:00:00	IWM	ETF	175.27	175.605	174.765	175.11	2187146.0
2023-04-28 15:00:00	IWM	ETF	175.11	175.4	174.935	175.21	5619276.0
2023-04-28 16:00:00	IWM	ETF	175.2	175.6	175.2	175.43	1158028.0
2023-04-28 17:00:00	IWM	ETF	175.44	175.44	175.06	175.14	46795.0
2023-04-28 18:00:00	IWM	ETF	175.18	175.4	175.07	175.38	6674.0
2023-04-28 19:00:00	IWM	ETF	175.3	175.4	175.3	175.33	5431.0
2023-04-28 04:00:00	DIA	ETF	337.21	337.22	336.73	336.81	3500.0
2023-04-28 05:00:00	DIA	ETF	336.59	337.21	336.59	337.21	3600.0

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

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