PREVIEW / etf_1hour / 2023-08-07

all etf 1-hour files

  file:    by_date/etf_1hour/2023/2023-08-07.parquet
  size:    478 KB
  rows:    17,290

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-08-07 04:00:00	SPY	ETF	448.94	449.08	447.76	448.14	57805.0
2023-08-07 05:00:00	SPY	ETF	448.14	448.45	447.91	448.4	12639.0
2023-08-07 06:00:00	SPY	ETF	448.38	448.38	447.47	447.78	43283.0
2023-08-07 07:00:00	SPY	ETF	447.82	448.06	447.72	447.88	125602.0
2023-08-07 08:00:00	SPY	ETF	447.94	448.76	447.44	448.72	424246.0
2023-08-07 09:00:00	SPY	ETF	448.69	449.65	448.2601	448.49	6535217.0
2023-08-07 10:00:00	SPY	ETF	448.49	449.9	447.99	449.07	8763990.0
2023-08-07 11:00:00	SPY	ETF	449.09	449.63	448.25	449.52	5374870.0
2023-08-07 12:00:00	SPY	ETF	449.52	449.815	448.95	449.66	3342737.0
2023-08-07 13:00:00	SPY	ETF	449.66	450.22	449.48	450.21	3568249.0
2023-08-07 14:00:00	SPY	ETF	450.22	450.5	449.475	450.09	3937987.0
2023-08-07 15:00:00	SPY	ETF	450.1	450.865	449.62	450.7	9959914.0
2023-08-07 16:00:00	SPY	ETF	450.7	451.06	450.57	450.91	3527839.0
2023-08-07 17:00:00	SPY	ETF	450.91	451.05	450.85	451.0	75096.0
2023-08-07 18:00:00	SPY	ETF	450.93	450.97	450.65	450.73	73533.0
2023-08-07 19:00:00	SPY	ETF	450.76	450.79	450.66	450.75	20201.0
2023-08-07 04:00:00	QQQ	ETF	374.61	374.65	373.29	373.65	91528.0
2023-08-07 05:00:00	QQQ	ETF	373.67	374.12	373.5	374.0	28649.0
2023-08-07 06:00:00	QQQ	ETF	373.8	373.99	373.0	373.53	149138.0
2023-08-07 07:00:00	QQQ	ETF	373.46	373.63	373.3	373.53	137438.0
2023-08-07 08:00:00	QQQ	ETF	373.44	374.66	372.94	374.08	312533.0
2023-08-07 09:00:00	QQQ	ETF	374.06	374.85	372.45	372.78	5022146.0
2023-08-07 10:00:00	QQQ	ETF	372.72	374.14	372.05	372.94	4616872.0
2023-08-07 11:00:00	QQQ	ETF	372.945	373.52	371.51	373.44	4614190.0
2023-08-07 12:00:00	QQQ	ETF	373.46	373.77	372.8801	373.661	2445007.0
2023-08-07 13:00:00	QQQ	ETF	373.67	374.23	373.325	374.19	2209405.0
2023-08-07 14:00:00	QQQ	ETF	374.2	374.55	373.605	374.26	2368670.0
2023-08-07 15:00:00	QQQ	ETF	374.29	375.29	373.95	375.2	4245195.0
2023-08-07 16:00:00	QQQ	ETF	375.2	375.37	375.0417	375.27	761295.0
2023-08-07 17:00:00	QQQ	ETF	375.26	375.39	375.26	375.33	42201.0
2023-08-07 18:00:00	QQQ	ETF	375.4	375.41	375.05	375.15	58234.0
2023-08-07 19:00:00	QQQ	ETF	375.17	375.24	375.08	375.21	47009.0
2023-08-07 04:00:00	IWM	ETF	195.23	195.31	194.56	194.81	9884.0
2023-08-07 05:00:00	IWM	ETF	194.7	194.89	194.62	194.85	6718.0
2023-08-07 06:00:00	IWM	ETF	194.78	194.88	194.33	194.44	14559.0
2023-08-07 07:00:00	IWM	ETF	194.54	194.7	194.52	194.64	14933.0
2023-08-07 08:00:00	IWM	ETF	194.63	195.1796	194.36	194.98	75345.0
2023-08-07 09:00:00	IWM	ETF	194.96	195.06	193.0	193.19	3227583.0
2023-08-07 10:00:00	IWM	ETF	193.18	194.28	192.68	194.07	3184017.0
2023-08-07 11:00:00	IWM	ETF	194.06	194.2	193.56	194.09	1653391.0
2023-08-07 12:00:00	IWM	ETF	194.09	194.32	193.76	194.16	1078818.0
2023-08-07 13:00:00	IWM	ETF	194.15	194.39	194.065	194.3121	1216161.0
2023-08-07 14:00:00	IWM	ETF	194.3	194.375	193.95	194.085	1250146.0
2023-08-07 15:00:00	IWM	ETF	194.085	194.485	193.97	194.34	3262447.0
2023-08-07 16:00:00	IWM	ETF	194.35	194.54	194.27	194.4	490202.0
2023-08-07 17:00:00	IWM	ETF	194.4	194.52	194.38	194.4	7957.0
2023-08-07 18:00:00	IWM	ETF	194.45	194.46	194.24	194.24	21128.0
2023-08-07 19:00:00	IWM	ETF	194.24	194.32	194.22	194.27	10201.0
2023-08-07 04:00:00	DIA	ETF	351.89	352.08	351.28	351.28	4037.0
2023-08-07 05:00:00	DIA	ETF	351.41	351.41	351.41	351.41	100.0

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

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