PREVIEW / etf_1hour / 2004-06-09

all etf 1-hour files

  file:    by_date/etf_1hour/2004/2004-06-09.parquet
  size:    25 KB
  rows:    683

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-06-09 08:00:00	SPY	ETF	114.54	114.59	114.51	114.57	52700.0
2004-06-09 09:00:00	SPY	ETF	114.55	114.7	114.42	114.55	2298300.0
2004-06-09 10:00:00	SPY	ETF	114.549	114.6	114.21	114.23	4690600.0
2004-06-09 11:00:00	SPY	ETF	114.23	114.37	114.1	114.24	4313200.0
2004-06-09 12:00:00	SPY	ETF	114.24	114.26	114.06	114.25	3166100.0
2004-06-09 13:00:00	SPY	ETF	114.28	114.32	113.89	113.96	3199500.0
2004-06-09 14:00:00	SPY	ETF	113.94	114.25	113.84	114.14	6696200.0
2004-06-09 15:00:00	SPY	ETF	114.14	114.19	113.73	113.77	6373500.0
2004-06-09 16:00:00	SPY	ETF	113.78	114.2	113.56	113.9	2792200.0
2004-06-09 17:00:00	SPY	ETF	113.9	113.97	113.9	113.94	110100.0
2004-06-09 18:00:00	SPY	ETF	113.95	113.97	113.95	113.95	10100.0
2004-06-09 19:00:00	SPY	ETF	113.94	113.94	113.87	113.87	9600.0
2004-06-09 08:00:00	QQQ	ETF	36.97	36.99	36.94	36.98	58000.0
2004-06-09 09:00:00	QQQ	ETF	36.98	37.05	36.926	36.97	9454800.0
2004-06-09 10:00:00	QQQ	ETF	36.972	37.0	36.83	36.857	14686400.0
2004-06-09 11:00:00	QQQ	ETF	36.86	36.9	36.8	36.84	7941000.0
2004-06-09 12:00:00	QQQ	ETF	36.85	36.86	36.74	36.823	7773700.0
2004-06-09 13:00:00	QQQ	ETF	36.823	36.86	36.56	36.57	15451000.0
2004-06-09 14:00:00	QQQ	ETF	36.577	36.74	36.55	36.67	18373200.0
2004-06-09 15:00:00	QQQ	ETF	36.677	36.7	36.51	36.53	16709500.0
2004-06-09 16:00:00	QQQ	ETF	36.515	36.632	36.499	36.6	4571200.0
2004-06-09 17:00:00	QQQ	ETF	36.59	36.61	36.59	36.6	23600.0
2004-06-09 18:00:00	QQQ	ETF	36.6	36.6	36.58	36.6	19400.0
2004-06-09 19:00:00	QQQ	ETF	36.6	36.6	36.59	36.6	8300.0
2004-06-09 08:00:00	IWM	ETF	57.56	57.56	57.51	57.51	1800.0
2004-06-09 09:00:00	IWM	ETF	57.555	57.755	57.51	57.67	698400.0
2004-06-09 10:00:00	IWM	ETF	57.645	57.705	57.17	57.185	1472400.0
2004-06-09 11:00:00	IWM	ETF	57.19	57.275	57.065	57.14	1577200.0
2004-06-09 12:00:00	IWM	ETF	57.145	57.165	57.025	57.1	314600.0
2004-06-09 13:00:00	IWM	ETF	57.1	57.15	56.825	56.825	893800.0
2004-06-09 14:00:00	IWM	ETF	56.835	57.03	56.735	57.015	1598000.0
2004-06-09 15:00:00	IWM	ETF	57.0	57.005	56.65	56.65	2646800.0
2004-06-09 16:00:00	IWM	ETF	56.65	56.745	56.615	56.745	680800.0
2004-06-09 08:00:00	DIA	ETF	104.16	104.21	104.13	104.19	11400.0
2004-06-09 09:00:00	DIA	ETF	104.21	104.37	104.08	104.28	269800.0
2004-06-09 10:00:00	DIA	ETF	104.3	104.4	104.06	104.08	845400.0
2004-06-09 11:00:00	DIA	ETF	104.09	104.18	103.98	104.16	1134300.0
2004-06-09 12:00:00	DIA	ETF	104.15	104.2	104.01	104.18	447100.0
2004-06-09 13:00:00	DIA	ETF	104.17	104.24	103.94	103.99	499800.0
2004-06-09 14:00:00	DIA	ETF	103.95	104.19	103.88	104.14	375800.0
2004-06-09 15:00:00	DIA	ETF	104.14	104.16	103.8	103.81	811200.0
2004-06-09 16:00:00	DIA	ETF	103.85	104.04	103.77	103.95	308000.0
2004-06-09 17:00:00	DIA	ETF	103.9	103.9	103.9	103.9	100.0
2004-06-09 09:00:00	TLT	ETF	81.45	81.52	81.45	81.49	31800.0
2004-06-09 10:00:00	TLT	ETF	81.49	81.51	81.38	81.42	27100.0
2004-06-09 11:00:00	TLT	ETF	81.42	81.43	81.16	81.21	101700.0
2004-06-09 12:00:00	TLT	ETF	81.21	81.33	81.15	81.33	23500.0
2004-06-09 13:00:00	TLT	ETF	81.3	81.34	81.0	81.0	304900.0
2004-06-09 14:00:00	TLT	ETF	81.0	81.35	81.0	81.26	38000.0
2004-06-09 15:00:00	TLT	ETF	81.3	81.33	81.26	81.26	52900.0

> showing 50 of 683 rows — these rows as CSV

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