PREVIEW / etf_1hour / 2001-05-04

all etf 1-hour files

  file:    by_date/etf_1hour/2001/2001-05-04.parquet
  size:    11 KB
  rows:    219

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-05-04 09:00:00	SPY	ETF	123.65	124.09	123.44	124.01	753200.0
2001-05-04 10:00:00	SPY	ETF	124.05	125.42	123.71	125.19	2811300.0
2001-05-04 11:00:00	SPY	ETF	125.3	125.96	125.11	125.69	1294900.0
2001-05-04 12:00:00	SPY	ETF	125.75	126.61	125.52	126.37	1248000.0
2001-05-04 13:00:00	SPY	ETF	126.4	126.54	125.94	126.37	971700.0
2001-05-04 14:00:00	SPY	ETF	126.32	126.79	126.06	126.36	990800.0
2001-05-04 15:00:00	SPY	ETF	126.38	127.2	126.31	126.95	1880200.0
2001-05-04 16:00:00	SPY	ETF	127.04	127.35	126.78	127.1	469300.0
2001-05-04 09:00:00	QQQ	ETF	45.32	45.74	45.22	45.54	5232800.0
2001-05-04 10:00:00	QQQ	ETF	45.59	46.92	45.3	46.65	16129200.0
2001-05-04 11:00:00	QQQ	ETF	46.63	47.13	46.4	46.99	9659900.0
2001-05-04 12:00:00	QQQ	ETF	46.95	47.95	46.83	47.85	7464900.0
2001-05-04 13:00:00	QQQ	ETF	47.85	47.9	47.32	47.71	6230200.0
2001-05-04 14:00:00	QQQ	ETF	47.73	48.16	47.16	47.6	8071100.0
2001-05-04 15:00:00	QQQ	ETF	47.64	48.08	47.52	47.95	8151400.0
2001-05-04 16:00:00	QQQ	ETF	47.94	48.25	47.49	48.15	1430400.0
2001-05-04 17:00:00	QQQ	ETF	48.12	48.17	48.0	48.11	37200.0
2001-05-04 18:00:00	QQQ	ETF	48.07	48.2	48.07	48.1	3300.0
2001-05-04 09:00:00	IWM	ETF	47.9	48.05	47.735	47.875	208000.0
2001-05-04 10:00:00	IWM	ETF	47.995	48.35	47.985	48.155	70800.0
2001-05-04 11:00:00	IWM	ETF	48.4	48.525	48.255	48.435	59200.0
2001-05-04 12:00:00	IWM	ETF	48.495	48.75	48.365	48.715	121800.0
2001-05-04 13:00:00	IWM	ETF	48.77	48.875	48.7	48.7	26800.0
2001-05-04 14:00:00	IWM	ETF	48.7	48.95	48.7	48.7	21600.0
2001-05-04 15:00:00	IWM	ETF	48.835	49.145	48.71	49.145	195800.0
2001-05-04 16:00:00	IWM	ETF	49.15	49.15	49.05	49.05	6000.0
2001-05-04 09:00:00	DIA	ETF	106.97	107.23	106.77	107.2	276900.0
2001-05-04 10:00:00	DIA	ETF	107.29	108.3	107.01	108.11	2323100.0
2001-05-04 11:00:00	DIA	ETF	108.05	108.75	108.05	108.38	713500.0
2001-05-04 12:00:00	DIA	ETF	108.38	109.1	108.32	108.9	853400.0
2001-05-04 13:00:00	DIA	ETF	108.9	108.92	108.55	108.81	256600.0
2001-05-04 14:00:00	DIA	ETF	108.82	109.28	108.71	109.0	255000.0
2001-05-04 15:00:00	DIA	ETF	109.0	109.69	109.0	109.58	388800.0
2001-05-04 16:00:00	DIA	ETF	109.67	110.42	109.37	109.86	148300.0
2001-05-04 17:00:00	DIA	ETF	109.8	109.8	109.8	109.8	10000.0

> showing 35 of 219 rows — these rows as CSV

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