PREVIEW / etf_1hour / 2009-06-29

all etf 1-hour files

  file:    by_date/etf_1hour/2009/2009-06-29.parquet
  size:    131 KB
  rows:    4,056

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
2009-06-29 04:00:00	SPY	ETF	91.84	91.84	91.7	91.72	1610.0
2009-06-29 05:00:00	SPY	ETF	91.75	91.75	91.75	91.75	200.0
2009-06-29 06:00:00	SPY	ETF	91.87	92.15	91.87	92.15	25950.0
2009-06-29 07:00:00	SPY	ETF	92.15	92.25	92.05	92.22	1346730.0
2009-06-29 08:00:00	SPY	ETF	92.22	92.32	92.05	92.09	2285404.0
2009-06-29 09:00:00	SPY	ETF	92.09	92.2	91.6	91.73	23153881.0
2009-06-29 10:00:00	SPY	ETF	91.73	92.75	91.66	92.61	34518330.0
2009-06-29 11:00:00	SPY	ETF	92.6199	92.77	92.55	92.74	14494786.0
2009-06-29 12:00:00	SPY	ETF	92.7395	92.81	92.58	92.59	10914841.0
2009-06-29 13:00:00	SPY	ETF	92.59	92.78	92.56	92.66	9924088.0
2009-06-29 14:00:00	SPY	ETF	92.6501	92.7	92.45	92.64	20180957.0
2009-06-29 15:00:00	SPY	ETF	92.64	92.82	92.42	92.72	32515974.0
2009-06-29 16:00:00	SPY	ETF	92.73	92.75	91.85	92.56	9804892.0
2009-06-29 17:00:00	SPY	ETF	92.57	92.63	92.56	92.62	92822.0
2009-06-29 18:00:00	SPY	ETF	92.6	92.68	92.52	92.55	60491.0
2009-06-29 19:00:00	SPY	ETF	92.58	92.63	92.52	92.59	56952.0
2009-06-29 05:00:00	QQQ	ETF	36.31	36.37	36.31	36.33	600.0
2009-06-29 06:00:00	QQQ	ETF	36.33	36.51	36.33	36.5	45900.0
2009-06-29 07:00:00	QQQ	ETF	36.5	36.54	36.46	36.52	576421.0
2009-06-29 08:00:00	QQQ	ETF	36.5	36.55	36.43	36.45	851821.0
2009-06-29 09:00:00	QQQ	ETF	36.46	36.52	36.17	36.26	14764284.0
2009-06-29 10:00:00	QQQ	ETF	36.26	36.51	36.12	36.45	16390788.0
2009-06-29 11:00:00	QQQ	ETF	36.46	36.69	36.43	36.68	11449438.0
2009-06-29 12:00:00	QQQ	ETF	36.69	36.75	36.59	36.59	8432419.0
2009-06-29 13:00:00	QQQ	ETF	36.5905	36.64	36.47	36.52	6533638.0
2009-06-29 14:00:00	QQQ	ETF	36.52	36.55	36.44	36.54	8579664.0
2009-06-29 15:00:00	QQQ	ETF	36.534	36.59	36.38	36.45	15933470.0
2009-06-29 16:00:00	QQQ	ETF	36.45	36.52	36.4064	36.4064	5705497.0
2009-06-29 17:00:00	QQQ	ETF	36.48	36.5	36.47	36.5	32800.0
2009-06-29 18:00:00	QQQ	ETF	36.47	36.5	36.46	36.48	39709.0
2009-06-29 19:00:00	QQQ	ETF	36.49	36.5	36.47	36.48	21400.0
2009-06-29 06:00:00	IWM	ETF	51.39	51.42	51.38	51.4	28822.0
2009-06-29 07:00:00	IWM	ETF	51.28	51.48	51.28	51.46	252398.0
2009-06-29 08:00:00	IWM	ETF	51.46	51.48	51.3	51.35	1156809.0
2009-06-29 09:00:00	IWM	ETF	51.35	51.42	50.49	50.67	10205439.0
2009-06-29 10:00:00	IWM	ETF	50.66	51.39	50.4	51.24	9512604.0
2009-06-29 11:00:00	IWM	ETF	51.25	51.3401	51.17	51.34	2779696.0
2009-06-29 12:00:00	IWM	ETF	51.35	51.58	51.3	51.3399	3283455.0
2009-06-29 13:00:00	IWM	ETF	51.33	51.4699	51.18	51.26	2902353.0
2009-06-29 14:00:00	IWM	ETF	51.27	51.4	51.1299	51.309	2705366.0
2009-06-29 15:00:00	IWM	ETF	51.31	51.43	51.09	51.22	7853820.0
2009-06-29 16:00:00	IWM	ETF	51.22	51.5083	51.1	51.2	5083219.0
2009-06-29 17:00:00	IWM	ETF	51.23	51.24	51.21	51.21	2206.0
2009-06-29 19:00:00	IWM	ETF	51.25	51.25	51.14	51.14	1200.0
2009-06-29 07:00:00	DIA	ETF	84.55	84.62	84.49	84.61	900.0
2009-06-29 08:00:00	DIA	ETF	84.6	84.73	84.5	84.53	29300.0
2009-06-29 09:00:00	DIA	ETF	84.57	84.69	84.3	84.39	1321971.0
2009-06-29 10:00:00	DIA	ETF	84.39	85.33	84.34	85.23	2059570.0
2009-06-29 11:00:00	DIA	ETF	85.21	85.31	85.09	85.31	770933.0
2009-06-29 12:00:00	DIA	ETF	85.3	85.35	85.15	85.17	586536.0

> showing 50 of 4,056 rows — these rows as CSV

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