PREVIEW / etf_1hour / 2007-08-22

all etf 1-hour files

  file:    by_date/etf_1hour/2007/2007-08-22.parquet
  size:    84 KB
  rows:    2,843

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-08-22 04:00:00	SPY	ETF	145.79	146.08	145.79	145.96	6800.0
2007-08-22 06:00:00	SPY	ETF	146.03	146.12	146.01	146.05	25400.0
2007-08-22 07:00:00	SPY	ETF	146.0	146.06	145.75	145.83	768200.0
2007-08-22 08:00:00	SPY	ETF	145.83	146.125	145.78	145.99	1674300.0
2007-08-22 09:00:00	SPY	ETF	146.0	146.6	145.87	146.29	25154324.0
2007-08-22 10:00:00	SPY	ETF	146.29	146.53	146.1	146.25	21926100.0
2007-08-22 11:00:00	SPY	ETF	146.25	146.35	145.77	146.12	23665200.0
2007-08-22 12:00:00	SPY	ETF	146.11	146.39	145.42	145.72	23355000.0
2007-08-22 13:00:00	SPY	ETF	145.72	146.21	145.33	146.14	19041048.0
2007-08-22 14:00:00	SPY	ETF	146.12	146.18	145.5	146.0	13380500.0
2007-08-22 15:00:00	SPY	ETF	146.0	146.8	145.84	146.66	29513200.0
2007-08-22 16:00:00	SPY	ETF	146.69	146.8	146.48	146.73	3633400.0
2007-08-22 17:00:00	SPY	ETF	146.73	147.15	144.9721	147.15	4006800.0
2007-08-22 18:00:00	SPY	ETF	147.15	147.88	146.78	147.73	2870900.0
2007-08-22 19:00:00	SPY	ETF	147.73	147.84	147.58	147.82	232200.0
2007-08-22 04:00:00	QQQ	ETF	47.24	47.28	47.24	47.28	400.0
2007-08-22 05:00:00	QQQ	ETF	47.2	47.25	47.2	47.25	25100.0
2007-08-22 06:00:00	QQQ	ETF	47.25	47.34	47.2	47.34	80100.0
2007-08-22 07:00:00	QQQ	ETF	47.27	47.27	47.19	47.24	511356.0
2007-08-22 08:00:00	QQQ	ETF	47.24	47.33	47.23	47.31	1062143.0
2007-08-22 09:00:00	QQQ	ETF	47.32	47.57	47.3	47.49	22307786.0
2007-08-22 10:00:00	QQQ	ETF	47.49	47.55	47.4	47.4619	13119764.0
2007-08-22 11:00:00	QQQ	ETF	47.47	47.51	47.362	47.4799	9869068.0
2007-08-22 12:00:00	QQQ	ETF	47.47	47.52	47.28	47.36	11528936.0
2007-08-22 13:00:00	QQQ	ETF	47.35	47.52	47.27	47.49	12605506.0
2007-08-22 14:00:00	QQQ	ETF	47.49	47.53	47.33	47.486	12933998.0
2007-08-22 15:00:00	QQQ	ETF	47.49	47.7	47.44	47.63	17688139.0
2007-08-22 16:00:00	QQQ	ETF	47.63	47.72	47.61	47.7	5163210.0
2007-08-22 17:00:00	QQQ	ETF	47.7	47.81	47.66	47.81	1404981.0
2007-08-22 18:00:00	QQQ	ETF	47.77	47.97	47.76	47.96	974634.0
2007-08-22 19:00:00	QQQ	ETF	47.97	48.0	47.92	47.98	347121.0
2007-08-22 06:00:00	IWM	ETF	79.31	79.48	79.31	79.48	400.0
2007-08-22 07:00:00	IWM	ETF	79.3	79.35	79.28	79.35	105000.0
2007-08-22 08:00:00	IWM	ETF	79.3	79.49	79.29	79.42	219700.0
2007-08-22 09:00:00	IWM	ETF	79.45	79.78	79.31	79.57	13884022.0
2007-08-22 10:00:00	IWM	ETF	79.57	79.71	79.39	79.49	8595000.0
2007-08-22 11:00:00	IWM	ETF	79.49	79.57	79.26	79.41	6187200.0
2007-08-22 12:00:00	IWM	ETF	79.4	79.48	78.96	79.13	6352600.0
2007-08-22 13:00:00	IWM	ETF	79.13	79.5	78.93	79.43	7945400.0
2007-08-22 14:00:00	IWM	ETF	79.43	79.48	79.06	79.39	7862300.0
2007-08-22 15:00:00	IWM	ETF	79.39	79.79	79.34	79.47	13076700.0
2007-08-22 16:00:00	IWM	ETF	79.47	79.68	79.44	79.63	1236200.0
2007-08-22 17:00:00	IWM	ETF	79.62	79.89	79.62	79.78	2007700.0
2007-08-22 18:00:00	IWM	ETF	79.86	80.26	79.63	79.63	752700.0
2007-08-22 19:00:00	IWM	ETF	80.21	80.26	80.15	80.26	84200.0
2007-08-22 07:00:00	DIA	ETF	131.6	131.6	131.43	131.49	5000.0
2007-08-22 08:00:00	DIA	ETF	131.39	131.58	131.36	131.56	28000.0
2007-08-22 09:00:00	DIA	ETF	131.54	132.1	131.53	131.84	1341300.0
2007-08-22 10:00:00	DIA	ETF	131.83	132.08	131.73	131.91	2034500.0
2007-08-22 11:00:00	DIA	ETF	131.89	132.0	131.56	131.87	1855500.0

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

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