PREVIEW / etf_1hour / 2005-08-25

all etf 1-hour files

  file:    by_date/etf_1hour/2005/2005-08-25.parquet
  size:    30 KB
  rows:    917

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
2005-08-25 07:00:00	SPY	ETF	121.37	121.42	121.27	121.32	152400.0
2005-08-25 08:00:00	SPY	ETF	121.32	122.33	121.28	121.44	969100.0
2005-08-25 09:00:00	SPY	ETF	121.44	122.32	121.21	121.27	5010700.0
2005-08-25 10:00:00	SPY	ETF	121.26	121.58	121.25	121.5	6719200.0
2005-08-25 11:00:00	SPY	ETF	121.5	121.62	121.36	121.48	5613200.0
2005-08-25 12:00:00	SPY	ETF	121.48	121.55	121.28	121.4	3420300.0
2005-08-25 13:00:00	SPY	ETF	121.41	121.48	121.28	121.37	2728700.0
2005-08-25 14:00:00	SPY	ETF	121.37	121.66	121.3	121.66	4403500.0
2005-08-25 15:00:00	SPY	ETF	121.67	121.67	121.33	121.53	4870200.0
2005-08-25 16:00:00	SPY	ETF	121.53	121.65	121.4468	121.54	1036200.0
2005-08-25 17:00:00	SPY	ETF	121.53	121.58	121.52	121.55	7400.0
2005-08-25 18:00:00	SPY	ETF	121.55	121.55	121.53	121.53	4900.0
2005-08-25 19:00:00	SPY	ETF	121.55	121.58	121.55	121.58	4000.0
2005-08-25 09:00:00	QQQ	ETF	38.56	38.62	38.49	38.54	7804400.0
2005-08-25 10:00:00	QQQ	ETF	38.54	38.67	38.52	38.64	10153600.0
2005-08-25 11:00:00	QQQ	ETF	38.64	38.69	38.56	38.6	6700100.0
2005-08-25 12:00:00	QQQ	ETF	38.59	38.62	38.5	38.57	4737600.0
2005-08-25 13:00:00	QQQ	ETF	38.57	38.6	38.54	38.56	4558400.0
2005-08-25 14:00:00	QQQ	ETF	38.55	38.67	38.53	38.65	5376800.0
2005-08-25 15:00:00	QQQ	ETF	38.65	38.65	38.55	38.59	7226600.0
2005-08-25 08:00:00	IWM	ETF	65.31	65.37	65.31	65.35	9900.0
2005-08-25 09:00:00	IWM	ETF	65.35	65.54	65.18	65.26	2329300.0
2005-08-25 10:00:00	IWM	ETF	65.25	65.55	65.22	65.49	2507900.0
2005-08-25 11:00:00	IWM	ETF	65.5	65.68	65.46	65.56	1374000.0
2005-08-25 12:00:00	IWM	ETF	65.55	65.58	65.39	65.46	992800.0
2005-08-25 13:00:00	IWM	ETF	65.47	65.59	65.33	65.44	727600.0
2005-08-25 14:00:00	IWM	ETF	65.44	65.55	65.35	65.51	1517600.0
2005-08-25 15:00:00	IWM	ETF	65.51	65.52	65.25	65.5	3823100.0
2005-08-25 16:00:00	IWM	ETF	65.49	65.65	65.49	65.56	291400.0
2005-08-25 18:00:00	IWM	ETF	65.58	65.58	65.58	65.58	2500.0
2005-08-25 08:00:00	DIA	ETF	104.32	104.4	104.31	104.39	11600.0
2005-08-25 09:00:00	DIA	ETF	104.4	104.46	104.2	104.23	648200.0
2005-08-25 10:00:00	DIA	ETF	104.23	104.53	104.22	104.46	1321200.0
2005-08-25 11:00:00	DIA	ETF	104.47	104.54	104.35	104.43	817000.0
2005-08-25 12:00:00	DIA	ETF	104.42	104.47	104.27	104.32	617400.0
2005-08-25 13:00:00	DIA	ETF	104.34	104.43	104.25	104.32	280600.0
2005-08-25 14:00:00	DIA	ETF	104.32	104.59	104.29	104.59	615000.0
2005-08-25 15:00:00	DIA	ETF	104.59	104.59	104.3	104.42	1093600.0
2005-08-25 16:00:00	DIA	ETF	104.45	104.47	104.45	104.47	2700.0
2005-08-25 17:00:00	DIA	ETF	104.52	104.52	104.52	104.52	100.0
2005-08-25 08:00:00	GLD	ETF	43.78	43.78	43.74	43.74	3000.0
2005-08-25 09:00:00	GLD	ETF	43.76	43.81	43.74	43.81	88500.0
2005-08-25 10:00:00	GLD	ETF	43.8	43.81	43.66	43.72	207300.0
2005-08-25 11:00:00	GLD	ETF	43.722	43.8	43.6508	43.6508	183000.0
2005-08-25 12:00:00	GLD	ETF	43.67	43.72	43.6	43.63	529000.0
2005-08-25 13:00:00	GLD	ETF	43.634	43.76	43.63	43.7595	52700.0
2005-08-25 14:00:00	GLD	ETF	43.75	43.75	43.69	43.7	373200.0
2005-08-25 15:00:00	GLD	ETF	43.7	43.73	43.68	43.71	160000.0
2005-08-25 16:00:00	GLD	ETF	43.73	43.73	43.73	43.73	1000.0
2005-08-25 08:00:00	TLT	ETF	94.18	94.36	94.18	94.36	700.0

> showing 50 of 917 rows — these rows as CSV

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