PREVIEW / etf_1hour / 2024-01-29

all etf 1-hour files

  file:    by_date/etf_1hour/2024/2024-01-29.parquet
  size:    529 KB
  rows:    19,622

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
2024-01-29 04:00:00	SPY	ETF	487.7	487.94	487.17	487.24	19370.0
2024-01-29 05:00:00	SPY	ETF	487.4	487.68	487.37	487.56	3365.0
2024-01-29 06:00:00	SPY	ETF	487.69	487.85	487.57	487.79	20174.0
2024-01-29 07:00:00	SPY	ETF	487.8	488.0	487.5	487.54	149232.0
2024-01-29 08:00:00	SPY	ETF	487.54	488.0	486.94	487.48	231290.0
2024-01-29 09:00:00	SPY	ETF	487.46	488.15	487.36	488.03	4503649.0
2024-01-29 10:00:00	SPY	ETF	488.03	488.27	487.18	487.3	6217301.0
2024-01-29 11:00:00	SPY	ETF	487.32	488.18	487.17	488.1204	3367736.0
2024-01-29 12:00:00	SPY	ETF	488.13	488.59	487.86	488.18	4345961.0
2024-01-29 13:00:00	SPY	ETF	488.18	488.54	487.84	488.215	2461433.0
2024-01-29 14:00:00	SPY	ETF	488.22	489.11	488.09	488.885	4031091.0
2024-01-29 15:00:00	SPY	ETF	488.89	491.415	488.89	491.26	14560976.0
2024-01-29 16:00:00	SPY	ETF	491.265	491.33	488.4372	490.88	4513503.0
2024-01-29 17:00:00	SPY	ETF	490.9	491.27	490.9	491.01	128116.0
2024-01-29 18:00:00	SPY	ETF	491.01	491.27	490.86	491.05	701730.0
2024-01-29 19:00:00	SPY	ETF	491.05	491.4	490.93	491.29	55850.0
2024-01-29 04:00:00	QQQ	ETF	425.07	425.29	424.14	424.26	45007.0
2024-01-29 05:00:00	QQQ	ETF	424.3	424.89	424.28	424.65	32100.0
2024-01-29 06:00:00	QQQ	ETF	424.63	424.94	424.52	424.8	37465.0
2024-01-29 07:00:00	QQQ	ETF	424.76	425.01	424.3	424.48	78420.0
2024-01-29 08:00:00	QQQ	ETF	424.92	424.9787	423.76	424.23	160056.0
2024-01-29 09:00:00	QQQ	ETF	424.2	425.12	423.85	424.53	2829124.0
2024-01-29 10:00:00	QQQ	ETF	424.54	424.8	423.76	423.85	4490470.0
2024-01-29 11:00:00	QQQ	ETF	423.84	425.0899	423.61	425.06	2775459.0
2024-01-29 12:00:00	QQQ	ETF	425.06	425.75	424.95	425.45	3790215.0
2024-01-29 13:00:00	QQQ	ETF	425.47	425.6201	425.01	425.2351	2198694.0
2024-01-29 14:00:00	QQQ	ETF	425.25	426.34	425.1262	426.16	3075351.0
2024-01-29 15:00:00	QQQ	ETF	426.17	428.35	426.17	428.16	7783733.0
2024-01-29 16:00:00	QQQ	ETF	428.15	428.2	425.4482	428.0	1646866.0
2024-01-29 17:00:00	QQQ	ETF	428.04	428.48	428.01	428.28	98725.0
2024-01-29 18:00:00	QQQ	ETF	428.31	428.73	428.0	428.49	140614.0
2024-01-29 19:00:00	QQQ	ETF	428.46	428.84	428.25	428.65	59971.0
2024-01-29 04:00:00	IWM	ETF	196.07	196.12	195.62	195.62	16126.0
2024-01-29 05:00:00	IWM	ETF	195.62	195.92	195.56	195.85	7543.0
2024-01-29 06:00:00	IWM	ETF	195.81	195.98	195.81	195.87	5467.0
2024-01-29 07:00:00	IWM	ETF	195.81	196.05	195.7	195.8	52301.0
2024-01-29 08:00:00	IWM	ETF	195.9509	196.34	195.73	196.19	73026.0
2024-01-29 09:00:00	IWM	ETF	196.16	196.32	195.09	195.98	2454458.0
2024-01-29 10:00:00	IWM	ETF	195.99	197.015	195.36	196.63	3937169.0
2024-01-29 11:00:00	IWM	ETF	196.62	197.06	196.44	196.84	1522097.0
2024-01-29 12:00:00	IWM	ETF	196.83	197.15	196.54	196.885	1952090.0
2024-01-29 13:00:00	IWM	ETF	196.89	197.24	196.675	197.07	1494877.0
2024-01-29 14:00:00	IWM	ETF	197.07	197.73	197.035	197.53	1986997.0
2024-01-29 15:00:00	IWM	ETF	197.535	199.41	197.535	199.37	8813387.0
2024-01-29 16:00:00	IWM	ETF	199.37	199.41	198.99	198.99	1074371.0
2024-01-29 17:00:00	IWM	ETF	199.0	199.41	198.98	199.23	108379.0
2024-01-29 18:00:00	IWM	ETF	199.11	199.33	199.06	199.2	30349.0
2024-01-29 19:00:00	IWM	ETF	199.2	199.64	199.14	199.5596	121724.0
2024-01-29 04:00:00	DIA	ETF	380.97	380.97	380.83	380.86	325.0
2024-01-29 07:00:00	DIA	ETF	380.99	380.99	380.84	380.88	357.0

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

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