PREVIEW / etf_1hour / 2006-12-04

all etf 1-hour files

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

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-04 06:00:00	SPY	ETF	140.11	140.11	140.11	140.11	18900.0
2006-12-04 07:00:00	SPY	ETF	140.15	140.25	140.12	140.15	46400.0
2006-12-04 08:00:00	SPY	ETF	140.14	140.32	140.11	140.16	769100.0
2006-12-04 09:00:00	SPY	ETF	140.16	140.66	140.14	140.56	9740300.0
2006-12-04 10:00:00	SPY	ETF	140.58	140.81	140.39	140.64	13194400.0
2006-12-04 11:00:00	SPY	ETF	140.65	141.14	140.63	140.94	21643800.0
2006-12-04 12:00:00	SPY	ETF	140.9425	141.06	140.81	141.03	5505100.0
2006-12-04 13:00:00	SPY	ETF	141.03	141.49	141.01	141.4	12760900.0
2006-12-04 14:00:00	SPY	ETF	141.4	141.55	141.22	141.53	9691700.0
2006-12-04 15:00:00	SPY	ETF	141.53	141.55	141.16	141.31	10033700.0
2006-12-04 16:00:00	SPY	ETF	141.32	141.33	141.06	141.28	1403800.0
2006-12-04 17:00:00	SPY	ETF	141.29	141.34	141.25	141.34	1180400.0
2006-12-04 18:00:00	SPY	ETF	141.32	141.32	141.3	141.3	800.0
2006-12-04 19:00:00	SPY	ETF	141.25	141.32	141.25	141.31	1700.0
2006-12-04 09:00:00	QQQ	ETF	43.79	43.99	43.79	43.91	12340100.0
2006-12-04 10:00:00	QQQ	ETF	43.9	44.17	43.87	44.13	19763400.0
2006-12-04 11:00:00	QQQ	ETF	44.13	44.38	44.13	44.24	16345000.0
2006-12-04 12:00:00	QQQ	ETF	44.23	44.34	44.2	44.33	6908100.0
2006-12-04 13:00:00	QQQ	ETF	44.33	44.45	44.28	44.42	6953900.0
2006-12-04 14:00:00	QQQ	ETF	44.42	44.46	44.32	44.46	7176000.0
2006-12-04 15:00:00	QQQ	ETF	44.45	44.48	44.22	44.25	15746000.0
2006-12-04 07:00:00	IWM	ETF	77.73	77.73	77.73	77.73	400.0
2006-12-04 08:00:00	IWM	ETF	77.73	77.95	77.73	77.88	1259400.0
2006-12-04 09:00:00	IWM	ETF	77.89	78.32	77.85	78.29	6829100.0
2006-12-04 10:00:00	IWM	ETF	78.3	78.74	78.15	78.66	9379500.0
2006-12-04 11:00:00	IWM	ETF	78.65	79.12	78.2601	78.9575	12011600.0
2006-12-04 12:00:00	IWM	ETF	78.96	79.05	78.77	79.04	5356200.0
2006-12-04 13:00:00	IWM	ETF	79.0495	79.25	79.02	79.09	5809300.0
2006-12-04 14:00:00	IWM	ETF	79.1	79.29	78.95	79.28	3440600.0
2006-12-04 15:00:00	IWM	ETF	79.28	79.3	78.92	79.25	8016300.0
2006-12-04 16:00:00	IWM	ETF	79.24	79.33	79.23	79.3	762700.0
2006-12-04 17:00:00	IWM	ETF	79.32	79.45	79.29	79.45	132400.0
2006-12-04 18:00:00	IWM	ETF	79.35	79.36	79.1786	79.36	10026900.0
2006-12-04 07:00:00	DIA	ETF	121.9	121.95	121.9	121.95	6600.0
2006-12-04 08:00:00	DIA	ETF	121.94	122.02	121.9	121.95	22800.0
2006-12-04 09:00:00	DIA	ETF	122.0	122.38	121.95	122.27	1012900.0
2006-12-04 10:00:00	DIA	ETF	122.26	122.53	122.17	122.34	1207900.0
2006-12-04 11:00:00	DIA	ETF	122.34	122.7	122.32	122.57	812400.0
2006-12-04 12:00:00	DIA	ETF	122.57	122.66	122.49	122.64	371700.0
2006-12-04 13:00:00	DIA	ETF	122.6399	123.06	122.62	122.98	793000.0
2006-12-04 14:00:00	DIA	ETF	122.97	123.11	122.87	123.1	684000.0
2006-12-04 15:00:00	DIA	ETF	123.1	123.11	122.71	122.84	1197000.0
2006-12-04 16:00:00	DIA	ETF	122.83	122.85	122.79	122.84	135100.0
2006-12-04 17:00:00	DIA	ETF	122.85	122.85	122.85	122.85	200.0
2006-12-04 08:00:00	GLD	ETF	64.12	64.12	63.93	64.0	49500.0
2006-12-04 09:00:00	GLD	ETF	64.03	64.13	64.02	64.13	413200.0
2006-12-04 10:00:00	GLD	ETF	64.12	64.14	63.56	63.88	1293600.0
2006-12-04 11:00:00	GLD	ETF	63.87	64.08	63.87	63.98	551100.0
2006-12-04 12:00:00	GLD	ETF	63.99	64.11	63.93	64.07	231700.0
2006-12-04 13:00:00	GLD	ETF	64.06	64.12	63.97	64.08	297700.0

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

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