PREVIEW / etf_1hour / 2001-10-25

all etf 1-hour files

  file:    by_date/etf_1hour/2001/2001-10-25.parquet
  size:    12 KB
  rows:    256

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-10-25 09:00:00	SPY	ETF	107.45	107.82	107.32	107.5	1970000.0
2001-10-25 10:00:00	SPY	ETF	107.5	107.54	106.74	107.07	2898600.0
2001-10-25 11:00:00	SPY	ETF	107.1	107.74	107.04	107.5	1695100.0
2001-10-25 12:00:00	SPY	ETF	107.44	107.8	107.34	107.51	2333700.0
2001-10-25 13:00:00	SPY	ETF	107.51	108.23	107.5	108.11	3800500.0
2001-10-25 14:00:00	SPY	ETF	108.18	109.95	108.1	109.66	5424900.0
2001-10-25 15:00:00	SPY	ETF	109.65	110.32	109.5	110.31	6986500.0
2001-10-25 16:00:00	SPY	ETF	110.3	110.64	109.99	110.5	2059100.0
2001-10-25 17:00:00	SPY	ETF	110.57	110.6	110.35	110.57	28300.0
2001-10-25 09:00:00	QQQ	ETF	34.7	34.97	34.5	34.65	16794000.0
2001-10-25 10:00:00	QQQ	ETF	34.65	34.7	34.23	34.53	16708300.0
2001-10-25 11:00:00	QQQ	ETF	34.52	34.7	34.38	34.59	6816500.0
2001-10-25 12:00:00	QQQ	ETF	34.6	34.97	34.57	34.92	9337500.0
2001-10-25 13:00:00	QQQ	ETF	34.91	35.38	34.9	35.34	14519800.0
2001-10-25 14:00:00	QQQ	ETF	35.3	36.44	35.27	36.16	26873300.0
2001-10-25 15:00:00	QQQ	ETF	36.2	36.82	36.13	36.76	22255500.0
2001-10-25 16:00:00	QQQ	ETF	36.77	36.81	34.7	36.61	3533700.0
2001-10-25 17:00:00	QQQ	ETF	36.66	36.8	36.2	36.72	553000.0
2001-10-25 18:00:00	QQQ	ETF	36.72	36.74	36.61	36.68	39900.0
2001-10-25 09:00:00	IWM	ETF	42.2	42.325	42.075	42.295	63400.0
2001-10-25 10:00:00	IWM	ETF	42.15	42.19	42.0	42.15	31400.0
2001-10-25 11:00:00	IWM	ETF	42.185	42.385	42.13	42.345	138400.0
2001-10-25 12:00:00	IWM	ETF	42.38	42.59	42.38	42.59	28400.0
2001-10-25 13:00:00	IWM	ETF	42.585	42.815	42.585	42.81	317000.0
2001-10-25 14:00:00	IWM	ETF	42.82	43.275	42.815	43.17	336400.0
2001-10-25 15:00:00	IWM	ETF	43.125	43.45	43.09	43.45	220800.0
2001-10-25 16:00:00	IWM	ETF	43.495	43.625	43.495	43.625	46600.0
2001-10-25 09:00:00	DIA	ETF	92.5	92.75	92.2	92.35	419700.0
2001-10-25 10:00:00	DIA	ETF	92.36	92.4	91.74	92.07	782100.0
2001-10-25 11:00:00	DIA	ETF	92.06	92.67	92.04	92.33	257400.0
2001-10-25 12:00:00	DIA	ETF	92.35	92.6	92.26	92.43	77600.0
2001-10-25 13:00:00	DIA	ETF	92.44	92.89	92.44	92.84	225800.0
2001-10-25 14:00:00	DIA	ETF	92.9	94.5	92.8	94.04	1098600.0
2001-10-25 15:00:00	DIA	ETF	94.08	94.74	94.0	94.66	775700.0
2001-10-25 16:00:00	DIA	ETF	94.6	94.99	94.46	94.98	127800.0

> showing 35 of 256 rows — these rows as CSV

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