PREVIEW / etf_1hour / 2001-11-05

all etf 1-hour files

  file:    by_date/etf_1hour/2001/2001-11-05.parquet
  size:    12 KB
  rows:    235

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-11-05 09:00:00	SPY	ETF	110.12	110.8	109.95	110.63	3961500.0
2001-11-05 10:00:00	SPY	ETF	110.61	111.09	110.36	110.78	2972100.0
2001-11-05 11:00:00	SPY	ETF	110.78	110.94	110.25	110.25	1994300.0
2001-11-05 12:00:00	SPY	ETF	110.27	110.48	110.15	110.31	1427000.0
2001-11-05 13:00:00	SPY	ETF	110.28	110.82	110.22	110.79	1340100.0
2001-11-05 14:00:00	SPY	ETF	110.72	110.94	110.55	110.89	1019100.0
2001-11-05 15:00:00	SPY	ETF	110.87	111.05	110.32	110.58	2373900.0
2001-11-05 16:00:00	SPY	ETF	110.61	111.08	107.76	111.0	812500.0
2001-11-05 17:00:00	SPY	ETF	111.1	111.24	110.7	110.8	25700.0
2001-11-05 18:00:00	SPY	ETF	110.62	110.9	110.5	110.9	112700.0
2001-11-05 09:00:00	QQQ	ETF	36.26	36.67	36.16	36.46	10335100.0
2001-11-05 10:00:00	QQQ	ETF	36.47	36.8	36.3	36.62	11385800.0
2001-11-05 11:00:00	QQQ	ETF	36.63	36.84	36.52	36.54	5996900.0
2001-11-05 12:00:00	QQQ	ETF	36.54	36.72	36.51	36.7	2883200.0
2001-11-05 13:00:00	QQQ	ETF	36.69	37.01	36.66	36.96	6644400.0
2001-11-05 14:00:00	QQQ	ETF	36.96	37.1	36.82	37.1	7159800.0
2001-11-05 15:00:00	QQQ	ETF	37.04	37.16	36.7	36.84	14304200.0
2001-11-05 16:00:00	QQQ	ETF	36.82	37.41	36.74	37.2	3335700.0
2001-11-05 17:00:00	QQQ	ETF	37.2	37.39	36.9	37.28	724100.0
2001-11-05 18:00:00	QQQ	ETF	37.3	37.31	37.24	37.26	194900.0
2001-11-05 10:00:00	IWM	ETF	43.6	43.65	43.465	43.5	47600.0
2001-11-05 11:00:00	IWM	ETF	43.5	43.65	43.475	43.535	78200.0
2001-11-05 12:00:00	IWM	ETF	43.5	43.525	43.42	43.42	13000.0
2001-11-05 13:00:00	IWM	ETF	43.42	43.5	43.4	43.5	11200.0
2001-11-05 14:00:00	IWM	ETF	43.55	43.55	43.44	43.495	56400.0
2001-11-05 15:00:00	IWM	ETF	43.495	43.58	43.31	43.485	46200.0
2001-11-05 16:00:00	IWM	ETF	43.625	43.625	43.54	43.54	43600.0
2001-11-05 17:00:00	IWM	ETF	43.625	43.625	43.625	43.625	2000.0
2001-11-05 09:00:00	DIA	ETF	94.25	94.64	94.05	94.45	378800.0
2001-11-05 10:00:00	DIA	ETF	94.45	94.87	94.35	94.56	537900.0
2001-11-05 11:00:00	DIA	ETF	94.54	94.74	94.18	94.18	367700.0
2001-11-05 12:00:00	DIA	ETF	94.18	94.42	94.1	94.21	196800.0
2001-11-05 13:00:00	DIA	ETF	94.24	94.67	94.2	94.55	122100.0
2001-11-05 14:00:00	DIA	ETF	94.6	94.75	94.46	94.75	156300.0
2001-11-05 15:00:00	DIA	ETF	94.7	94.86	94.28	94.5	349000.0
2001-11-05 16:00:00	DIA	ETF	94.45	94.68	94.32	94.68	110300.0
2001-11-05 17:00:00	DIA	ETF	94.68	94.68	94.68	94.68	100.0

> showing 37 of 235 rows — these rows as CSV

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