PREVIEW / etf_1hour / 2006-11-21

all etf 1-hour files

  file:    by_date/etf_1hour/2006/2006-11-21.parquet
  size:    56 KB
  rows:    1,765

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-11-21 05:00:00	SPY	ETF	140.6	140.6	140.6	140.6	400.0
2006-11-21 07:00:00	SPY	ETF	140.64	140.67	140.6	140.64	242500.0
2006-11-21 08:00:00	SPY	ETF	140.64	140.7	140.56	140.61	1240400.0
2006-11-21 09:00:00	SPY	ETF	140.61	140.62	140.37	140.41	8788300.0
2006-11-21 10:00:00	SPY	ETF	140.4	140.63	140.33	140.47	10102400.0
2006-11-21 11:00:00	SPY	ETF	140.48	140.48	140.29	140.44	7212200.0
2006-11-21 12:00:00	SPY	ETF	140.44	140.6	140.42	140.54	5304400.0
2006-11-21 13:00:00	SPY	ETF	140.52	140.67	140.41	140.56	4558900.0
2006-11-21 14:00:00	SPY	ETF	140.57	140.65	140.44	140.54	5699000.0
2006-11-21 15:00:00	SPY	ETF	140.54	140.6	140.48	140.59	5939900.0
2006-11-21 16:00:00	SPY	ETF	140.59	140.67	140.4911	140.67	1333100.0
2006-11-21 17:00:00	SPY	ETF	140.67	140.7	140.64	140.7	159600.0
2006-11-21 18:00:00	SPY	ETF	140.68	140.7	140.68	140.7	2600.0
2006-11-21 19:00:00	SPY	ETF	140.67	140.7	140.67	140.7	1500.0
2006-11-21 09:00:00	QQQ	ETF	44.42	44.48	44.36	44.38	8920800.0
2006-11-21 10:00:00	QQQ	ETF	44.38	45.4	44.26	44.33	14094300.0
2006-11-21 11:00:00	QQQ	ETF	44.33	44.39	44.25	44.38	7096900.0
2006-11-21 12:00:00	QQQ	ETF	44.38	44.47	44.35	44.44	6036100.0
2006-11-21 13:00:00	QQQ	ETF	44.44	44.51	44.4	44.46	5152500.0
2006-11-21 14:00:00	QQQ	ETF	44.46	44.46	44.35	44.41	7101500.0
2006-11-21 15:00:00	QQQ	ETF	44.41	44.48	44.37	44.46	10591000.0
2006-11-21 08:00:00	IWM	ETF	78.78	78.78	78.7	78.73	1807200.0
2006-11-21 09:00:00	IWM	ETF	78.73	78.8	78.42	78.45	3774700.0
2006-11-21 10:00:00	IWM	ETF	78.45	78.82	78.44	78.58	6743600.0
2006-11-21 11:00:00	IWM	ETF	78.57	78.6	78.31	78.57	3772500.0
2006-11-21 12:00:00	IWM	ETF	78.58	78.86	78.57	78.78	5996200.0
2006-11-21 13:00:00	IWM	ETF	78.79	78.86	78.7	78.72	2244800.0
2006-11-21 14:00:00	IWM	ETF	78.72	78.82	78.62	78.78	3086000.0
2006-11-21 15:00:00	IWM	ETF	78.79	78.85	78.67	78.83	4170400.0
2006-11-21 16:00:00	IWM	ETF	78.83	78.93	78.77	78.92	2752700.0
2006-11-21 17:00:00	IWM	ETF	78.93	79.03	78.6546	79.03	5229500.0
2006-11-21 18:00:00	IWM	ETF	79.0	79.0	79.0	79.0	1000.0
2006-11-21 08:00:00	DIA	ETF	123.26	123.26	123.19	123.24	224500.0
2006-11-21 09:00:00	DIA	ETF	123.21	123.21	123.0	123.04	839400.0
2006-11-21 10:00:00	DIA	ETF	123.04	123.2	122.95	123.04	1128600.0
2006-11-21 11:00:00	DIA	ETF	123.04	123.1	122.86	123.08	1151900.0
2006-11-21 12:00:00	DIA	ETF	123.08	123.27	123.07	123.2	432100.0
2006-11-21 13:00:00	DIA	ETF	123.21	123.32	123.12	123.26	440300.0
2006-11-21 14:00:00	DIA	ETF	123.27	123.28	123.08	123.19	463700.0
2006-11-21 15:00:00	DIA	ETF	123.19	123.21	123.09	123.11	793300.0
2006-11-21 16:00:00	DIA	ETF	123.12	123.15	123.06	123.14	31300.0
2006-11-21 17:00:00	DIA	ETF	123.11	123.11	123.11	123.11	150000.0
2006-11-21 08:00:00	GLD	ETF	62.1	62.29	62.1	62.25	47600.0
2006-11-21 09:00:00	GLD	ETF	62.25	62.35	62.07	62.1	288600.0
2006-11-21 10:00:00	GLD	ETF	62.0902	62.39	62.03	62.38	842000.0
2006-11-21 11:00:00	GLD	ETF	62.37	62.47	62.2	62.23	453900.0
2006-11-21 12:00:00	GLD	ETF	62.23	62.3	62.1	62.1482	195100.0
2006-11-21 13:00:00	GLD	ETF	62.15	62.49	62.13	62.46	406500.0
2006-11-21 14:00:00	GLD	ETF	62.47	62.52	62.41	62.47	290400.0
2006-11-21 15:00:00	GLD	ETF	62.47	62.48	62.2	62.28	377700.0

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

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