PREVIEW / etf_1hour / 2006-12-29

all etf 1-hour files

  file:    by_date/etf_1hour/2006/2006-12-29.parquet
  size:    58 KB
  rows:    1,846

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-12-29 07:00:00	SPY	ETF	142.14	142.22	142.14	142.22	31500.0
2006-12-29 08:00:00	SPY	ETF	142.2	142.33	142.19	142.31	161300.0
2006-12-29 09:00:00	SPY	ETF	142.3	142.46	141.97	142.34	4953800.0
2006-12-29 10:00:00	SPY	ETF	142.34	142.54	142.22	142.29	5812500.0
2006-12-29 11:00:00	SPY	ETF	142.29	142.31	142.15	142.21	5488300.0
2006-12-29 12:00:00	SPY	ETF	142.21	142.3459	142.07	142.14	3560400.0
2006-12-29 13:00:00	SPY	ETF	142.145	142.23	142.07	142.21	2613000.0
2006-12-29 14:00:00	SPY	ETF	142.18	142.22	141.96	142.05	4992400.0
2006-12-29 15:00:00	SPY	ETF	142.05	142.1	141.43	141.5	13473400.0
2006-12-29 16:00:00	SPY	ETF	141.48	141.78	141.41	141.54	2408200.0
2006-12-29 17:00:00	SPY	ETF	141.63	141.67	141.6	141.6	20700.0
2006-12-29 18:00:00	SPY	ETF	141.65	141.67	141.65	141.65	6000.0
2006-12-29 19:00:00	SPY	ETF	141.6	141.67	141.6	141.67	1400.0
2006-12-29 09:00:00	QQQ	ETF	43.2	43.5	43.19	43.46	10032200.0
2006-12-29 10:00:00	QQQ	ETF	43.46	43.61	43.41	43.49	18928400.0
2006-12-29 11:00:00	QQQ	ETF	43.48	43.48	43.41	43.43	3538800.0
2006-12-29 12:00:00	QQQ	ETF	43.43	43.44	43.33	43.38	5064200.0
2006-12-29 13:00:00	QQQ	ETF	43.38	43.41	43.31	43.37	4019800.0
2006-12-29 14:00:00	QQQ	ETF	43.37	43.38	43.22	43.25	6667300.0
2006-12-29 15:00:00	QQQ	ETF	43.25	43.3	43.12	43.14	22606000.0
2006-12-29 08:00:00	IWM	ETF	78.79	78.83	78.79	78.82	124400.0
2006-12-29 09:00:00	IWM	ETF	78.84	78.95	78.56	78.88	3436100.0
2006-12-29 10:00:00	IWM	ETF	78.88	78.99	78.7	78.78	3416500.0
2006-12-29 11:00:00	IWM	ETF	78.78	78.8	78.7	78.75	1990600.0
2006-12-29 12:00:00	IWM	ETF	78.75	78.77	78.6	78.64	1859800.0
2006-12-29 13:00:00	IWM	ETF	78.63	78.74	78.5	78.56	1516600.0
2006-12-29 14:00:00	IWM	ETF	78.56	78.56	78.17	78.24	4076800.0
2006-12-29 15:00:00	IWM	ETF	78.25	78.34	77.99	78.05	12154100.0
2006-12-29 16:00:00	IWM	ETF	78.05	78.17	78.0	78.15	1122800.0
2006-12-29 17:00:00	IWM	ETF	78.15	78.19	78.15	78.19	600.0
2006-12-29 07:00:00	DIA	ETF	124.77	124.77	124.77	124.77	300.0
2006-12-29 08:00:00	DIA	ETF	124.84	124.89	124.83	124.87	8800.0
2006-12-29 09:00:00	DIA	ETF	124.9	125.05	124.69	124.98	520000.0
2006-12-29 10:00:00	DIA	ETF	124.98	125.1	124.9	124.93	621300.0
2006-12-29 11:00:00	DIA	ETF	124.92	124.93	124.82	124.87	336900.0
2006-12-29 12:00:00	DIA	ETF	124.88	124.91	124.75	124.81	323800.0
2006-12-29 13:00:00	DIA	ETF	124.81	124.92	124.77	124.88	354400.0
2006-12-29 14:00:00	DIA	ETF	124.88	124.91	124.7	124.82	368700.0
2006-12-29 15:00:00	DIA	ETF	124.83	124.87	124.34	124.5	2057200.0
2006-12-29 16:00:00	DIA	ETF	124.49	124.63	124.44	124.48	98600.0
2006-12-29 17:00:00	DIA	ETF	124.55	124.55	124.5	124.51	1000.0
2006-12-29 18:00:00	DIA	ETF	124.55	124.6	124.55	124.6	200.0
2006-12-29 19:00:00	DIA	ETF	124.57	124.6	124.57	124.6	900.0
2006-12-29 08:00:00	GLD	ETF	62.99	63.01	62.93	62.97	8900.0
2006-12-29 09:00:00	GLD	ETF	62.91	63.06	62.86	62.99	375300.0
2006-12-29 10:00:00	GLD	ETF	62.98	63.01	62.88	62.93	345300.0
2006-12-29 11:00:00	GLD	ETF	62.91	63.03	62.9	62.9672	308700.0
2006-12-29 12:00:00	GLD	ETF	62.99	63.08	62.9	63.032	383600.0
2006-12-29 13:00:00	GLD	ETF	63.04	63.2	63.03	63.17	330700.0
2006-12-29 14:00:00	GLD	ETF	63.17	63.18	63.08	63.1	72400.0

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

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