PREVIEW / etf_1hour / 2023-09-01

all etf 1-hour files

  file:    by_date/etf_1hour/2023/2023-09-01.parquet
  size:    477 KB
  rows:    17,106

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-09-01 04:00:00	SPY	ETF	451.53	451.61	451.12	451.37	17437.0
2023-09-01 05:00:00	SPY	ETF	451.52	451.95	451.52	451.71	26702.0
2023-09-01 06:00:00	SPY	ETF	451.7	452.54	451.49	452.05	141104.0
2023-09-01 07:00:00	SPY	ETF	451.99	452.32	451.86	452.06	124783.0
2023-09-01 08:00:00	SPY	ETF	450.94	453.5	450.75	453.11	1326712.0
2023-09-01 09:00:00	SPY	ETF	453.13	453.67	451.15	452.3358	7127589.0
2023-09-01 10:00:00	SPY	ETF	452.3	453.04	450.67	450.98	9044784.0
2023-09-01 11:00:00	SPY	ETF	450.95	451.25	449.69	449.882	5570792.0
2023-09-01 12:00:00	SPY	ETF	449.88	451.0	449.68	450.74	4159028.0
2023-09-01 13:00:00	SPY	ETF	450.74	450.895	450.18	450.65	2977058.0
2023-09-01 14:00:00	SPY	ETF	450.6457	450.7901	449.88	450.55	3370098.0
2023-09-01 15:00:00	SPY	ETF	450.54	451.3	450.38	451.21	10511318.0
2023-09-01 16:00:00	SPY	ETF	451.21	452.3699	450.81	450.82	3145045.0
2023-09-01 17:00:00	SPY	ETF	450.92	450.93	450.1	450.48	243611.0
2023-09-01 18:00:00	SPY	ETF	450.5	451.0	450.0	450.85	151185.0
2023-09-01 19:00:00	SPY	ETF	450.94	450.95	450.85	450.92	13644.0
2023-09-01 04:00:00	QQQ	ETF	378.13	378.61	378.13	378.3	16683.0
2023-09-01 05:00:00	QQQ	ETF	378.29	378.8	378.28	378.45	35743.0
2023-09-01 06:00:00	QQQ	ETF	378.51	378.83	378.31	378.57	10538.0
2023-09-01 07:00:00	QQQ	ETF	378.67	379.1	378.6	378.83	86498.0
2023-09-01 08:00:00	QQQ	ETF	378.78	381.0	377.3	380.49	1549280.0
2023-09-01 09:00:00	QQQ	ETF	380.55	381.05	377.15	378.58	6222189.0
2023-09-01 10:00:00	QQQ	ETF	378.56	379.42	376.751	377.055	6176234.0
2023-09-01 11:00:00	QQQ	ETF	377.05	377.82	376.12	376.29	3546763.0
2023-09-01 12:00:00	QQQ	ETF	376.27	377.73	376.0801	377.55	2868778.0
2023-09-01 13:00:00	QQQ	ETF	377.55	377.69	376.62	377.23	2108635.0
2023-09-01 14:00:00	QQQ	ETF	377.25	377.39	376.19	376.96	2113038.0
2023-09-01 15:00:00	QQQ	ETF	376.95	377.83	376.8299	377.67	4259143.0
2023-09-01 16:00:00	QQQ	ETF	377.65	377.71	377.4	377.47	1559142.0
2023-09-01 17:00:00	QQQ	ETF	377.45	377.59	377.18	377.34	47281.0
2023-09-01 18:00:00	QQQ	ETF	377.43	377.4899	377.29	377.4	3713.0
2023-09-01 19:00:00	QQQ	ETF	377.42	377.55	377.33	377.4	19374.0
2023-09-01 04:00:00	IWM	ETF	189.42	189.48	189.34	189.42	12092.0
2023-09-01 05:00:00	IWM	ETF	189.43	189.58	189.43	189.47	16935.0
2023-09-01 06:00:00	IWM	ETF	189.41	189.8	189.33	189.64	124022.0
2023-09-01 07:00:00	IWM	ETF	189.57	189.76	189.51	189.51	24867.0
2023-09-01 08:00:00	IWM	ETF	189.66	190.48	189.03	190.18	362247.0
2023-09-01 09:00:00	IWM	ETF	190.19	191.86	189.85	190.51	4862689.0
2023-09-01 10:00:00	IWM	ETF	190.49	191.67	189.86	191.07	4738674.0
2023-09-01 11:00:00	IWM	ETF	191.07	191.33	190.44	190.595	1998178.0
2023-09-01 12:00:00	IWM	ETF	190.59	191.19	190.465	191.055	1343879.0
2023-09-01 13:00:00	IWM	ETF	191.045	191.11	190.811	191.07	921957.0
2023-09-01 14:00:00	IWM	ETF	191.08	191.145	190.565	190.75	1444808.0
2023-09-01 15:00:00	IWM	ETF	190.75	190.8898	190.59	190.8	3401697.0
2023-09-01 16:00:00	IWM	ETF	190.85	190.85	190.66	190.67	810985.0
2023-09-01 17:00:00	IWM	ETF	190.67	190.79	190.5	190.6	11124.0
2023-09-01 18:00:00	IWM	ETF	190.65	190.85	190.65	190.85	5167.0
2023-09-01 19:00:00	IWM	ETF	190.85	190.94	190.58	190.65	3694.0
2023-09-01 04:00:00	DIA	ETF	348.98	349.0	348.87	348.88	1205.0
2023-09-01 05:00:00	DIA	ETF	348.95	348.95	348.95	348.95	100.0

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

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