PREVIEW / etf_1hour / 2001-01-29

all etf 1-hour files

  file:    by_date/etf_1hour/2001/2001-01-29.parquet
  size:    11 KB
  rows:    202

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-01-29 09:00:00	SPY	ETF	135.5	136.1	135.37	135.87	869300.0
2001-01-29 10:00:00	SPY	ETF	135.86	136.0	135.54	135.98	1038700.0
2001-01-29 11:00:00	SPY	ETF	135.87	136.35	135.53	136.16	1114800.0
2001-01-29 12:00:00	SPY	ETF	136.14	136.21	135.95	136.14	452700.0
2001-01-29 13:00:00	SPY	ETF	136.08	136.49	136.0	136.49	590700.0
2001-01-29 14:00:00	SPY	ETF	136.37	136.82	136.28	136.79	403000.0
2001-01-29 15:00:00	SPY	ETF	136.79	136.9	136.53	136.65	1077000.0
2001-01-29 16:00:00	SPY	ETF	136.61	136.73	136.16	136.6	406200.0
2001-01-29 09:00:00	QQQ	ETF	64.75	65.42	64.25	65.21	4647500.0
2001-01-29 10:00:00	QQQ	ETF	65.27	65.39	64.53	65.05	4172100.0
2001-01-29 11:00:00	QQQ	ETF	65.07	65.87	64.75	65.65	4108900.0
2001-01-29 12:00:00	QQQ	ETF	65.69	65.83	65.35	65.79	2761500.0
2001-01-29 13:00:00	QQQ	ETF	65.8	66.4	65.65	66.4	3019800.0
2001-01-29 14:00:00	QQQ	ETF	66.41	67.15	66.3	66.83	5563300.0
2001-01-29 15:00:00	QQQ	ETF	66.85	67.25	66.75	67.1	4891000.0
2001-01-29 16:00:00	QQQ	ETF	67.08	67.13	66.95	67.02	595000.0
2001-01-29 17:00:00	QQQ	ETF	67.05	67.15	67.0	67.05	10500.0
2001-01-29 18:00:00	QQQ	ETF	67.05	67.1	67.0	67.1	6300.0
2001-01-29 09:00:00	IWM	ETF	49.695	50.15	49.695	50.15	9800.0
2001-01-29 10:00:00	IWM	ETF	50.15	50.225	50.025	50.195	173400.0
2001-01-29 11:00:00	IWM	ETF	50.22	50.45	50.205	50.45	63600.0
2001-01-29 12:00:00	IWM	ETF	50.45	50.475	50.45	50.47	11200.0
2001-01-29 13:00:00	IWM	ETF	50.465	50.575	50.38	50.5	155600.0
2001-01-29 14:00:00	IWM	ETF	50.5	50.645	50.5	50.515	60200.0
2001-01-29 15:00:00	IWM	ETF	50.62	50.725	50.375	50.7	48800.0
2001-01-29 16:00:00	IWM	ETF	50.7	50.825	50.7	50.825	3400.0
2001-01-29 09:00:00	DIA	ETF	106.61	106.86	106.58	106.7	92200.0
2001-01-29 10:00:00	DIA	ETF	106.65	106.79	106.32	106.32	89100.0
2001-01-29 11:00:00	DIA	ETF	106.32	106.77	106.15	106.58	71800.0
2001-01-29 12:00:00	DIA	ETF	106.64	106.8	106.56	106.74	26000.0
2001-01-29 13:00:00	DIA	ETF	106.72	106.83	106.62	106.83	70600.0
2001-01-29 14:00:00	DIA	ETF	106.83	107.2	106.83	107.2	72000.0
2001-01-29 15:00:00	DIA	ETF	107.1	107.36	106.96	107.0	81000.0
2001-01-29 16:00:00	DIA	ETF	107.13	107.15	106.95	107.1	65900.0

> showing 34 of 202 rows — these rows as CSV

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