PREVIEW / etf_1hour / 2007-06-05

all etf 1-hour files

  file:    by_date/etf_1hour/2007/2007-06-05.parquet
  size:    78 KB
  rows:    2,642

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-06-05 05:00:00	SPY	ETF	154.19	154.19	154.19	154.19	1000.0
2007-06-05 06:00:00	SPY	ETF	154.18	154.18	154.01	154.01	30000.0
2007-06-05 07:00:00	SPY	ETF	154.0	154.0	153.81	153.85	208300.0
2007-06-05 08:00:00	SPY	ETF	153.96	153.96	153.63	153.72	4639400.0
2007-06-05 09:00:00	SPY	ETF	153.7	153.84	153.51	153.64	11113140.0
2007-06-05 10:00:00	SPY	ETF	153.63	153.9	153.32	153.8	29986018.0
2007-06-05 11:00:00	SPY	ETF	153.8	153.89	153.22	153.23	13163362.0
2007-06-05 12:00:00	SPY	ETF	153.23	153.5	152.86	153.23	20399833.0
2007-06-05 13:00:00	SPY	ETF	153.23	153.39	153.04	153.26	10775754.0
2007-06-05 14:00:00	SPY	ETF	153.27	153.43	153.08	153.16	10375960.0
2007-06-05 15:00:00	SPY	ETF	153.17	153.63	153.12	153.445	19606286.0
2007-06-05 16:00:00	SPY	ETF	153.45	153.55	153.37	153.53	2206100.0
2007-06-05 17:00:00	SPY	ETF	153.52	153.55	153.08	153.51	1062500.0
2007-06-05 18:00:00	SPY	ETF	153.51	153.56	153.51	153.54	3500.0
2007-06-05 19:00:00	SPY	ETF	153.55	153.55	153.47	153.47	23600.0
2007-06-05 06:00:00	QQQ	ETF	47.53	47.53	47.53	47.53	150.0
2007-06-05 07:00:00	QQQ	ETF	47.5	47.5	47.42	47.46	161071.0
2007-06-05 08:00:00	QQQ	ETF	47.46	47.48	47.41	47.44	901221.0
2007-06-05 09:00:00	QQQ	ETF	47.44	47.5	47.34	47.43	10557763.0
2007-06-05 10:00:00	QQQ	ETF	47.43	47.52	47.29	47.47	19154531.0
2007-06-05 11:00:00	QQQ	ETF	47.48	47.53	47.27	47.27	29236072.0
2007-06-05 12:00:00	QQQ	ETF	47.26	47.32	47.0	47.31	37861672.0
2007-06-05 13:00:00	QQQ	ETF	47.31	47.41	47.24	47.36	21196456.0
2007-06-05 14:00:00	QQQ	ETF	47.35	47.44	47.28	47.342	10131195.0
2007-06-05 15:00:00	QQQ	ETF	47.3415	47.58	47.33	47.575	16098164.0
2007-06-05 16:00:00	QQQ	ETF	47.57	47.61	47.51	47.57	2890983.0
2007-06-05 17:00:00	QQQ	ETF	47.55	47.56	47.54	47.56	25948.0
2007-06-05 18:00:00	QQQ	ETF	47.56	47.57	47.56	47.56	8100.0
2007-06-05 19:00:00	QQQ	ETF	47.54	47.57	47.54	47.57	7779.0
2007-06-05 08:00:00	IWM	ETF	84.6	84.61	84.5	84.57	201300.0
2007-06-05 09:00:00	IWM	ETF	84.56	84.69	84.27	84.39	9044200.0
2007-06-05 10:00:00	IWM	ETF	84.38	84.61	84.2	84.56	10868325.0
2007-06-05 11:00:00	IWM	ETF	84.56	84.72	84.16	84.17	13074835.0
2007-06-05 12:00:00	IWM	ETF	84.16	84.2	83.9	84.16	11822232.0
2007-06-05 13:00:00	IWM	ETF	84.16	84.26	83.83	83.99	12649511.0
2007-06-05 14:00:00	IWM	ETF	83.99	84.22	83.93	84.03	7710951.0
2007-06-05 15:00:00	IWM	ETF	84.02	86.23	83.99	84.3	9245418.0
2007-06-05 16:00:00	IWM	ETF	84.29	84.5	84.29	84.49	2805200.0
2007-06-05 17:00:00	IWM	ETF	84.49	84.49	84.49	84.49	182700.0
2007-06-05 18:00:00	IWM	ETF	84.49	84.49	84.49	84.49	200.0
2007-06-05 07:00:00	DIA	ETF	136.4	136.42	136.35	136.35	4300.0
2007-06-05 08:00:00	DIA	ETF	136.41	136.41	136.17	136.17	26900.0
2007-06-05 09:00:00	DIA	ETF	136.21	136.3	135.94	136.05	1294300.0
2007-06-05 10:00:00	DIA	ETF	136.04	136.32	135.92	136.24	2978300.0
2007-06-05 11:00:00	DIA	ETF	136.24	136.31	135.79	135.79	1854201.0
2007-06-05 12:00:00	DIA	ETF	135.78	135.83	135.43	135.75	1863600.0
2007-06-05 13:00:00	DIA	ETF	135.75	135.85	135.54	135.69	963123.0
2007-06-05 14:00:00	DIA	ETF	135.69	135.83	135.54	135.61	1078348.0
2007-06-05 15:00:00	DIA	ETF	135.61	135.98	135.58	135.87	2887750.0
2007-06-05 16:00:00	DIA	ETF	135.87	135.99	135.87	135.99	39800.0

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

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