PREVIEW / etf_1hour / 2003-11-14

all etf 1-hour files

  file:    by_date/etf_1hour/2003/2003-11-14.parquet
  size:    19 KB
  rows:    488

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
2003-11-14 08:00:00	SPY	ETF	106.38	106.53	106.27	106.38	335200.0
2003-11-14 09:00:00	SPY	ETF	106.36	106.95	106.3	106.82	5763900.0
2003-11-14 10:00:00	SPY	ETF	106.82	106.84	106.0	106.12	8201600.0
2003-11-14 11:00:00	SPY	ETF	106.11	106.38	106.08	106.33	2295100.0
2003-11-14 12:00:00	SPY	ETF	106.35	106.44	106.25	106.38	1882300.0
2003-11-14 13:00:00	SPY	ETF	106.39	106.5	106.18	106.25	1612100.0
2003-11-14 14:00:00	SPY	ETF	106.25	106.28	105.47	105.6	9894800.0
2003-11-14 15:00:00	SPY	ETF	105.62	105.75	105.29	105.55	7926900.0
2003-11-14 16:00:00	SPY	ETF	105.54	105.64	105.36	105.46	2261400.0
2003-11-14 17:00:00	SPY	ETF	105.43	105.43	105.3	105.31	5300.0
2003-11-14 18:00:00	SPY	ETF	105.35	105.35	105.35	105.35	100.0
2003-11-14 19:00:00	SPY	ETF	105.4	105.4	105.4	105.4	400.0
2003-11-14 20:00:00	SPY	ETF	105.4	105.4	105.4	105.4	100.0
2003-11-14 08:00:00	QQQ	ETF	35.79	35.86	35.7	35.74	163500.0
2003-11-14 09:00:00	QQQ	ETF	35.78	36.02	35.75	35.95	7841300.0
2003-11-14 10:00:00	QQQ	ETF	35.96	35.962	35.32	35.34	19609400.0
2003-11-14 11:00:00	QQQ	ETF	35.34	35.54	35.32	35.49	9034600.0
2003-11-14 12:00:00	QQQ	ETF	35.491	35.551	35.43	35.5	3736400.0
2003-11-14 13:00:00	QQQ	ETF	35.491	35.57	35.36	35.42	4902300.0
2003-11-14 14:00:00	QQQ	ETF	35.42	35.43	35.12	35.16	12655500.0
2003-11-14 15:00:00	QQQ	ETF	35.141	35.194	34.99	35.01	18883800.0
2003-11-14 16:00:00	QQQ	ETF	35.02	35.06	34.95	35.01	4034700.0
2003-11-14 17:00:00	QQQ	ETF	35.03	35.05	34.99	35.039	127400.0
2003-11-14 18:00:00	QQQ	ETF	35.05	35.08	35.03	35.05	24200.0
2003-11-14 19:00:00	QQQ	ETF	35.06	35.1	35.04	35.09	12000.0
2003-11-14 09:00:00	IWM	ETF	54.115	54.47	54.095	54.41	482600.0
2003-11-14 10:00:00	IWM	ETF	54.435	54.44	53.575	53.61	1041600.0
2003-11-14 11:00:00	IWM	ETF	53.585	53.815	53.575	53.76	473600.0
2003-11-14 12:00:00	IWM	ETF	53.77	53.85	53.74	53.775	171000.0
2003-11-14 13:00:00	IWM	ETF	53.775	53.86	53.65	53.725	408400.0
2003-11-14 14:00:00	IWM	ETF	53.68	53.685	53.195	53.25	1125000.0
2003-11-14 15:00:00	IWM	ETF	53.21	53.37	53.095	53.16	1775600.0
2003-11-14 16:00:00	IWM	ETF	53.195	53.195	53.01	53.1	358200.0
2003-11-14 08:00:00	DIA	ETF	98.7	98.75	98.67	98.68	25600.0
2003-11-14 09:00:00	DIA	ETF	98.72	99.305	98.68	99.18	788900.0
2003-11-14 10:00:00	DIA	ETF	99.18	99.219	98.54	98.65	711700.0
2003-11-14 11:00:00	DIA	ETF	98.66	98.88	98.62	98.84	440700.0
2003-11-14 12:00:00	DIA	ETF	98.8	98.9	98.65	98.738	284600.0
2003-11-14 13:00:00	DIA	ETF	98.75	98.85	98.64	98.71	137600.0
2003-11-14 14:00:00	DIA	ETF	98.67	98.67	97.925	98.02	974400.0
2003-11-14 15:00:00	DIA	ETF	98.02	98.22	97.74	98.033	1244000.0
2003-11-14 16:00:00	DIA	ETF	98.033	98.09	97.95	98.0	994300.0
2003-11-14 17:00:00	DIA	ETF	98.0	98.0	97.93	97.95	16700.0
2003-11-14 18:00:00	DIA	ETF	97.96	97.96	97.95	97.95	200.0
2003-11-14 19:00:00	DIA	ETF	97.97	97.97	97.97	97.97	100.0
2003-11-14 09:00:00	TLT	ETF	85.3	85.4	85.2	85.37	46000.0
2003-11-14 10:00:00	TLT	ETF	85.46	85.9	85.46	85.75	175200.0
2003-11-14 11:00:00	TLT	ETF	85.78	85.85	85.66	85.82	50200.0
2003-11-14 12:00:00	TLT	ETF	85.82	85.87	85.65	85.65	28700.0
2003-11-14 13:00:00	TLT	ETF	85.65	85.75	85.56	85.62	42000.0

> showing 50 of 488 rows — these rows as CSV

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