PREVIEW / etf_1hour / 2001-08-29

all etf 1-hour files

  file:    by_date/etf_1hour/2001/2001-08-29.parquet
  size:    12 KB
  rows:    245

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-29 09:00:00	SPY	ETF	117.13	117.18	116.71	116.79	2311800.0
2001-08-29 10:00:00	SPY	ETF	116.8	116.8	115.53	115.84	4459600.0
2001-08-29 11:00:00	SPY	ETF	115.84	116.09	115.64	115.64	1370700.0
2001-08-29 12:00:00	SPY	ETF	115.65	115.95	115.61	115.71	666700.0
2001-08-29 13:00:00	SPY	ETF	115.71	115.96	115.52	115.76	858900.0
2001-08-29 14:00:00	SPY	ETF	115.74	115.86	115.34	115.38	1357800.0
2001-08-29 15:00:00	SPY	ETF	115.4	115.65	115.17	115.39	3058900.0
2001-08-29 16:00:00	SPY	ETF	115.37	115.66	115.26	115.66	1403400.0
2001-08-29 17:00:00	SPY	ETF	115.55	115.6	115.45	115.54	21200.0
2001-08-29 09:00:00	QQQ	ETF	38.37	38.45	37.85	37.88	9657400.0
2001-08-29 10:00:00	QQQ	ETF	37.91	37.93	37.15	37.47	14355400.0
2001-08-29 11:00:00	QQQ	ETF	37.48	37.69	37.35	37.41	6058800.0
2001-08-29 12:00:00	QQQ	ETF	37.45	37.71	37.41	37.5	2501500.0
2001-08-29 13:00:00	QQQ	ETF	37.53	37.65	37.22	37.44	4893900.0
2001-08-29 14:00:00	QQQ	ETF	37.45	37.67	37.22	37.3	6764200.0
2001-08-29 15:00:00	QQQ	ETF	37.27	37.52	37.13	37.35	9167400.0
2001-08-29 16:00:00	QQQ	ETF	37.35	38.05	37.25	37.4	2302200.0
2001-08-29 17:00:00	QQQ	ETF	37.4	37.48	37.2	37.4	389700.0
2001-08-29 18:00:00	QQQ	ETF	37.4	37.4	37.25	37.32	34500.0
2001-08-29 09:00:00	IWM	ETF	47.525	47.525	47.375	47.375	34800.0
2001-08-29 10:00:00	IWM	ETF	47.305	47.305	46.9	47.035	211000.0
2001-08-29 11:00:00	IWM	ETF	47.055	47.145	47.05	47.05	3400.0
2001-08-29 12:00:00	IWM	ETF	47.125	47.2	47.105	47.155	3800.0
2001-08-29 13:00:00	IWM	ETF	47.14	47.325	47.14	47.29	147200.0
2001-08-29 14:00:00	IWM	ETF	47.29	47.295	47.1	47.175	37800.0
2001-08-29 15:00:00	IWM	ETF	47.11	47.18	47.0	47.105	91400.0
2001-08-29 16:00:00	IWM	ETF	47.05	47.15	47.05	47.15	123600.0
2001-08-29 09:00:00	DIA	ETF	102.7	102.85	102.37	102.5	377600.0
2001-08-29 10:00:00	DIA	ETF	102.52	102.52	101.13	101.45	962400.0
2001-08-29 11:00:00	DIA	ETF	101.48	101.63	101.18	101.21	226900.0
2001-08-29 12:00:00	DIA	ETF	101.19	101.41	101.0	101.25	475300.0
2001-08-29 13:00:00	DIA	ETF	101.24	101.49	101.0	101.39	245800.0
2001-08-29 14:00:00	DIA	ETF	101.39	101.4	101.01	101.05	264000.0
2001-08-29 15:00:00	DIA	ETF	101.04	101.29	100.9	101.1	440900.0
2001-08-29 16:00:00	DIA	ETF	101.09	101.2	101.04	101.16	54100.0
2001-08-29 17:00:00	DIA	ETF	101.15	101.15	101.0	101.0	1100.0

> showing 36 of 245 rows — these rows as CSV

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