PREVIEW / etf_1hour / 2023-01-31

all etf 1-hour files

  file:    by_date/etf_1hour/2023/2023-01-31.parquet
  size:    474 KB
  rows:    17,516

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-01-31 04:00:00	SPY	ETF	399.95	400.0	399.21	399.5	38241.0
2023-01-31 05:00:00	SPY	ETF	399.31	399.47	398.7	398.75	25763.0
2023-01-31 06:00:00	SPY	ETF	398.7	399.32	398.25	399.22	110267.0
2023-01-31 07:00:00	SPY	ETF	399.3	400.15	399.25	399.95	203619.0
2023-01-31 08:00:00	SPY	ETF	399.5	402.23	398.69	401.8	1116833.0
2023-01-31 09:00:00	SPY	ETF	401.84	402.3401	400.88	401.2399	5715813.0
2023-01-31 10:00:00	SPY	ETF	401.23	403.34	400.77	402.92	7104421.0
2023-01-31 11:00:00	SPY	ETF	402.932	403.53	402.726	403.05	4687211.0
2023-01-31 12:00:00	SPY	ETF	403.05	403.88	402.5	403.66	3810847.0
2023-01-31 13:00:00	SPY	ETF	403.68	404.3	403.18	404.22	3576046.0
2023-01-31 14:00:00	SPY	ETF	404.24	404.74	404.09	404.49	4449856.0
2023-01-31 15:00:00	SPY	ETF	404.5	406.53	403.645	406.45	22679634.0
2023-01-31 16:00:00	SPY	ETF	406.45	406.48	405.69	405.95	8387239.0
2023-01-31 17:00:00	SPY	ETF	405.92	406.08	405.79	406.02	114021.0
2023-01-31 18:00:00	SPY	ETF	406.02	406.02	405.33	405.55	110512.0
2023-01-31 19:00:00	SPY	ETF	405.51	405.95	405.01	405.09	85260.0
2023-01-31 04:00:00	QQQ	ETF	289.05	289.64	288.68	288.88	73894.0
2023-01-31 05:00:00	QQQ	ETF	288.91	288.91	288.1	288.14	61486.0
2023-01-31 06:00:00	QQQ	ETF	288.16	288.82	287.84	288.79	94861.0
2023-01-31 07:00:00	QQQ	ETF	288.76	289.44	288.64	289.25	142548.0
2023-01-31 08:00:00	QQQ	ETF	288.92	291.33	288.2504	290.96	1209781.0
2023-01-31 09:00:00	QQQ	ETF	290.99	292.27	290.2	290.78	5177854.0
2023-01-31 10:00:00	QQQ	ETF	290.81	292.925	290.35	292.71	6118165.0
2023-01-31 11:00:00	QQQ	ETF	292.72	293.22	292.25	292.5211	3559626.0
2023-01-31 12:00:00	QQQ	ETF	292.54	293.1995	291.928	292.985	2473854.0
2023-01-31 13:00:00	QQQ	ETF	292.9951	293.355	292.36	293.22	1793886.0
2023-01-31 14:00:00	QQQ	ETF	293.22	293.78	293.056	293.59	2242251.0
2023-01-31 15:00:00	QQQ	ETF	293.6	294.72	292.66	294.67	7554139.0
2023-01-31 16:00:00	QQQ	ETF	294.67	294.6801	293.61	293.75	2321252.0
2023-01-31 17:00:00	QQQ	ETF	293.84	294.62	293.72	293.82	155104.0
2023-01-31 18:00:00	QQQ	ETF	293.74	293.75	293.25	293.5	98144.0
2023-01-31 19:00:00	QQQ	ETF	293.43	293.85	293.05	293.08	102428.0
2023-01-31 04:00:00	IWM	ETF	186.94	186.94	186.4	186.52	7678.0
2023-01-31 05:00:00	IWM	ETF	186.5	186.6	186.24	186.24	23315.0
2023-01-31 06:00:00	IWM	ETF	186.22	186.65	186.05	186.64	28501.0
2023-01-31 07:00:00	IWM	ETF	186.8	187.08	186.7	186.95	51470.0
2023-01-31 08:00:00	IWM	ETF	186.76	188.0	186.335	187.73	322436.0
2023-01-31 09:00:00	IWM	ETF	187.84	188.885	187.35	188.26	1949046.0
2023-01-31 10:00:00	IWM	ETF	188.26	190.165	187.79	190.01	2583651.0
2023-01-31 11:00:00	IWM	ETF	190.01	190.661	189.91	190.48	1793071.0
2023-01-31 12:00:00	IWM	ETF	190.49	190.61	190.2073	190.36	1013465.0
2023-01-31 13:00:00	IWM	ETF	190.355	190.76	190.23	190.69	858291.0
2023-01-31 14:00:00	IWM	ETF	190.7	190.96	190.57	190.79	1414972.0
2023-01-31 15:00:00	IWM	ETF	190.79	191.58	190.4	191.5	3874451.0
2023-01-31 16:00:00	IWM	ETF	191.51	191.51	191.24	191.32	2493035.0
2023-01-31 17:00:00	IWM	ETF	191.26	191.43	191.26	191.36	8986.0
2023-01-31 18:00:00	IWM	ETF	191.4	191.4	191.12	191.26	23084.0
2023-01-31 19:00:00	IWM	ETF	191.26	191.4	190.99	191.08	58872.0
2023-01-31 04:00:00	DIA	ETF	336.2	336.23	336.01	336.16	730.0
2023-01-31 05:00:00	DIA	ETF	335.99	335.99	335.99	335.99	200.0

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

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