PREVIEW / etf_1hour / 2023-04-21

all etf 1-hour files

  file:    by_date/etf_1hour/2023/2023-04-21.parquet
  size:    455 KB
  rows:    16,603

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-21 04:00:00	SPY	ETF	411.48	412.02	411.31	412.0	34540.0
2023-04-21 05:00:00	SPY	ETF	412.1	412.18	411.81	412.0	10711.0
2023-04-21 06:00:00	SPY	ETF	411.6	411.71	410.8	410.88	54051.0
2023-04-21 07:00:00	SPY	ETF	410.89	411.27	410.66	411.14	116905.0
2023-04-21 08:00:00	SPY	ETF	410.7	412.1796	410.7	412.0	331145.0
2023-04-21 09:00:00	SPY	ETF	412.01	412.49	410.914	410.95	6194155.0
2023-04-21 10:00:00	SPY	ETF	410.945	412.44	410.17	410.8163	10677604.0
2023-04-21 11:00:00	SPY	ETF	410.84	411.95	410.7401	411.745	6166028.0
2023-04-21 12:00:00	SPY	ETF	411.755	412.02	411.25	411.61	4039707.0
2023-04-21 13:00:00	SPY	ETF	411.61	412.385	411.34	412.22	4770492.0
2023-04-21 14:00:00	SPY	ETF	412.225	412.68	411.72	412.02	5666490.0
2023-04-21 15:00:00	SPY	ETF	412.02	412.38	411.36	412.18	12169601.0
2023-04-21 16:00:00	SPY	ETF	412.17	412.35	411.9	411.97	2470686.0
2023-04-21 17:00:00	SPY	ETF	412.0	412.2	411.94	412.01	486003.0
2023-04-21 18:00:00	SPY	ETF	412.07	412.07	412.03	412.05	4776.0
2023-04-21 19:00:00	SPY	ETF	412.04	412.07	412.03	412.07	11979.0
2023-04-21 04:00:00	QQQ	ETF	315.96	316.55	315.77	316.55	49569.0
2023-04-21 05:00:00	QQQ	ETF	316.55	316.56	316.15	316.15	10700.0
2023-04-21 06:00:00	QQQ	ETF	316.14	316.15	314.75	314.82	163003.0
2023-04-21 07:00:00	QQQ	ETF	314.83	315.27	314.65	315.08	267403.0
2023-04-21 08:00:00	QQQ	ETF	315.1616	316.68	314.7	315.82	448498.0
2023-04-21 09:00:00	QQQ	ETF	315.85	316.34	314.39	314.41	5693309.0
2023-04-21 10:00:00	QQQ	ETF	314.41	316.47	314.1	315.52	8278538.0
2023-04-21 11:00:00	QQQ	ETF	315.53	316.81	315.48	316.5	4807467.0
2023-04-21 12:00:00	QQQ	ETF	316.52	316.69	315.91	316.235	3011227.0
2023-04-21 13:00:00	QQQ	ETF	316.25	317.0483	316.01	316.88	3713756.0
2023-04-21 14:00:00	QQQ	ETF	316.9	317.4	316.36	316.565	3540926.0
2023-04-21 15:00:00	QQQ	ETF	316.56	316.73	315.84	316.6	6037562.0
2023-04-21 16:00:00	QQQ	ETF	316.605	316.75	316.25	316.35	1042583.0
2023-04-21 17:00:00	QQQ	ETF	316.36	316.5	316.26	316.5	30137.0
2023-04-21 18:00:00	QQQ	ETF	316.5	316.57	316.46	316.49	6875.0
2023-04-21 19:00:00	QQQ	ETF	316.5	316.5	316.45	316.48	6491.0
2023-04-21 04:00:00	IWM	ETF	177.12	177.26	177.01	177.26	2574.0
2023-04-21 05:00:00	IWM	ETF	177.27	177.56	177.27	177.3	3276.0
2023-04-21 06:00:00	IWM	ETF	177.13	177.23	177.05	177.05	2952.0
2023-04-21 07:00:00	IWM	ETF	177.07	177.2	176.93	177.15	29539.0
2023-04-21 08:00:00	IWM	ETF	176.89	177.73	176.89	177.73	72565.0
2023-04-21 09:00:00	IWM	ETF	177.78	178.37	176.795	176.945	2181491.0
2023-04-21 10:00:00	IWM	ETF	176.94	177.35	175.86	176.18	3217155.0
2023-04-21 11:00:00	IWM	ETF	176.19	177.26	176.09	177.15	2014841.0
2023-04-21 12:00:00	IWM	ETF	177.16	177.49	176.85	177.1	1108951.0
2023-04-21 13:00:00	IWM	ETF	177.11	177.56	176.72	177.525	1102788.0
2023-04-21 14:00:00	IWM	ETF	177.53	177.958	177.47	177.67	1789647.0
2023-04-21 15:00:00	IWM	ETF	177.67	177.76	177.24	177.62	3026634.0
2023-04-21 16:00:00	IWM	ETF	177.56	177.69	177.43	177.43	1111170.0
2023-04-21 17:00:00	IWM	ETF	177.27	177.56	177.27	177.5	175818.0
2023-04-21 18:00:00	IWM	ETF	177.34	177.46	177.34	177.46	900.0
2023-04-21 19:00:00	IWM	ETF	177.44	177.44	177.26	177.26	795.0
2023-04-21 04:00:00	DIA	ETF	337.45	337.45	337.45	337.45	200.0
2023-04-21 05:00:00	DIA	ETF	337.87	337.96	337.87	337.96	1148.0

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

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