PREVIEW / etf_1hour / 2004-05-13

all etf 1-hour files

  file:    by_date/etf_1hour/2004/2004-05-13.parquet
  size:    24 KB
  rows:    675

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-13 08:00:00	SPY	ETF	110.12	110.18	109.81	109.91	211900.0
2004-05-13 09:00:00	SPY	ETF	109.93	110.27	109.73	109.99	5941400.0
2004-05-13 10:00:00	SPY	ETF	109.96	110.39	109.63	110.33	11321000.0
2004-05-13 11:00:00	SPY	ETF	110.36	110.81	110.14	110.68	9599600.0
2004-05-13 12:00:00	SPY	ETF	110.69	110.79	110.1	110.19	5465300.0
2004-05-13 13:00:00	SPY	ETF	110.21	110.39	109.88	110.02	3569700.0
2004-05-13 14:00:00	SPY	ETF	110.03	110.15	109.67	109.9	4578900.0
2004-05-13 15:00:00	SPY	ETF	109.88	110.39	109.86	110.15	7226100.0
2004-05-13 16:00:00	SPY	ETF	110.14	110.31	109.87	110.0	3184000.0
2004-05-13 17:00:00	SPY	ETF	110.0	110.06	110.0	110.0	161700.0
2004-05-13 18:00:00	SPY	ETF	110.02	110.06	110.02	110.03	1300.0
2004-05-13 19:00:00	SPY	ETF	110.03	110.05	110.0	110.0	9200.0
2004-05-13 08:00:00	QQQ	ETF	35.18	35.19	35.05	35.1	394100.0
2004-05-13 09:00:00	QQQ	ETF	35.09	35.24	35.03	35.15	15209800.0
2004-05-13 10:00:00	QQQ	ETF	35.13	35.32	34.92	35.281	24472100.0
2004-05-13 11:00:00	QQQ	ETF	35.281	35.443	35.169	35.39	17865200.0
2004-05-13 12:00:00	QQQ	ETF	35.39	35.45	35.16	35.2	13275200.0
2004-05-13 13:00:00	QQQ	ETF	35.2	35.3	35.07	35.16	14380700.0
2004-05-13 14:00:00	QQQ	ETF	35.17	35.26	35.01	35.17	19940000.0
2004-05-13 15:00:00	QQQ	ETF	35.18	35.36	35.16	35.22	20051100.0
2004-05-13 16:00:00	QQQ	ETF	35.226	35.25	34.99	35.07	6077800.0
2004-05-13 17:00:00	QQQ	ETF	35.07	35.1	35.03	35.07	827400.0
2004-05-13 18:00:00	QQQ	ETF	35.09	35.09	35.05	35.08	51200.0
2004-05-13 19:00:00	QQQ	ETF	35.07	35.09	35.06	35.07	9600.0
2004-05-13 08:00:00	IWM	ETF	54.95	54.97	54.54	54.63	59200.0
2004-05-13 09:00:00	IWM	ETF	54.6	55.03	54.54	54.625	3311600.0
2004-05-13 10:00:00	IWM	ETF	54.645	55.015	54.38	54.91	2946200.0
2004-05-13 11:00:00	IWM	ETF	54.885	55.15	54.615	55.105	2860000.0
2004-05-13 12:00:00	IWM	ETF	55.1	55.165	54.665	54.685	2629600.0
2004-05-13 13:00:00	IWM	ETF	54.65	54.855	54.54	54.675	1038400.0
2004-05-13 14:00:00	IWM	ETF	54.665	54.72	54.215	54.46	4033800.0
2004-05-13 15:00:00	IWM	ETF	54.44	54.795	54.44	54.46	2398400.0
2004-05-13 16:00:00	IWM	ETF	54.5	54.52	54.285	54.32	402400.0
2004-05-13 19:00:00	IWM	ETF	54.305	54.305	54.305	54.305	1000.0
2004-05-13 08:00:00	DIA	ETF	100.64	100.72	100.4	100.47	26400.0
2004-05-13 09:00:00	DIA	ETF	100.42	100.65	100.13	100.27	1569200.0
2004-05-13 10:00:00	DIA	ETF	100.27	100.62	100.0	100.49	1658800.0
2004-05-13 11:00:00	DIA	ETF	100.49	101.08	100.35	100.97	1425600.0
2004-05-13 12:00:00	DIA	ETF	100.96	101.06	100.48	100.61	1277100.0
2004-05-13 13:00:00	DIA	ETF	100.6	100.73	100.2	100.36	761700.0
2004-05-13 14:00:00	DIA	ETF	100.38	100.47	100.05	100.21	866500.0
2004-05-13 15:00:00	DIA	ETF	100.2	100.72	100.2	100.42	1505100.0
2004-05-13 16:00:00	DIA	ETF	100.4	100.5	100.16	100.26	249300.0
2004-05-13 08:00:00	TLT	ETF	80.81	80.81	80.8	80.8	1200.0
2004-05-13 09:00:00	TLT	ETF	80.89	80.92	80.73	80.83	62600.0
2004-05-13 10:00:00	TLT	ETF	80.83	80.9	80.7	80.75	242100.0
2004-05-13 11:00:00	TLT	ETF	80.71	80.82	80.63	80.63	103800.0
2004-05-13 12:00:00	TLT	ETF	80.68	80.72	80.51	80.6	325900.0
2004-05-13 13:00:00	TLT	ETF	80.6	80.86	80.6	80.73	208100.0
2004-05-13 14:00:00	TLT	ETF	80.72	80.78	80.56	80.63	37000.0

> showing 50 of 675 rows — these rows as CSV

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