PREVIEW / etf_1hour / 2001-03-23

all etf 1-hour files

  file:    by_date/etf_1hour/2001/2001-03-23.parquet
  size:    11 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-03-23 09:00:00	SPY	ETF	113.25	113.25	111.83	112.19	2493200.0
2001-03-23 10:00:00	SPY	ETF	112.14	113.35	111.92	113.15	2452600.0
2001-03-23 11:00:00	SPY	ETF	113.15	113.95	113.05	113.25	1537700.0
2001-03-23 12:00:00	SPY	ETF	113.3	113.45	112.4	112.68	973800.0
2001-03-23 13:00:00	SPY	ETF	112.8	113.78	112.78	113.4	1071300.0
2001-03-23 14:00:00	SPY	ETF	113.26	114.29	113.2	114.01	1427100.0
2001-03-23 15:00:00	SPY	ETF	113.99	114.48	113.57	114.25	1682700.0
2001-03-23 16:00:00	SPY	ETF	114.15	114.66	114.15	114.6	941200.0
2001-03-23 09:00:00	QQQ	ETF	43.55	43.83	42.51	42.9	21000700.0
2001-03-23 10:00:00	QQQ	ETF	42.9	43.5	42.45	43.1	17835100.0
2001-03-23 11:00:00	QQQ	ETF	43.1	43.33	42.5	42.55	9259100.0
2001-03-23 12:00:00	QQQ	ETF	42.5	42.55	41.5	41.82	14520300.0
2001-03-23 13:00:00	QQQ	ETF	41.76	42.47	41.73	42.0	6029900.0
2001-03-23 14:00:00	QQQ	ETF	41.95	43.0	41.87	42.73	9577300.0
2001-03-23 15:00:00	QQQ	ETF	42.7	43.02	42.3	42.5	9822800.0
2001-03-23 16:00:00	QQQ	ETF	42.5	42.9	42.0	42.85	2009400.0
2001-03-23 17:00:00	QQQ	ETF	42.85	42.9	42.8	42.85	20900.0
2001-03-23 18:00:00	QQQ	ETF	42.85	42.9	42.8	42.8	13100.0
2001-03-23 09:00:00	IWM	ETF	43.875	43.875	43.5	43.65	41200.0
2001-03-23 10:00:00	IWM	ETF	43.9	44.045	43.575	43.875	22000.0
2001-03-23 11:00:00	IWM	ETF	44.05	44.125	43.85	43.95	61800.0
2001-03-23 12:00:00	IWM	ETF	43.675	43.775	43.525	43.7	70400.0
2001-03-23 13:00:00	IWM	ETF	43.675	44.025	43.675	44.025	36800.0
2001-03-23 14:00:00	IWM	ETF	44.02	44.25	44.02	44.145	26400.0
2001-03-23 15:00:00	IWM	ETF	44.25	44.25	43.875	44.0	34400.0
2001-03-23 16:00:00	IWM	ETF	44.17	44.17	44.125	44.125	2200.0
2001-03-23 09:00:00	DIA	ETF	94.49	95.1	93.45	93.82	1213800.0
2001-03-23 10:00:00	DIA	ETF	93.6	94.61	93.3	94.4	910100.0
2001-03-23 11:00:00	DIA	ETF	94.4	95.0	94.3	94.4	517500.0
2001-03-23 12:00:00	DIA	ETF	94.33	94.65	93.57	93.99	1290200.0
2001-03-23 13:00:00	DIA	ETF	94.0	94.8	93.77	94.5	283800.0
2001-03-23 14:00:00	DIA	ETF	94.6	95.24	94.42	94.88	915500.0
2001-03-23 15:00:00	DIA	ETF	94.75	95.49	94.65	95.26	931600.0
2001-03-23 16:00:00	DIA	ETF	95.25	95.44	95.15	95.21	126400.0
2001-03-23 17:00:00	DIA	ETF	95.1	95.1	95.1	95.1	2000.0

> showing 35 of 230 rows — these rows as CSV

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