PREVIEW / etf_1hour / 2001-10-18

all etf 1-hour files

  file:    by_date/etf_1hour/2001/2001-10-18.parquet
  size:    12 KB
  rows:    250

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-18 09:00:00	SPY	ETF	107.82	108.16	107.39	107.57	2946200.0
2001-10-18 10:00:00	SPY	ETF	107.55	108.1	107.37	107.6	2626600.0
2001-10-18 11:00:00	SPY	ETF	107.52	108.12	107.52	107.53	2142700.0
2001-10-18 12:00:00	SPY	ETF	107.52	107.7	107.14	107.22	2224700.0
2001-10-18 13:00:00	SPY	ETF	107.25	107.38	106.75	106.9	2134500.0
2001-10-18 14:00:00	SPY	ETF	106.87	107.55	106.87	107.08	1435200.0
2001-10-18 15:00:00	SPY	ETF	107.1	107.36	106.75	107.21	2065500.0
2001-10-18 16:00:00	SPY	ETF	107.23	108.0	107.0	107.67	434400.0
2001-10-18 17:00:00	SPY	ETF	107.67	107.83	107.3	107.4	19100.0
2001-10-18 18:00:00	SPY	ETF	107.4	107.4	107.22	107.22	4200.0
2001-10-18 09:00:00	QQQ	ETF	32.7	33.15	32.4	32.69	18075800.0
2001-10-18 10:00:00	QQQ	ETF	32.71	33.25	32.58	33.01	17251500.0
2001-10-18 11:00:00	QQQ	ETF	33.02	33.54	33.01	33.1	12427300.0
2001-10-18 12:00:00	QQQ	ETF	33.05	33.19	32.89	32.9	7381400.0
2001-10-18 13:00:00	QQQ	ETF	32.91	32.95	32.61	32.8	8657500.0
2001-10-18 14:00:00	QQQ	ETF	32.77	33.25	32.77	32.96	8621300.0
2001-10-18 15:00:00	QQQ	ETF	32.96	33.19	32.76	33.17	10210700.0
2001-10-18 16:00:00	QQQ	ETF	33.16	33.7	32.85	33.5	3789400.0
2001-10-18 17:00:00	QQQ	ETF	33.51	33.56	33.1	33.1	823700.0
2001-10-18 18:00:00	QQQ	ETF	33.2	33.25	32.95	32.99	98900.0
2001-10-18 09:00:00	IWM	ETF	42.275	42.275	42.025	42.11	28400.0
2001-10-18 10:00:00	IWM	ETF	42.05	42.225	42.0	42.09	184000.0
2001-10-18 11:00:00	IWM	ETF	42.08	42.275	42.025	42.275	136600.0
2001-10-18 12:00:00	IWM	ETF	42.13	42.18	42.125	42.125	116400.0
2001-10-18 13:00:00	IWM	ETF	42.125	42.135	41.935	41.935	227800.0
2001-10-18 14:00:00	IWM	ETF	42.02	42.1	41.96	41.99	58600.0
2001-10-18 15:00:00	IWM	ETF	42.055	42.055	41.65	41.925	211200.0
2001-10-18 16:00:00	IWM	ETF	41.925	41.925	41.78	41.78	2400.0
2001-10-18 09:00:00	DIA	ETF	92.25	92.57	91.9	91.92	571900.0
2001-10-18 10:00:00	DIA	ETF	91.9	92.44	91.85	92.06	476400.0
2001-10-18 11:00:00	DIA	ETF	92.1	92.49	92.04	92.17	286900.0
2001-10-18 12:00:00	DIA	ETF	92.11	92.23	91.72	91.76	429800.0
2001-10-18 13:00:00	DIA	ETF	91.76	91.94	91.57	91.72	285700.0
2001-10-18 14:00:00	DIA	ETF	91.72	92.29	91.71	91.95	284900.0
2001-10-18 15:00:00	DIA	ETF	91.96	92.13	91.45	91.87	391700.0
2001-10-18 16:00:00	DIA	ETF	91.73	92.38	91.73	92.38	37000.0

> showing 36 of 250 rows — these rows as CSV

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