PREVIEW / etf_1hour / 2006-10-30

all etf 1-hour files

  file:    by_date/etf_1hour/2006/2006-10-30.parquet
  size:    54 KB
  rows:    1,738

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-10-30 06:00:00	SPY	ETF	137.65	137.67	137.65	137.67	12500.0
2006-10-30 07:00:00	SPY	ETF	137.66	137.81	137.61	137.79	210700.0
2006-10-30 08:00:00	SPY	ETF	137.76	137.81	137.61	137.65	923600.0
2006-10-30 09:00:00	SPY	ETF	137.65	137.92	137.51	137.57	7398600.0
2006-10-30 10:00:00	SPY	ETF	137.57	137.88	137.4	137.71	8971200.0
2006-10-30 11:00:00	SPY	ETF	137.71	138.1	137.69	137.86	7781600.0
2006-10-30 12:00:00	SPY	ETF	137.85	137.85	137.66	137.81	3447900.0
2006-10-30 13:00:00	SPY	ETF	137.82	138.17	137.76	138.16	6351800.0
2006-10-30 14:00:00	SPY	ETF	138.15	138.2	137.99	138.04	4517800.0
2006-10-30 15:00:00	SPY	ETF	138.05	138.17	137.74	137.89	7737800.0
2006-10-30 16:00:00	SPY	ETF	137.87	137.88	137.79	137.82	978600.0
2006-10-30 17:00:00	SPY	ETF	137.82	137.86	137.82	137.86	6000.0
2006-10-30 09:00:00	QQQ	ETF	42.17	42.31	40.2	42.11	17058200.0
2006-10-30 10:00:00	QQQ	ETF	42.11	42.31	41.14	42.26	17160500.0
2006-10-30 11:00:00	QQQ	ETF	42.27	42.49	42.26	42.41	15590000.0
2006-10-30 12:00:00	QQQ	ETF	42.41	42.41	42.26	42.35	9143000.0
2006-10-30 13:00:00	QQQ	ETF	42.35	42.6	42.34	42.6	13642200.0
2006-10-30 14:00:00	QQQ	ETF	42.59	42.65	42.54	42.56	9852100.0
2006-10-30 15:00:00	QQQ	ETF	42.56	42.61	42.4	42.48	14010400.0
2006-10-30 07:00:00	IWM	ETF	76.04	76.04	76.04	76.04	400.0
2006-10-30 08:00:00	IWM	ETF	75.89	76.04	75.87	75.88	262200.0
2006-10-30 09:00:00	IWM	ETF	75.89	76.12	75.64	75.76	8009700.0
2006-10-30 10:00:00	IWM	ETF	75.75	76.0	75.53	75.84	7181400.0
2006-10-30 11:00:00	IWM	ETF	75.83	76.35	75.82	76.22	5957100.0
2006-10-30 12:00:00	IWM	ETF	76.22	76.22	76.0	76.1024	1720100.0
2006-10-30 13:00:00	IWM	ETF	76.1	76.63	76.1	76.59	5974900.0
2006-10-30 14:00:00	IWM	ETF	76.59	76.71	76.54	76.55	4285800.0
2006-10-30 15:00:00	IWM	ETF	76.55	76.66	76.1163	76.54	7837300.0
2006-10-30 16:00:00	IWM	ETF	76.54	76.59	76.4	76.51	1059400.0
2006-10-30 17:00:00	IWM	ETF	76.51	76.51	76.51	76.51	500.0
2006-10-30 18:00:00	IWM	ETF	76.54	76.54	76.54	76.54	3000.0
2006-10-30 07:00:00	DIA	ETF	120.74	120.74	120.74	120.74	100.0
2006-10-30 08:00:00	DIA	ETF	120.75	120.77	120.64	120.66	51500.0
2006-10-30 09:00:00	DIA	ETF	120.68	120.87	120.55	120.59	779700.0
2006-10-30 10:00:00	DIA	ETF	120.56	120.78	120.36	120.69	1178900.0
2006-10-30 11:00:00	DIA	ETF	120.69	120.94	120.69	120.78	578400.0
2006-10-30 12:00:00	DIA	ETF	120.79	120.82	120.66	120.78	353700.0
2006-10-30 13:00:00	DIA	ETF	120.78	121.0	120.7	120.99	736000.0
2006-10-30 14:00:00	DIA	ETF	120.99	121.06	120.89	120.92	550600.0
2006-10-30 15:00:00	DIA	ETF	120.93	121.06	120.66	120.7601	1336000.0
2006-10-30 16:00:00	DIA	ETF	120.78	120.8	120.73	120.79	31900.0
2006-10-30 18:00:00	DIA	ETF	120.85	120.9	120.85	120.9	200.0
2006-10-30 07:00:00	GLD	ETF	59.9	59.93	59.76	59.76	14200.0
2006-10-30 08:00:00	GLD	ETF	59.85	60.01	59.76	59.8	84300.0
2006-10-30 09:00:00	GLD	ETF	59.84	60.65	59.83	60.6101	1362800.0
2006-10-30 10:00:00	GLD	ETF	60.62	60.64	60.3	60.37	994900.0
2006-10-30 11:00:00	GLD	ETF	60.37	60.44	60.16	60.23	532200.0
2006-10-30 12:00:00	GLD	ETF	60.23	60.32	60.17	60.3	382200.0
2006-10-30 13:00:00	GLD	ETF	60.3	60.35	59.94	59.94	360800.0
2006-10-30 14:00:00	GLD	ETF	59.96	60.08	59.9	60.01	455100.0

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

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