PREVIEW / etf_1hour / 2009-06-26

all etf 1-hour files

  file:    by_date/etf_1hour/2009/2009-06-26.parquet
  size:    132 KB
  rows:    4,060

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-26 04:00:00	SPY	ETF	92.0	92.02	91.85	92.02	5750.0
2009-06-26 05:00:00	SPY	ETF	92.07	92.07	91.84	91.84	1690.0
2009-06-26 06:00:00	SPY	ETF	91.8	91.85	91.7	91.85	202200.0
2009-06-26 07:00:00	SPY	ETF	91.85	91.98	91.8	91.93	151765.0
2009-06-26 08:00:00	SPY	ETF	91.93	92.29	91.58	91.68	3030536.0
2009-06-26 09:00:00	SPY	ETF	91.68	92.04	91.48	91.55	28671294.0
2009-06-26 10:00:00	SPY	ETF	91.54	91.86	91.38	91.515	28772462.0
2009-06-26 11:00:00	SPY	ETF	91.51	91.62	91.27	91.58	18487812.0
2009-06-26 12:00:00	SPY	ETF	91.59	91.87	91.495	91.75	15431574.0
2009-06-26 13:00:00	SPY	ETF	91.75	91.79	91.55	91.65	15305866.0
2009-06-26 14:00:00	SPY	ETF	91.65	91.93	91.52	91.9125	11320318.0
2009-06-26 15:00:00	SPY	ETF	91.91	92.24	91.77	91.78	28966129.0
2009-06-26 16:00:00	SPY	ETF	91.79	92.13	91.688	91.9	8786402.0
2009-06-26 17:00:00	SPY	ETF	91.85	91.91	91.8	91.88	72653.0
2009-06-26 18:00:00	SPY	ETF	91.86	91.91	91.84	91.87	33228.0
2009-06-26 19:00:00	SPY	ETF	91.86	91.87	91.82	91.85	18977.0
2009-06-26 06:00:00	QQQ	ETF	36.18	36.18	36.15	36.15	2278.0
2009-06-26 07:00:00	QQQ	ETF	36.2	36.23	36.15	36.21	70936.0
2009-06-26 08:00:00	QQQ	ETF	36.22	36.32	36.07	36.1	598752.0
2009-06-26 09:00:00	QQQ	ETF	36.1	36.41	36.05	36.22	19546600.0
2009-06-26 10:00:00	QQQ	ETF	36.22	36.38	36.16	36.24	15559052.0
2009-06-26 11:00:00	QQQ	ETF	36.249	36.34	36.17	36.33	6748757.0
2009-06-26 12:00:00	QQQ	ETF	36.33	36.44	36.3	36.389	8074297.0
2009-06-26 13:00:00	QQQ	ETF	36.39	36.43	36.33	36.37	6808466.0
2009-06-26 14:00:00	QQQ	ETF	36.37	36.45	36.33	36.44	7106071.0
2009-06-26 15:00:00	QQQ	ETF	36.4399	36.5	36.35	36.38	15931509.0
2009-06-26 16:00:00	QQQ	ETF	36.38	36.41	36.31	36.35	4865041.0
2009-06-26 17:00:00	QQQ	ETF	36.34	36.35	36.32	36.35	101580.0
2009-06-26 18:00:00	QQQ	ETF	36.34	36.41	36.34	36.37	14096.0
2009-06-26 19:00:00	QQQ	ETF	36.36	36.38	36.34	36.34	17000.0
2009-06-26 05:00:00	IWM	ETF	51.14	51.14	51.14	51.14	116.0
2009-06-26 07:00:00	IWM	ETF	50.81	50.95	50.81	50.92	8200.0
2009-06-26 08:00:00	IWM	ETF	50.91	51.11	50.71	50.74	159317.0
2009-06-26 09:00:00	IWM	ETF	50.7	51.06	50.57	50.61	7069528.0
2009-06-26 10:00:00	IWM	ETF	50.61	50.96	50.57	50.77	7662472.0
2009-06-26 11:00:00	IWM	ETF	50.77	50.94	50.63	50.9	4220038.0
2009-06-26 12:00:00	IWM	ETF	50.89	51.1	50.86	51.04	3409083.0
2009-06-26 13:00:00	IWM	ETF	51.05	51.15	50.98	51.03	3090250.0
2009-06-26 14:00:00	IWM	ETF	51.03	51.11	50.93	51.09	2457214.0
2009-06-26 15:00:00	IWM	ETF	51.1	51.565	51.05	51.12	14257105.0
2009-06-26 16:00:00	IWM	ETF	51.13	51.4188	49.3078	51.06	11692502.0
2009-06-26 17:00:00	IWM	ETF	51.1	51.11	51.09	51.11	18600.0
2009-06-26 18:00:00	IWM	ETF	51.09	51.11	51.08	51.09	7700.0
2009-06-26 19:00:00	IWM	ETF	51.09	51.1	51.03	51.1	2100.0
2009-06-26 07:00:00	DIA	ETF	84.56	84.56	84.56	84.56	100.0
2009-06-26 08:00:00	DIA	ETF	84.58	84.83	84.31	84.31	48165.0
2009-06-26 09:00:00	DIA	ETF	84.31	84.69	84.23	84.3	1972709.0
2009-06-26 10:00:00	DIA	ETF	84.31	84.55	84.1	84.22	1398731.0
2009-06-26 11:00:00	DIA	ETF	84.21	84.24	84.0201	84.21	830233.0
2009-06-26 12:00:00	DIA	ETF	84.21	84.4101	84.09	84.33	696940.0

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

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