PREVIEW / etf_1hour / 2007-02-16

all etf 1-hour files

  file:    by_date/etf_1hour/2007/2007-02-16.parquet
  size:    63 KB
  rows:    2,049

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-02-16 06:00:00	SPY	ETF	145.6	145.6	145.6	145.6	1000.0
2007-02-16 07:00:00	SPY	ETF	145.65	145.72	145.59	145.72	18100.0
2007-02-16 08:00:00	SPY	ETF	145.72	145.77	145.5	145.63	1313400.0
2007-02-16 09:00:00	SPY	ETF	145.63	145.63	145.38	145.41	6339000.0
2007-02-16 10:00:00	SPY	ETF	145.41	145.57	145.23	145.53	7883500.0
2007-02-16 11:00:00	SPY	ETF	145.53	145.61	145.43	145.5	2992100.0
2007-02-16 12:00:00	SPY	ETF	145.5	145.53	145.4	145.5	2049300.0
2007-02-16 13:00:00	SPY	ETF	145.5	145.55	145.38	145.47	3499300.0
2007-02-16 14:00:00	SPY	ETF	145.46	145.58	145.45	145.5	6314800.0
2007-02-16 15:00:00	SPY	ETF	145.5	145.74	145.49	145.68	6068800.0
2007-02-16 16:00:00	SPY	ETF	145.7	145.81	145.65	145.73	1131200.0
2007-02-16 17:00:00	SPY	ETF	145.71	145.72	145.71	145.71	2000.0
2007-02-16 18:00:00	SPY	ETF	145.73	145.73	145.73	145.73	500.0
2007-02-16 19:00:00	SPY	ETF	145.71	145.73	145.71	145.73	700.0
2007-02-16 06:00:00	QQQ	ETF	44.76	44.76	44.76	44.76	500.0
2007-02-16 07:00:00	QQQ	ETF	44.76	44.82	44.75	44.81	31746.0
2007-02-16 08:00:00	QQQ	ETF	44.8	44.83	44.69	44.74	990156.0
2007-02-16 09:00:00	QQQ	ETF	44.74	44.74	44.58	44.64	13077358.0
2007-02-16 10:00:00	QQQ	ETF	44.65	44.77	44.57	44.73	17066000.0
2007-02-16 11:00:00	QQQ	ETF	44.73	44.77	44.65	44.7	8508700.0
2007-02-16 12:00:00	QQQ	ETF	44.71	44.74	44.65	44.69	4522300.0
2007-02-16 13:00:00	QQQ	ETF	44.69	44.75	44.67	44.72	5059300.0
2007-02-16 14:00:00	QQQ	ETF	44.73	44.79	44.72	44.74	5890400.0
2007-02-16 15:00:00	QQQ	ETF	44.74	44.83	44.73	44.78	9743300.0
2007-02-16 16:00:00	QQQ	ETF	44.77	44.81	44.73	44.81	3080157.0
2007-02-16 17:00:00	QQQ	ETF	44.81	44.82	44.78	44.78	15873.0
2007-02-16 18:00:00	QQQ	ETF	44.79	44.82	44.78	44.8	10644.0
2007-02-16 19:00:00	QQQ	ETF	44.8	44.82	44.8	44.81	11800.0
2007-02-16 07:00:00	IWM	ETF	80.63	80.77	80.63	80.77	1500.0
2007-02-16 08:00:00	IWM	ETF	80.8	80.92	80.72	80.75	364700.0
2007-02-16 09:00:00	IWM	ETF	80.76	80.85	80.52	80.55	7702600.0
2007-02-16 10:00:00	IWM	ETF	80.56	80.76	80.34	80.72	10469600.0
2007-02-16 11:00:00	IWM	ETF	80.71	80.81	80.65	80.79	3062600.0
2007-02-16 12:00:00	IWM	ETF	80.8	80.83	80.73	80.81	2050400.0
2007-02-16 13:00:00	IWM	ETF	80.81	80.96	80.8	80.91	3032900.0
2007-02-16 14:00:00	IWM	ETF	80.92	81.08	80.89	80.95	3164000.0
2007-02-16 15:00:00	IWM	ETF	80.95	81.27	80.59	81.18	7280500.0
2007-02-16 16:00:00	IWM	ETF	81.18	81.21	81.1033	81.21	468800.0
2007-02-16 17:00:00	IWM	ETF	81.15	81.25	81.15	81.25	2700.0
2007-02-16 18:00:00	IWM	ETF	81.17	81.17	81.17	81.17	800.0
2007-02-16 19:00:00	IWM	ETF	81.25	81.25	81.25	81.25	1500.0
2007-02-16 07:00:00	DIA	ETF	127.46	127.53	127.45	127.53	3200.0
2007-02-16 08:00:00	DIA	ETF	127.5	127.55	127.48	127.49	12100.0
2007-02-16 09:00:00	DIA	ETF	127.48	127.53	127.33	127.41	797100.0
2007-02-16 10:00:00	DIA	ETF	127.4	127.44	127.32	127.4	2128200.0
2007-02-16 11:00:00	DIA	ETF	127.4	127.46	127.31	127.4	811600.0
2007-02-16 12:00:00	DIA	ETF	127.41	127.44	127.35	127.4	448400.0
2007-02-16 13:00:00	DIA	ETF	127.4	127.44	127.33	127.37	362100.0
2007-02-16 14:00:00	DIA	ETF	127.37	127.47	127.36	127.38	370000.0
2007-02-16 15:00:00	DIA	ETF	127.38	127.57	127.38	127.55	775800.0

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

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