PREVIEW / etf_1hour / 2001-08-21

all etf 1-hour files

  file:    by_date/etf_1hour/2001/2001-08-21.parquet
  size:    12 KB
  rows:    246

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
2001-08-21 09:00:00	SPY	ETF	117.8	117.84	117.65	117.78	631100.0
2001-08-21 10:00:00	SPY	ETF	117.78	118.14	117.78	118.14	1112400.0
2001-08-21 11:00:00	SPY	ETF	118.15	118.39	118.15	118.19	1557100.0
2001-08-21 12:00:00	SPY	ETF	118.17	118.34	118.17	118.26	698400.0
2001-08-21 13:00:00	SPY	ETF	118.26	118.51	118.23	118.47	1278500.0
2001-08-21 14:00:00	SPY	ETF	118.49	118.54	117.31	117.32	3564000.0
2001-08-21 15:00:00	SPY	ETF	117.3	117.35	116.03	116.13	3953000.0
2001-08-21 16:00:00	SPY	ETF	116.12	116.12	115.76	115.95	931600.0
2001-08-21 17:00:00	SPY	ETF	115.9	115.91	115.9	115.91	700.0
2001-08-21 18:00:00	SPY	ETF	116.0	116.0	116.0	116.0	100.0
2001-08-21 09:00:00	QQQ	ETF	38.29	38.45	38.19	38.33	3007400.0
2001-08-21 10:00:00	QQQ	ETF	38.32	38.5	38.3	38.39	6732600.0
2001-08-21 11:00:00	QQQ	ETF	38.37	38.58	38.35	38.46	2804800.0
2001-08-21 12:00:00	QQQ	ETF	38.46	38.56	38.44	38.46	2253400.0
2001-08-21 13:00:00	QQQ	ETF	38.47	38.58	38.42	38.57	4813800.0
2001-08-21 14:00:00	QQQ	ETF	38.56	38.65	37.84	37.84	13790400.0
2001-08-21 15:00:00	QQQ	ETF	37.86	37.88	36.89	36.92	17781000.0
2001-08-21 16:00:00	QQQ	ETF	36.91	37.15	36.61	36.62	2626500.0
2001-08-21 17:00:00	QQQ	ETF	36.61	36.97	36.59	36.77	137900.0
2001-08-21 18:00:00	QQQ	ETF	36.77	36.88	36.62	36.81	50700.0
2001-08-21 09:00:00	IWM	ETF	47.85	47.85	47.75	47.82	4200.0
2001-08-21 10:00:00	IWM	ETF	47.655	47.95	47.655	47.75	333200.0
2001-08-21 11:00:00	IWM	ETF	47.9	47.95	47.83	47.925	6400.0
2001-08-21 12:00:00	IWM	ETF	47.925	47.935	47.86	47.86	4600.0
2001-08-21 13:00:00	IWM	ETF	47.975	47.985	47.95	47.975	3000.0
2001-08-21 14:00:00	IWM	ETF	47.99	48.0	47.525	47.7	110800.0
2001-08-21 15:00:00	IWM	ETF	47.375	47.425	47.0	47.0	442000.0
2001-08-21 16:00:00	IWM	ETF	47.15	47.15	47.15	47.15	800.0
2001-08-21 09:00:00	DIA	ETF	103.5	103.51	103.29	103.42	233200.0
2001-08-21 10:00:00	DIA	ETF	103.45	103.59	103.43	103.54	219400.0
2001-08-21 11:00:00	DIA	ETF	103.63	103.79	103.62	103.65	346900.0
2001-08-21 12:00:00	DIA	ETF	103.69	103.7	103.62	103.69	46700.0
2001-08-21 13:00:00	DIA	ETF	103.7	103.88	103.7	103.83	152700.0
2001-08-21 14:00:00	DIA	ETF	103.8	103.89	102.82	102.9	1034800.0
2001-08-21 15:00:00	DIA	ETF	102.85	102.89	101.5	101.65	1401600.0
2001-08-21 16:00:00	DIA	ETF	101.6	101.7	101.46	101.67	193500.0
2001-08-21 17:00:00	DIA	ETF	101.67	101.67	101.45	101.45	400.0

> showing 37 of 246 rows — these rows as CSV

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