PREVIEW / etf_30min / 2013-12-23

all etf 30-min files

  file:    by_date/etf_30min/2013/2013-12-23.parquet
  size:    338 KB
  rows:    11,620

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-12-23 04:30:00	SPY	ETF	182.42	182.44	182.4	182.44	16680.0
2013-12-23 05:00:00	SPY	ETF	182.44	182.46	182.44	182.46	41682.0
2013-12-23 05:30:00	SPY	ETF	182.49	182.49	182.4	182.43	5906.0
2013-12-23 06:00:00	SPY	ETF	182.46	182.47	182.43	182.43	13395.0
2013-12-23 06:30:00	SPY	ETF	182.48	182.49	182.32	182.37	28979.0
2013-12-23 07:00:00	SPY	ETF	182.36	182.44	182.36	182.37	110271.0
2013-12-23 07:30:00	SPY	ETF	182.36	182.48	182.35	182.48	116550.0
2013-12-23 08:00:00	SPY	ETF	182.47	182.6	182.39	182.56	234383.0
2013-12-23 08:30:00	SPY	ETF	182.54	182.58	181.56	182.53	1199369.0
2013-12-23 09:00:00	SPY	ETF	182.56	182.56	182.4	182.41	436301.0
2013-12-23 09:30:00	SPY	ETF	182.41	182.52	182.18	182.1875	9979526.0
2013-12-23 10:00:00	SPY	ETF	182.181	182.39	182.065	182.32	6489608.0
2013-12-23 10:30:00	SPY	ETF	182.32	182.44	182.2	182.39	4162851.0
2013-12-23 11:00:00	SPY	ETF	182.39	182.48	182.37	182.47	3715554.0
2013-12-23 11:30:00	SPY	ETF	182.47	182.56	182.45	182.495	5864281.0
2013-12-23 12:00:00	SPY	ETF	182.49	182.64	182.44	182.58	3394260.0
2013-12-23 12:30:00	SPY	ETF	182.59	182.61	182.46	182.47	3187711.0
2013-12-23 13:00:00	SPY	ETF	182.47	182.53	182.42	182.472	2709180.0
2013-12-23 13:30:00	SPY	ETF	182.4799	182.53	182.15	182.2901	4209721.0
2013-12-23 14:00:00	SPY	ETF	182.295	182.41	182.225	182.3	2635173.0
2013-12-23 14:30:00	SPY	ETF	182.3	182.44	182.29	182.332	4204271.0
2013-12-23 15:00:00	SPY	ETF	182.34	182.45	182.3	182.43	4794053.0
2013-12-23 15:30:00	SPY	ETF	182.43	182.52	182.33	182.46	11480781.0
2013-12-23 16:00:00	SPY	ETF	182.47	182.58	181.4662	182.55	4051868.0
2013-12-23 16:30:00	SPY	ETF	182.55	182.55	181.4664	182.55	2979613.0
2013-12-23 17:00:00	SPY	ETF	182.54	182.54	182.45	182.5	82128.0
2013-12-23 17:30:00	SPY	ETF	182.53	182.56	182.5	182.5	32313.0
2013-12-23 18:00:00	SPY	ETF	182.5	182.54	182.49	182.51	36710.0
2013-12-23 18:30:00	SPY	ETF	182.51	182.51	182.47	182.49	5061.0
2013-12-23 19:00:00	SPY	ETF	182.48	182.48	182.34	182.34	121225.0
2013-12-23 19:30:00	SPY	ETF	182.34	182.37	182.29	182.31	30030.0
2013-12-23 04:00:00	QQQ	ETF	87.01	87.12	86.47	87.12	33410.0
2013-12-23 04:30:00	QQQ	ETF	87.14	87.18	87.14	87.17	2264.0
2013-12-23 05:00:00	QQQ	ETF	87.16	87.19	87.16	87.19	13300.0
2013-12-23 05:30:00	QQQ	ETF	87.16	87.19	87.16	87.19	5400.0
2013-12-23 06:00:00	QQQ	ETF	87.19	87.19	87.19	87.19	7200.0
2013-12-23 06:30:00	QQQ	ETF	87.2	87.2	87.1	87.1	2600.0
2013-12-23 07:00:00	QQQ	ETF	87.1	87.18	87.1	87.14	7420.0
2013-12-23 07:30:00	QQQ	ETF	87.14	87.2	87.14	87.19	17760.0
2013-12-23 08:00:00	QQQ	ETF	87.2	87.26	87.18	87.26	70410.0
2013-12-23 08:30:00	QQQ	ETF	87.27	87.28	87.24	87.27	63614.0
2013-12-23 09:00:00	QQQ	ETF	87.26	87.26	87.15	87.19	202487.0
2013-12-23 09:30:00	QQQ	ETF	87.19	87.24	87.035	87.04	3325779.0
2013-12-23 10:00:00	QQQ	ETF	87.04	87.129	86.95	87.11	1807606.0
2013-12-23 10:30:00	QQQ	ETF	87.11	87.19	87.05	87.18	1175679.0
2013-12-23 11:00:00	QQQ	ETF	87.18	87.23	87.16	87.22	1307654.0
2013-12-23 11:30:00	QQQ	ETF	87.225	87.29	87.2	87.25	1449651.0
2013-12-23 12:00:00	QQQ	ETF	87.25	87.34	87.22	87.325	952990.0
2013-12-23 12:30:00	QQQ	ETF	87.325	87.35	87.2403	87.25	1037584.0
2013-12-23 13:00:00	QQQ	ETF	87.25	87.3	87.23	87.26	623369.0

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

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