PREVIEW / etf_1hour / 2023-12-15

all etf 1-hour files

  file:    by_date/etf_1hour/2023/2023-12-15.parquet
  size:    532 KB
  rows:    19,493

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-12-15 04:00:00	SPY	ETF	471.18	471.48	471.0	471.43	48923.0
2023-12-15 05:00:00	SPY	ETF	471.47	471.65	471.17	471.32	27932.0
2023-12-15 06:00:00	SPY	ETF	471.3	471.48	471.21	471.27	121891.0
2023-12-15 07:00:00	SPY	ETF	471.3	471.37	470.79	470.93	138927.0
2023-12-15 08:00:00	SPY	ETF	471.0	472.58	469.28	469.99	972269.0
2023-12-15 09:00:00	SPY	ETF	470.0	470.61	468.81	469.15	9270106.0
2023-12-15 10:00:00	SPY	ETF	469.16	470.54	469.12	470.32	7512103.0
2023-12-15 11:00:00	SPY	ETF	470.32	470.52	469.74	470.0799	5782596.0
2023-12-15 12:00:00	SPY	ETF	470.08	470.405	469.27	469.355	5768572.0
2023-12-15 13:00:00	SPY	ETF	469.35	469.95	468.44	468.68	7828310.0
2023-12-15 14:00:00	SPY	ETF	468.68	469.29	468.465	468.99	7337509.0
2023-12-15 15:00:00	SPY	ETF	468.99	470.7	468.83	469.37	25482455.0
2023-12-15 16:00:00	SPY	ETF	469.36	470.5382	469.32	469.68	8365763.0
2023-12-15 17:00:00	SPY	ETF	469.67	469.99	469.67	469.79	93477.0
2023-12-15 18:00:00	SPY	ETF	469.77	470.15	469.4	470.0	240980.0
2023-12-15 19:00:00	SPY	ETF	470.0	470.1	469.9401	470.1	15051.0
2023-12-15 04:00:00	QQQ	ETF	404.0	404.81	404.0	404.81	38358.0
2023-12-15 05:00:00	QQQ	ETF	404.8	404.86	404.4	404.52	31550.0
2023-12-15 06:00:00	QQQ	ETF	404.54	404.91	404.45	404.75	37116.0
2023-12-15 07:00:00	QQQ	ETF	404.75	404.83	404.36	404.46	142928.0
2023-12-15 08:00:00	QQQ	ETF	404.7	404.8187	403.51	404.27	579711.0
2023-12-15 09:00:00	QQQ	ETF	404.29	405.57	403.39	405.0	6447266.0
2023-12-15 10:00:00	QQQ	ETF	405.01	406.29	404.71	405.87	5269715.0
2023-12-15 11:00:00	QQQ	ETF	405.88	406.5399	405.38	405.97	3923495.0
2023-12-15 12:00:00	QQQ	ETF	405.98	406.15	404.435	404.505	3633041.0
2023-12-15 13:00:00	QQQ	ETF	404.515	405.4699	403.57	404.01	5312091.0
2023-12-15 14:00:00	QQQ	ETF	404.0	405.17	403.77	404.82	3464335.0
2023-12-15 15:00:00	QQQ	ETF	404.815	406.1	404.65	404.94	7673174.0
2023-12-15 16:00:00	QQQ	ETF	404.93	405.34	404.86	404.88	1842009.0
2023-12-15 17:00:00	QQQ	ETF	404.9	405.1	404.89	405.01	52134.0
2023-12-15 18:00:00	QQQ	ETF	405.03	405.55	404.6	405.55	120063.0
2023-12-15 19:00:00	QQQ	ETF	405.55	405.67	405.38	405.67	39744.0
2023-12-15 04:00:00	IWM	ETF	200.0	200.8	199.93	200.46	156402.0
2023-12-15 05:00:00	IWM	ETF	200.41	200.89	200.35	200.52	63620.0
2023-12-15 06:00:00	IWM	ETF	200.55	200.84	200.3	200.3	78281.0
2023-12-15 07:00:00	IWM	ETF	200.39	200.63	199.84	199.86	324265.0
2023-12-15 08:00:00	IWM	ETF	200.5597	200.7396	196.9	198.84	1138941.0
2023-12-15 09:00:00	IWM	ETF	198.84	199.43	197.5	198.22	8405102.0
2023-12-15 10:00:00	IWM	ETF	198.225	199.55	197.92	199.22	7026480.0
2023-12-15 11:00:00	IWM	ETF	199.21	199.4499	197.6	198.1	4636987.0
2023-12-15 12:00:00	IWM	ETF	198.11	198.32	197.07	197.19	3749281.0
2023-12-15 13:00:00	IWM	ETF	197.18	197.2399	196.03	196.17	6006026.0
2023-12-15 14:00:00	IWM	ETF	196.16	196.85	195.95	196.8	4429326.0
2023-12-15 15:00:00	IWM	ETF	196.79	197.635	196.71	196.97	7614285.0
2023-12-15 16:00:00	IWM	ETF	196.97	197.51	196.96	197.41	4618710.0
2023-12-15 17:00:00	IWM	ETF	197.43	197.78	197.04	197.51	182337.0
2023-12-15 18:00:00	IWM	ETF	197.58	197.9	197.19	197.89	276220.0
2023-12-15 19:00:00	IWM	ETF	197.79	197.87	197.51	197.7	11274.0
2023-12-15 04:00:00	DIA	ETF	373.33	373.72	373.33	373.72	8279.0
2023-12-15 05:00:00	DIA	ETF	373.77	373.85	373.63	373.69	2325.0

> showing 50 of 19,493 rows — these rows as CSV

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