PREVIEW / etf_1hour / 2023-12-14

all etf 1-hour files

  file:    by_date/etf_1hour/2023/2023-12-14.parquet
  size:    550 KB
  rows:    20,297

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-14 04:00:00	SPY	ETF	472.05	472.06	471.3	471.52	116626.0
2023-12-14 05:00:00	SPY	ETF	471.59	472.25	471.41	471.9	43375.0
2023-12-14 06:00:00	SPY	ETF	472.03	472.24	471.63	471.92	48546.0
2023-12-14 07:00:00	SPY	ETF	471.8	472.4	471.8	472.17	136339.0
2023-12-14 08:00:00	SPY	ETF	471.7995	473.31	471.3796	473.31	649803.0
2023-12-14 09:00:00	SPY	ETF	473.33	473.73	472.255	473.14	9372855.0
2023-12-14 10:00:00	SPY	ETF	473.14	473.18	471.67	472.5899	11307121.0
2023-12-14 11:00:00	SPY	ETF	472.585	472.68	471.46	472.54	7209065.0
2023-12-14 12:00:00	SPY	ETF	472.54	473.365	471.9513	471.9901	7271803.0
2023-12-14 13:00:00	SPY	ETF	472.0	472.01	469.25	470.18	11256715.0
2023-12-14 14:00:00	SPY	ETF	470.18	471.57	470.15	471.52	7116342.0
2023-12-14 15:00:00	SPY	ETF	471.52	472.06	471.09	472.0	16224264.0
2023-12-14 16:00:00	SPY	ETF	472.01	472.11	470.28	471.37	8572174.0
2023-12-14 17:00:00	SPY	ETF	471.4	472.01	471.24	471.3	1081921.0
2023-12-14 18:00:00	SPY	ETF	471.25	472.01	471.04	471.68	1047427.0
2023-12-14 19:00:00	SPY	ETF	471.69	471.93	471.64	471.67	130100.0
2023-12-14 04:00:00	QQQ	ETF	405.65	406.12	405.0	405.06	84001.0
2023-12-14 05:00:00	QQQ	ETF	405.2	405.79	405.05	405.62	44736.0
2023-12-14 06:00:00	QQQ	ETF	405.57	405.73	405.17	405.28	41172.0
2023-12-14 07:00:00	QQQ	ETF	405.26	405.8	405.26	405.47	109642.0
2023-12-14 08:00:00	QQQ	ETF	405.65	406.42	404.042	405.75	408694.0
2023-12-14 09:00:00	QQQ	ETF	405.75	406.3	404.76	405.6399	5503547.0
2023-12-14 10:00:00	QQQ	ETF	405.63	405.66	403.65	404.76	7759578.0
2023-12-14 11:00:00	QQQ	ETF	404.77	404.8651	403.12	404.01	5222241.0
2023-12-14 12:00:00	QQQ	ETF	404.01	404.9479	402.93	402.95	3847911.0
2023-12-14 13:00:00	QQQ	ETF	402.96	402.96	400.34	401.31	7018615.0
2023-12-14 14:00:00	QQQ	ETF	401.29	403.05	401.28	402.94	4029870.0
2023-12-14 15:00:00	QQQ	ETF	402.95	403.42	402.72	403.37	6531951.0
2023-12-14 16:00:00	QQQ	ETF	403.37	403.6	401.56	403.11	1080168.0
2023-12-14 17:00:00	QQQ	ETF	403.09	403.16	402.8	402.92	49636.0
2023-12-14 18:00:00	QQQ	ETF	402.94	403.53	402.82	403.47	91050.0
2023-12-14 19:00:00	QQQ	ETF	403.47	403.77	403.37	403.45	47491.0
2023-12-14 04:00:00	IWM	ETF	194.86	194.95	194.2	194.87	53411.0
2023-12-14 05:00:00	IWM	ETF	194.89	195.67	194.75	195.48	40234.0
2023-12-14 06:00:00	IWM	ETF	195.55	195.86	195.27	195.73	119918.0
2023-12-14 07:00:00	IWM	ETF	195.69	196.63	195.64	196.51	311491.0
2023-12-14 08:00:00	IWM	ETF	196.4	197.7	194.35	197.7	839795.0
2023-12-14 09:00:00	IWM	ETF	197.73	200.035	196.62	199.04	14454115.0
2023-12-14 10:00:00	IWM	ETF	199.04	199.29	196.86	197.99	13398126.0
2023-12-14 11:00:00	IWM	ETF	197.99	199.125	197.72	198.91	6965259.0
2023-12-14 12:00:00	IWM	ETF	198.91	199.39	198.24	198.26	5663234.0
2023-12-14 13:00:00	IWM	ETF	198.26	198.475	196.48	197.15	7581453.0
2023-12-14 14:00:00	IWM	ETF	197.16	198.31	197.14	198.2907	4453918.0
2023-12-14 15:00:00	IWM	ETF	198.295	199.32	198.13	198.73	9648474.0
2023-12-14 16:00:00	IWM	ETF	198.72	198.83	198.25	198.31	1321346.0
2023-12-14 17:00:00	IWM	ETF	198.26	198.31	198.08	198.15	43439.0
2023-12-14 18:00:00	IWM	ETF	198.2	198.29	197.95	198.25	33394.0
2023-12-14 19:00:00	IWM	ETF	198.29	198.44	198.08	198.08	120921.0
2023-12-14 04:00:00	DIA	ETF	372.7	372.75	372.23	372.26	6789.0
2023-12-14 05:00:00	DIA	ETF	372.14	372.66	372.14	372.66	7500.0

> showing 50 of 20,297 rows — these rows as CSV

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