PREVIEW / etf_1hour / 2023-07-18

all etf 1-hour files

  file:    by_date/etf_1hour/2023/2023-07-18.parquet
  size:    488 KB
  rows:    17,697

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-07-18 04:00:00	SPY	ETF	450.52	451.02	450.5	450.65	19136.0
2023-07-18 05:00:00	SPY	ETF	450.62	451.01	450.62	450.9	4821.0
2023-07-18 06:00:00	SPY	ETF	450.94	451.01	450.56	450.66	7551.0
2023-07-18 07:00:00	SPY	ETF	450.61	450.74	450.42	450.61	25714.0
2023-07-18 08:00:00	SPY	ETF	450.24	450.84	450.01	450.29	233213.0
2023-07-18 09:00:00	SPY	ETF	450.29	451.63	450.0484	451.52	5430088.0
2023-07-18 10:00:00	SPY	ETF	451.51	452.31	451.3401	452.26	6132083.0
2023-07-18 11:00:00	SPY	ETF	452.26	453.3784	452.05	453.2	7323801.0
2023-07-18 12:00:00	SPY	ETF	453.22	453.28	452.44	452.845	5173565.0
2023-07-18 13:00:00	SPY	ETF	452.85	453.52	452.82	453.49	4469623.0
2023-07-18 14:00:00	SPY	ETF	453.485	454.43	453.41	454.15	6634864.0
2023-07-18 15:00:00	SPY	ETF	454.155	454.86	453.8398	454.19	18456671.0
2023-07-18 16:00:00	SPY	ETF	454.18	454.19	453.0	453.77	4204233.0
2023-07-18 17:00:00	SPY	ETF	453.87	453.87	453.73	453.73	36797.0
2023-07-18 18:00:00	SPY	ETF	453.7	454.06	453.7	453.95	37845.0
2023-07-18 19:00:00	SPY	ETF	454.01	454.12	453.98	454.04	57858.0
2023-07-18 04:00:00	QQQ	ETF	382.33	382.62	382.02	382.19	23398.0
2023-07-18 05:00:00	QQQ	ETF	382.17	382.4	382.12	382.31	8819.0
2023-07-18 06:00:00	QQQ	ETF	382.35	382.43	381.91	382.11	80622.0
2023-07-18 07:00:00	QQQ	ETF	382.12	382.34	381.9	382.1	79670.0
2023-07-18 08:00:00	QQQ	ETF	382.1389	382.48	381.52	381.92	354347.0
2023-07-18 09:00:00	QQQ	ETF	381.95	382.02	380.0	381.1062	5821140.0
2023-07-18 10:00:00	QQQ	ETF	381.09	381.6	380.43	381.32	5735148.0
2023-07-18 11:00:00	QQQ	ETF	381.33	383.73	380.92	383.5588	7052181.0
2023-07-18 12:00:00	QQQ	ETF	383.56	384.67	383.22	384.1727	6781288.0
2023-07-18 13:00:00	QQQ	ETF	384.19	385.281	384.1401	385.275	3567056.0
2023-07-18 14:00:00	QQQ	ETF	385.28	386.705	385.19	386.515	5118565.0
2023-07-18 15:00:00	QQQ	ETF	386.52	387.13	385.71	385.76	7660434.0
2023-07-18 16:00:00	QQQ	ETF	385.78	385.78	385.13	385.16	1240961.0
2023-07-18 17:00:00	QQQ	ETF	385.16	385.32	385.15	385.24	61005.0
2023-07-18 18:00:00	QQQ	ETF	385.22	385.54	385.12	385.4599	55891.0
2023-07-18 19:00:00	QQQ	ETF	385.45	385.62	385.45	385.481	49898.0
2023-07-18 04:00:00	IWM	ETF	193.41	193.65	193.36	193.48	7423.0
2023-07-18 05:00:00	IWM	ETF	193.45	193.71	193.45	193.68	2881.0
2023-07-18 06:00:00	IWM	ETF	193.72	193.72	193.34	193.41	11592.0
2023-07-18 07:00:00	IWM	ETF	193.4	193.45	193.23	193.33	13654.0
2023-07-18 08:00:00	IWM	ETF	193.38	193.4904	192.93	193.3296	73186.0
2023-07-18 09:00:00	IWM	ETF	193.32	196.0	193.25	195.97	3755919.0
2023-07-18 10:00:00	IWM	ETF	195.96	196.39	195.36	195.68	3873902.0
2023-07-18 11:00:00	IWM	ETF	195.69	196.02	195.13	195.6356	2823936.0
2023-07-18 12:00:00	IWM	ETF	195.64	195.72	195.24	195.49	1860976.0
2023-07-18 13:00:00	IWM	ETF	195.49	195.63	195.22	195.275	1525485.0
2023-07-18 14:00:00	IWM	ETF	195.275	195.95	195.25	195.895	1691008.0
2023-07-18 15:00:00	IWM	ETF	195.895	196.19	195.76	196.05	5037332.0
2023-07-18 16:00:00	IWM	ETF	195.97	196.07	195.88	195.88	1429973.0
2023-07-18 17:00:00	IWM	ETF	195.91	196.01	195.86	195.9	5151.0
2023-07-18 18:00:00	IWM	ETF	195.86	196.05	195.8	195.98	35996.0
2023-07-18 19:00:00	IWM	ETF	196.02	196.17	196.0	196.11	32182.0
2023-07-18 04:00:00	DIA	ETF	345.94	346.02	345.94	346.02	200.0
2023-07-18 05:00:00	DIA	ETF	346.12	346.12	346.12	346.12	100.0

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

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