PREVIEW / etf_30min / 2013-07-29

all etf 30-min files

  file:    by_date/etf_30min/2013/2013-07-29.parquet
  size:    305 KB
  rows:    10,494

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-07-29 04:00:00	SPY	ETF	169.07	169.07	168.54	168.54	13030.0
2013-07-29 04:30:00	SPY	ETF	168.64	168.73	168.63	168.73	11400.0
2013-07-29 05:00:00	SPY	ETF	168.74	168.9	168.74	168.83	5600.0
2013-07-29 05:30:00	SPY	ETF	168.88	168.88	168.6	168.63	45500.0
2013-07-29 06:00:00	SPY	ETF	168.68	168.69	168.56	168.68	92100.0
2013-07-29 06:30:00	SPY	ETF	168.73	168.85	168.64	168.85	19920.0
2013-07-29 07:00:00	SPY	ETF	168.83	168.85	168.72	168.75	97332.0
2013-07-29 07:30:00	SPY	ETF	168.74	168.81	168.65	168.81	75820.0
2013-07-29 08:00:00	SPY	ETF	168.83	168.83	168.69	168.8	184171.0
2013-07-29 08:30:00	SPY	ETF	168.8	168.81	168.67	168.73	166539.0
2013-07-29 09:00:00	SPY	ETF	168.72	168.75	168.62	168.69	308736.0
2013-07-29 09:30:00	SPY	ETF	168.68	169.06	168.63	168.87	9827597.0
2013-07-29 10:00:00	SPY	ETF	168.87	168.92	168.54	168.769	8173424.0
2013-07-29 10:30:00	SPY	ETF	168.77	168.77	168.48	168.6987	6198724.0
2013-07-29 11:00:00	SPY	ETF	168.69	168.74	168.14	168.18	8321784.0
2013-07-29 11:30:00	SPY	ETF	168.19	168.34	168.11	168.285	4934529.0
2013-07-29 12:00:00	SPY	ETF	168.28	168.41	168.22	168.34	3562789.0
2013-07-29 12:30:00	SPY	ETF	168.35	168.53	168.325	168.46	3058044.0
2013-07-29 13:00:00	SPY	ETF	168.45	168.57	168.42	168.47	3232710.0
2013-07-29 13:30:00	SPY	ETF	168.47	168.5	168.31	168.45	3238007.0
2013-07-29 14:00:00	SPY	ETF	168.45	168.779	168.44	168.742	4363543.0
2013-07-29 14:30:00	SPY	ETF	168.75	168.83	168.68	168.7	3111310.0
2013-07-29 15:00:00	SPY	ETF	168.7	168.74	168.56	168.695	3036560.0
2013-07-29 15:30:00	SPY	ETF	168.7	168.72	168.4	168.57	8292730.0
2013-07-29 16:00:00	SPY	ETF	168.57	168.73	168.4931	168.73	5660647.0
2013-07-29 16:30:00	SPY	ETF	168.7	168.73	168.69	168.69	113953.0
2013-07-29 17:00:00	SPY	ETF	168.7	168.75	168.69	168.74	79777.0
2013-07-29 17:30:00	SPY	ETF	168.72	168.72	168.68	168.69	19900.0
2013-07-29 18:00:00	SPY	ETF	168.68	168.7	168.68	168.7	13525.0
2013-07-29 18:30:00	SPY	ETF	168.68	168.71	168.68	168.69	2875.0
2013-07-29 19:00:00	SPY	ETF	168.69	168.71	168.66	168.68	20571.0
2013-07-29 19:30:00	SPY	ETF	168.67	168.75	168.67	168.74	95680.0
2013-07-29 04:00:00	QQQ	ETF	75.26	75.26	75.16	75.16	12200.0
2013-07-29 04:30:00	QQQ	ETF	75.18	75.22	75.18	75.22	3200.0
2013-07-29 05:00:00	QQQ	ETF	75.24	75.3	75.24	75.3	4200.0
2013-07-29 05:30:00	QQQ	ETF	75.28	75.28	75.2	75.2	6600.0
2013-07-29 06:00:00	QQQ	ETF	75.2	75.2	75.16	75.2	5600.0
2013-07-29 06:30:00	QQQ	ETF	75.22	75.26	75.2	75.26	6000.0
2013-07-29 07:00:00	QQQ	ETF	75.26	75.26	75.22	75.25	21200.0
2013-07-29 07:30:00	QQQ	ETF	75.22	75.24	75.19	75.24	14700.0
2013-07-29 08:00:00	QQQ	ETF	75.26	75.27	75.23	75.27	42489.0
2013-07-29 08:30:00	QQQ	ETF	75.25	75.27	75.22	75.23	14854.0
2013-07-29 09:00:00	QQQ	ETF	75.21	75.24	75.19	75.23	139640.0
2013-07-29 09:30:00	QQQ	ETF	75.22	75.54	75.19	75.44	3596452.0
2013-07-29 10:00:00	QQQ	ETF	75.446	75.479	75.32	75.42	1534081.0
2013-07-29 10:30:00	QQQ	ETF	75.41	75.41	75.25	75.37	985952.0
2013-07-29 11:00:00	QQQ	ETF	75.37	75.39	75.0328	75.05	1569208.0
2013-07-29 11:30:00	QQQ	ETF	75.049	75.12	75.0299	75.1	943520.0
2013-07-29 12:00:00	QQQ	ETF	75.1	75.14	75.0565	75.1	756338.0
2013-07-29 12:30:00	QQQ	ETF	75.0928	75.23	75.0928	75.2	476048.0

> showing 50 of 10,494 rows — these rows as CSV

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