PREVIEW / etf_1hour / 2001-03-09

all etf 1-hour files

  file:    by_date/etf_1hour/2001/2001-03-09.parquet
  size:    11 KB
  rows:    225

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-03-09 09:00:00	SPY	ETF	126.1	126.1	124.94	125.1	1418100.0
2001-03-09 10:00:00	SPY	ETF	125.05	125.1	123.8	124.3	1905400.0
2001-03-09 11:00:00	SPY	ETF	124.3	124.42	123.76	124.27	902400.0
2001-03-09 12:00:00	SPY	ETF	124.4	124.48	123.91	123.94	927200.0
2001-03-09 13:00:00	SPY	ETF	124.0	124.38	123.88	124.25	796500.0
2001-03-09 14:00:00	SPY	ETF	124.32	124.39	123.37	123.58	1136600.0
2001-03-09 15:00:00	SPY	ETF	123.5	124.32	123.11	123.67	2164800.0
2001-03-09 16:00:00	SPY	ETF	123.6	123.82	123.36	123.36	347400.0
2001-03-09 09:00:00	QQQ	ETF	47.25	47.37	46.54	46.67	10088200.0
2001-03-09 10:00:00	QQQ	ETF	46.6	46.69	45.9	46.0	14385300.0
2001-03-09 11:00:00	QQQ	ETF	45.98	46.12	45.51	45.83	9394000.0
2001-03-09 12:00:00	QQQ	ETF	45.84	46.05	45.35	45.48	5618400.0
2001-03-09 13:00:00	QQQ	ETF	45.54	45.88	45.4	45.83	4549000.0
2001-03-09 14:00:00	QQQ	ETF	45.85	45.9	45.07	45.12	10427300.0
2001-03-09 15:00:00	QQQ	ETF	45.1	45.9	44.95	45.2	18022800.0
2001-03-09 16:00:00	QQQ	ETF	45.32	45.51	45.0	45.01	2022500.0
2001-03-09 17:00:00	QQQ	ETF	45.02	45.85	45.0	45.78	42900.0
2001-03-09 18:00:00	QQQ	ETF	45.04	45.2	45.0	45.04	6700.0
2001-03-09 09:00:00	IWM	ETF	47.3	47.4	47.2	47.3	66200.0
2001-03-09 10:00:00	IWM	ETF	47.255	47.255	47.0	47.25	55600.0
2001-03-09 11:00:00	IWM	ETF	47.05	47.225	47.025	47.225	8800.0
2001-03-09 12:00:00	IWM	ETF	47.25	47.345	47.1	47.345	56200.0
2001-03-09 13:00:00	IWM	ETF	47.29	47.4	47.15	47.25	6000.0
2001-03-09 14:00:00	IWM	ETF	47.3	47.425	47.17	47.2	7400.0
2001-03-09 15:00:00	IWM	ETF	47.0	47.775	47.0	47.225	24200.0
2001-03-09 16:00:00	IWM	ETF	46.955	47.055	46.955	47.055	800.0
2001-03-09 09:00:00	DIA	ETF	108.0	108.0	107.41	107.45	580300.0
2001-03-09 10:00:00	DIA	ETF	107.45	107.55	106.51	106.83	630500.0
2001-03-09 11:00:00	DIA	ETF	106.83	107.1	106.52	107.01	320300.0
2001-03-09 12:00:00	DIA	ETF	107.02	107.26	106.75	106.8	221900.0
2001-03-09 13:00:00	DIA	ETF	106.75	107.0	106.6	106.89	88500.0
2001-03-09 14:00:00	DIA	ETF	106.85	106.96	106.11	106.34	211200.0
2001-03-09 15:00:00	DIA	ETF	106.34	106.75	105.75	106.46	830200.0
2001-03-09 16:00:00	DIA	ETF	106.49	106.55	105.95	106.3	177000.0

> showing 34 of 225 rows — these rows as CSV

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