PREVIEW / etf_1hour / 2023-05-22

all etf 1-hour files

  file:    by_date/etf_1hour/2023/2023-05-22.parquet
  size:    460 KB
  rows:    16,996

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-22 04:00:00	SPY	ETF	418.05	418.89	418.05	418.74	23806.0
2023-05-22 05:00:00	SPY	ETF	418.75	418.79	418.44	418.44	25903.0
2023-05-22 06:00:00	SPY	ETF	418.37	418.71	418.18	418.41	67139.0
2023-05-22 07:00:00	SPY	ETF	418.44	418.9	418.1	418.89	71527.0
2023-05-22 08:00:00	SPY	ETF	418.4013	419.25	418.1	418.88	406215.0
2023-05-22 09:00:00	SPY	ETF	418.93	420.39	418.62	419.0684	5778015.0
2023-05-22 10:00:00	SPY	ETF	419.06	419.38	417.35	418.81	10352771.0
2023-05-22 11:00:00	SPY	ETF	418.82	419.5	418.685	419.25	5160464.0
2023-05-22 12:00:00	SPY	ETF	419.25	419.46	418.74	419.085	3270615.0
2023-05-22 13:00:00	SPY	ETF	419.08	419.4899	418.25	419.16	5492045.0
2023-05-22 14:00:00	SPY	ETF	419.14	420.24	419.1	419.76	5134855.0
2023-05-22 15:00:00	SPY	ETF	419.76	419.95	418.405	418.78	10595686.0
2023-05-22 16:00:00	SPY	ETF	418.77	419.01	418.64	419.01	2121191.0
2023-05-22 17:00:00	SPY	ETF	419.0	419.05	418.79	419.0	112604.0
2023-05-22 18:00:00	SPY	ETF	419.02	419.16	418.84	419.11	85301.0
2023-05-22 19:00:00	SPY	ETF	419.15	419.98	418.99	419.92	302817.0
2023-05-22 04:00:00	QQQ	ETF	336.57	336.97	336.57	336.66	33643.0
2023-05-22 05:00:00	QQQ	ETF	336.69	336.7	336.02	336.06	18916.0
2023-05-22 06:00:00	QQQ	ETF	336.08	336.32	335.91	336.14	53141.0
2023-05-22 07:00:00	QQQ	ETF	336.14	336.5	335.74	336.47	164662.0
2023-05-22 08:00:00	QQQ	ETF	336.15	336.93	335.77	336.45	351849.0
2023-05-22 09:00:00	QQQ	ETF	336.46	338.67	336.21	338.22	5819460.0
2023-05-22 10:00:00	QQQ	ETF	338.23	338.47	336.61	337.76	6645736.0
2023-05-22 11:00:00	QQQ	ETF	337.77	338.15	337.08	337.38	3082596.0
2023-05-22 12:00:00	QQQ	ETF	337.38	337.81	336.918	337.47	2063809.0
2023-05-22 13:00:00	QQQ	ETF	337.47	338.12	336.81	337.61	3126423.0
2023-05-22 14:00:00	QQQ	ETF	337.62	338.56	337.53	338.07	2652706.0
2023-05-22 15:00:00	QQQ	ETF	338.07	338.21	337.15	337.66	5761015.0
2023-05-22 16:00:00	QQQ	ETF	337.65	337.98	337.55	337.89	1296216.0
2023-05-22 17:00:00	QQQ	ETF	337.88	337.95	337.64	337.88	236000.0
2023-05-22 18:00:00	QQQ	ETF	337.86	338.03	337.83	337.96	41383.0
2023-05-22 19:00:00	QQQ	ETF	337.96	338.78	337.89	338.58	75706.0
2023-05-22 04:00:00	IWM	ETF	176.14	176.46	176.02	176.45	12328.0
2023-05-22 05:00:00	IWM	ETF	176.42	176.43	176.28	176.34	6125.0
2023-05-22 06:00:00	IWM	ETF	176.32	176.71	176.28	176.43	25870.0
2023-05-22 07:00:00	IWM	ETF	176.39	176.81	176.25	176.81	47244.0
2023-05-22 08:00:00	IWM	ETF	176.8	177.09	176.08	176.77	209106.0
2023-05-22 09:00:00	IWM	ETF	176.75	177.735	176.465	176.845	2783899.0
2023-05-22 10:00:00	IWM	ETF	176.84	177.475	176.04	177.09	3185332.0
2023-05-22 11:00:00	IWM	ETF	177.1	178.38	177.1	178.33	3092569.0
2023-05-22 12:00:00	IWM	ETF	178.33	178.63	178.02	178.355	2257963.0
2023-05-22 13:00:00	IWM	ETF	178.35	178.5499	177.88	178.2799	1838499.0
2023-05-22 14:00:00	IWM	ETF	178.28	179.02	178.17	178.8	2315637.0
2023-05-22 15:00:00	IWM	ETF	178.8	178.91	178.001	178.25	4955659.0
2023-05-22 16:00:00	IWM	ETF	178.26	178.52	178.25	178.46	983692.0
2023-05-22 17:00:00	IWM	ETF	178.5	178.54	178.26	178.46	86325.0
2023-05-22 18:00:00	IWM	ETF	178.46	178.63	178.46	178.63	9400.0
2023-05-22 19:00:00	IWM	ETF	178.63	179.14	178.6	179.07	35903.0
2023-05-22 04:00:00	DIA	ETF	333.91	334.3	333.91	334.3	1000.0
2023-05-22 05:00:00	DIA	ETF	334.36	334.36	334.27	334.27	1300.0

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

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