PREVIEW / etf_1hour / 2004-09-28

all etf 1-hour files

  file:    by_date/etf_1hour/2004/2004-09-28.parquet
  size:    24 KB
  rows:    664

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-28 08:00:00	SPY	ETF	111.0	111.01	110.92	110.97	44300.0
2004-09-28 09:00:00	SPY	ETF	110.94	111.03	110.73	110.75	3887600.0
2004-09-28 10:00:00	SPY	ETF	110.75	110.91	110.41	110.68	6994400.0
2004-09-28 11:00:00	SPY	ETF	110.69	111.11	110.64	111.01	4252700.0
2004-09-28 12:00:00	SPY	ETF	111.01	111.15	110.94	110.99	2732700.0
2004-09-28 13:00:00	SPY	ETF	110.99	111.08	110.8	110.91	3003300.0
2004-09-28 14:00:00	SPY	ETF	110.92	111.44	110.84	111.39	5801800.0
2004-09-28 15:00:00	SPY	ETF	111.39	111.51	111.29	111.35	8658600.0
2004-09-28 16:00:00	SPY	ETF	111.35	111.46	111.22	111.29	4559700.0
2004-09-28 17:00:00	SPY	ETF	111.29	111.31	111.28	111.31	9600.0
2004-09-28 18:00:00	SPY	ETF	111.31	111.32	111.28	111.28	11700.0
2004-09-28 19:00:00	SPY	ETF	111.25	111.29	111.25	111.29	400.0
2004-09-28 08:00:00	QQQ	ETF	34.56	34.61	34.53	34.56	155800.0
2004-09-28 09:00:00	QQQ	ETF	34.56	34.586	34.42	34.448	9750900.0
2004-09-28 10:00:00	QQQ	ETF	34.44	34.54	34.23	34.36	19508200.0
2004-09-28 11:00:00	QQQ	ETF	34.36	34.57	34.34	34.5	12566400.0
2004-09-28 12:00:00	QQQ	ETF	34.5	34.53	34.43	34.45	5245800.0
2004-09-28 13:00:00	QQQ	ETF	34.44	34.48	34.32	34.415	7514200.0
2004-09-28 14:00:00	QQQ	ETF	34.417	34.58	34.36	34.56	10933600.0
2004-09-28 15:00:00	QQQ	ETF	34.56	34.69	34.53	34.59	15078600.0
2004-09-28 16:00:00	QQQ	ETF	34.589	34.6166	34.53	34.56	2169300.0
2004-09-28 17:00:00	QQQ	ETF	34.56	34.6	34.55	34.57	163200.0
2004-09-28 18:00:00	QQQ	ETF	34.58	34.6	34.56	34.58	40600.0
2004-09-28 19:00:00	QQQ	ETF	34.57	34.58	34.57	34.58	24500.0
2004-09-28 09:00:00	IWM	ETF	55.79	56.0	55.7	55.745	1953800.0
2004-09-28 10:00:00	IWM	ETF	55.725	55.83	55.57	55.74	2537400.0
2004-09-28 11:00:00	IWM	ETF	55.74	56.005	55.72	55.97	1487000.0
2004-09-28 12:00:00	IWM	ETF	55.97	56.045	55.935	55.955	717600.0
2004-09-28 13:00:00	IWM	ETF	55.95	55.98	55.85	55.88	679600.0
2004-09-28 14:00:00	IWM	ETF	55.875	56.18	55.845	56.17	1938200.0
2004-09-28 15:00:00	IWM	ETF	56.16	56.375	56.14	56.32	2840800.0
2004-09-28 16:00:00	IWM	ETF	56.32	56.4	56.3	56.38	592000.0
2004-09-28 08:00:00	DIA	ETF	100.33	100.33	100.27	100.27	600.0
2004-09-28 09:00:00	DIA	ETF	100.25	100.42	100.22	100.24	937600.0
2004-09-28 10:00:00	DIA	ETF	100.25	100.33	99.91	100.12	2140500.0
2004-09-28 11:00:00	DIA	ETF	100.12	100.61	100.09	100.52	1413600.0
2004-09-28 12:00:00	DIA	ETF	100.52	100.65	100.48	100.57	457500.0
2004-09-28 13:00:00	DIA	ETF	100.54	100.61	100.4	100.49	571800.0
2004-09-28 14:00:00	DIA	ETF	100.49	100.89	100.41	100.86	897800.0
2004-09-28 15:00:00	DIA	ETF	100.82	101.15	100.81	100.95	1602400.0
2004-09-28 16:00:00	DIA	ETF	100.95	101.01	100.86	100.9	122400.0
2004-09-28 09:00:00	TLT	ETF	89.72	89.79	89.64	89.75	108000.0
2004-09-28 10:00:00	TLT	ETF	89.79	89.95	89.67	89.68	122800.0
2004-09-28 11:00:00	TLT	ETF	89.77	89.77	89.45	89.47	279700.0
2004-09-28 12:00:00	TLT	ETF	89.47	89.47	89.27	89.36	238900.0
2004-09-28 13:00:00	TLT	ETF	89.37	89.43	89.22	89.25	144500.0
2004-09-28 14:00:00	TLT	ETF	89.29	89.4	89.28	89.4	35500.0
2004-09-28 15:00:00	TLT	ETF	89.4	89.55	89.4	89.44	218300.0
2004-09-28 16:00:00	TLT	ETF	89.46	89.54	89.46	89.52	6300.0

> showing 49 of 664 rows — these rows as CSV

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