PREVIEW / etf_1hour / 2004-05-17

all etf 1-hour files

  file:    by_date/etf_1hour/2004/2004-05-17.parquet
  size:    25 KB
  rows:    703

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-17 08:00:00	SPY	ETF	108.9	109.01	108.76	108.76	113400.0
2004-05-17 09:00:00	SPY	ETF	108.78	109.12	108.7	108.88	7395600.0
2004-05-17 10:00:00	SPY	ETF	108.87	109.25	108.41	108.95	15142900.0
2004-05-17 11:00:00	SPY	ETF	108.97	109.5	108.8	109.38	6033800.0
2004-05-17 12:00:00	SPY	ETF	109.37	109.48	108.83	109.08	3652300.0
2004-05-17 13:00:00	SPY	ETF	109.07	109.165	108.71	108.93	3709900.0
2004-05-17 14:00:00	SPY	ETF	108.94	109.31	108.87	109.08	4500200.0
2004-05-17 15:00:00	SPY	ETF	109.08	109.42	108.66	108.861	6447100.0
2004-05-17 16:00:00	SPY	ETF	108.84	109.15	108.81	109.07	3680400.0
2004-05-17 17:00:00	SPY	ETF	109.08	109.08	109.05	109.05	82500.0
2004-05-17 18:00:00	SPY	ETF	109.07	109.26	109.06	109.23	24300.0
2004-05-17 19:00:00	SPY	ETF	109.13	109.13	109.11	109.13	6800.0
2004-05-17 08:00:00	QQQ	ETF	34.3	34.38	34.27	34.35	786200.0
2004-05-17 09:00:00	QQQ	ETF	34.34	34.45	34.24	34.3	16728700.0
2004-05-17 10:00:00	QQQ	ETF	34.3	34.43	34.11	34.321	37048100.0
2004-05-17 11:00:00	QQQ	ETF	34.321	34.615	34.225	34.508	17683400.0
2004-05-17 12:00:00	QQQ	ETF	34.52	34.564	34.28	34.37	10572200.0
2004-05-17 13:00:00	QQQ	ETF	34.35	34.43	34.19	34.28	13802400.0
2004-05-17 14:00:00	QQQ	ETF	34.28	34.5	34.26	34.417	20600200.0
2004-05-17 15:00:00	QQQ	ETF	34.418	34.54	34.25	34.33	20915000.0
2004-05-17 16:00:00	QQQ	ETF	34.33	34.46	34.28	34.44	3223200.0
2004-05-17 17:00:00	QQQ	ETF	34.44	34.47	34.43	34.45	44400.0
2004-05-17 18:00:00	QQQ	ETF	34.45	34.49	34.44	34.49	39400.0
2004-05-17 19:00:00	QQQ	ETF	34.49	34.49	34.44	34.48	13200.0
2004-05-17 08:00:00	IWM	ETF	53.425	53.425	53.3	53.3	11000.0
2004-05-17 09:00:00	IWM	ETF	53.3	53.35	52.765	53.15	3043600.0
2004-05-17 10:00:00	IWM	ETF	53.125	53.65	52.755	53.19	4124400.0
2004-05-17 11:00:00	IWM	ETF	53.16	53.55	53.05	53.505	2304400.0
2004-05-17 12:00:00	IWM	ETF	53.515	53.575	53.3	53.42	1509000.0
2004-05-17 13:00:00	IWM	ETF	53.42	53.51	53.25	53.385	1332600.0
2004-05-17 14:00:00	IWM	ETF	53.38	53.735	53.345	53.675	1564400.0
2004-05-17 15:00:00	IWM	ETF	53.72	53.925	53.27	53.405	3477400.0
2004-05-17 16:00:00	IWM	ETF	53.385	53.56	53.275	53.395	811800.0
2004-05-17 18:00:00	IWM	ETF	53.535	53.535	53.525	53.525	16000.0
2004-05-17 08:00:00	DIA	ETF	99.47	99.58	99.35	99.35	24700.0
2004-05-17 09:00:00	DIA	ETF	99.36	99.63	99.24	99.33	757600.0
2004-05-17 10:00:00	DIA	ETF	99.34	99.78	99.0	99.52	1983800.0
2004-05-17 11:00:00	DIA	ETF	99.52	99.97	99.33	99.75	721900.0
2004-05-17 12:00:00	DIA	ETF	99.77	99.889	99.35	99.55	317000.0
2004-05-17 13:00:00	DIA	ETF	99.56	99.6	99.25	99.43	437200.0
2004-05-17 14:00:00	DIA	ETF	99.45	99.71	99.36	99.47	589300.0
2004-05-17 15:00:00	DIA	ETF	99.47	99.72	99.16	99.4	1338900.0
2004-05-17 16:00:00	DIA	ETF	99.38	99.59	99.31	99.59	112800.0
2004-05-17 17:00:00	DIA	ETF	99.54	99.54	99.54	99.54	900.0
2004-05-17 18:00:00	DIA	ETF	99.54	99.63	99.54	99.63	1100.0
2004-05-17 19:00:00	DIA	ETF	99.68	99.68	99.68	99.68	500.0
2004-05-17 08:00:00	TLT	ETF	81.63	81.65	81.63	81.65	2600.0
2004-05-17 09:00:00	TLT	ETF	81.6	81.87	81.6	81.77	261800.0
2004-05-17 10:00:00	TLT	ETF	81.77	81.85	81.71	81.78	205500.0
2004-05-17 11:00:00	TLT	ETF	81.77	81.92	81.77	81.87	440700.0

> showing 50 of 703 rows — these rows as CSV

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