PREVIEW / etf_30min / 2011-04-12

all etf 30-min files

  file:    by_date/etf_30min/2011/2011-04-12.parquet
  size:    282 KB
  rows:    9,427

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
2011-04-12 04:00:00	SPY	ETF	131.98	132.35	131.8	131.8	3200.0
2011-04-12 04:30:00	SPY	ETF	131.68	132.2	131.62	131.62	1900.0
2011-04-12 05:00:00	SPY	ETF	131.73	131.73	131.63	131.71	17400.0
2011-04-12 05:30:00	SPY	ETF	131.78	131.86	131.78	131.86	5775.0
2011-04-12 06:00:00	SPY	ETF	131.81	131.81	131.81	131.81	10000.0
2011-04-12 06:30:00	SPY	ETF	131.8	131.81	131.7	131.72	9900.0
2011-04-12 07:00:00	SPY	ETF	131.72	131.72	131.65	131.7	484795.0
2011-04-12 07:30:00	SPY	ETF	131.7	131.73	131.61	131.73	147457.0
2011-04-12 08:00:00	SPY	ETF	131.71	131.83	131.68	131.81	258337.0
2011-04-12 08:30:00	SPY	ETF	131.81	131.82	131.47	131.74	1614088.0
2011-04-12 09:00:00	SPY	ETF	131.74	131.76	131.64	131.71	736680.0
2011-04-12 09:30:00	SPY	ETF	131.72	131.98	131.43	131.543	20195931.0
2011-04-12 10:00:00	SPY	ETF	131.55	131.63	131.22	131.52	18724342.0
2011-04-12 10:30:00	SPY	ETF	131.51	131.53	130.99	131.01	17927045.0
2011-04-12 11:00:00	SPY	ETF	131.02	131.19	130.99	131.18	9930032.0
2011-04-12 11:30:00	SPY	ETF	131.18	131.36	131.13	131.23	7446582.0
2011-04-12 12:00:00	SPY	ETF	131.23	131.31	131.17	131.26	4384628.0
2011-04-12 12:30:00	SPY	ETF	131.26	131.45	131.105	131.3429	6096375.0
2011-04-12 13:00:00	SPY	ETF	131.34	131.425	131.19	131.42	6547791.0
2011-04-12 13:30:00	SPY	ETF	131.41	131.65	131.25	131.53	7638631.0
2011-04-12 14:00:00	SPY	ETF	131.53	131.84	131.52	131.77	11400609.0
2011-04-12 14:30:00	SPY	ETF	131.76	131.81	131.49	131.55	9117649.0
2011-04-12 15:00:00	SPY	ETF	131.55	131.61	131.23	131.28	10854052.0
2011-04-12 15:30:00	SPY	ETF	131.28	131.55	131.17	131.47	19446992.0
2011-04-12 16:00:00	SPY	ETF	131.46	132.4928	131.21	131.24	5754939.0
2011-04-12 16:30:00	SPY	ETF	131.25	131.463	131.22	131.32	680421.0
2011-04-12 17:00:00	SPY	ETF	131.31	131.43	131.31	131.36	60544.0
2011-04-12 17:30:00	SPY	ETF	131.37	131.44	131.36	131.38	71371.0
2011-04-12 18:00:00	SPY	ETF	131.41	131.46	131.38	131.38	187682.0
2011-04-12 18:30:00	SPY	ETF	131.37	131.39	131.31	131.31	5153.0
2011-04-12 19:00:00	SPY	ETF	131.29	131.37	131.28	131.31	6247.0
2011-04-12 19:30:00	SPY	ETF	131.31	131.64	131.31	131.62	68318.0
2011-04-12 04:00:00	QQQ	ETF	56.48	56.53	56.48	56.49	710.0
2011-04-12 04:30:00	QQQ	ETF	56.47	56.47	56.38	56.4	6124.0
2011-04-12 05:00:00	QQQ	ETF	56.43	56.44	56.43	56.44	15000.0
2011-04-12 05:30:00	QQQ	ETF	56.48	56.48	56.48	56.48	200.0
2011-04-12 06:00:00	QQQ	ETF	56.48	56.48	56.48	56.48	10000.0
2011-04-12 06:30:00	QQQ	ETF	56.44	56.5	56.44	56.5	4500.0
2011-04-12 07:00:00	QQQ	ETF	56.48	56.48	56.43	56.46	22658.0
2011-04-12 07:30:00	QQQ	ETF	56.43	56.45	56.4	56.43	45400.0
2011-04-12 08:00:00	QQQ	ETF	56.44	56.52	56.42	56.49	453653.0
2011-04-12 08:30:00	QQQ	ETF	56.47	56.5	56.36	56.49	792459.0
2011-04-12 09:00:00	QQQ	ETF	56.49	56.53	56.48	56.52	852850.0
2011-04-12 09:30:00	QQQ	ETF	56.52	56.64	56.36	56.4038	6996280.0
2011-04-12 10:00:00	QQQ	ETF	56.4	56.455	56.25	56.43	5693031.0
2011-04-12 10:30:00	QQQ	ETF	56.43	56.45	56.22	56.24	3857817.0
2011-04-12 11:00:00	QQQ	ETF	56.245	56.28	56.15	56.252	2312858.0
2011-04-12 11:30:00	QQQ	ETF	56.25	56.345	56.24	56.27	1588379.0
2011-04-12 12:00:00	QQQ	ETF	56.2701	56.34	56.21	56.29	2050490.0
2011-04-12 12:30:00	QQQ	ETF	56.2901	56.42	56.23	56.35	2490907.0

> showing 50 of 9,427 rows — these rows as CSV

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