PREVIEW / etf_1hour / 2006-12-15

all etf 1-hour files

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

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-15 04:00:00	SPY	ETF	142.38	142.38	142.38	142.38	3100.0
2006-12-15 06:00:00	SPY	ETF	142.34	142.34	142.32	142.32	28000.0
2006-12-15 07:00:00	SPY	ETF	142.31	142.36	142.27	142.27	138700.0
2006-12-15 08:00:00	SPY	ETF	142.28	142.97	142.2	142.9	6446100.0
2006-12-15 09:00:00	SPY	ETF	142.9	142.93	142.46	142.68	13144500.0
2006-12-15 10:00:00	SPY	ETF	142.68	142.82	142.54	142.8	7735900.0
2006-12-15 11:00:00	SPY	ETF	142.8	142.89	142.59	142.67	7859500.0
2006-12-15 12:00:00	SPY	ETF	142.68	142.69	142.34	142.51	7189500.0
2006-12-15 13:00:00	SPY	ETF	142.51	142.8	142.24	142.44	7040900.0
2006-12-15 14:00:00	SPY	ETF	142.43	142.58	142.35	142.55	5477300.0
2006-12-15 15:00:00	SPY	ETF	142.55	142.59	142.32	142.4	8464900.0
2006-12-15 16:00:00	SPY	ETF	142.4	142.45	142.2	142.31	969200.0
2006-12-15 17:00:00	SPY	ETF	142.27	142.5677	142.27	142.32	1126400.0
2006-12-15 18:00:00	SPY	ETF	142.34	142.34	142.34	142.34	1300.0
2006-12-15 19:00:00	SPY	ETF	142.3	142.3	142.27	142.27	1400.0
2006-12-15 09:00:00	QQQ	ETF	44.67	44.76	44.49	44.64	22796500.0
2006-12-15 10:00:00	QQQ	ETF	44.63	44.68	44.56	44.61	9349200.0
2006-12-15 11:00:00	QQQ	ETF	44.62	44.66	44.54	44.62	7582600.0
2006-12-15 12:00:00	QQQ	ETF	44.61	44.63	44.4	44.47	10503800.0
2006-12-15 13:00:00	QQQ	ETF	44.47	44.6	44.35	44.45	10231700.0
2006-12-15 14:00:00	QQQ	ETF	44.46	44.51	44.4	44.48	7668800.0
2006-12-15 15:00:00	QQQ	ETF	44.49	44.52	44.38	44.43	10505200.0
2006-12-15 08:00:00	IWM	ETF	78.95	79.42	78.93	79.38	850200.0
2006-12-15 09:00:00	IWM	ETF	79.37	79.43	79.11	79.33	6828900.0
2006-12-15 10:00:00	IWM	ETF	79.34	79.41	79.2	79.4	5819400.0
2006-12-15 11:00:00	IWM	ETF	79.4	79.5	79.25	79.3	5846900.0
2006-12-15 12:00:00	IWM	ETF	79.3	79.3	79.05	79.09	2651900.0
2006-12-15 13:00:00	IWM	ETF	79.08	79.3	78.81	78.98	7523900.0
2006-12-15 14:00:00	IWM	ETF	78.97	79.02	78.87	79.0	2990900.0
2006-12-15 15:00:00	IWM	ETF	79.0	79.0	78.82	78.87	4674700.0
2006-12-15 16:00:00	IWM	ETF	78.88	79.3	78.85	79.3	549700.0
2006-12-15 17:00:00	IWM	ETF	78.9	78.96	78.9	78.96	23000.0
2006-12-15 07:00:00	DIA	ETF	123.93	123.93	123.92	123.92	1500.0
2006-12-15 08:00:00	DIA	ETF	123.94	124.38	123.88	124.31	192300.0
2006-12-15 09:00:00	DIA	ETF	124.31	124.45	124.16	124.37	2138700.0
2006-12-15 10:00:00	DIA	ETF	124.38	124.53	124.34	124.5	1231700.0
2006-12-15 11:00:00	DIA	ETF	124.51	124.59	124.3	124.35	820200.0
2006-12-15 12:00:00	DIA	ETF	124.35	124.43	124.21	124.3	1036600.0
2006-12-15 13:00:00	DIA	ETF	124.3	124.37	124.12	124.24	669400.0
2006-12-15 14:00:00	DIA	ETF	124.24	124.34	124.2	124.27	652300.0
2006-12-15 15:00:00	DIA	ETF	124.27	124.28	124.1	124.22	901200.0
2006-12-15 16:00:00	DIA	ETF	124.22	124.24	124.1	124.1	74100.0
2006-12-15 17:00:00	DIA	ETF	124.12	124.3119	124.12	124.25	1552700.0
2006-12-15 07:00:00	GLD	ETF	62.08	62.08	62.08	62.08	2000.0
2006-12-15 08:00:00	GLD	ETF	62.1	62.45	62.05	62.43	113600.0
2006-12-15 09:00:00	GLD	ETF	62.4	62.42	62.01	62.01	373200.0
2006-12-15 10:00:00	GLD	ETF	62.0	62.12	61.74	61.9	1219900.0
2006-12-15 11:00:00	GLD	ETF	61.8912	61.99	61.8	61.94	453900.0
2006-12-15 12:00:00	GLD	ETF	61.94	61.94	61.33	61.45	1938500.0
2006-12-15 13:00:00	GLD	ETF	61.46	61.54	60.93	61.0694	2415100.0

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

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