PREVIEW / etf_1hour / 2001-08-09

all etf 1-hour files

  file:    by_date/etf_1hour/2001/2001-08-09.parquet
  size:    12 KB
  rows:    230

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-09 09:00:00	SPY	ETF	118.7	118.87	118.23	118.8	2360100.0
2001-08-09 10:00:00	SPY	ETF	118.79	118.9	117.88	118.17	3097400.0
2001-08-09 11:00:00	SPY	ETF	118.23	118.49	117.91	117.93	1306500.0
2001-08-09 12:00:00	SPY	ETF	117.95	118.54	117.86	118.5	1065100.0
2001-08-09 13:00:00	SPY	ETF	118.55	118.89	118.22	118.31	1177900.0
2001-08-09 14:00:00	SPY	ETF	118.31	118.58	117.95	118.25	1471100.0
2001-08-09 15:00:00	SPY	ETF	118.27	118.97	118.24	118.74	1995800.0
2001-08-09 16:00:00	SPY	ETF	118.74	118.98	118.43	118.7	992800.0
2001-08-09 17:00:00	SPY	ETF	119.04	119.04	119.04	119.04	1000.0
2001-08-09 09:00:00	QQQ	ETF	40.41	40.75	40.16	40.73	9653200.0
2001-08-09 10:00:00	QQQ	ETF	40.75	40.88	39.98	40.25	11924800.0
2001-08-09 11:00:00	QQQ	ETF	40.25	40.64	40.11	40.26	9074200.0
2001-08-09 12:00:00	QQQ	ETF	40.26	40.47	40.04	40.41	5523600.0
2001-08-09 13:00:00	QQQ	ETF	40.43	40.75	40.22	40.38	6695900.0
2001-08-09 14:00:00	QQQ	ETF	40.4	40.53	40.02	40.17	7758000.0
2001-08-09 15:00:00	QQQ	ETF	40.16	40.68	40.1	40.54	10569800.0
2001-08-09 16:00:00	QQQ	ETF	40.6	40.75	40.0	40.7	1970400.0
2001-08-09 17:00:00	QQQ	ETF	40.68	40.9	40.67	40.81	57400.0
2001-08-09 18:00:00	QQQ	ETF	40.81	40.9	40.72	40.8	32900.0
2001-08-09 09:00:00	IWM	ETF	47.1	47.17	46.955	47.17	204000.0
2001-08-09 10:00:00	IWM	ETF	47.245	47.25	46.75	46.945	177800.0
2001-08-09 11:00:00	IWM	ETF	46.94	47.085	46.905	47.07	14000.0
2001-08-09 12:00:00	IWM	ETF	46.85	46.9	46.725	46.895	9800.0
2001-08-09 13:00:00	IWM	ETF	46.9	47.095	46.9	47.095	24800.0
2001-08-09 14:00:00	IWM	ETF	46.975	47.05	46.945	46.995	23200.0
2001-08-09 15:00:00	IWM	ETF	46.995	47.22	46.955	47.125	73200.0
2001-08-09 16:00:00	IWM	ETF	47.325	47.35	47.325	47.35	1200.0
2001-08-09 09:00:00	DIA	ETF	102.99	103.05	102.67	102.86	357400.0
2001-08-09 10:00:00	DIA	ETF	102.86	102.9	102.13	102.45	1053200.0
2001-08-09 11:00:00	DIA	ETF	102.46	102.72	102.25	102.29	604000.0
2001-08-09 12:00:00	DIA	ETF	102.25	102.72	102.18	102.72	203500.0
2001-08-09 13:00:00	DIA	ETF	102.72	103.12	102.58	102.69	365500.0
2001-08-09 14:00:00	DIA	ETF	102.69	102.88	102.42	102.6	407400.0
2001-08-09 15:00:00	DIA	ETF	102.64	103.25	102.64	103.07	596600.0
2001-08-09 16:00:00	DIA	ETF	103.05	103.19	103.05	103.15	1726900.0
2001-08-09 18:00:00	DIA	ETF	103.19	103.19	103.19	103.19	300.0

> showing 36 of 230 rows — these rows as CSV

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