PREVIEW / etf_1hour / 2006-12-07

all etf 1-hour files

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

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-07 07:00:00	SPY	ETF	141.82	141.86	141.81	141.86	183900.0
2006-12-07 08:00:00	SPY	ETF	141.86	141.97	141.8	141.94	955700.0
2006-12-07 09:00:00	SPY	ETF	141.92	142.3	141.92	142.12	8584400.0
2006-12-07 10:00:00	SPY	ETF	142.12	142.12	141.43	141.59	12287000.0
2006-12-07 11:00:00	SPY	ETF	141.58	141.83	141.43	141.75	5643000.0
2006-12-07 12:00:00	SPY	ETF	141.74	141.8	141.58	141.66	3645300.0
2006-12-07 13:00:00	SPY	ETF	141.65	141.89	141.62	141.69	3915900.0
2006-12-07 14:00:00	SPY	ETF	141.69	141.85	141.31	141.38	7888700.0
2006-12-07 15:00:00	SPY	ETF	141.38	141.56	141.11	141.1829	14937100.0
2006-12-07 16:00:00	SPY	ETF	141.23	141.26	141.13	141.15	2799300.0
2006-12-07 17:00:00	SPY	ETF	141.15	141.2	141.09	141.15	592500.0
2006-12-07 18:00:00	SPY	ETF	141.15	141.15	141.11	141.11	26200.0
2006-12-07 19:00:00	SPY	ETF	141.1	141.15	141.1	141.15	5000.0
2006-12-07 09:00:00	QQQ	ETF	44.34	44.48	44.3	44.32	12182300.0
2006-12-07 10:00:00	QQQ	ETF	44.32	44.33	43.88	43.94	29782500.0
2006-12-07 11:00:00	QQQ	ETF	43.93	44.95	43.89	44.07	14898100.0
2006-12-07 12:00:00	QQQ	ETF	44.08	44.15	44.04	44.06	7240000.0
2006-12-07 13:00:00	QQQ	ETF	44.06	44.18	44.03	44.07	7873300.0
2006-12-07 14:00:00	QQQ	ETF	44.08	44.08	43.86	43.89	13567800.0
2006-12-07 15:00:00	QQQ	ETF	43.89	43.89	43.7	43.7	25327600.0
2006-12-07 08:00:00	IWM	ETF	79.18	79.24	79.11	79.2	184800.0
2006-12-07 09:00:00	IWM	ETF	79.2	79.51	79.15	79.37	3765200.0
2006-12-07 10:00:00	IWM	ETF	79.37	79.37	78.66	78.79	12951100.0
2006-12-07 11:00:00	IWM	ETF	78.77	79.13	78.76	79.05	2649600.0
2006-12-07 12:00:00	IWM	ETF	79.05	79.27	79.01	79.17	2028900.0
2006-12-07 13:00:00	IWM	ETF	79.18	79.46	79.13	79.35	3220200.0
2006-12-07 14:00:00	IWM	ETF	79.33	79.35	78.95	79.05	4049000.0
2006-12-07 15:00:00	IWM	ETF	79.05	79.05	78.79	78.83	7922400.0
2006-12-07 16:00:00	IWM	ETF	78.84	79.0	78.6	78.61	1978000.0
2006-12-07 17:00:00	IWM	ETF	78.66	78.68	78.58	78.65	6800.0
2006-12-07 18:00:00	IWM	ETF	78.75	78.75	78.63	78.63	2700.0
2006-12-07 19:00:00	IWM	ETF	78.66	78.66	78.66	78.66	1500.0
2006-12-07 08:00:00	DIA	ETF	123.25	123.3	123.25	123.3	7600.0
2006-12-07 09:00:00	DIA	ETF	123.3	123.65	123.3	123.51	757200.0
2006-12-07 10:00:00	DIA	ETF	123.51	123.52	123.01	123.18	1392200.0
2006-12-07 11:00:00	DIA	ETF	123.16	123.22	122.96	123.18	995000.0
2006-12-07 12:00:00	DIA	ETF	123.18	123.22	123.1	123.15	243100.0
2006-12-07 13:00:00	DIA	ETF	123.14	123.27	123.11	123.14	562700.0
2006-12-07 14:00:00	DIA	ETF	123.14	123.14	122.83	122.85	672200.0
2006-12-07 15:00:00	DIA	ETF	122.84	122.89	122.68	122.83	1765900.0
2006-12-07 16:00:00	DIA	ETF	122.85	122.86	122.76	122.83	7500.0
2006-12-07 19:00:00	DIA	ETF	122.85	122.85	122.85	122.85	800.0
2006-12-07 08:00:00	GLD	ETF	62.62	62.78	62.5	62.6	140400.0
2006-12-07 09:00:00	GLD	ETF	62.57	62.68	62.28	62.36	1279600.0
2006-12-07 10:00:00	GLD	ETF	62.36	62.37	61.99	62.23	1573200.0
2006-12-07 11:00:00	GLD	ETF	62.21	62.34	62.12	62.3195	724000.0
2006-12-07 12:00:00	GLD	ETF	62.32	62.52	62.311	62.419	570400.0
2006-12-07 13:00:00	GLD	ETF	62.42	62.78	62.4	62.7	438600.0
2006-12-07 14:00:00	GLD	ETF	62.7	62.7	62.6	62.65	279100.0
2006-12-07 15:00:00	GLD	ETF	62.64	62.74	62.63	62.73	329700.0

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

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