PREVIEW / etf_1hour / 2001-09-18

all etf 1-hour files

  file:    by_date/etf_1hour/2001/2001-09-18.parquet
  size:    12 KB
  rows:    269

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-09-18 09:00:00	SPY	ETF	104.33	104.7	103.7	104.33	3492400.0
2001-09-18 10:00:00	SPY	ETF	104.35	105.19	104.16	105.12	3677000.0
2001-09-18 11:00:00	SPY	ETF	105.15	105.15	104.0	104.5	1960300.0
2001-09-18 12:00:00	SPY	ETF	104.5	104.9	104.44	104.71	2179500.0
2001-09-18 13:00:00	SPY	ETF	104.78	105.3	104.63	104.9	1868200.0
2001-09-18 14:00:00	SPY	ETF	104.83	104.94	104.01	104.34	3292500.0
2001-09-18 15:00:00	SPY	ETF	104.32	104.32	103.36	103.82	4256500.0
2001-09-18 16:00:00	SPY	ETF	103.9	105.5	103.6	104.2	631900.0
2001-09-18 17:00:00	SPY	ETF	104.04	104.05	104.04	104.05	30600.0
2001-09-18 09:00:00	QQQ	ETF	31.53	31.62	31.1	31.57	10465700.0
2001-09-18 10:00:00	QQQ	ETF	31.56	32.0	31.45	31.79	12346400.0
2001-09-18 11:00:00	QQQ	ETF	31.85	31.85	31.25	31.31	6568400.0
2001-09-18 12:00:00	QQQ	ETF	31.32	31.5	31.21	31.42	5785500.0
2001-09-18 13:00:00	QQQ	ETF	31.42	31.67	31.31	31.38	5346800.0
2001-09-18 14:00:00	QQQ	ETF	31.42	31.42	30.77	30.88	9131400.0
2001-09-18 15:00:00	QQQ	ETF	30.9	30.91	30.37	30.49	12805000.0
2001-09-18 16:00:00	QQQ	ETF	30.49	30.98	30.43	30.51	1041400.0
2001-09-18 17:00:00	QQQ	ETF	30.54	30.6	30.49	30.51	17700.0
2001-09-18 18:00:00	QQQ	ETF	30.54	30.6	30.49	30.57	11200.0
2001-09-18 09:00:00	IWM	ETF	41.87	41.875	41.55	41.75	1090400.0
2001-09-18 10:00:00	IWM	ETF	41.75	41.925	41.615	41.87	1488000.0
2001-09-18 11:00:00	IWM	ETF	41.87	41.895	41.5	41.5	233000.0
2001-09-18 12:00:00	IWM	ETF	41.565	41.565	41.45	41.525	72400.0
2001-09-18 13:00:00	IWM	ETF	41.525	41.7	41.525	41.605	708600.0
2001-09-18 14:00:00	IWM	ETF	41.575	41.575	41.15	41.25	198400.0
2001-09-18 15:00:00	IWM	ETF	41.255	41.255	40.8	41.055	431000.0
2001-09-18 16:00:00	IWM	ETF	41.055	41.075	41.055	41.075	9600.0
2001-09-18 09:00:00	DIA	ETF	89.75	89.9	88.85	89.3	1313200.0
2001-09-18 10:00:00	DIA	ETF	89.3	89.97	89.1	89.95	1861300.0
2001-09-18 11:00:00	DIA	ETF	89.9	89.95	89.41	89.55	286800.0
2001-09-18 12:00:00	DIA	ETF	89.57	90.1	89.43	89.83	417300.0
2001-09-18 13:00:00	DIA	ETF	89.86	90.5	89.75	90.02	657200.0
2001-09-18 14:00:00	DIA	ETF	90.05	90.1	89.35	89.42	751600.0
2001-09-18 15:00:00	DIA	ETF	89.55	89.55	88.76	89.21	1116900.0
2001-09-18 16:00:00	DIA	ETF	89.25	90.5	89.2	89.6	84600.0
2001-09-18 17:00:00	DIA	ETF	89.63	89.63	89.55	89.6	600.0

> showing 36 of 269 rows — these rows as CSV

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