PREVIEW / etf_1hour / 2007-09-26

all etf 1-hour files

  file:    by_date/etf_1hour/2007/2007-09-26.parquet
  size:    86 KB
  rows:    2,873

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-09-26 04:00:00	SPY	ETF	152.06	152.08	151.97	152.03	3800.0
2007-09-26 05:00:00	SPY	ETF	152.05	152.19	152.04	152.1	15900.0
2007-09-26 06:00:00	SPY	ETF	152.1	152.15	152.03	152.15	41000.0
2007-09-26 07:00:00	SPY	ETF	152.1	152.37	152.08	152.14	1224700.0
2007-09-26 08:00:00	SPY	ETF	152.2	152.38	152.06	152.27	2871600.0
2007-09-26 09:00:00	SPY	ETF	152.27	152.41	151.94	152.06	15099754.0
2007-09-26 10:00:00	SPY	ETF	152.06	152.2	151.86	152.12	14763300.0
2007-09-26 11:00:00	SPY	ETF	152.12	152.62	152.11	152.46	17813100.0
2007-09-26 12:00:00	SPY	ETF	152.47	152.55	152.24	152.28	6894800.0
2007-09-26 13:00:00	SPY	ETF	152.27	152.46	151.64	151.76	18109100.0
2007-09-26 14:00:00	SPY	ETF	151.77	152.1	151.75	151.99	13941200.0
2007-09-26 15:00:00	SPY	ETF	151.98	152.77	151.94	152.37	27358300.0
2007-09-26 16:00:00	SPY	ETF	152.34	152.35	151.52	152.3	4305900.0
2007-09-26 17:00:00	SPY	ETF	152.3	152.41	150.52	152.3	9065000.0
2007-09-26 18:00:00	SPY	ETF	152.3	152.31	152.28	152.3	14500.0
2007-09-26 19:00:00	SPY	ETF	152.3	152.39	152.28	152.38	41700.0
2007-09-26 05:00:00	QQQ	ETF	51.28	51.29	51.28	51.29	1990.0
2007-09-26 06:00:00	QQQ	ETF	51.28	51.29	51.28	51.29	3200.0
2007-09-26 07:00:00	QQQ	ETF	51.25	51.42	51.25	51.32	1164340.0
2007-09-26 08:00:00	QQQ	ETF	51.34	51.4	51.25	51.34	1846388.0
2007-09-26 09:00:00	QQQ	ETF	51.35	51.39	51.2	51.255	14018285.0
2007-09-26 10:00:00	QQQ	ETF	51.26	51.37	51.19	51.28	17670398.0
2007-09-26 11:00:00	QQQ	ETF	51.28	51.51	51.27	51.42	16325956.0
2007-09-26 12:00:00	QQQ	ETF	51.43	51.47	51.38	51.41	3502105.0
2007-09-26 13:00:00	QQQ	ETF	51.42	51.5	51.14	51.17	12159854.0
2007-09-26 14:00:00	QQQ	ETF	51.17	51.3	51.12	51.23	11935219.0
2007-09-26 15:00:00	QQQ	ETF	51.23	51.43	51.22	51.34	14900799.0
2007-09-26 16:00:00	QQQ	ETF	51.32	51.4129	51.26	51.39	2311663.0
2007-09-26 17:00:00	QQQ	ETF	51.32	51.4	51.32	51.39	259663.0
2007-09-26 18:00:00	QQQ	ETF	51.39	51.39	51.38	51.39	2500.0
2007-09-26 19:00:00	QQQ	ETF	51.38	51.4	51.34	51.34	22050.0
2007-09-26 06:00:00	IWM	ETF	80.33	80.33	80.32	80.32	5100.0
2007-09-26 07:00:00	IWM	ETF	80.32	80.52	80.24	80.44	365900.0
2007-09-26 08:00:00	IWM	ETF	80.45	80.55	80.34	80.46	1209300.0
2007-09-26 09:00:00	IWM	ETF	80.48	80.57	79.82	80.44	7082264.0
2007-09-26 10:00:00	IWM	ETF	80.43	80.76	80.38	80.5	12386500.0
2007-09-26 11:00:00	IWM	ETF	80.5	80.92	80.5	80.76	8335200.0
2007-09-26 12:00:00	IWM	ETF	80.76	80.8	80.58	80.59	4119300.0
2007-09-26 13:00:00	IWM	ETF	80.6	80.68	80.02	80.15	7472900.0
2007-09-26 14:00:00	IWM	ETF	80.15	80.42	80.12	80.34	7298700.0
2007-09-26 15:00:00	IWM	ETF	80.35	80.75	80.25	80.52	14122800.0
2007-09-26 16:00:00	IWM	ETF	80.52	80.65	79.92	80.54	3018900.0
2007-09-26 17:00:00	IWM	ETF	80.54	80.6	80.54	80.6	7300.0
2007-09-26 18:00:00	IWM	ETF	80.55	80.55	80.55	80.55	200.0
2007-09-26 19:00:00	IWM	ETF	80.5	80.54	80.5	80.54	900.0
2007-09-26 07:00:00	DIA	ETF	138.4	138.5	138.33	138.34	52800.0
2007-09-26 08:00:00	DIA	ETF	138.35	138.43	138.26	138.38	32200.0
2007-09-26 09:00:00	DIA	ETF	138.34	138.42	138.14	138.24	1265300.0
2007-09-26 10:00:00	DIA	ETF	138.25	138.36	138.18	138.29	885800.0
2007-09-26 11:00:00	DIA	ETF	138.27	138.59	138.27	138.47	1347200.0

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

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