PREVIEW / etf_1hour / 2022-08-26

all etf 1-hour files

  file:    by_date/etf_1hour/2022/2022-08-26.parquet
  size:    444 KB
  rows:    16,198

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
2022-08-26 04:00:00	SPY	ETF	419.1	419.1	417.86	418.22	60493.0
2022-08-26 05:00:00	SPY	ETF	418.13	418.31	417.7	417.86	33993.0
2022-08-26 06:00:00	SPY	ETF	417.86	418.13	417.59	417.75	164397.0
2022-08-26 07:00:00	SPY	ETF	417.84	418.52	417.39	418.32	111714.0
2022-08-26 08:00:00	SPY	ETF	417.67	419.5	417.46	419.45	461575.0
2022-08-26 09:00:00	SPY	ETF	419.45	421.02	418.05	419.17	4751450.0
2022-08-26 10:00:00	SPY	ETF	419.185	419.96	411.95	412.7799	16535212.0
2022-08-26 11:00:00	SPY	ETF	412.76	412.86	410.06	411.08	10323319.0
2022-08-26 12:00:00	SPY	ETF	411.08	411.13	409.36	410.35	6395225.0
2022-08-26 13:00:00	SPY	ETF	410.34	410.69	408.9	409.08	4487396.0
2022-08-26 14:00:00	SPY	ETF	409.08	409.33	407.355	407.45	7051050.0
2022-08-26 15:00:00	SPY	ETF	407.44	407.95	405.25	405.32	20006356.0
2022-08-26 16:00:00	SPY	ETF	405.31	405.36	403.8	403.81	5788538.0
2022-08-26 17:00:00	SPY	ETF	403.79	405.31	403.76	404.2	964009.0
2022-08-26 18:00:00	SPY	ETF	404.21	405.31	403.9	403.91	107081.0
2022-08-26 19:00:00	SPY	ETF	403.91	404.25	403.7	403.9	67850.0
2022-08-26 04:00:00	QQQ	ETF	319.98	319.98	318.84	319.1	57076.0
2022-08-26 05:00:00	QQQ	ETF	319.07	319.11	318.57	318.73	36560.0
2022-08-26 06:00:00	QQQ	ETF	318.8	319.03	318.59	318.81	57834.0
2022-08-26 07:00:00	QQQ	ETF	318.88	319.54	318.4	319.34	149550.0
2022-08-26 08:00:00	QQQ	ETF	318.93	320.82	318.4099	320.54	699917.0
2022-08-26 09:00:00	QQQ	ETF	320.5299	322.03	318.77	319.98	4079135.0
2022-08-26 10:00:00	QQQ	ETF	319.99	321.51	313.52	314.0466	14073025.0
2022-08-26 11:00:00	QQQ	ETF	314.04	314.2	311.29	312.15	7663390.0
2022-08-26 12:00:00	QQQ	ETF	312.15	312.18	310.86	311.94	3907773.0
2022-08-26 13:00:00	QQQ	ETF	311.94	312.31	310.26	310.49	3399224.0
2022-08-26 14:00:00	QQQ	ETF	310.48	310.68	309.39	309.55	4628862.0
2022-08-26 15:00:00	QQQ	ETF	309.54	310.05	307.35	307.42	10853403.0
2022-08-26 16:00:00	QQQ	ETF	307.43	307.52	305.97	306.0	3505653.0
2022-08-26 17:00:00	QQQ	ETF	306.09	307.44	306.04	306.34	684807.0
2022-08-26 18:00:00	QQQ	ETF	306.35	307.44	306.19	306.2	148293.0
2022-08-26 19:00:00	QQQ	ETF	306.2	306.34	306.0	306.1	44011.0
2022-08-26 04:00:00	IWM	ETF	194.74	194.9	194.51	194.71	15667.0
2022-08-26 05:00:00	IWM	ETF	194.74	194.76	194.48	194.59	10975.0
2022-08-26 06:00:00	IWM	ETF	194.72	194.72	194.42	194.44	108983.0
2022-08-26 07:00:00	IWM	ETF	194.57	194.97	194.34	194.88	23008.0
2022-08-26 08:00:00	IWM	ETF	194.5	195.42	194.5	195.39	54936.0
2022-08-26 09:00:00	IWM	ETF	195.389	196.29	193.95	194.52	1422979.0
2022-08-26 10:00:00	IWM	ETF	194.54	194.89	191.21	191.54	4582174.0
2022-08-26 11:00:00	IWM	ETF	191.53	191.64	190.22	190.93	2049902.0
2022-08-26 12:00:00	IWM	ETF	190.96	190.96	190.12	190.6843	1139455.0
2022-08-26 13:00:00	IWM	ETF	190.68	191.09	190.3	190.38	1533689.0
2022-08-26 14:00:00	IWM	ETF	190.37	190.54	189.62	189.68	1492467.0
2022-08-26 15:00:00	IWM	ETF	189.68	189.93	188.66	188.86	4599307.0
2022-08-26 16:00:00	IWM	ETF	188.86	188.98	187.97	187.97	1379996.0
2022-08-26 17:00:00	IWM	ETF	187.98	188.58	187.97	188.47	118941.0
2022-08-26 18:00:00	IWM	ETF	188.47	188.98	188.16	188.22	67005.0
2022-08-26 19:00:00	IWM	ETF	188.28	188.49	188.01	188.3	10829.0
2022-08-26 04:00:00	DIA	ETF	332.4	332.56	332.4	332.56	2353.0
2022-08-26 05:00:00	DIA	ETF	332.39	332.4	332.15	332.15	1400.0

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

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