PREVIEW / etf_1hour / 2006-06-20

all etf 1-hour files

  file:    by_date/etf_1hour/2006/2006-06-20.parquet
  size:    44 KB
  rows:    1,380

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-06-20 04:00:00	SPY	ETF	124.1	124.1	124.1	124.1	100.0
2006-06-20 05:00:00	SPY	ETF	123.92	123.97	123.92	123.97	7500.0
2006-06-20 06:00:00	SPY	ETF	123.89	123.89	123.89	123.89	1500.0
2006-06-20 07:00:00	SPY	ETF	123.96	124.0	123.73	123.77	56800.0
2006-06-20 08:00:00	SPY	ETF	123.67	123.97	123.6	123.89	1632800.0
2006-06-20 09:00:00	SPY	ETF	123.9	124.98	123.72	123.8	8846600.0
2006-06-20 10:00:00	SPY	ETF	123.8	124.26	123.72	124.15	10950600.0
2006-06-20 11:00:00	SPY	ETF	124.15	124.81	124.07	124.62	10570200.0
2006-06-20 12:00:00	SPY	ETF	124.62	124.66	124.18	124.29	6585300.0
2006-06-20 13:00:00	SPY	ETF	124.3	124.56	124.06	124.21	6239400.0
2006-06-20 14:00:00	SPY	ETF	124.22	124.34	123.9	124.22	7720900.0
2006-06-20 15:00:00	SPY	ETF	124.2	124.56	123.73	123.88	9991400.0
2006-06-20 16:00:00	SPY	ETF	123.88	124.13	123.84	124.11	649700.0
2006-06-20 17:00:00	SPY	ETF	124.09	124.2	123.9	124.17	1383900.0
2006-06-20 18:00:00	SPY	ETF	124.13	124.13	124.06	124.06	22100.0
2006-06-20 19:00:00	SPY	ETF	124.02	124.02	123.98	124.0	5700.0
2006-06-20 09:00:00	QQQ	ETF	38.09	38.18	37.95	38.0	14306800.0
2006-06-20 10:00:00	QQQ	ETF	38.0	38.13	37.94	38.06	18020600.0
2006-06-20 11:00:00	QQQ	ETF	38.06	38.48	38.04	38.38	23998000.0
2006-06-20 12:00:00	QQQ	ETF	38.38	38.4	38.21	38.23	6666800.0
2006-06-20 13:00:00	QQQ	ETF	38.23	38.28	38.09	38.15	9484900.0
2006-06-20 14:00:00	QQQ	ETF	38.15	38.19	38.0	38.15	11977800.0
2006-06-20 15:00:00	QQQ	ETF	38.16	38.2	38.0	38.08	12305700.0
2006-06-20 08:00:00	IWM	ETF	67.23	67.8	67.19	67.43	2085800.0
2006-06-20 09:00:00	IWM	ETF	67.49	68.08	67.35	67.38	10248700.0
2006-06-20 10:00:00	IWM	ETF	67.38	68.0	67.31	67.77	9238400.0
2006-06-20 11:00:00	IWM	ETF	67.77	68.33	67.68	68.14	10370100.0
2006-06-20 12:00:00	IWM	ETF	68.15	68.18	67.72	67.79	4068500.0
2006-06-20 13:00:00	IWM	ETF	67.79	67.9	67.56	67.73	4305200.0
2006-06-20 14:00:00	IWM	ETF	67.71	67.78	67.37	67.73	6291100.0
2006-06-20 15:00:00	IWM	ETF	67.72	67.86	67.4	67.4	7937000.0
2006-06-20 16:00:00	IWM	ETF	67.4	67.7346	67.33	67.33	2979000.0
2006-06-20 17:00:00	IWM	ETF	67.42	67.55	67.41	67.41	2671300.0
2006-06-20 18:00:00	IWM	ETF	67.41	67.41	67.38	67.38	1800.0
2006-06-20 19:00:00	IWM	ETF	67.37	67.37	67.36	67.36	2000.0
2006-06-20 08:00:00	DIA	ETF	109.19	109.38	109.19	109.38	2200.0
2006-06-20 09:00:00	DIA	ETF	109.38	109.63	109.28	109.33	643100.0
2006-06-20 10:00:00	DIA	ETF	109.34	109.63	109.27	109.59	1107000.0
2006-06-20 11:00:00	DIA	ETF	109.58	110.22	109.52	110.2	1312500.0
2006-06-20 12:00:00	DIA	ETF	110.19	110.23	109.86	109.97	580300.0
2006-06-20 13:00:00	DIA	ETF	109.97	110.04	109.75	109.86	1185900.0
2006-06-20 14:00:00	DIA	ETF	109.85	110.0	109.65	109.91	1083000.0
2006-06-20 15:00:00	DIA	ETF	109.92	109.98	109.53	109.63	709100.0
2006-06-20 16:00:00	DIA	ETF	109.64	109.87	109.6337	109.87	437400.0
2006-06-20 19:00:00	DIA	ETF	109.86	109.86	109.85	109.85	700.0
2006-06-20 07:00:00	GLD	ETF	56.8	56.8	56.65	56.65	10300.0
2006-06-20 08:00:00	GLD	ETF	56.66	56.93	56.33	56.73	890600.0
2006-06-20 09:00:00	GLD	ETF	56.71	56.71	56.37	56.53	1695600.0
2006-06-20 10:00:00	GLD	ETF	56.53	56.61	56.16	56.54	1026700.0
2006-06-20 11:00:00	GLD	ETF	56.55	56.84	56.49	56.81	1176800.0

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

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