PREVIEW / etf_1hour / 2001-09-17

all etf 1-hour files

  file:    by_date/etf_1hour/2001/2001-09-17.parquet
  size:    12 KB
  rows:    254

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-17 09:00:00	SPY	ETF	101.0	104.5	101.0	103.75	3848500.0
2001-09-17 10:00:00	SPY	ETF	103.79	106.0	102.4	105.7	6819200.0
2001-09-17 11:00:00	SPY	ETF	105.49	106.4	104.95	105.93	6309300.0
2001-09-17 12:00:00	SPY	ETF	105.83	106.1	105.1	105.33	3904300.0
2001-09-17 13:00:00	SPY	ETF	105.38	105.42	104.32	104.84	2972700.0
2001-09-17 14:00:00	SPY	ETF	104.85	105.18	104.1	104.29	2200700.0
2001-09-17 15:00:00	SPY	ETF	104.31	104.8	104.15	104.3	4306800.0
2001-09-17 16:00:00	SPY	ETF	104.4	104.65	103.25	104.3	1073000.0
2001-09-17 17:00:00	SPY	ETF	104.35	104.51	104.33	104.33	39900.0
2001-09-17 09:00:00	QQQ	ETF	31.25	32.8	31.25	31.89	18433800.0
2001-09-17 10:00:00	QQQ	ETF	31.9	32.69	31.53	32.5	21866500.0
2001-09-17 11:00:00	QQQ	ETF	32.5	32.62	32.1	32.39	12883100.0
2001-09-17 12:00:00	QQQ	ETF	32.42	32.5	31.77	31.87	9075500.0
2001-09-17 13:00:00	QQQ	ETF	31.9	31.99	31.58	31.73	5990400.0
2001-09-17 14:00:00	QQQ	ETF	31.73	31.86	31.25	31.28	8122800.0
2001-09-17 15:00:00	QQQ	ETF	31.26	31.6	31.2	31.22	10664700.0
2001-09-17 16:00:00	QQQ	ETF	31.24	31.48	31.08	31.25	3750400.0
2001-09-17 17:00:00	QQQ	ETF	31.25	32.48	31.15	31.4	52600.0
2001-09-17 18:00:00	QQQ	ETF	31.39	31.4	31.35	31.35	2000.0
2001-09-17 09:00:00	IWM	ETF	41.0	41.225	41.0	41.225	48400.0
2001-09-17 10:00:00	IWM	ETF	41.3	42.345	41.075	42.295	428800.0
2001-09-17 11:00:00	IWM	ETF	42.295	42.495	41.85	42.425	306000.0
2001-09-17 12:00:00	IWM	ETF	42.445	42.495	42.3	42.325	75800.0
2001-09-17 13:00:00	IWM	ETF	42.35	42.38	42.01	42.14	86600.0
2001-09-17 14:00:00	IWM	ETF	42.105	42.225	41.725	41.905	67200.0
2001-09-17 15:00:00	IWM	ETF	41.905	41.905	41.525	41.65	120600.0
2001-09-17 16:00:00	IWM	ETF	41.575	41.75	41.0	41.0	190400.0
2001-09-17 09:00:00	DIA	ETF	90.5	91.25	89.0	90.25	1694900.0
2001-09-17 10:00:00	DIA	ETF	90.2	92.3	89.3	91.7	3489300.0
2001-09-17 11:00:00	DIA	ETF	91.52	91.9	90.7	91.56	1489800.0
2001-09-17 12:00:00	DIA	ETF	91.65	91.79	90.75	90.9	822200.0
2001-09-17 13:00:00	DIA	ETF	91.0	91.04	89.55	89.95	1645700.0
2001-09-17 14:00:00	DIA	ETF	89.93	90.2	89.0	89.09	1465700.0
2001-09-17 15:00:00	DIA	ETF	89.05	89.85	89.05	89.45	1405300.0
2001-09-17 16:00:00	DIA	ETF	89.44	91.0	88.95	89.2	565600.0
2001-09-17 17:00:00	DIA	ETF	89.07	89.2	89.05	89.2	600.0

> showing 36 of 254 rows — these rows as CSV

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