PREVIEW / etf_1hour / 2023-04-04

all etf 1-hour files

  file:    by_date/etf_1hour/2023/2023-04-04.parquet
  size:    473 KB
  rows:    17,386

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-04-04 04:00:00	SPY	ETF	410.7	411.47	410.65	411.1	27701.0
2023-04-04 05:00:00	SPY	ETF	411.24	412.39	411.16	412.24	34737.0
2023-04-04 06:00:00	SPY	ETF	412.13	412.75	412.0	412.42	44237.0
2023-04-04 07:00:00	SPY	ETF	412.4	412.5	412.01	412.14	113192.0
2023-04-04 08:00:00	SPY	ETF	412.37	412.74	410.75	412.03	165977.0
2023-04-04 09:00:00	SPY	ETF	412.01	412.06	409.7339	411.01	5261223.0
2023-04-04 10:00:00	SPY	ETF	411.03	411.92	409.54	409.72	9850774.0
2023-04-04 11:00:00	SPY	ETF	409.714	409.72	408.21	408.3	8623615.0
2023-04-04 12:00:00	SPY	ETF	408.3	408.54	407.24	408.33	6441160.0
2023-04-04 13:00:00	SPY	ETF	408.35	409.29	408.11	408.68	4675781.0
2023-04-04 14:00:00	SPY	ETF	408.69	408.975	407.68	407.85	5011688.0
2023-04-04 15:00:00	SPY	ETF	407.84	408.71	407.48	408.7	10310152.0
2023-04-04 16:00:00	SPY	ETF	408.71	409.0385	408.63	408.97	2802219.0
2023-04-04 17:00:00	SPY	ETF	408.99	409.05	408.91	409.05	38640.0
2023-04-04 18:00:00	SPY	ETF	409.04	409.09	408.88	408.95	134664.0
2023-04-04 19:00:00	SPY	ETF	409.04	409.18	408.95	409.09	56645.0
2023-04-04 04:00:00	QQQ	ETF	319.52	320.22	319.52	320.13	32925.0
2023-04-04 05:00:00	QQQ	ETF	320.22	322.16	320.18	322.04	82423.0
2023-04-04 06:00:00	QQQ	ETF	322.05	322.16	321.67	321.7	78982.0
2023-04-04 07:00:00	QQQ	ETF	321.62	321.81	321.29	321.63	157790.0
2023-04-04 08:00:00	QQQ	ETF	321.6287	322.0496	319.52	321.04	353192.0
2023-04-04 09:00:00	QQQ	ETF	321.03	321.03	319.28	320.49	4375439.0
2023-04-04 10:00:00	QQQ	ETF	320.51	321.63	319.67	320.13	7015979.0
2023-04-04 11:00:00	QQQ	ETF	320.13	320.15	318.73	319.32	4621878.0
2023-04-04 12:00:00	QQQ	ETF	319.33	319.5001	318.22	319.075	3672261.0
2023-04-04 13:00:00	QQQ	ETF	319.0801	319.77	318.76	319.29	2814764.0
2023-04-04 14:00:00	QQQ	ETF	319.29	319.48	318.14	318.2897	2811707.0
2023-04-04 15:00:00	QQQ	ETF	318.3	319.14	317.8251	319.13	5789004.0
2023-04-04 16:00:00	QQQ	ETF	319.135	319.36	319.07	319.32	2467593.0
2023-04-04 17:00:00	QQQ	ETF	319.32	319.35	319.1	319.2	122381.0
2023-04-04 18:00:00	QQQ	ETF	319.23	319.4	319.18	319.31	105070.0
2023-04-04 19:00:00	QQQ	ETF	319.32	319.7	319.32	319.58	60658.0
2023-04-04 04:00:00	IWM	ETF	178.28	178.73	178.28	178.42	13152.0
2023-04-04 05:00:00	IWM	ETF	178.57	179.11	178.55	179.09	13851.0
2023-04-04 06:00:00	IWM	ETF	179.02	179.36	178.92	179.18	14153.0
2023-04-04 07:00:00	IWM	ETF	179.19	179.3	179.04	179.13	36741.0
2023-04-04 08:00:00	IWM	ETF	179.08	179.26	179.03	179.12	121926.0
2023-04-04 09:00:00	IWM	ETF	179.13	179.2	177.05	177.31	2461258.0
2023-04-04 10:00:00	IWM	ETF	177.32	177.79	175.29	175.37	4051103.0
2023-04-04 11:00:00	IWM	ETF	175.36	175.41	174.49	174.6799	3963503.0
2023-04-04 12:00:00	IWM	ETF	174.69	175.17	174.32	174.995	2674637.0
2023-04-04 13:00:00	IWM	ETF	175.0	175.51	174.88	174.975	1665684.0
2023-04-04 14:00:00	IWM	ETF	174.97	175.21	174.46	174.53	2628977.0
2023-04-04 15:00:00	IWM	ETF	174.52	175.32	174.38	175.3	4432194.0
2023-04-04 16:00:00	IWM	ETF	175.35	175.61	175.1422	175.54	1830781.0
2023-04-04 17:00:00	IWM	ETF	175.73	175.73	175.36	175.41	5955.0
2023-04-04 18:00:00	IWM	ETF	175.48	175.62	175.48	175.56	12538.0
2023-04-04 19:00:00	IWM	ETF	175.58	175.63	175.47	175.51	7364.0
2023-04-04 05:00:00	DIA	ETF	336.27	336.36	336.27	336.36	1120.0
2023-04-04 06:00:00	DIA	ETF	336.53	336.53	336.53	336.53	100.0

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

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