PREVIEW / etf_1hour / 2023-04-24

all etf 1-hour files

  file:    by_date/etf_1hour/2023/2023-04-24.parquet
  size:    463 KB
  rows:    16,655

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-24 04:00:00	SPY	ETF	410.5	411.02	410.5	410.75	60031.0
2023-04-24 05:00:00	SPY	ETF	410.79	411.57	410.79	411.42	35299.0
2023-04-24 06:00:00	SPY	ETF	411.44	411.74	411.34	411.72	16353.0
2023-04-24 07:00:00	SPY	ETF	411.77	412.26	411.68	411.96	96097.0
2023-04-24 08:00:00	SPY	ETF	411.78	412.35	410.25	412.21	324144.0
2023-04-24 09:00:00	SPY	ETF	412.22	412.95	411.92	412.69	4796808.0
2023-04-24 10:00:00	SPY	ETF	412.7	413.07	411.38	411.62	7688285.0
2023-04-24 11:00:00	SPY	ETF	411.6	411.72	410.79	410.91	6270251.0
2023-04-24 12:00:00	SPY	ETF	410.92	411.75	410.6	411.6899	4367706.0
2023-04-24 13:00:00	SPY	ETF	411.69	412.3	411.38	412.17	4477173.0
2023-04-24 14:00:00	SPY	ETF	412.18	412.4	411.7	412.09	4937251.0
2023-04-24 15:00:00	SPY	ETF	412.1	412.64	411.9	412.63	12059182.0
2023-04-24 16:00:00	SPY	ETF	412.62	412.8	412.31	412.35	2840285.0
2023-04-24 17:00:00	SPY	ETF	412.41	412.53	412.15	412.2	84828.0
2023-04-24 18:00:00	SPY	ETF	412.27	412.43	412.2	412.21	100467.0
2023-04-24 19:00:00	SPY	ETF	412.24	412.39	412.2	412.25	40299.0
2023-04-24 04:00:00	QQQ	ETF	315.5	315.62	315.14	315.3	42720.0
2023-04-24 05:00:00	QQQ	ETF	315.45	316.49	315.41	316.3	42556.0
2023-04-24 06:00:00	QQQ	ETF	316.22	316.44	315.91	316.4	80474.0
2023-04-24 07:00:00	QQQ	ETF	316.41	316.85	316.34	316.46	147842.0
2023-04-24 08:00:00	QQQ	ETF	316.41	316.91	315.05	316.75	278480.0
2023-04-24 09:00:00	QQQ	ETF	316.82	317.7391	315.81	316.92	3890618.0
2023-04-24 10:00:00	QQQ	ETF	316.92	317.0	314.71	315.09	6465514.0
2023-04-24 11:00:00	QQQ	ETF	315.1	315.28	313.74	314.01	4963584.0
2023-04-24 12:00:00	QQQ	ETF	314.02	314.9	313.82	314.84	3298649.0
2023-04-24 13:00:00	QQQ	ETF	314.84	315.75	314.582	315.62	2688949.0
2023-04-24 14:00:00	QQQ	ETF	315.6199	316.16	315.23	315.78	3432959.0
2023-04-24 15:00:00	QQQ	ETF	315.79	316.0797	315.46	315.94	5884609.0
2023-04-24 16:00:00	QQQ	ETF	315.94	316.14	315.65	315.73	1288805.0
2023-04-24 17:00:00	QQQ	ETF	315.74	315.8	315.55	315.62	40596.0
2023-04-24 18:00:00	QQQ	ETF	315.67	315.889	315.57	315.65	57454.0
2023-04-24 19:00:00	QQQ	ETF	315.66	315.89	315.62	315.74	24331.0
2023-04-24 04:00:00	IWM	ETF	176.88	177.11	176.83	176.93	28385.0
2023-04-24 05:00:00	IWM	ETF	176.95	177.31	176.92	177.24	27235.0
2023-04-24 06:00:00	IWM	ETF	177.16	177.41	177.15	177.41	21684.0
2023-04-24 07:00:00	IWM	ETF	177.46	177.62	177.35	177.43	58236.0
2023-04-24 08:00:00	IWM	ETF	177.38	177.55	176.8896	177.48	33543.0
2023-04-24 09:00:00	IWM	ETF	177.46	178.26	177.2301	178.06	1958584.0
2023-04-24 10:00:00	IWM	ETF	178.03	178.45	177.0	177.02	2818982.0
2023-04-24 11:00:00	IWM	ETF	177.01	177.09	176.565	176.65	1417078.0
2023-04-24 12:00:00	IWM	ETF	176.65	177.15	176.495	177.07	1348179.0
2023-04-24 13:00:00	IWM	ETF	177.09	177.59	176.9	177.55	738037.0
2023-04-24 14:00:00	IWM	ETF	177.55	177.6	177.04	177.2	825589.0
2023-04-24 15:00:00	IWM	ETF	177.21	177.48	177.18	177.43	2982156.0
2023-04-24 16:00:00	IWM	ETF	177.44	177.6251	177.01	177.11	704160.0
2023-04-24 17:00:00	IWM	ETF	177.1	177.15	176.95	177.1	7163.0
2023-04-24 18:00:00	IWM	ETF	177.1	177.16	176.96	177.01	86181.0
2023-04-24 19:00:00	IWM	ETF	177.01	177.13	176.97	177.03	12945.0
2023-04-24 04:00:00	DIA	ETF	337.17	337.17	337.09	337.09	1600.0
2023-04-24 05:00:00	DIA	ETF	337.39	337.66	337.38	337.57	2475.0

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

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