PREVIEW / etf_1hour / 2007-07-05

all etf 1-hour files

  file:    by_date/etf_1hour/2007/2007-07-05.parquet
  size:    80 KB
  rows:    2,710

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-07-05 04:00:00	SPY	ETF	152.49	152.49	152.49	152.49	100.0
2007-07-05 06:00:00	SPY	ETF	152.64	152.64	152.52	152.52	4500.0
2007-07-05 07:00:00	SPY	ETF	152.46	152.72	152.39	152.68	270800.0
2007-07-05 08:00:00	SPY	ETF	152.68	152.76	152.22	152.32	1678000.0
2007-07-05 09:00:00	SPY	ETF	152.54	152.54	152.11	152.38	9672123.0
2007-07-05 10:00:00	SPY	ETF	152.38	152.56	152.08	152.23	16022181.0
2007-07-05 11:00:00	SPY	ETF	152.23	152.32	151.93	152.06	11049965.0
2007-07-05 12:00:00	SPY	ETF	152.05	152.19	151.63	151.77	17183819.0
2007-07-05 13:00:00	SPY	ETF	151.77	152.13	151.73	151.9	7029778.0
2007-07-05 14:00:00	SPY	ETF	151.89	152.35	151.84	152.29	7975714.0
2007-07-05 15:00:00	SPY	ETF	152.3	152.53	152.16	152.43	10049158.0
2007-07-05 16:00:00	SPY	ETF	152.42	152.44	151.85	152.18	4975200.0
2007-07-05 17:00:00	SPY	ETF	152.19	152.25	152.19	152.2	31100.0
2007-07-05 18:00:00	SPY	ETF	152.22	152.39	152.18	152.39	214900.0
2007-07-05 19:00:00	SPY	ETF	152.34	152.34	152.3	152.34	14300.0
2007-07-05 04:00:00	QQQ	ETF	48.33	48.35	48.33	48.35	29044.0
2007-07-05 07:00:00	QQQ	ETF	48.31	48.45	48.3	48.43	451589.0
2007-07-05 08:00:00	QQQ	ETF	48.44	48.47	48.36	48.38	1988076.0
2007-07-05 09:00:00	QQQ	ETF	48.38	48.45	48.29	48.43	6557929.0
2007-07-05 10:00:00	QQQ	ETF	48.422	48.52	48.39	48.4699	10159215.0
2007-07-05 11:00:00	QQQ	ETF	48.47	48.47	48.3	48.4	9324930.0
2007-07-05 12:00:00	QQQ	ETF	48.4	48.44	48.29	48.37	9816334.0
2007-07-05 13:00:00	QQQ	ETF	48.37	48.48	48.36	48.44	4630725.0
2007-07-05 14:00:00	QQQ	ETF	48.435	48.65	48.43	48.63	8066639.0
2007-07-05 15:00:00	QQQ	ETF	48.64	48.77	48.59	48.71	15666578.0
2007-07-05 16:00:00	QQQ	ETF	48.7	48.71	48.6	48.62	3691787.0
2007-07-05 17:00:00	QQQ	ETF	48.63	48.67	48.63	48.65	125709.0
2007-07-05 18:00:00	QQQ	ETF	48.65	48.69	48.64	48.67	62520.0
2007-07-05 19:00:00	QQQ	ETF	48.67	48.7	48.67	48.7	7090.0
2007-07-05 07:00:00	IWM	ETF	84.45	84.61	84.45	84.53	17500.0
2007-07-05 08:00:00	IWM	ETF	84.55	84.63	84.34	84.36	377800.0
2007-07-05 09:00:00	IWM	ETF	84.35	84.65	84.3	84.58	3078586.0
2007-07-05 10:00:00	IWM	ETF	84.56	84.67	84.36	84.47	5543400.0
2007-07-05 11:00:00	IWM	ETF	84.47	84.47	84.13	84.29	6433955.0
2007-07-05 12:00:00	IWM	ETF	84.29	84.5	83.86	83.98	9946837.0
2007-07-05 13:00:00	IWM	ETF	83.98	84.18	83.97	84.07	3775944.0
2007-07-05 14:00:00	IWM	ETF	84.07	84.38	84.05	84.35	4479814.0
2007-07-05 15:00:00	IWM	ETF	84.35	84.6	84.09	84.53	4284768.0
2007-07-05 16:00:00	IWM	ETF	84.53	84.58	84.47	84.5	2624100.0
2007-07-05 19:00:00	IWM	ETF	84.48	84.48	84.48	84.48	300.0
2007-07-05 07:00:00	DIA	ETF	135.71	135.73	135.71	135.73	900.0
2007-07-05 08:00:00	DIA	ETF	135.85	135.85	135.49	135.49	76200.0
2007-07-05 09:00:00	DIA	ETF	135.49	135.64	135.19	135.53	1516603.0
2007-07-05 10:00:00	DIA	ETF	135.54	135.71	135.41	135.5	1996640.0
2007-07-05 11:00:00	DIA	ETF	135.49	135.53	135.25	135.36	1334800.0
2007-07-05 12:00:00	DIA	ETF	135.36	135.47	135.05	135.18	1577000.0
2007-07-05 13:00:00	DIA	ETF	135.18	135.42	135.13	135.24	684746.0
2007-07-05 14:00:00	DIA	ETF	135.25	135.68	135.18	135.6	1144100.0
2007-07-05 15:00:00	DIA	ETF	135.6	135.72	135.46	135.63	1006400.0
2007-07-05 16:00:00	DIA	ETF	135.62	135.64	135.52	135.52	38700.0

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

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