PREVIEW / etf_30min / 2010-03-12

all etf 30-min files

  file:    by_date/etf_30min/2010/2010-03-12.parquet
  size:    242 KB
  rows:    8,198

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
2010-03-12 04:00:00	SPY	ETF	115.5	115.5	115.5	115.5	100.0
2010-03-12 04:30:00	SPY	ETF	115.55	115.57	115.55	115.57	2000.0
2010-03-12 05:00:00	SPY	ETF	115.75	115.86	115.75	115.86	6100.0
2010-03-12 05:30:00	SPY	ETF	115.78	115.84	115.78	115.84	3200.0
2010-03-12 06:00:00	SPY	ETF	115.78	115.83	115.73	115.82	1000.0
2010-03-12 06:30:00	SPY	ETF	115.78	115.78	115.7	115.72	4300.0
2010-03-12 07:00:00	SPY	ETF	115.72	115.83	115.72	115.81	83900.0
2010-03-12 07:30:00	SPY	ETF	115.79	115.84	115.75	115.75	526790.0
2010-03-12 08:00:00	SPY	ETF	115.75	115.81	115.66	115.79	1244744.0
2010-03-12 08:30:00	SPY	ETF	115.84	116.16	115.83	116.04	3198604.0
2010-03-12 09:00:00	SPY	ETF	116.03	116.04	115.45	115.95	1899475.0
2010-03-12 09:30:00	SPY	ETF	115.95	115.97	115.54	115.7	27055399.0
2010-03-12 10:00:00	SPY	ETF	115.69	115.71	115.14	115.35	23466683.0
2010-03-12 10:30:00	SPY	ETF	115.35	115.5	115.205	115.34	12111233.0
2010-03-12 11:00:00	SPY	ETF	115.34	115.61	115.26	115.49	11269269.0
2010-03-12 11:30:00	SPY	ETF	115.52	115.53	115.35	115.39	6436394.0
2010-03-12 12:00:00	SPY	ETF	115.39	115.52	115.3	115.46	4786673.0
2010-03-12 12:30:00	SPY	ETF	115.47	115.47	115.26	115.4	9302063.0
2010-03-12 13:00:00	SPY	ETF	115.3901	115.54	115.39	115.46	4499725.0
2010-03-12 13:30:00	SPY	ETF	115.46	115.54	115.39	115.53	4099634.0
2010-03-12 14:00:00	SPY	ETF	115.53	115.6	115.41	115.44	8351813.0
2010-03-12 14:30:00	SPY	ETF	115.44	115.5	115.33	115.42	5773791.0
2010-03-12 15:00:00	SPY	ETF	115.42	115.5	115.19	115.19	10452147.0
2010-03-12 15:30:00	SPY	ETF	115.2	115.5	115.18	115.45	15790662.0
2010-03-12 16:00:00	SPY	ETF	115.45	115.88	115.25	115.54	9572961.0
2010-03-12 16:30:00	SPY	ETF	115.54	115.57	115.49	115.493	1852212.0
2010-03-12 17:00:00	SPY	ETF	115.52	115.54	115.51	115.54	10087.0
2010-03-12 17:30:00	SPY	ETF	115.52	115.57	115.52	115.54	77108.0
2010-03-12 18:00:00	SPY	ETF	115.53	115.56	115.46	115.52	75576.0
2010-03-12 18:30:00	SPY	ETF	115.54	115.54	115.52	115.54	3742.0
2010-03-12 19:00:00	SPY	ETF	115.54	115.55	115.53	115.54	26600.0
2010-03-12 19:30:00	SPY	ETF	115.55	115.6	115.5	115.5	43589.0
2010-03-12 04:30:00	QQQ	ETF	47.42	47.42	47.42	47.42	5000.0
2010-03-12 05:00:00	QQQ	ETF	47.4	47.4	47.4	47.4	4000.0
2010-03-12 06:00:00	QQQ	ETF	47.42	47.42	47.42	47.42	200.0
2010-03-12 06:30:00	QQQ	ETF	47.4	47.4	47.4	47.4	204.0
2010-03-12 07:00:00	QQQ	ETF	47.43	47.44	47.42	47.44	9325.0
2010-03-12 07:30:00	QQQ	ETF	47.44	47.44	47.43	47.43	38458.0
2010-03-12 08:00:00	QQQ	ETF	47.42	47.47	47.4	47.43	210482.0
2010-03-12 08:30:00	QQQ	ETF	47.43	47.56	47.43	47.51	577646.0
2010-03-12 09:00:00	QQQ	ETF	47.52	47.53	47.47	47.5	438504.0
2010-03-12 09:30:00	QQQ	ETF	47.5	47.5	47.33	47.43	10622492.0
2010-03-12 10:00:00	QQQ	ETF	47.44	47.53	47.1626	47.2524	9816823.0
2010-03-12 10:30:00	QQQ	ETF	47.26	47.32	47.1	47.28	4842675.0
2010-03-12 11:00:00	QQQ	ETF	47.28	47.43	47.249	47.4001	3827063.0
2010-03-12 11:30:00	QQQ	ETF	47.4025	47.41	47.33	47.35	1928755.0
2010-03-12 12:00:00	QQQ	ETF	47.3501	47.4	47.33	47.36	1794745.0
2010-03-12 12:30:00	QQQ	ETF	47.36	47.37	47.27	47.35	2804827.0
2010-03-12 13:00:00	QQQ	ETF	47.359	47.39	47.34	47.35	1970749.0
2010-03-12 13:30:00	QQQ	ETF	47.36	47.4	47.33	47.4	3088783.0

> showing 50 of 8,198 rows — these rows as CSV

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