PREVIEW / etf_1hour / 2024-04-25

all etf 1-hour files

  file:    by_date/etf_1hour/2024/2024-04-25.parquet
  size:    529 KB
  rows:    19,593

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
2024-04-25 04:00:00	SPY	ETF	502.45	503.34	502.38	503.03	51430.0
2024-04-25 05:00:00	SPY	ETF	503.05	503.39	502.99	503.2	18710.0
2024-04-25 06:00:00	SPY	ETF	503.1	503.32	502.41	502.49	66295.0
2024-04-25 07:00:00	SPY	ETF	502.44	502.89	502.08	502.84	176073.0
2024-04-25 08:00:00	SPY	ETF	502.3808	503.3196	499.46	499.69	1394133.0
2024-04-25 09:00:00	SPY	ETF	499.72	499.93	497.865	498.2	8163863.0
2024-04-25 10:00:00	SPY	ETF	498.2	499.82	497.49	498.41	8499971.0
2024-04-25 11:00:00	SPY	ETF	498.4	500.4	498.36	500.25	5641744.0
2024-04-25 12:00:00	SPY	ETF	500.25	502.04	499.91	501.77	5024930.0
2024-04-25 13:00:00	SPY	ETF	501.77	503.82	500.97	503.49	5436285.0
2024-04-25 14:00:00	SPY	ETF	503.5	503.715	501.68	502.49	6164180.0
2024-04-25 15:00:00	SPY	ETF	502.5	504.27	502.44	503.44	9002345.0
2024-04-25 16:00:00	SPY	ETF	503.45	508.39	503.12	508.26	3988363.0
2024-04-25 17:00:00	SPY	ETF	508.3075	508.35	507.24	508.08	186866.0
2024-04-25 18:00:00	SPY	ETF	508.09	508.5	503.49	507.47	282901.0
2024-04-25 19:00:00	SPY	ETF	507.37	507.43	506.85	507.09	89186.0
2024-04-25 04:00:00	QQQ	ETF	421.63	423.0	421.63	422.7	131550.0
2024-04-25 05:00:00	QQQ	ETF	422.71	423.39	422.71	423.19	59295.0
2024-04-25 06:00:00	QQQ	ETF	423.16	423.24	422.2	422.45	82339.0
2024-04-25 07:00:00	QQQ	ETF	422.43	422.85	421.9	422.82	236889.0
2024-04-25 08:00:00	QQQ	ETF	422.24	426.829	419.62	419.9	1085935.0
2024-04-25 09:00:00	QQQ	ETF	419.92	420.17	418.14	419.33	7916189.0
2024-04-25 10:00:00	QQQ	ETF	419.36	421.53	418.68	419.25	7137723.0
2024-04-25 11:00:00	QQQ	ETF	419.26	420.88	419.19	420.74	4407701.0
2024-04-25 12:00:00	QQQ	ETF	420.69	423.01	420.34	422.7	4238763.0
2024-04-25 13:00:00	QQQ	ETF	422.68	424.75	421.9212	424.45	5115503.0
2024-04-25 14:00:00	QQQ	ETF	424.46	424.81	422.63	423.45	3523126.0
2024-04-25 15:00:00	QQQ	ETF	423.45	425.32	423.39	424.38	6632141.0
2024-04-25 16:00:00	QQQ	ETF	424.4	430.71	423.88	430.33	3357422.0
2024-04-25 17:00:00	QQQ	ETF	430.36	430.36	429.21	430.05	416294.0
2024-04-25 18:00:00	QQQ	ETF	430.1	430.51	429.0	429.51	499570.0
2024-04-25 19:00:00	QQQ	ETF	429.51	429.51	428.8	429.07	106797.0
2024-04-25 04:00:00	IWM	ETF	198.3	198.93	198.3	198.82	31032.0
2024-04-25 05:00:00	IWM	ETF	198.83	199.17	198.8	198.9	8396.0
2024-04-25 06:00:00	IWM	ETF	199.04	199.04	198.71	198.84	8562.0
2024-04-25 07:00:00	IWM	ETF	198.62	198.79	198.19	198.71	75054.0
2024-04-25 08:00:00	IWM	ETF	198.6879	199.37	195.18	195.63	851904.0
2024-04-25 09:00:00	IWM	ETF	195.61	195.8	193.88	194.285	4394935.0
2024-04-25 10:00:00	IWM	ETF	194.29	195.42	193.77	194.86	4364814.0
2024-04-25 11:00:00	IWM	ETF	194.85	195.39	194.65	195.34	2272232.0
2024-04-25 12:00:00	IWM	ETF	195.33	195.88	195.09	195.7101	2372713.0
2024-04-25 13:00:00	IWM	ETF	195.73	196.5	195.225	196.31	2881488.0
2024-04-25 14:00:00	IWM	ETF	196.31	196.39	195.6	196.09	2092630.0
2024-04-25 15:00:00	IWM	ETF	196.09	196.83	196.01	196.49	3417974.0
2024-04-25 16:00:00	IWM	ETF	196.48	196.53	195.7897	196.23	1844155.0
2024-04-25 17:00:00	IWM	ETF	196.24	196.65	196.15	196.48	128620.0
2024-04-25 18:00:00	IWM	ETF	196.4	196.48	195.8	196.17	64440.0
2024-04-25 19:00:00	IWM	ETF	196.14	196.14	195.83	195.92	35691.0
2024-04-25 04:00:00	DIA	ETF	383.69	383.69	383.69	383.69	100.0
2024-04-25 05:00:00	DIA	ETF	383.54	383.54	383.54	383.54	300.0

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

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