PREVIEW / etf_1hour / 2001-12-20

all etf 1-hour files

  file:    by_date/etf_1hour/2001/2001-12-20.parquet
  size:    13 KB
  rows:    288

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-12-20 09:00:00	SPY	ETF	115.5	115.73	115.33	115.72	2803500.0
2001-12-20 10:00:00	SPY	ETF	115.72	115.8	115.08	115.17	2715100.0
2001-12-20 11:00:00	SPY	ETF	115.15	115.39	115.0	115.29	1476400.0
2001-12-20 12:00:00	SPY	ETF	115.31	115.6	115.01	115.12	1689400.0
2001-12-20 13:00:00	SPY	ETF	115.11	115.39	114.97	115.02	885700.0
2001-12-20 14:00:00	SPY	ETF	115.05	115.26	114.76	114.76	2110100.0
2001-12-20 15:00:00	SPY	ETF	114.77	114.95	114.63	114.69	1855300.0
2001-12-20 16:00:00	SPY	ETF	114.69	114.9	114.55	114.66	1297500.0
2001-12-20 17:00:00	SPY	ETF	114.58	114.58	114.54	114.54	2600.0
2001-12-20 18:00:00	SPY	ETF	114.74	114.9	114.74	114.9	1500.0
2001-12-20 09:00:00	QQQ	ETF	40.1	40.3	40.0	40.14	8557500.0
2001-12-20 10:00:00	QQQ	ETF	40.13	40.22	39.39	39.42	20413200.0
2001-12-20 11:00:00	QQQ	ETF	39.42	39.53	39.2	39.47	10631900.0
2001-12-20 12:00:00	QQQ	ETF	39.49	39.69	39.24	39.31	8209500.0
2001-12-20 13:00:00	QQQ	ETF	39.29	39.57	39.17	39.2	7577300.0
2001-12-20 14:00:00	QQQ	ETF	39.2	39.47	38.98	39.0	10454100.0
2001-12-20 15:00:00	QQQ	ETF	39.0	39.1	38.8	38.81	12678100.0
2001-12-20 16:00:00	QQQ	ETF	38.8	38.86	38.67	38.79	2866300.0
2001-12-20 17:00:00	QQQ	ETF	38.8	38.82	38.72	38.81	44100.0
2001-12-20 18:00:00	QQQ	ETF	38.81	38.81	38.7	38.74	24900.0
2001-12-20 09:00:00	IWM	ETF	47.9	47.9	47.65	47.845	25000.0
2001-12-20 10:00:00	IWM	ETF	47.835	47.915	47.25	47.37	174400.0
2001-12-20 11:00:00	IWM	ETF	47.35	47.49	47.3	47.49	66200.0
2001-12-20 12:00:00	IWM	ETF	47.485	47.54	47.31	47.47	117000.0
2001-12-20 13:00:00	IWM	ETF	47.4	47.55	47.335	47.4	113800.0
2001-12-20 14:00:00	IWM	ETF	47.38	47.575	47.31	47.32	330600.0
2001-12-20 15:00:00	IWM	ETF	47.305	47.42	46.975	46.975	415200.0
2001-12-20 16:00:00	IWM	ETF	46.975	47.15	46.975	47.07	4333800.0
2001-12-20 09:00:00	DIA	ETF	100.8	101.0	100.7	100.99	244800.0
2001-12-20 10:00:00	DIA	ETF	101.0	101.07	100.46	100.58	350300.0
2001-12-20 11:00:00	DIA	ETF	100.52	100.73	100.41	100.62	218700.0
2001-12-20 12:00:00	DIA	ETF	100.72	100.92	100.48	100.62	241200.0
2001-12-20 13:00:00	DIA	ETF	100.59	100.75	100.4	100.4	94500.0
2001-12-20 14:00:00	DIA	ETF	100.45	100.65	100.28	100.29	389800.0
2001-12-20 15:00:00	DIA	ETF	100.32	100.41	100.11	100.11	561800.0
2001-12-20 16:00:00	DIA	ETF	100.18	100.34	100.1	100.21	154400.0

> showing 36 of 288 rows — these rows as CSV

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