PREVIEW / etf_30min / 2005-08-26

all etf 30-min files

  file:    by_date/etf_30min/2005/2005-08-26.parquet
  size:    45 KB
  rows:    1,585

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
2005-08-26 07:00:00	SPY	ETF	121.65	121.65	121.65	121.65	25000.0
2005-08-26 07:30:00	SPY	ETF	121.66	121.69	121.65	121.69	94400.0
2005-08-26 08:00:00	SPY	ETF	121.65	121.65	121.46	121.48	80300.0
2005-08-26 08:30:00	SPY	ETF	121.5	121.51	121.4	121.4	93800.0
2005-08-26 09:00:00	SPY	ETF	121.39	121.55	121.36	121.48	298900.0
2005-08-26 09:30:00	SPY	ETF	121.48	121.49	121.05	121.19	7898600.0
2005-08-26 10:00:00	SPY	ETF	121.18	121.18	120.81	121.03	8816700.0
2005-08-26 10:30:00	SPY	ETF	121.04	121.12	120.88	121.06	2918700.0
2005-08-26 11:00:00	SPY	ETF	121.05	121.49	120.85	120.86	2288200.0
2005-08-26 11:30:00	SPY	ETF	120.85	120.88	120.68	120.79	4476600.0
2005-08-26 12:00:00	SPY	ETF	120.79	121.02	120.77	120.96	2762600.0
2005-08-26 12:30:00	SPY	ETF	120.96	121.0	120.8	120.86	4305800.0
2005-08-26 13:00:00	SPY	ETF	120.86	120.96	120.75	120.79	1548200.0
2005-08-26 13:30:00	SPY	ETF	120.79	120.94	120.75	120.84	1843100.0
2005-08-26 14:00:00	SPY	ETF	120.87	121.36	120.74	121.22	7497300.0
2005-08-26 14:30:00	SPY	ETF	121.22	121.29	120.97	121.09	4263800.0
2005-08-26 15:00:00	SPY	ETF	121.09	121.38	121.01	121.0992	2235200.0
2005-08-26 15:30:00	SPY	ETF	121.09	121.16	120.81	120.82	5512800.0
2005-08-26 16:00:00	SPY	ETF	120.83	121.0211	120.72	120.77	1655600.0
2005-08-26 16:30:00	SPY	ETF	120.79	120.79	120.71	120.72	1067600.0
2005-08-26 17:00:00	SPY	ETF	120.71	120.72	120.6	120.6	25700.0
2005-08-26 17:30:00	SPY	ETF	120.62	120.7	120.53	120.7	7900.0
2005-08-26 18:00:00	SPY	ETF	120.7	120.7	120.7	120.7	2900.0
2005-08-26 18:30:00	SPY	ETF	120.72	120.74	120.72	120.74	800.0
2005-08-26 19:00:00	SPY	ETF	120.75	120.75	120.75	120.75	200.0
2005-08-26 09:30:00	QQQ	ETF	38.54	38.56	38.4	38.45	7730700.0
2005-08-26 10:00:00	QQQ	ETF	38.45	38.45	38.27	38.38	11001300.0
2005-08-26 10:30:00	QQQ	ETF	38.38	38.43	38.31	38.39	5783700.0
2005-08-26 11:00:00	QQQ	ETF	38.38	38.41	38.33	38.35	3087900.0
2005-08-26 11:30:00	QQQ	ETF	38.35	38.38	38.32	38.36	3434000.0
2005-08-26 12:00:00	QQQ	ETF	38.36	38.46	38.36	38.44	3100800.0
2005-08-26 12:30:00	QQQ	ETF	38.44	38.47	38.41	38.43	2232000.0
2005-08-26 13:00:00	QQQ	ETF	38.43	38.45	38.37	38.39	2709000.0
2005-08-26 13:30:00	QQQ	ETF	38.39	38.45	38.38	38.41	1476100.0
2005-08-26 14:00:00	QQQ	ETF	38.42	38.57	38.37	38.52	4812900.0
2005-08-26 14:30:00	QQQ	ETF	38.52	38.55	38.47	38.52	3637100.0
2005-08-26 15:00:00	QQQ	ETF	38.52	38.6	38.5	38.53	3401300.0
2005-08-26 15:30:00	QQQ	ETF	38.53	38.54	38.43	38.46	6377300.0
2005-08-26 08:30:00	IWM	ETF	65.56	65.56	65.56	65.56	500.0
2005-08-26 09:00:00	IWM	ETF	65.5	65.56	65.5	65.56	11600.0
2005-08-26 09:30:00	IWM	ETF	65.56	65.57	64.88	64.99	1934100.0
2005-08-26 10:00:00	IWM	ETF	64.97	64.97	64.73	64.81	2791400.0
2005-08-26 10:30:00	IWM	ETF	64.81	64.89	64.652	64.79	1427100.0
2005-08-26 11:00:00	IWM	ETF	64.8	64.82	64.53	64.54	1242700.0
2005-08-26 11:30:00	IWM	ETF	64.54	64.8	64.44	64.5	3015700.0
2005-08-26 12:00:00	IWM	ETF	64.5	64.7	64.49	64.63	897000.0
2005-08-26 12:30:00	IWM	ETF	64.64	64.67	64.58	64.6	298100.0
2005-08-26 13:00:00	IWM	ETF	64.6	64.68	64.55	64.59	462400.0
2005-08-26 13:30:00	IWM	ETF	64.59	64.78	64.57	64.73	631200.0
2005-08-26 14:00:00	IWM	ETF	64.72	64.89	64.54	64.81	1262100.0

> showing 50 of 1,585 rows — these rows as CSV

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