PREVIEW / etf_1hour / 2023-12-18

all etf 1-hour files

  file:    by_date/etf_1hour/2023/2023-12-18.parquet
  size:    541 KB
  rows:    19,774

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-12-18 04:00:00	SPY	ETF	470.61	470.76	470.33	470.63	26541.0
2023-12-18 05:00:00	SPY	ETF	470.61	470.88	470.46	470.52	9140.0
2023-12-18 06:00:00	SPY	ETF	470.47	470.74	470.12	470.24	17414.0
2023-12-18 07:00:00	SPY	ETF	470.24	470.75	470.24	470.75	80580.0
2023-12-18 08:00:00	SPY	ETF	470.2697	471.15	470.01	471.01	278392.0
2023-12-18 09:00:00	SPY	ETF	471.0	471.43	470.64	471.37	4994336.0
2023-12-18 10:00:00	SPY	ETF	471.375	471.88	471.08	471.27	7076313.0
2023-12-18 11:00:00	SPY	ETF	471.27	472.17	471.105	471.99	5574571.0
2023-12-18 12:00:00	SPY	ETF	472.0	472.65	472.0	472.425	4295906.0
2023-12-18 13:00:00	SPY	ETF	472.425	472.62	472.11	472.49	3440640.0
2023-12-18 14:00:00	SPY	ETF	472.49	472.98	472.205	472.54	6130414.0
2023-12-18 15:00:00	SPY	ETF	472.555	472.81	471.95	472.02	10972242.0
2023-12-18 16:00:00	SPY	ETF	472.02	472.3809	471.58	471.97	11239045.0
2023-12-18 17:00:00	SPY	ETF	471.97	472.02	471.65	471.67	854639.0
2023-12-18 18:00:00	SPY	ETF	471.73	472.02	471.65	471.79	97890.0
2023-12-18 19:00:00	SPY	ETF	471.79	471.8404	471.7	471.79	28898.0
2023-12-18 04:00:00	QQQ	ETF	404.76	405.08	404.7	404.82	23069.0
2023-12-18 05:00:00	QQQ	ETF	404.77	405.01	404.64	404.67	29662.0
2023-12-18 06:00:00	QQQ	ETF	404.56	404.69	404.14	404.27	35673.0
2023-12-18 07:00:00	QQQ	ETF	404.29	404.77	404.21	404.75	47963.0
2023-12-18 08:00:00	QQQ	ETF	404.71	405.15	404.03	405.08	228458.0
2023-12-18 09:00:00	QQQ	ETF	405.1	405.81	404.6	405.71	3752333.0
2023-12-18 10:00:00	QQQ	ETF	405.71	406.34	405.39	405.465	4312673.0
2023-12-18 11:00:00	QQQ	ETF	405.46	406.55	405.145	406.32	3320243.0
2023-12-18 12:00:00	QQQ	ETF	406.33	407.1	406.325	406.97	2280667.0
2023-12-18 13:00:00	QQQ	ETF	406.98	407.585	406.72	407.52	2364525.0
2023-12-18 14:00:00	QQQ	ETF	407.53	407.99	407.36	407.67	3590790.0
2023-12-18 15:00:00	QQQ	ETF	407.68	407.95	407.1	407.11	5754498.0
2023-12-18 16:00:00	QQQ	ETF	407.105	407.105	406.52	406.74	1903960.0
2023-12-18 17:00:00	QQQ	ETF	406.71	407.08	406.55	406.65	33738.0
2023-12-18 18:00:00	QQQ	ETF	406.66	406.87	406.65	406.75	27747.0
2023-12-18 19:00:00	QQQ	ETF	406.7804	406.79	406.64	406.73	15795.0
2023-12-18 04:00:00	IWM	ETF	197.72	197.89	197.67	197.76	18746.0
2023-12-18 05:00:00	IWM	ETF	197.71	197.94	197.65	197.77	11699.0
2023-12-18 06:00:00	IWM	ETF	197.76	197.82	197.21	197.38	132491.0
2023-12-18 07:00:00	IWM	ETF	197.4	197.9	197.4	197.86	54674.0
2023-12-18 08:00:00	IWM	ETF	197.3695	198.28	197.2796	197.97	209745.0
2023-12-18 09:00:00	IWM	ETF	197.97	198.7	196.84	198.37	7153391.0
2023-12-18 10:00:00	IWM	ETF	198.39	198.77	196.68	197.18	5956702.0
2023-12-18 11:00:00	IWM	ETF	197.17	197.48	196.83	197.15	3464060.0
2023-12-18 12:00:00	IWM	ETF	197.15	197.77	197.05	197.37	3470327.0
2023-12-18 13:00:00	IWM	ETF	197.37	197.4	196.93	197.105	2223290.0
2023-12-18 14:00:00	IWM	ETF	197.1	197.445	196.7524	197.25	2892948.0
2023-12-18 15:00:00	IWM	ETF	197.25	197.68	197.02	197.08	7122145.0
2023-12-18 16:00:00	IWM	ETF	197.11	197.3862	196.8	197.01	3299762.0
2023-12-18 17:00:00	IWM	ETF	197.0	197.11	196.79	196.86	901047.0
2023-12-18 18:00:00	IWM	ETF	196.95	196.96	196.65	196.68	109326.0
2023-12-18 19:00:00	IWM	ETF	196.72	196.84	196.69	196.79	46049.0
2023-12-18 04:00:00	DIA	ETF	373.18	373.18	373.11	373.11	325.0
2023-12-18 05:00:00	DIA	ETF	373.48	373.52	373.43	373.43	431.0

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

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