PREVIEW / etf_30min / 2013-10-21

all etf 30-min files

  file:    by_date/etf_30min/2013/2013-10-21.parquet
  size:    325 KB
  rows:    11,156

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-10-21 04:00:00	SPY	ETF	174.27	174.3	174.25	174.29	918.0
2013-10-21 04:30:00	SPY	ETF	174.28	174.3	174.26	174.28	14000.0
2013-10-21 05:00:00	SPY	ETF	174.26	174.26	174.19	174.22	8348.0
2013-10-21 05:30:00	SPY	ETF	174.22	174.23	174.19	174.23	3066.0
2013-10-21 06:30:00	SPY	ETF	174.21	174.21	174.08	174.11	21114.0
2013-10-21 07:00:00	SPY	ETF	174.09	174.25	174.06	174.23	33284.0
2013-10-21 07:30:00	SPY	ETF	174.23	174.3	174.19	174.25	71111.0
2013-10-21 08:00:00	SPY	ETF	174.25	174.38	174.15	174.32	133832.0
2013-10-21 08:30:00	SPY	ETF	174.31	174.37	174.27	174.36	202513.0
2013-10-21 09:00:00	SPY	ETF	174.36	174.47	174.32	174.44	574413.0
2013-10-21 09:30:00	SPY	ETF	174.45	174.68	174.24	174.6	9774258.0
2013-10-21 10:00:00	SPY	ETF	174.61	174.75	174.33	174.334	7408396.0
2013-10-21 10:30:00	SPY	ETF	174.34	174.4	174.11	174.2	9098484.0
2013-10-21 11:00:00	SPY	ETF	174.21	174.34	174.17	174.32	4907583.0
2013-10-21 11:30:00	SPY	ETF	174.32	174.42	174.17	174.37	4926078.0
2013-10-21 12:00:00	SPY	ETF	174.37	174.4927	174.32	174.37	2232465.0
2013-10-21 12:30:00	SPY	ETF	174.38	174.48	174.34	174.47	2353374.0
2013-10-21 13:00:00	SPY	ETF	174.47	174.51	174.38	174.3911	3108910.0
2013-10-21 13:30:00	SPY	ETF	174.39	174.47	174.35	174.42	4244338.0
2013-10-21 14:00:00	SPY	ETF	174.42	174.42	174.01	174.129	6169561.0
2013-10-21 14:30:00	SPY	ETF	174.13	174.21	174.06	174.0999	3149650.0
2013-10-21 15:00:00	SPY	ETF	174.095	174.35	174.075	174.2401	16937626.0
2013-10-21 15:30:00	SPY	ETF	174.24	174.4109	174.16	174.4	10370612.0
2013-10-21 16:00:00	SPY	ETF	174.39	174.5363	174.2706	174.34	10535119.0
2013-10-21 16:30:00	SPY	ETF	174.32	174.34	174.26	174.29	221579.0
2013-10-21 17:00:00	SPY	ETF	174.31	174.4109	174.2627	174.32	2615025.0
2013-10-21 17:30:00	SPY	ETF	174.3	174.32	174.27	174.32	539755.0
2013-10-21 18:00:00	SPY	ETF	174.28	174.29	174.26	174.29	13660.0
2013-10-21 18:30:00	SPY	ETF	174.32	174.32	174.25	174.25	7198.0
2013-10-21 19:00:00	SPY	ETF	174.25	174.3	174.24	174.29	9451.0
2013-10-21 19:30:00	SPY	ETF	174.3	174.35	174.3	174.35	18217.0
2013-10-21 04:00:00	QQQ	ETF	82.18	82.21	82.17	82.21	8869.0
2013-10-21 04:30:00	QQQ	ETF	82.22	82.22	82.19	82.19	4100.0
2013-10-21 05:00:00	QQQ	ETF	82.18	82.18	82.17	82.18	1300.0
2013-10-21 05:30:00	QQQ	ETF	82.19	82.21	82.18	82.21	3600.0
2013-10-21 06:00:00	QQQ	ETF	82.2	82.2	82.2	82.2	35000.0
2013-10-21 06:30:00	QQQ	ETF	82.19	82.2	82.16	82.16	6800.0
2013-10-21 07:00:00	QQQ	ETF	82.15	82.24	82.14	82.22	8675.0
2013-10-21 07:30:00	QQQ	ETF	82.21	82.25	82.19	82.2	70700.0
2013-10-21 08:00:00	QQQ	ETF	82.2	82.27	82.19	82.27	66274.0
2013-10-21 08:30:00	QQQ	ETF	82.26	82.27	82.25	82.26	52475.0
2013-10-21 09:00:00	QQQ	ETF	82.27	82.34	82.26	82.3	119004.0
2013-10-21 09:30:00	QQQ	ETF	82.31	82.49	82.16	82.469	4698790.0
2013-10-21 10:00:00	QQQ	ETF	82.47	82.54	82.29	82.3	3411167.0
2013-10-21 10:30:00	QQQ	ETF	82.3	82.34	82.22	82.28	2623080.0
2013-10-21 11:00:00	QQQ	ETF	82.29	82.39	82.255	82.34	1893097.0
2013-10-21 11:30:00	QQQ	ETF	82.35	82.39	82.27	82.3751	962399.0
2013-10-21 12:00:00	QQQ	ETF	82.37	82.4	82.33	82.36	1357093.0
2013-10-21 12:30:00	QQQ	ETF	82.366	82.44	82.34	82.43	1338865.0
2013-10-21 13:00:00	QQQ	ETF	82.42	82.43	82.35	82.35	977710.0

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

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