PREVIEW / etf_30min / 2007-05-17

all etf 30-min files

  file:    by_date/etf_30min/2007/2007-05-17.parquet
  size:    111 KB
  rows:    4,302

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-05-17 06:00:00	SPY	ETF	151.46	151.46	151.44	151.44	23500.0
2007-05-17 06:30:00	SPY	ETF	151.47	151.47	151.47	151.47	3500.0
2007-05-17 07:00:00	SPY	ETF	151.49	151.51	151.44	151.45	22400.0
2007-05-17 07:30:00	SPY	ETF	151.44	151.51	151.44	151.49	31500.0
2007-05-17 08:00:00	SPY	ETF	151.47	151.54	151.42	151.49	205200.0
2007-05-17 08:30:00	SPY	ETF	151.55	151.63	151.31	151.43	897700.0
2007-05-17 09:00:00	SPY	ETF	151.41	151.41	151.26	151.39	533100.0
2007-05-17 09:30:00	SPY	ETF	151.38	151.47	151.11	151.23	10886379.0
2007-05-17 10:00:00	SPY	ETF	151.23	151.57	151.11	151.45	8259318.0
2007-05-17 10:30:00	SPY	ETF	151.44	151.51	151.23	151.51	6590157.0
2007-05-17 11:00:00	SPY	ETF	151.51	151.58	151.38	151.43	5397900.0
2007-05-17 11:30:00	SPY	ETF	151.43	151.73	151.42	151.47	6784459.0
2007-05-17 12:00:00	SPY	ETF	151.48	151.59	151.34	151.47	5519694.0
2007-05-17 12:30:00	SPY	ETF	151.47	151.47	151.25	151.32	4724350.0
2007-05-17 13:00:00	SPY	ETF	151.32	151.44	151.21	151.43	3903890.0
2007-05-17 13:30:00	SPY	ETF	151.44	151.54	151.35	151.44	4412333.0
2007-05-17 14:00:00	SPY	ETF	151.44	151.68	151.36	151.67	5118300.0
2007-05-17 14:30:00	SPY	ETF	151.66	151.86	151.53	151.8	7776523.0
2007-05-17 15:00:00	SPY	ETF	151.8	151.96	151.71	151.72	12166324.0
2007-05-17 15:30:00	SPY	ETF	151.72	151.86	151.44	151.44	14489949.0
2007-05-17 16:00:00	SPY	ETF	151.42	151.44	151.27	151.35	894500.0
2007-05-17 16:30:00	SPY	ETF	151.35	151.48	151.35	151.36	464200.0
2007-05-17 17:00:00	SPY	ETF	151.36	151.39	151.31	151.35	161000.0
2007-05-17 17:30:00	SPY	ETF	151.34	151.42	151.34	151.4	413100.0
2007-05-17 18:00:00	SPY	ETF	151.31	151.36	151.31	151.36	20100.0
2007-05-17 18:30:00	SPY	ETF	151.38	151.38	151.38	151.38	2500.0
2007-05-17 19:00:00	SPY	ETF	151.38	151.38	151.38	151.38	400.0
2007-05-17 19:30:00	SPY	ETF	151.35	151.37	151.35	151.37	300.0
2007-05-17 07:00:00	QQQ	ETF	46.51	46.51	46.51	46.51	4100.0
2007-05-17 07:30:00	QQQ	ETF	46.53	46.54	46.52	46.54	1100.0
2007-05-17 08:00:00	QQQ	ETF	46.54	46.55	46.51	46.54	20742.0
2007-05-17 08:30:00	QQQ	ETF	46.56	46.58	46.46	46.51	2061765.0
2007-05-17 09:00:00	QQQ	ETF	46.5	46.51	46.45	46.5	317816.0
2007-05-17 09:30:00	QQQ	ETF	46.5	46.5	46.38	46.465	11670493.0
2007-05-17 10:00:00	QQQ	ETF	46.46	46.57	46.42	46.44	11616660.0
2007-05-17 10:30:00	QQQ	ETF	46.4425	46.48	46.32	46.477	8052048.0
2007-05-17 11:00:00	QQQ	ETF	46.4786	46.51	46.35	46.36	8354937.0
2007-05-17 11:30:00	QQQ	ETF	46.3674	46.52	46.36	46.42	5233591.0
2007-05-17 12:00:00	QQQ	ETF	46.42	46.48	46.36	46.42	10003837.0
2007-05-17 12:30:00	QQQ	ETF	46.41	46.42	46.34	46.34	3509791.0
2007-05-17 13:00:00	QQQ	ETF	46.34	46.39	46.29	46.38	4265767.0
2007-05-17 13:30:00	QQQ	ETF	46.39	46.45	46.34	46.37	6445608.0
2007-05-17 14:00:00	QQQ	ETF	46.37	46.49	46.34	46.49	5809048.0
2007-05-17 14:30:00	QQQ	ETF	46.49	46.51	46.39	46.5	7689535.0
2007-05-17 15:00:00	QQQ	ETF	46.4986	46.55	46.45	46.46	9389988.0
2007-05-17 15:30:00	QQQ	ETF	46.45	46.48	46.33	46.34	10741894.0
2007-05-17 16:00:00	QQQ	ETF	46.33	46.35	46.28	46.34	2878205.0
2007-05-17 16:30:00	QQQ	ETF	46.34	46.37	46.32	46.35	260535.0
2007-05-17 17:00:00	QQQ	ETF	46.35	46.37	46.34	46.36	32656.0
2007-05-17 17:30:00	QQQ	ETF	46.37	46.39	46.36	46.39	604010.0

> showing 50 of 4,302 rows — these rows as CSV

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