PREVIEW / etf_1hour / 2004-05-11

all etf 1-hour files

  file:    by_date/etf_1hour/2004/2004-05-11.parquet
  size:    25 KB
  rows:    717

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
2004-05-11 08:00:00	SPY	ETF	109.35	109.51	109.3	109.48	248000.0
2004-05-11 09:00:00	SPY	ETF	109.47	109.89	109.35	109.74	8095800.0
2004-05-11 10:00:00	SPY	ETF	109.76	109.96	109.52	109.72	4945500.0
2004-05-11 11:00:00	SPY	ETF	109.73	110.05	109.7	109.82	4672900.0
2004-05-11 12:00:00	SPY	ETF	109.82	109.94	109.7	109.79	2541200.0
2004-05-11 13:00:00	SPY	ETF	109.78	109.83	109.33	109.47	4512600.0
2004-05-11 14:00:00	SPY	ETF	109.47	109.9	109.42	109.7	4891100.0
2004-05-11 15:00:00	SPY	ETF	109.71	110.04	109.52	110.01	4836900.0
2004-05-11 16:00:00	SPY	ETF	110.01	110.05	109.59	109.82	3098000.0
2004-05-11 17:00:00	SPY	ETF	109.84	109.85	108.2	109.51	423500.0
2004-05-11 18:00:00	SPY	ETF	109.5	109.56	109.41	109.55	39900.0
2004-05-11 19:00:00	SPY	ETF	109.55	109.55	109.5	109.52	1400.0
2004-05-11 08:00:00	QQQ	ETF	34.86	34.98	34.86	34.95	613800.0
2004-05-11 09:00:00	QQQ	ETF	34.96	35.164	34.91	35.117	16553300.0
2004-05-11 10:00:00	QQQ	ETF	35.12	35.29	35.03	35.2	21239300.0
2004-05-11 11:00:00	QQQ	ETF	35.185	35.38	35.17	35.28	13739700.0
2004-05-11 12:00:00	QQQ	ETF	35.28	35.34	35.19	35.25	4703600.0
2004-05-11 13:00:00	QQQ	ETF	35.242	35.28	35.06	35.128	9244600.0
2004-05-11 14:00:00	QQQ	ETF	35.129	35.33	35.1	35.28	11716700.0
2004-05-11 15:00:00	QQQ	ETF	35.28	35.35	35.16	35.3	15715400.0
2004-05-11 16:00:00	QQQ	ETF	35.3	35.35	35.098	35.281	5512000.0
2004-05-11 17:00:00	QQQ	ETF	35.28	35.29	35.06	35.1	932700.0
2004-05-11 18:00:00	QQQ	ETF	35.1	35.13	35.08	35.13	73600.0
2004-05-11 19:00:00	QQQ	ETF	35.13	35.13	35.1	35.11	33700.0
2004-05-11 08:00:00	IWM	ETF	53.87	53.99	53.87	53.97	44400.0
2004-05-11 09:00:00	IWM	ETF	53.98	54.525	53.75	54.35	6251000.0
2004-05-11 10:00:00	IWM	ETF	54.35	54.6	54.135	54.455	4395200.0
2004-05-11 11:00:00	IWM	ETF	54.45	54.745	54.425	54.66	1176600.0
2004-05-11 12:00:00	IWM	ETF	54.66	54.71	54.535	54.66	629800.0
2004-05-11 13:00:00	IWM	ETF	54.67	54.685	54.24	54.275	1429200.0
2004-05-11 14:00:00	IWM	ETF	54.27	54.645	54.27	54.49	1851200.0
2004-05-11 15:00:00	IWM	ETF	54.495	54.79	54.4	54.79	2947000.0
2004-05-11 16:00:00	IWM	ETF	54.8	54.81	54.585	54.71	326800.0
2004-05-11 17:00:00	IWM	ETF	54.625	54.625	54.45	54.45	23200.0
2004-05-11 18:00:00	IWM	ETF	54.45	54.45	54.45	54.45	1200.0
2004-05-11 08:00:00	DIA	ETF	100.34	100.43	100.3	100.38	17300.0
2004-05-11 09:00:00	DIA	ETF	100.41	100.57	100.25	100.42	1383200.0
2004-05-11 10:00:00	DIA	ETF	100.43	100.59	100.16	100.36	1547300.0
2004-05-11 11:00:00	DIA	ETF	100.38	100.65	100.35	100.45	717400.0
2004-05-11 12:00:00	DIA	ETF	100.45	100.53	100.31	100.37	274400.0
2004-05-11 13:00:00	DIA	ETF	100.41	100.41	100.0	100.09	979400.0
2004-05-11 14:00:00	DIA	ETF	100.09	100.43	100.08	100.27	656100.0
2004-05-11 15:00:00	DIA	ETF	100.26	100.46	100.05	100.46	1746700.0
2004-05-11 16:00:00	DIA	ETF	100.48	100.48	100.13	100.36	143700.0
2004-05-11 17:00:00	DIA	ETF	100.3	100.3	100.15	100.15	10200.0
2004-05-11 18:00:00	DIA	ETF	100.27	100.29	100.17	100.17	21600.0
2004-05-11 09:00:00	TLT	ETF	81.11	81.25	81.11	81.21	102200.0
2004-05-11 10:00:00	TLT	ETF	81.14	81.28	81.14	81.25	67100.0
2004-05-11 11:00:00	TLT	ETF	81.25	81.48	81.25	81.36	134200.0
2004-05-11 12:00:00	TLT	ETF	81.38	81.38	81.27	81.35	22400.0

> showing 50 of 717 rows — these rows as CSV

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