PREVIEW / etf_1hour / 2001-03-20

all etf 1-hour files

  file:    by_date/etf_1hour/2001/2001-03-20.parquet
  size:    11 KB
  rows:    227

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-20 09:00:00	SPY	ETF	117.9	117.9	117.03	117.15	1068800.0
2001-03-20 10:00:00	SPY	ETF	117.12	118.0	117.0	117.65	1155900.0
2001-03-20 11:00:00	SPY	ETF	117.65	118.18	117.5	118.14	993200.0
2001-03-20 12:00:00	SPY	ETF	118.01	118.26	117.66	117.66	614700.0
2001-03-20 13:00:00	SPY	ETF	117.66	118.27	117.56	118.03	716000.0
2001-03-20 14:00:00	SPY	ETF	117.99	118.46	116.25	116.56	4764400.0
2001-03-20 15:00:00	SPY	ETF	116.71	116.71	114.22	114.25	3595400.0
2001-03-20 16:00:00	SPY	ETF	114.15	114.62	114.0	114.0	1497000.0
2001-03-20 17:00:00	SPY	ETF	113.85	114.3	113.85	113.89	3800.0
2001-03-20 09:00:00	QQQ	ETF	43.44	43.69	42.91	43.13	11039300.0
2001-03-20 10:00:00	QQQ	ETF	43.08	43.55	42.92	43.24	8421900.0
2001-03-20 11:00:00	QQQ	ETF	43.21	43.4	42.94	43.37	7230100.0
2001-03-20 12:00:00	QQQ	ETF	43.35	43.45	42.88	42.91	8224100.0
2001-03-20 13:00:00	QQQ	ETF	42.91	43.6	42.82	43.3	7022000.0
2001-03-20 14:00:00	QQQ	ETF	43.25	43.81	41.65	41.76	31233800.0
2001-03-20 15:00:00	QQQ	ETF	41.78	41.9	40.2	40.2	24986500.0
2001-03-20 16:00:00	QQQ	ETF	40.2	41.0	40.0	40.25	2575300.0
2001-03-20 17:00:00	QQQ	ETF	40.25	40.45	40.02	40.06	213500.0
2001-03-20 18:00:00	QQQ	ETF	40.08	40.2	40.0	40.19	21400.0
2001-03-20 09:00:00	IWM	ETF	45.05	45.085	44.85	44.85	34800.0
2001-03-20 10:00:00	IWM	ETF	44.9	45.4	44.9	45.25	85800.0
2001-03-20 11:00:00	IWM	ETF	45.275	45.525	45.2	45.45	66800.0
2001-03-20 12:00:00	IWM	ETF	45.45	45.58	45.4	45.4	33600.0
2001-03-20 13:00:00	IWM	ETF	45.35	45.475	45.25	45.375	24000.0
2001-03-20 14:00:00	IWM	ETF	45.27	45.5	44.75	44.99	170800.0
2001-03-20 15:00:00	IWM	ETF	44.75	44.9	44.15	44.175	198000.0
2001-03-20 16:00:00	IWM	ETF	44.1	44.1	44.1	44.1	9000.0
2001-03-20 09:00:00	DIA	ETF	100.05	100.05	99.26	99.35	618200.0
2001-03-20 10:00:00	DIA	ETF	99.35	100.04	99.25	99.7	149700.0
2001-03-20 11:00:00	DIA	ETF	99.62	100.35	99.55	100.1	223700.0
2001-03-20 12:00:00	DIA	ETF	100.07	100.28	99.9	99.9	269600.0
2001-03-20 13:00:00	DIA	ETF	99.94	100.28	99.75	100.1	260700.0
2001-03-20 14:00:00	DIA	ETF	100.0	100.7	98.5	99.05	1545100.0
2001-03-20 15:00:00	DIA	ETF	99.02	99.1	97.01	97.13	1313200.0
2001-03-20 16:00:00	DIA	ETF	97.0	97.4	95.53	96.25	214400.0
2001-03-20 17:00:00	DIA	ETF	96.97	97.01	96.5	97.0	4200.0
2001-03-20 18:00:00	DIA	ETF	97.0	97.0	97.0	97.0	600.0

> showing 37 of 227 rows — these rows as CSV

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