PREVIEW / etf_1hour / 2023-05-08

all etf 1-hour files

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

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-08 04:00:00	SPY	ETF	412.72	412.84	412.52	412.58	17285.0
2023-05-08 05:00:00	SPY	ETF	412.58	412.91	412.58	412.87	8925.0
2023-05-08 06:00:00	SPY	ETF	412.91	413.2	412.91	413.09	46958.0
2023-05-08 07:00:00	SPY	ETF	413.1	413.41	413.09	413.32	125211.0
2023-05-08 08:00:00	SPY	ETF	413.3493	413.6	412.17	413.15	362052.0
2023-05-08 09:00:00	SPY	ETF	413.15	413.2	411.89	412.1726	5596441.0
2023-05-08 10:00:00	SPY	ETF	412.23	412.58	411.68	412.3901	6364770.0
2023-05-08 11:00:00	SPY	ETF	412.4	412.85	411.84	412.64	4110003.0
2023-05-08 12:00:00	SPY	ETF	412.65	412.7703	411.99	412.27	3641184.0
2023-05-08 13:00:00	SPY	ETF	412.28	412.94	412.09	412.76	3965570.0
2023-05-08 14:00:00	SPY	ETF	412.77	413.24	411.28	413.12	7305220.0
2023-05-08 15:00:00	SPY	ETF	413.13	413.18	412.42	412.79	8053839.0
2023-05-08 16:00:00	SPY	ETF	412.79	412.92	412.56	412.61	1911399.0
2023-05-08 17:00:00	SPY	ETF	412.54	412.8	412.45	412.62	46656.0
2023-05-08 18:00:00	SPY	ETF	412.62	412.62	412.48	412.55	18871.0
2023-05-08 19:00:00	SPY	ETF	412.54	412.6	412.45	412.54	28117.0
2023-05-08 04:00:00	QQQ	ETF	322.83	322.88	322.36	322.44	33579.0
2023-05-08 05:00:00	QQQ	ETF	322.42	322.72	322.38	322.72	8000.0
2023-05-08 06:00:00	QQQ	ETF	322.68	322.85	322.57	322.62	14220.0
2023-05-08 07:00:00	QQQ	ETF	322.68	322.97	322.6	322.75	178653.0
2023-05-08 08:00:00	QQQ	ETF	322.76	323.132	322.09	322.28	355461.0
2023-05-08 09:00:00	QQQ	ETF	322.23	322.6399	321.46	321.69	4337571.0
2023-05-08 10:00:00	QQQ	ETF	321.7	322.34	321.315	322.14	4522451.0
2023-05-08 11:00:00	QQQ	ETF	322.15	322.96	321.925	322.93	3531118.0
2023-05-08 12:00:00	QQQ	ETF	322.93	323.11	322.59	323.06	2749194.0
2023-05-08 13:00:00	QQQ	ETF	323.08	323.74	322.82	323.5078	2707178.0
2023-05-08 14:00:00	QQQ	ETF	323.51	324.04	322.14	323.905	4482414.0
2023-05-08 15:00:00	QQQ	ETF	323.905	323.98	323.3001	323.74	4587622.0
2023-05-08 16:00:00	QQQ	ETF	323.7	323.73	323.25	323.25	649425.0
2023-05-08 17:00:00	QQQ	ETF	323.27	323.44	323.27	323.4	46763.0
2023-05-08 18:00:00	QQQ	ETF	323.35	323.35	323.13	323.24	42308.0
2023-05-08 19:00:00	QQQ	ETF	323.27	323.34	323.16	323.3	24999.0
2023-05-08 04:00:00	IWM	ETF	174.8	174.95	174.8	174.8	4051.0
2023-05-08 05:00:00	IWM	ETF	174.78	174.92	174.73	174.91	8541.0
2023-05-08 06:00:00	IWM	ETF	174.89	175.09	174.85	174.92	9288.0
2023-05-08 07:00:00	IWM	ETF	174.95	175.24	174.95	175.16	11944.0
2023-05-08 08:00:00	IWM	ETF	175.25	175.41	174.59	175.21	134840.0
2023-05-08 09:00:00	IWM	ETF	175.19	175.55	173.9	174.17	3120344.0
2023-05-08 10:00:00	IWM	ETF	174.2	174.41	173.325	174.05	2969713.0
2023-05-08 11:00:00	IWM	ETF	174.06	174.21	173.15	173.58	3050408.0
2023-05-08 12:00:00	IWM	ETF	173.59	173.65	173.27	173.4853	1087289.0
2023-05-08 13:00:00	IWM	ETF	173.5	173.99	173.29	173.92	1059530.0
2023-05-08 14:00:00	IWM	ETF	173.92	174.18	173.13	174.07	2048527.0
2023-05-08 15:00:00	IWM	ETF	174.08	174.255	173.75	174.05	3116990.0
2023-05-08 16:00:00	IWM	ETF	174.05	174.15	173.88	174.1	497652.0
2023-05-08 17:00:00	IWM	ETF	174.1	174.19	174.05	174.14	4622.0
2023-05-08 18:00:00	IWM	ETF	174.05	174.12	173.97	173.99	2405.0
2023-05-08 19:00:00	IWM	ETF	174.05	174.05	173.8	173.98	44209.0
2023-05-08 04:00:00	DIA	ETF	337.19	337.22	337.19	337.22	500.0
2023-05-08 05:00:00	DIA	ETF	337.2	337.2	337.2	337.2	200.0

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

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