PREVIEW / etf_1hour / 2004-09-13

all etf 1-hour files

  file:    by_date/etf_1hour/2004/2004-09-13.parquet
  size:    25 KB
  rows:    705

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-09-13 08:00:00	SPY	ETF	113.3	113.39	113.22	113.37	114800.0
2004-09-13 09:00:00	SPY	ETF	113.35	113.35	113.09	113.23	3851600.0
2004-09-13 10:00:00	SPY	ETF	113.23	113.49	113.19	113.47	9383700.0
2004-09-13 11:00:00	SPY	ETF	113.47	113.64	113.44	113.5	3576900.0
2004-09-13 12:00:00	SPY	ETF	113.49	113.71	113.49	113.62	3294900.0
2004-09-13 13:00:00	SPY	ETF	113.61	113.74	113.36	113.41	4358300.0
2004-09-13 14:00:00	SPY	ETF	113.41	113.56	113.32	113.34	4635600.0
2004-09-13 15:00:00	SPY	ETF	113.34	113.45	113.01	113.31	9678900.0
2004-09-13 16:00:00	SPY	ETF	113.3	113.51	113.27	113.48	3541800.0
2004-09-13 17:00:00	SPY	ETF	113.46	113.48	113.4008	113.48	551800.0
2004-09-13 18:00:00	SPY	ETF	113.42	113.42	113.42	113.42	300.0
2004-09-13 19:00:00	SPY	ETF	113.43	113.48	113.4	113.4	1200.0
2004-09-13 08:00:00	QQQ	ETF	35.26	35.29	35.22	35.26	252700.0
2004-09-13 09:00:00	QQQ	ETF	35.27	35.33	35.151	35.281	14103000.0
2004-09-13 10:00:00	QQQ	ETF	35.281	35.54	35.23	35.52	22204800.0
2004-09-13 11:00:00	QQQ	ETF	35.51	35.68	35.51	35.576	13974500.0
2004-09-13 12:00:00	QQQ	ETF	35.576	35.7	35.57	35.68	8862800.0
2004-09-13 13:00:00	QQQ	ETF	35.67	35.72	35.53	35.535	11813000.0
2004-09-13 14:00:00	QQQ	ETF	35.53	35.634	35.51	35.51	10996400.0
2004-09-13 15:00:00	QQQ	ETF	35.51	35.57	35.35	35.44	20138400.0
2004-09-13 16:00:00	QQQ	ETF	35.44	35.591	35.4	35.57	4051500.0
2004-09-13 17:00:00	QQQ	ETF	35.57	35.58	35.55	35.56	77600.0
2004-09-13 18:00:00	QQQ	ETF	35.56	35.56	35.55	35.55	23200.0
2004-09-13 19:00:00	QQQ	ETF	35.56	35.57	35.56	35.57	6500.0
2004-09-13 08:00:00	IWM	ETF	56.905	57.025	56.9	57.025	20200.0
2004-09-13 09:00:00	IWM	ETF	56.97	57.17	56.88	57.055	1732200.0
2004-09-13 10:00:00	IWM	ETF	57.055	57.33	57.0	57.33	2826600.0
2004-09-13 11:00:00	IWM	ETF	57.33	57.44	57.275	57.3	1050000.0
2004-09-13 12:00:00	IWM	ETF	57.285	57.415	57.285	57.335	1239200.0
2004-09-13 13:00:00	IWM	ETF	57.345	57.4	57.125	57.19	1100400.0
2004-09-13 14:00:00	IWM	ETF	57.2	57.345	57.135	57.165	872800.0
2004-09-13 15:00:00	IWM	ETF	57.17	57.245	57.01	57.13	1768400.0
2004-09-13 16:00:00	IWM	ETF	57.1	57.225	57.09	57.225	304200.0
2004-09-13 08:00:00	DIA	ETF	103.56	103.56	103.5	103.53	5600.0
2004-09-13 09:00:00	DIA	ETF	103.5	103.53	103.29	103.37	829900.0
2004-09-13 10:00:00	DIA	ETF	103.39	103.55	103.34	103.51	616400.0
2004-09-13 11:00:00	DIA	ETF	103.52	103.64	103.48	103.55	642100.0
2004-09-13 12:00:00	DIA	ETF	103.54	103.69	103.54	103.62	268000.0
2004-09-13 13:00:00	DIA	ETF	103.62	103.72	103.45	103.5	448200.0
2004-09-13 14:00:00	DIA	ETF	103.48	103.61	103.39	103.43	442000.0
2004-09-13 15:00:00	DIA	ETF	103.43	103.53	103.18	103.34	1156500.0
2004-09-13 16:00:00	DIA	ETF	103.37	103.52	103.31	103.48	151200.0
2004-09-13 17:00:00	DIA	ETF	103.5	103.52	103.5	103.52	2800.0
2004-09-13 18:00:00	DIA	ETF	103.54	103.54	103.54	103.54	1900.0
2004-09-13 08:00:00	TLT	ETF	87.03	87.03	87.03	87.03	200.0
2004-09-13 09:00:00	TLT	ETF	87.15	87.2	87.12	87.14	11200.0
2004-09-13 10:00:00	TLT	ETF	87.13	87.42	87.13	87.42	29200.0
2004-09-13 11:00:00	TLT	ETF	87.36	87.44	87.32	87.43	14700.0
2004-09-13 12:00:00	TLT	ETF	87.44	87.5	87.4	87.49	47500.0
2004-09-13 13:00:00	TLT	ETF	87.51	87.51	87.416	87.42	12800.0

> showing 50 of 705 rows — these rows as CSV

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