PREVIEW / etf_1hour / 2023-11-27

all etf 1-hour files

  file:    by_date/etf_1hour/2023/2023-11-27.parquet
  size:    497 KB
  rows:    18,331

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-11-27 04:00:00	SPY	ETF	454.62	454.71	454.0	454.0	16618.0
2023-11-27 05:00:00	SPY	ETF	454.07	454.96	454.07	454.96	15845.0
2023-11-27 06:00:00	SPY	ETF	454.91	455.0	454.61	454.61	8668.0
2023-11-27 07:00:00	SPY	ETF	454.67	454.93	454.56	454.62	35837.0
2023-11-27 08:00:00	SPY	ETF	454.6817	455.3	453.77	454.6	248380.0
2023-11-27 09:00:00	SPY	ETF	454.71	455.245	454.0799	454.5169	4417000.0
2023-11-27 10:00:00	SPY	ETF	454.52	455.21	454.25	454.79	5939752.0
2023-11-27 11:00:00	SPY	ETF	454.8	455.39	454.2309	455.0388	4290288.0
2023-11-27 12:00:00	SPY	ETF	455.04	455.25	454.79	455.17	3244748.0
2023-11-27 13:00:00	SPY	ETF	455.18	455.4901	454.955	455.135	3403859.0
2023-11-27 14:00:00	SPY	ETF	455.14	455.29	454.11	454.655	4176131.0
2023-11-27 15:00:00	SPY	ETF	454.65	455.31	454.37	454.5	9638915.0
2023-11-27 16:00:00	SPY	ETF	454.49	454.67	454.3	454.66	1759745.0
2023-11-27 17:00:00	SPY	ETF	454.65	454.74	454.63	454.67	32844.0
2023-11-27 18:00:00	SPY	ETF	454.69	454.88	454.67	454.85	38919.0
2023-11-27 19:00:00	SPY	ETF	454.85	454.85	454.5	454.6999	41432.0
2023-11-27 04:00:00	QQQ	ETF	388.02	388.98	388.02	388.38	30894.0
2023-11-27 05:00:00	QQQ	ETF	388.44	389.26	388.44	389.23	34288.0
2023-11-27 06:00:00	QQQ	ETF	389.23	389.25	388.96	389.04	29291.0
2023-11-27 07:00:00	QQQ	ETF	389.04	389.42	388.989	389.1	36552.0
2023-11-27 08:00:00	QQQ	ETF	387.25	389.802	387.25	389.0	187812.0
2023-11-27 09:00:00	QQQ	ETF	389.07	389.912	388.28	389.21	4192917.0
2023-11-27 10:00:00	QQQ	ETF	389.22	390.245	388.98	389.995	4896687.0
2023-11-27 11:00:00	QQQ	ETF	390.0	390.575	389.16	390.32	3135351.0
2023-11-27 12:00:00	QQQ	ETF	390.34	390.82	390.1603	390.745	2558058.0
2023-11-27 13:00:00	QQQ	ETF	390.745	391.1499	390.08	390.27	2832537.0
2023-11-27 14:00:00	QQQ	ETF	390.3	390.3999	388.94	389.61	2977097.0
2023-11-27 15:00:00	QQQ	ETF	389.6	390.14	388.97	389.14	6496161.0
2023-11-27 16:00:00	QQQ	ETF	389.14	390.3171	389.05	389.1	719467.0
2023-11-27 17:00:00	QQQ	ETF	389.1	389.229	389.07	389.18	39410.0
2023-11-27 18:00:00	QQQ	ETF	389.15	389.25	389.07	389.2	24744.0
2023-11-27 19:00:00	QQQ	ETF	389.19	389.19	388.67	389.0804	50643.0
2023-11-27 04:00:00	IWM	ETF	178.56	178.58	178.22	178.22	13586.0
2023-11-27 05:00:00	IWM	ETF	178.21	178.73	178.21	178.7	12183.0
2023-11-27 06:00:00	IWM	ETF	178.74	178.75	178.46	178.57	14392.0
2023-11-27 07:00:00	IWM	ETF	178.6	178.78	178.54	178.68	33616.0
2023-11-27 08:00:00	IWM	ETF	178.67	179.33	178.26	178.64	73591.0
2023-11-27 09:00:00	IWM	ETF	178.62	178.72	177.23	178.02	3905744.0
2023-11-27 10:00:00	IWM	ETF	178.02	178.815	177.9	178.65	2971731.0
2023-11-27 11:00:00	IWM	ETF	178.64	178.81	178.31	178.55	2175071.0
2023-11-27 12:00:00	IWM	ETF	178.54	178.8	178.38	178.64	1537770.0
2023-11-27 13:00:00	IWM	ETF	178.64	178.98	178.53	178.675	1518829.0
2023-11-27 14:00:00	IWM	ETF	178.68	178.995	178.64	178.89	1921186.0
2023-11-27 15:00:00	IWM	ETF	178.88	179.11	178.65	178.74	3910920.0
2023-11-27 16:00:00	IWM	ETF	178.73	178.82	178.66	178.82	430894.0
2023-11-27 17:00:00	IWM	ETF	178.85	178.88	178.78	178.83	9083.0
2023-11-27 18:00:00	IWM	ETF	178.86	178.95	178.79	178.92	12434.0
2023-11-27 19:00:00	IWM	ETF	178.92	178.95	178.81	178.85	15989.0
2023-11-27 04:00:00	DIA	ETF	353.46	353.46	353.09	353.1	2720.0
2023-11-27 07:00:00	DIA	ETF	353.48	353.48	353.46	353.48	400.0

> showing 50 of 18,331 rows — these rows as CSV

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