PREVIEW / etf_1hour / 2001-07-26

all etf 1-hour files

  file:    by_date/etf_1hour/2001/2001-07-26.parquet
  size:    11 KB
  rows:    214

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-07-26 09:00:00	SPY	ETF	119.06	119.32	118.81	119.18	1560700.0
2001-07-26 10:00:00	SPY	ETF	119.2	119.57	118.86	119.1	1314300.0
2001-07-26 11:00:00	SPY	ETF	119.1	119.16	118.56	118.92	2835100.0
2001-07-26 12:00:00	SPY	ETF	118.92	119.17	118.71	119.11	534400.0
2001-07-26 13:00:00	SPY	ETF	119.18	119.44	118.99	119.37	529800.0
2001-07-26 14:00:00	SPY	ETF	119.4	120.2	119.23	120.12	1915600.0
2001-07-26 15:00:00	SPY	ETF	120.01	120.85	120.01	120.74	2731600.0
2001-07-26 16:00:00	SPY	ETF	120.73	120.75	120.05	120.43	811300.0
2001-07-26 17:00:00	SPY	ETF	120.65	120.7	120.6	120.6	3500.0
2001-07-26 18:00:00	SPY	ETF	120.6	120.6	120.6	120.6	100.0
2001-07-26 09:00:00	QQQ	ETF	40.45	40.85	40.3	40.68	8797000.0
2001-07-26 10:00:00	QQQ	ETF	40.68	41.05	40.39	40.51	9377100.0
2001-07-26 11:00:00	QQQ	ETF	40.51	40.61	39.98	40.27	9397900.0
2001-07-26 12:00:00	QQQ	ETF	40.28	40.43	40.06	40.4	3893900.0
2001-07-26 13:00:00	QQQ	ETF	40.39	40.87	40.25	40.78	4180000.0
2001-07-26 14:00:00	QQQ	ETF	40.79	41.42	40.68	41.36	11683200.0
2001-07-26 15:00:00	QQQ	ETF	41.37	41.89	41.31	41.67	16138300.0
2001-07-26 16:00:00	QQQ	ETF	41.67	41.8	41.05	41.54	2991500.0
2001-07-26 17:00:00	QQQ	ETF	41.54	41.6	41.2	41.49	202100.0
2001-07-26 18:00:00	QQQ	ETF	41.45	41.65	40.5	41.55	68800.0
2001-07-26 09:00:00	IWM	ETF	47.505	47.75	47.4	47.75	13000.0
2001-07-26 10:00:00	IWM	ETF	47.6	47.75	47.525	47.625	9200.0
2001-07-26 11:00:00	IWM	ETF	47.665	47.665	47.23	47.5	3600.0
2001-07-26 12:00:00	IWM	ETF	47.6	47.6	47.45	47.5	5200.0
2001-07-26 13:00:00	IWM	ETF	47.5	47.645	47.5	47.525	20400.0
2001-07-26 14:00:00	IWM	ETF	47.575	48.175	47.575	48.01	262800.0
2001-07-26 15:00:00	IWM	ETF	48.1	48.55	48.05	48.4	265400.0
2001-07-26 16:00:00	IWM	ETF	48.375	48.375	48.325	48.325	40400.0
2001-07-26 09:00:00	DIA	ETF	103.7	103.7	103.31	103.46	257000.0
2001-07-26 10:00:00	DIA	ETF	103.5	103.73	103.29	103.38	226700.0
2001-07-26 11:00:00	DIA	ETF	103.4	103.4	102.85	103.19	298300.0
2001-07-26 12:00:00	DIA	ETF	103.15	103.4	103.12	103.4	171700.0
2001-07-26 13:00:00	DIA	ETF	103.4	103.72	103.29	103.6	134600.0
2001-07-26 14:00:00	DIA	ETF	103.64	104.24	103.48	104.15	411200.0
2001-07-26 15:00:00	DIA	ETF	104.19	104.74	104.19	104.6	621100.0
2001-07-26 16:00:00	DIA	ETF	104.6	104.7	104.52	104.64	321400.0

> showing 36 of 214 rows — these rows as CSV

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