PREVIEW / etf_1hour / 2023-11-29

all etf 1-hour files

  file:    by_date/etf_1hour/2023/2023-11-29.parquet
  size:    511 KB
  rows:    18,871

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-29 04:00:00	SPY	ETF	455.89	456.59	455.89	456.5	37620.0
2023-11-29 05:00:00	SPY	ETF	456.43	456.51	456.31	456.4	12923.0
2023-11-29 06:00:00	SPY	ETF	456.47	456.85	456.34	456.77	38786.0
2023-11-29 07:00:00	SPY	ETF	456.79	457.1	456.54	457.1	185541.0
2023-11-29 08:00:00	SPY	ETF	456.7897	457.63	455.4	457.09	723932.0
2023-11-29 09:00:00	SPY	ETF	457.15	458.32	456.92	458.11	6048547.0
2023-11-29 10:00:00	SPY	ETF	458.12	458.2513	456.1	456.61	9713773.0
2023-11-29 11:00:00	SPY	ETF	456.6	456.744	454.945	455.765	5771412.0
2023-11-29 12:00:00	SPY	ETF	455.765	456.38	455.55	456.29	3545433.0
2023-11-29 13:00:00	SPY	ETF	456.3	456.45	455.695	456.1011	3382758.0
2023-11-29 14:00:00	SPY	ETF	456.1	456.3399	455.09	455.525	4228514.0
2023-11-29 15:00:00	SPY	ETF	455.53	455.59	454.2	454.62	12386464.0
2023-11-29 16:00:00	SPY	ETF	454.62	456.3079	454.5632	454.89	2516803.0
2023-11-29 17:00:00	SPY	ETF	454.88	454.98	454.82	454.92	34197.0
2023-11-29 18:00:00	SPY	ETF	454.95	455.0	454.79	454.86	17543.0
2023-11-29 19:00:00	SPY	ETF	454.95	455.07	454.79	454.93	23874.0
2023-11-29 04:00:00	QQQ	ETF	390.79	392.08	390.79	391.9	64500.0
2023-11-29 05:00:00	QQQ	ETF	391.92	392.11	391.85	391.98	17140.0
2023-11-29 06:00:00	QQQ	ETF	391.99	392.42	391.83	392.34	24275.0
2023-11-29 07:00:00	QQQ	ETF	392.26	392.6	392.14	392.6	84166.0
2023-11-29 08:00:00	QQQ	ETF	392.2603	393.305	390.482	392.6399	424920.0
2023-11-29 09:00:00	QQQ	ETF	392.68	394.14	392.48	393.82	4180492.0
2023-11-29 10:00:00	QQQ	ETF	393.83	394.04	391.18	392.03	6424511.0
2023-11-29 11:00:00	QQQ	ETF	392.02	392.08	389.91	390.76	4384552.0
2023-11-29 12:00:00	QQQ	ETF	390.76	391.47	390.4301	391.345	2251204.0
2023-11-29 13:00:00	QQQ	ETF	391.35	391.54	390.535	390.98	2714626.0
2023-11-29 14:00:00	QQQ	ETF	390.97	391.18	390.0	390.69	2712480.0
2023-11-29 15:00:00	QQQ	ETF	390.7	390.72	389.46	389.75	4577833.0
2023-11-29 16:00:00	QQQ	ETF	389.75	390.44	389.74	390.11	1287719.0
2023-11-29 17:00:00	QQQ	ETF	390.13	390.13	389.91	390.1	153316.0
2023-11-29 18:00:00	QQQ	ETF	390.14	390.3	390.04	390.24	39506.0
2023-11-29 19:00:00	QQQ	ETF	390.22	390.5	390.12	390.35	27391.0
2023-11-29 04:00:00	IWM	ETF	178.88	179.52	178.4	179.43	9031.0
2023-11-29 05:00:00	IWM	ETF	179.39	179.5	179.16	179.16	6990.0
2023-11-29 06:00:00	IWM	ETF	179.21	179.48	179.09	179.46	47812.0
2023-11-29 07:00:00	IWM	ETF	179.41	179.82	179.34	179.82	148816.0
2023-11-29 08:00:00	IWM	ETF	179.4105	180.41	178.69	179.5604	305099.0
2023-11-29 09:00:00	IWM	ETF	179.57	181.69	179.46	181.58	5951245.0
2023-11-29 10:00:00	IWM	ETF	181.58	181.75	179.97	180.28	4747507.0
2023-11-29 11:00:00	IWM	ETF	180.26	180.45	179.23	179.905	2692483.0
2023-11-29 12:00:00	IWM	ETF	179.91	180.19	179.77	180.06	1730723.0
2023-11-29 13:00:00	IWM	ETF	180.06	180.105	179.71	179.95	1345586.0
2023-11-29 14:00:00	IWM	ETF	179.95	180.17	179.42	179.615	1927280.0
2023-11-29 15:00:00	IWM	ETF	179.61	179.645	178.7	178.95	5979291.0
2023-11-29 16:00:00	IWM	ETF	178.98	179.7806	178.9	178.91	1255743.0
2023-11-29 17:00:00	IWM	ETF	178.94	179.03	178.92	179.02	13465.0
2023-11-29 18:00:00	IWM	ETF	178.95	178.97	178.81	178.84	17622.0
2023-11-29 19:00:00	IWM	ETF	178.84	179.02	178.84	178.95	50468.0
2023-11-29 04:00:00	DIA	ETF	355.07	355.15	355.06	355.15	568.0
2023-11-29 05:00:00	DIA	ETF	355.2	355.2	355.2	355.2	1020.0

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

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