PREVIEW / etf_30min / 2013-05-22

all etf 30-min files

  file:    by_date/etf_30min/2013/2013-05-22.parquet
  size:    341 KB
  rows:    11,280

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
2013-05-22 04:00:00	SPY	ETF	167.36	167.4	167.28	167.38	4985.0
2013-05-22 04:30:00	SPY	ETF	167.38	167.38	167.23	167.23	5880.0
2013-05-22 05:00:00	SPY	ETF	167.23	167.28	167.18	167.28	3700.0
2013-05-22 05:30:00	SPY	ETF	167.24	167.24	167.14	167.17	6081.0
2013-05-22 06:00:00	SPY	ETF	167.17	167.26	167.17	167.26	20950.0
2013-05-22 06:30:00	SPY	ETF	167.27	167.35	167.2	167.27	49200.0
2013-05-22 07:00:00	SPY	ETF	167.27	167.35	167.21	167.31	44400.0
2013-05-22 07:30:00	SPY	ETF	167.3	167.35	167.27	167.35	69270.0
2013-05-22 08:00:00	SPY	ETF	167.34	167.56	167.25	167.49	265518.0
2013-05-22 08:30:00	SPY	ETF	167.49	167.53	167.42	167.44	182100.0
2013-05-22 09:00:00	SPY	ETF	167.44	167.49	167.31	167.33	443822.0
2013-05-22 09:30:00	SPY	ETF	167.34	167.75	167.2965	167.74	10671344.0
2013-05-22 10:00:00	SPY	ETF	167.74	169.07	167.71	168.92	25475449.0
2013-05-22 10:30:00	SPY	ETF	168.92	169.02	167.56	167.7	30789237.0
2013-05-22 11:00:00	SPY	ETF	167.71	168.33	167.56	168.27	12847927.0
2013-05-22 11:30:00	SPY	ETF	168.27	168.67	168.17	168.33	8730981.0
2013-05-22 12:00:00	SPY	ETF	168.33	168.45	168.04	168.07	6142867.0
2013-05-22 12:30:00	SPY	ETF	168.07	168.27	167.85	168.27	5841293.0
2013-05-22 13:00:00	SPY	ETF	168.24	168.28	167.44	167.48	8700580.0
2013-05-22 13:30:00	SPY	ETF	167.47	167.5	166.81	167.09	12963177.0
2013-05-22 14:00:00	SPY	ETF	167.09	167.37	166.06	166.28	26800069.0
2013-05-22 14:30:00	SPY	ETF	166.28	166.441	165.81	166.38	14569690.0
2013-05-22 15:00:00	SPY	ETF	166.3865	167.2171	165.25	165.29	22226029.0
2013-05-22 15:30:00	SPY	ETF	165.3	166.1771	165.17	165.85	34161169.0
2013-05-22 16:00:00	SPY	ETF	165.87	168.6948	165.7601	166.09	14753928.0
2013-05-22 16:30:00	SPY	ETF	166.1	166.29	165.8389	166.24	3199395.0
2013-05-22 17:00:00	SPY	ETF	166.24	166.28	166.2	166.26	215766.0
2013-05-22 17:30:00	SPY	ETF	166.25	166.3	166.23	166.26	88214.0
2013-05-22 18:00:00	SPY	ETF	166.27	166.39	166.23	166.29	186849.0
2013-05-22 18:30:00	SPY	ETF	166.3	166.3	166.17	166.18	67095.0
2013-05-22 19:00:00	SPY	ETF	166.18	166.2	166.14	166.18	35114.0
2013-05-22 19:30:00	SPY	ETF	166.18	166.3	166.15	166.27	73449.0
2013-05-22 04:00:00	QQQ	ETF	74.31	74.31	74.3	74.3	500.0
2013-05-22 05:30:00	QQQ	ETF	74.22	74.22	74.22	74.22	100.0
2013-05-22 06:00:00	QQQ	ETF	74.25	74.25	74.25	74.25	6000.0
2013-05-22 06:30:00	QQQ	ETF	74.28	74.29	74.28	74.29	2500.0
2013-05-22 07:00:00	QQQ	ETF	74.27	74.32	74.27	74.32	5600.0
2013-05-22 07:30:00	QQQ	ETF	74.31	74.31	74.28	74.3	4100.0
2013-05-22 08:00:00	QQQ	ETF	74.3	74.45	74.3	74.4	79182.0
2013-05-22 08:30:00	QQQ	ETF	74.4	74.42	74.37	74.39	15950.0
2013-05-22 09:00:00	QQQ	ETF	74.41	74.42	74.32	74.36	55170.0
2013-05-22 09:30:00	QQQ	ETF	74.36	74.54	74.23	74.5001	2804028.0
2013-05-22 10:00:00	QQQ	ETF	74.51	74.95	74.509	74.88	6074277.0
2013-05-22 10:30:00	QQQ	ETF	74.8899	74.92	74.29	74.35	8705063.0
2013-05-22 11:00:00	QQQ	ETF	74.3477	74.64	74.27	74.58	4239143.0
2013-05-22 11:30:00	QQQ	ETF	74.59	74.76	74.54	74.6599	1848186.0
2013-05-22 12:00:00	QQQ	ETF	74.66	74.6941	74.47	74.49	1560459.0
2013-05-22 12:30:00	QQQ	ETF	74.48	74.55	74.405	74.54	1412111.0
2013-05-22 13:00:00	QQQ	ETF	74.55	74.55	74.2	74.22	2148308.0
2013-05-22 13:30:00	QQQ	ETF	74.21	74.22	73.9	74.06	3608163.0

> showing 50 of 11,280 rows — these rows as CSV

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