PREVIEW / etf_30min / 2005-03-16

all etf 30-min files

  file:    by_date/etf_30min/2005/2005-03-16.parquet
  size:    46 KB
  rows:    1,537

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-03-16 08:00:00	SPY	ETF	120.11	120.17	119.96	119.96	154100.0
2005-03-16 08:30:00	SPY	ETF	120.0	120.06	119.6	119.71	270100.0
2005-03-16 09:00:00	SPY	ETF	119.71	119.72	119.63	119.68	75800.0
2005-03-16 09:30:00	SPY	ETF	119.7	119.86	119.5715	119.65	6612700.0
2005-03-16 10:00:00	SPY	ETF	119.65	119.88	119.64	119.72	5552400.0
2005-03-16 10:30:00	SPY	ETF	119.72	119.76	119.27	119.42	10455800.0
2005-03-16 11:00:00	SPY	ETF	119.41	119.5	119.16	119.34	5721000.0
2005-03-16 11:30:00	SPY	ETF	119.34	119.47	119.31	119.4	2099800.0
2005-03-16 12:00:00	SPY	ETF	119.39	119.55	119.32	119.41	3089500.0
2005-03-16 12:30:00	SPY	ETF	119.37	119.62	119.3	119.62	3541400.0
2005-03-16 13:00:00	SPY	ETF	119.62	119.68	119.49	119.5	3639500.0
2005-03-16 13:30:00	SPY	ETF	119.5	119.58	119.25	119.28	2291800.0
2005-03-16 14:00:00	SPY	ETF	119.28	119.34	119.07	119.27	3761900.0
2005-03-16 14:30:00	SPY	ETF	119.27	119.31	119.0	119.03	5159000.0
2005-03-16 15:00:00	SPY	ETF	119.04	120.155	118.92	118.99	7229300.0
2005-03-16 15:30:00	SPY	ETF	118.99	119.26	118.9	119.18	10126400.0
2005-03-16 16:00:00	SPY	ETF	119.18	119.19	119.1	119.17	1181600.0
2005-03-16 16:30:00	SPY	ETF	119.17	119.27	119.12	119.25	159100.0
2005-03-16 17:00:00	SPY	ETF	119.27	119.28	119.12	119.2	643500.0
2005-03-16 17:30:00	SPY	ETF	119.2	119.23	119.2	119.23	2100.0
2005-03-16 18:00:00	SPY	ETF	119.2	119.23	119.2	119.23	500.0
2005-03-16 18:30:00	SPY	ETF	119.2	119.27	119.2	119.27	700.0
2005-03-16 19:00:00	SPY	ETF	119.29	119.29	119.29	119.29	2600.0
2005-03-16 19:30:00	SPY	ETF	119.26	119.3	119.26	119.3	500.0
2005-03-16 09:30:00	QQQ	ETF	36.9	37.05	36.88	36.97	18873900.0
2005-03-16 10:00:00	QQQ	ETF	36.97	37.18	36.96	37.08	16180600.0
2005-03-16 10:30:00	QQQ	ETF	37.08	37.1	36.79	36.8	20487700.0
2005-03-16 11:00:00	QQQ	ETF	36.8	36.81	36.65	36.73	15862800.0
2005-03-16 11:30:00	QQQ	ETF	36.73	36.79	36.7	36.76	11336900.0
2005-03-16 12:00:00	QQQ	ETF	36.76	36.8	36.72	36.75	4878400.0
2005-03-16 12:30:00	QQQ	ETF	36.75	36.86	36.73	36.86	4698500.0
2005-03-16 13:00:00	QQQ	ETF	36.86	36.9	36.81	36.81	5154600.0
2005-03-16 13:30:00	QQQ	ETF	36.81	36.85	36.69	36.7	4685600.0
2005-03-16 14:00:00	QQQ	ETF	36.7	36.71	36.6	36.67	7910400.0
2005-03-16 14:30:00	QQQ	ETF	36.67	36.68	36.6	36.63	5893800.0
2005-03-16 15:00:00	QQQ	ETF	36.64	36.72	36.54	36.56	9675800.0
2005-03-16 15:30:00	QQQ	ETF	36.56	36.68	36.53	36.62	13044600.0
2005-03-16 08:00:00	IWM	ETF	62.595	62.65	62.515	62.515	34800.0
2005-03-16 08:30:00	IWM	ETF	62.5	62.5	62.325	62.35	36400.0
2005-03-16 09:00:00	IWM	ETF	62.35	62.365	62.315	62.33	27400.0
2005-03-16 09:30:00	IWM	ETF	62.37	62.55	62.205	62.31	1499200.0
2005-03-16 10:00:00	IWM	ETF	62.33	62.64	62.33	62.57	3898000.0
2005-03-16 10:30:00	IWM	ETF	62.565	62.585	62.33	62.39	2599400.0
2005-03-16 11:00:00	IWM	ETF	62.39	62.465	62.185	62.26	1314200.0
2005-03-16 11:30:00	IWM	ETF	62.255	62.395	62.245	62.345	900600.0
2005-03-16 12:00:00	IWM	ETF	62.35	62.385	62.27	62.29	531400.0
2005-03-16 12:30:00	IWM	ETF	62.285	62.415	62.25	62.415	851200.0
2005-03-16 13:00:00	IWM	ETF	62.415	62.43	62.305	62.305	548600.0
2005-03-16 13:30:00	IWM	ETF	62.3	62.32	62.1	62.145	1099600.0
2005-03-16 14:00:00	IWM	ETF	62.145	62.19	62.05	62.18	1187600.0

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

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