PREVIEW / etf_1hour / 2006-09-15

all etf 1-hour files

  file:    by_date/etf_1hour/2006/2006-09-15.parquet
  size:    52 KB
  rows:    1,662

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-09-15 04:00:00	SPY	ETF	131.66	131.68	131.66	131.68	1300.0
2006-09-15 07:00:00	SPY	ETF	131.57	131.72	131.57	131.66	19800.0
2006-09-15 08:00:00	SPY	ETF	131.67	132.3	131.56	132.28	4424300.0
2006-09-15 09:00:00	SPY	ETF	132.27	132.39	131.92	132.06	11280900.0
2006-09-15 10:00:00	SPY	ETF	132.07	132.39	132.0	132.11	9382400.0
2006-09-15 11:00:00	SPY	ETF	132.1	132.18	131.86	131.92	7277700.0
2006-09-15 12:00:00	SPY	ETF	131.91	131.97	131.68	131.7	8012000.0
2006-09-15 13:00:00	SPY	ETF	131.71	132.08	131.68	131.96	9024500.0
2006-09-15 14:00:00	SPY	ETF	131.96	132.17	131.9	131.97	4567600.0
2006-09-15 15:00:00	SPY	ETF	131.97	132.1	131.79	131.82	10734800.0
2006-09-15 16:00:00	SPY	ETF	131.83	132.34	131.82	131.94	1975300.0
2006-09-15 17:00:00	SPY	ETF	131.95	131.95	131.0802	131.94	1991000.0
2006-09-15 18:00:00	SPY	ETF	131.97	131.98	131.86	131.86	11400.0
2006-09-15 19:00:00	SPY	ETF	131.9	131.9	131.9	131.9	100.0
2006-09-15 09:00:00	QQQ	ETF	40.34	40.38	40.17	40.24	25234100.0
2006-09-15 10:00:00	QQQ	ETF	40.25	40.46	40.19	40.26	19686800.0
2006-09-15 11:00:00	QQQ	ETF	40.26	40.3	40.12	40.16	13836100.0
2006-09-15 12:00:00	QQQ	ETF	40.16	40.21	40.0	40.01	13906100.0
2006-09-15 13:00:00	QQQ	ETF	40.01	40.19	40.01	40.13	10327000.0
2006-09-15 14:00:00	QQQ	ETF	40.13	40.25	40.11	40.15	8086400.0
2006-09-15 15:00:00	QQQ	ETF	40.16	40.21	40.09	40.1	18954300.0
2006-09-15 07:00:00	IWM	ETF	72.4	72.5	72.1	72.5	4300.0
2006-09-15 08:00:00	IWM	ETF	72.5	73.04	72.43	73.04	1742800.0
2006-09-15 09:00:00	IWM	ETF	73.04	73.07	72.54	72.59	6284300.0
2006-09-15 10:00:00	IWM	ETF	72.59	73.01	72.51	72.67	6530500.0
2006-09-15 11:00:00	IWM	ETF	72.66	72.77	72.3	72.49	3749200.0
2006-09-15 12:00:00	IWM	ETF	72.5	72.65	72.17	72.23	5796700.0
2006-09-15 13:00:00	IWM	ETF	72.24	72.71	72.23	72.59	5222700.0
2006-09-15 14:00:00	IWM	ETF	72.59	72.8	72.52	72.6	3700500.0
2006-09-15 15:00:00	IWM	ETF	72.6	72.74	72.55	72.59	5105100.0
2006-09-15 16:00:00	IWM	ETF	72.6	72.61	72.26	72.59	1366300.0
2006-09-15 18:00:00	IWM	ETF	72.58	72.59	72.58	72.59	4000.0
2006-09-15 08:00:00	DIA	ETF	115.17	115.79	115.17	115.77	402500.0
2006-09-15 09:00:00	DIA	ETF	115.78	115.9	115.69	115.77	1389700.0
2006-09-15 10:00:00	DIA	ETF	115.78	116.03	115.71	115.82	1523100.0
2006-09-15 11:00:00	DIA	ETF	115.82	116.0	115.57	115.65	1175800.0
2006-09-15 12:00:00	DIA	ETF	115.66	115.72	115.53	115.54	923100.0
2006-09-15 13:00:00	DIA	ETF	115.54	115.79	115.53	115.72	562600.0
2006-09-15 14:00:00	DIA	ETF	115.71	115.88	115.65	115.67	801300.0
2006-09-15 15:00:00	DIA	ETF	115.68	115.76	115.45	115.45	749700.0
2006-09-15 16:00:00	DIA	ETF	115.47	115.62	115.47	115.53	47800.0
2006-09-15 07:00:00	GLD	ETF	57.15	57.15	57.06	57.06	23800.0
2006-09-15 08:00:00	GLD	ETF	57.08	57.48	57.04	57.45	106000.0
2006-09-15 09:00:00	GLD	ETF	57.43	57.45	56.66	56.98	1896500.0
2006-09-15 10:00:00	GLD	ETF	56.98	57.33	56.78	57.1191	1305400.0
2006-09-15 11:00:00	GLD	ETF	57.12	57.29	57.06	57.07	648600.0
2006-09-15 12:00:00	GLD	ETF	57.07	57.63	56.88	57.38	706500.0
2006-09-15 13:00:00	GLD	ETF	57.38	57.79	57.17	57.39	647700.0
2006-09-15 14:00:00	GLD	ETF	57.39	57.41	57.3	57.31	505100.0
2006-09-15 15:00:00	GLD	ETF	57.31	57.44	57.2	57.43	558100.0

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

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