PREVIEW / etf_1hour / 2023-12-20

all etf 1-hour files

  file:    by_date/etf_1hour/2023/2023-12-20.parquet
  size:    541 KB
  rows:    20,124

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-20 04:00:00	SPY	ETF	474.89	474.89	474.0	474.19	14416.0
2023-12-20 05:00:00	SPY	ETF	474.17	474.31	474.0	474.05	9158.0
2023-12-20 06:00:00	SPY	ETF	474.03	474.19	473.84	473.96	18272.0
2023-12-20 07:00:00	SPY	ETF	474.01	474.14	473.74	473.84	62174.0
2023-12-20 08:00:00	SPY	ETF	473.83	475.2	473.78	473.99	108304.0
2023-12-20 09:00:00	SPY	ETF	474.01	474.66	473.65	474.6201	4545156.0
2023-12-20 10:00:00	SPY	ETF	474.62	475.59	474.56	475.3599	5388033.0
2023-12-20 11:00:00	SPY	ETF	475.345	475.46	475.03	475.1719	3736009.0
2023-12-20 12:00:00	SPY	ETF	475.17	475.895	475.091	475.795	3334938.0
2023-12-20 13:00:00	SPY	ETF	475.8	475.815	474.98	475.06	3994156.0
2023-12-20 14:00:00	SPY	ETF	475.06	475.1	470.28	470.495	12963972.0
2023-12-20 15:00:00	SPY	ETF	470.49	471.1701	467.82	467.97	33538231.0
2023-12-20 16:00:00	SPY	ETF	467.97	475.7201	467.36	468.3	6792683.0
2023-12-20 17:00:00	SPY	ETF	468.3	472.5085	468.09	468.21	2512719.0
2023-12-20 18:00:00	SPY	ETF	468.21	468.94	468.21	468.86	119915.0
2023-12-20 19:00:00	SPY	ETF	468.9	468.9	467.91	468.73	320172.0
2023-12-20 04:00:00	QQQ	ETF	408.8	408.8	407.87	408.16	40041.0
2023-12-20 05:00:00	QQQ	ETF	408.1	408.28	407.99	408.15	17794.0
2023-12-20 06:00:00	QQQ	ETF	408.1	408.25	407.86	408.12	21445.0
2023-12-20 07:00:00	QQQ	ETF	408.14	408.38	407.96	408.05	72222.0
2023-12-20 08:00:00	QQQ	ETF	408.88	409.77	407.8996	408.28	440523.0
2023-12-20 09:00:00	QQQ	ETF	408.28	409.28	407.97	409.1101	3092278.0
2023-12-20 10:00:00	QQQ	ETF	409.12	410.4699	408.98	409.95	4914360.0
2023-12-20 11:00:00	QQQ	ETF	409.94	410.03	409.3801	409.67	2720162.0
2023-12-20 12:00:00	QQQ	ETF	409.68	410.22	409.23	410.16	2252727.0
2023-12-20 13:00:00	QQQ	ETF	410.15	410.25	409.42	409.62	2378728.0
2023-12-20 14:00:00	QQQ	ETF	409.61	409.72	404.71	404.8704	8583490.0
2023-12-20 15:00:00	QQQ	ETF	404.875	405.54	402.9	402.97	16859099.0
2023-12-20 16:00:00	QQQ	ETF	402.97	404.1	402.88	403.7	1986254.0
2023-12-20 17:00:00	QQQ	ETF	403.71	404.0	403.52	403.5216	56584.0
2023-12-20 18:00:00	QQQ	ETF	403.61	404.1699	402.93	404.1699	163864.0
2023-12-20 19:00:00	QQQ	ETF	404.05	404.12	403.08	403.99	93006.0
2023-12-20 04:00:00	IWM	ETF	200.57	200.57	199.85	199.98	22370.0
2023-12-20 05:00:00	IWM	ETF	200.06	200.25	200.02	200.02	3795.0
2023-12-20 06:00:00	IWM	ETF	200.08	200.09	199.72	199.88	37191.0
2023-12-20 07:00:00	IWM	ETF	199.91	200.31	199.78	200.15	142070.0
2023-12-20 08:00:00	IWM	ETF	199.93	200.8	199.8799	200.08	97576.0
2023-12-20 09:00:00	IWM	ETF	200.07	200.37	198.98	199.76	5225046.0
2023-12-20 10:00:00	IWM	ETF	199.76	202.17	199.57	201.45	8019951.0
2023-12-20 11:00:00	IWM	ETF	201.45	201.77	201.21	201.38	3372007.0
2023-12-20 12:00:00	IWM	ETF	201.385	202.16	201.3221	201.94	3109455.0
2023-12-20 13:00:00	IWM	ETF	201.955	201.98	201.49	201.61	2789836.0
2023-12-20 14:00:00	IWM	ETF	201.61	201.66	197.99	198.57	7041101.0
2023-12-20 15:00:00	IWM	ETF	198.57	199.11	196.16	196.26	15718495.0
2023-12-20 16:00:00	IWM	ETF	196.28	196.98	196.09	196.98	1166840.0
2023-12-20 17:00:00	IWM	ETF	196.95	197.05	196.28	196.76	55336.0
2023-12-20 18:00:00	IWM	ETF	196.89	197.33	196.28	197.2705	189958.0
2023-12-20 19:00:00	IWM	ETF	197.28	197.3	197.05	197.13	42663.0
2023-12-20 04:00:00	DIA	ETF	375.44	375.44	375.13	375.35	9730.0
2023-12-20 05:00:00	DIA	ETF	375.36	375.4	375.16	375.16	1125.0

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

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