PREVIEW / etf_1hour / 2006-02-22

all etf 1-hour files

  file:    by_date/etf_1hour/2006/2006-02-22.parquet
  size:    40 KB
  rows:    1,244

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
2006-02-22 06:00:00	SPY	ETF	128.41	128.41	128.41	128.41	2000.0
2006-02-22 07:00:00	SPY	ETF	128.63	128.71	128.63	128.71	18300.0
2006-02-22 08:00:00	SPY	ETF	128.44	128.835	128.44	128.8	1907300.0
2006-02-22 09:00:00	SPY	ETF	128.8	128.96	128.67	128.7612	5000700.0
2006-02-22 10:00:00	SPY	ETF	128.78	129.1	128.65	129.08	7107600.0
2006-02-22 11:00:00	SPY	ETF	129.08	129.48	129.04	129.35	6787200.0
2006-02-22 12:00:00	SPY	ETF	129.35	129.58	129.29	129.49	4064500.0
2006-02-22 13:00:00	SPY	ETF	129.5	129.62	129.26	129.37	4457700.0
2006-02-22 14:00:00	SPY	ETF	129.38	129.48	129.25	129.45	2553300.0
2006-02-22 15:00:00	SPY	ETF	129.45	129.65	129.28	129.43	4849700.0
2006-02-22 16:00:00	SPY	ETF	129.42	129.44	129.2	129.24	1756200.0
2006-02-22 17:00:00	SPY	ETF	128.503	129.3	128.503	129.25	2038200.0
2006-02-22 18:00:00	SPY	ETF	129.26	129.27	129.24	129.24	5100.0
2006-02-22 19:00:00	SPY	ETF	129.23	129.23	129.22	129.23	1400.0
2006-02-22 09:00:00	QQQ	ETF	40.8	40.83	40.68	40.7	10560200.0
2006-02-22 10:00:00	QQQ	ETF	40.7	40.94	40.68	40.93	16987200.0
2006-02-22 11:00:00	QQQ	ETF	40.93	41.3	40.9	41.21	18341800.0
2006-02-22 12:00:00	QQQ	ETF	41.2	41.4	41.19	41.37	13967500.0
2006-02-22 13:00:00	QQQ	ETF	41.37	41.54	41.21	41.3	11029300.0
2006-02-22 14:00:00	QQQ	ETF	41.29	41.37	41.26	41.31	5629600.0
2006-02-22 15:00:00	QQQ	ETF	41.3	41.38	41.26	41.28	9119200.0
2006-02-22 08:00:00	IWM	ETF	72.39	72.5	72.27	72.49	77600.0
2006-02-22 09:00:00	IWM	ETF	72.49	72.5	72.06	72.09	3154400.0
2006-02-22 10:00:00	IWM	ETF	72.09	72.48	71.98	72.37	5883000.0
2006-02-22 11:00:00	IWM	ETF	72.37	72.88	72.32	72.78	5872700.0
2006-02-22 12:00:00	IWM	ETF	72.79	72.96	72.78	72.89	2227300.0
2006-02-22 13:00:00	IWM	ETF	72.9	72.94	72.7	72.79	2634400.0
2006-02-22 14:00:00	IWM	ETF	72.79	72.91	72.74	72.86	1511100.0
2006-02-22 15:00:00	IWM	ETF	72.85	73.01	72.7	72.85	3384200.0
2006-02-22 16:00:00	IWM	ETF	72.84	72.95	72.72	72.75	204100.0
2006-02-22 17:00:00	IWM	ETF	72.2424	72.81	72.2424	72.81	302200.0
2006-02-22 18:00:00	IWM	ETF	72.81	72.81	72.81	72.81	100.0
2006-02-22 19:00:00	IWM	ETF	72.81	72.81	72.81	72.81	500.0
2006-02-22 08:00:00	DIA	ETF	110.73	110.77	110.68	110.77	7200.0
2006-02-22 09:00:00	DIA	ETF	110.81	111.0	110.73	110.9	439300.0
2006-02-22 10:00:00	DIA	ETF	110.89	111.2	110.85	111.18	710400.0
2006-02-22 11:00:00	DIA	ETF	111.17	111.44	111.13	111.35	959700.0
2006-02-22 12:00:00	DIA	ETF	111.35	111.5	111.32	111.44	748900.0
2006-02-22 13:00:00	DIA	ETF	111.45	111.52	111.23	111.31	520900.0
2006-02-22 14:00:00	DIA	ETF	111.32	111.41	111.21	111.3301	549000.0
2006-02-22 15:00:00	DIA	ETF	111.34	111.48	111.16	111.28	848600.0
2006-02-22 16:00:00	DIA	ETF	111.25	111.28	111.09	111.13	98900.0
2006-02-22 17:00:00	DIA	ETF	111.13	111.13	111.13	111.13	300.0
2006-02-22 19:00:00	DIA	ETF	111.1	111.1	111.1	111.1	300.0
2006-02-22 08:00:00	GLD	ETF	54.8	54.92	54.57	54.89	40000.0
2006-02-22 09:00:00	GLD	ETF	54.86	55.06	54.86	54.94	1113700.0
2006-02-22 10:00:00	GLD	ETF	54.93	55.13	54.91	54.95	641400.0
2006-02-22 11:00:00	GLD	ETF	54.9799	55.14	54.88	55.08	465200.0
2006-02-22 12:00:00	GLD	ETF	55.08	55.25	55.08	55.11	329400.0
2006-02-22 13:00:00	GLD	ETF	55.1	55.19	55.01	55.1	195100.0

> showing 50 of 1,244 rows — these rows as CSV

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