PREVIEW / etf_1hour / 2007-03-22

all etf 1-hour files

  file:    by_date/etf_1hour/2007/2007-03-22.parquet
  size:    68 KB
  rows:    2,166

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
2007-03-22 05:00:00	SPY	ETF	143.19	143.19	143.19	143.19	1000.0
2007-03-22 06:00:00	SPY	ETF	143.11	143.18	143.11	143.18	4500.0
2007-03-22 07:00:00	SPY	ETF	143.16	143.28	143.08	143.19	587200.0
2007-03-22 08:00:00	SPY	ETF	143.19	143.79	143.16	143.62	2923400.0
2007-03-22 09:00:00	SPY	ETF	143.62	143.68	143.1	143.14	17591579.0
2007-03-22 10:00:00	SPY	ETF	143.14	143.38	142.85	142.9	30132349.0
2007-03-22 11:00:00	SPY	ETF	142.9	143.35	142.79	143.35	16516249.0
2007-03-22 12:00:00	SPY	ETF	143.35	143.64	143.25	143.39	17920750.0
2007-03-22 13:00:00	SPY	ETF	143.4	143.41	143.11	143.32	8077525.0
2007-03-22 14:00:00	SPY	ETF	143.33	143.68	143.31	143.46	6646600.0
2007-03-22 15:00:00	SPY	ETF	143.47	143.47	143.05	143.31	15287050.0
2007-03-22 16:00:00	SPY	ETF	143.31	143.38	143.06	143.13	749500.0
2007-03-22 17:00:00	SPY	ETF	143.15	143.18	143.12	143.13	54000.0
2007-03-22 18:00:00	SPY	ETF	143.16	143.21	143.16	143.2	8700.0
2007-03-22 19:00:00	SPY	ETF	143.16	143.17	143.1	143.16	49100.0
2007-03-22 07:00:00	QQQ	ETF	44.32	44.45	44.32	44.42	725415.0
2007-03-22 08:00:00	QQQ	ETF	44.42	44.53	44.38	44.45	4328405.0
2007-03-22 09:00:00	QQQ	ETF	44.46	44.47	44.16	44.19	15556405.0
2007-03-22 10:00:00	QQQ	ETF	44.19	44.41	44.1	44.14	17860800.0
2007-03-22 11:00:00	QQQ	ETF	44.14	44.41	44.09	44.28	12039600.0
2007-03-22 12:00:00	QQQ	ETF	44.28	44.41	44.25	44.3	12011100.0
2007-03-22 13:00:00	QQQ	ETF	44.29	44.3	44.13	44.21	10724200.0
2007-03-22 14:00:00	QQQ	ETF	44.21	44.41	44.21	44.28	18332900.0
2007-03-22 15:00:00	QQQ	ETF	44.29	44.41	44.15	44.27	19084900.0
2007-03-22 16:00:00	QQQ	ETF	44.27	44.28	44.2	44.22	3465814.0
2007-03-22 17:00:00	QQQ	ETF	44.24	44.24	44.2	44.2	77212.0
2007-03-22 18:00:00	QQQ	ETF	44.23	44.23	44.21	44.21	6600.0
2007-03-22 19:00:00	QQQ	ETF	44.21	44.21	44.2	44.21	25685.0
2007-03-22 07:00:00	IWM	ETF	80.35	80.4	80.35	80.35	13000.0
2007-03-22 08:00:00	IWM	ETF	80.35	80.7	80.35	80.54	749600.0
2007-03-22 09:00:00	IWM	ETF	80.57	80.64	80.04	80.07	5476276.0
2007-03-22 10:00:00	IWM	ETF	80.07	80.28	79.91	79.97	9052500.0
2007-03-22 11:00:00	IWM	ETF	79.98	80.24	79.95	80.24	4542900.0
2007-03-22 12:00:00	IWM	ETF	80.24	80.39	80.18	80.24	5816700.0
2007-03-22 13:00:00	IWM	ETF	80.24	80.27	80.015	80.16	3583900.0
2007-03-22 14:00:00	IWM	ETF	80.16	80.37	80.16	80.29	2335100.0
2007-03-22 15:00:00	IWM	ETF	80.29	80.32	80.06	80.3	7700642.0
2007-03-22 16:00:00	IWM	ETF	80.29	80.34	80.18	80.27	408300.0
2007-03-22 17:00:00	IWM	ETF	80.23	80.23	80.19	80.2	50100.0
2007-03-22 18:00:00	IWM	ETF	80.27	80.27	80.27	80.27	4600.0
2007-03-22 19:00:00	IWM	ETF	80.27	80.27	80.27	80.27	300.0
2007-03-22 07:00:00	DIA	ETF	124.3	124.37	124.3	124.37	200.0
2007-03-22 08:00:00	DIA	ETF	124.39	124.73	124.37	124.66	36800.0
2007-03-22 09:00:00	DIA	ETF	124.61	124.63	124.1	124.14	1429000.0
2007-03-22 10:00:00	DIA	ETF	124.14	124.39	124.0	124.06	1209300.0
2007-03-22 11:00:00	DIA	ETF	124.05	124.41	123.98	124.41	722000.0
2007-03-22 12:00:00	DIA	ETF	124.42	124.64	124.34	124.4	847800.0
2007-03-22 13:00:00	DIA	ETF	124.4	124.43	124.15	124.39	721100.0
2007-03-22 14:00:00	DIA	ETF	124.41	124.63	124.4	124.55	468200.0
2007-03-22 15:00:00	DIA	ETF	124.55	124.56	124.24	124.5	933450.0

> showing 50 of 2,166 rows — these rows as CSV

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