PREVIEW / etf_30min / 2013-08-21

all etf 30-min files

  file:    by_date/etf_30min/2013/2013-08-21.parquet
  size:    327 KB
  rows:    11,015

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-08-21 04:00:00	SPY	ETF	165.25	165.31	165.18	165.31	30225.0
2013-08-21 04:30:00	SPY	ETF	165.29	165.35	165.2	165.2	18200.0
2013-08-21 05:00:00	SPY	ETF	165.17	165.17	164.95	165.03	54220.0
2013-08-21 05:30:00	SPY	ETF	165.07	165.11	165.01	165.11	36875.0
2013-08-21 06:00:00	SPY	ETF	165.11	165.16	165.08	165.09	15500.0
2013-08-21 06:30:00	SPY	ETF	165.09	165.1	165.0	165.04	20700.0
2013-08-21 07:00:00	SPY	ETF	165.07	165.17	165.02	165.17	144290.0
2013-08-21 07:30:00	SPY	ETF	165.16	165.35	165.12	165.29	97009.0
2013-08-21 08:00:00	SPY	ETF	165.29	165.41	165.05	165.32	145729.0
2013-08-21 08:30:00	SPY	ETF	165.31	165.34	165.16	165.2	202126.0
2013-08-21 09:00:00	SPY	ETF	165.21	165.25	165.13	165.13	669791.0
2013-08-21 09:30:00	SPY	ETF	165.12	165.42	164.91	165.19	13006169.0
2013-08-21 10:00:00	SPY	ETF	165.18	165.45	164.95	165.19	8600416.0
2013-08-21 10:30:00	SPY	ETF	165.19	165.5331	165.0	165.17	5500271.0
2013-08-21 11:00:00	SPY	ETF	165.17	165.22	164.87	164.91	5504901.0
2013-08-21 11:30:00	SPY	ETF	164.92	165.07	164.57	164.7701	7587319.0
2013-08-21 12:00:00	SPY	ETF	164.778	164.95	164.71	164.91	4002777.0
2013-08-21 12:30:00	SPY	ETF	164.92	165.05	164.81	165.035	2645948.0
2013-08-21 13:00:00	SPY	ETF	165.01	165.155	164.89	165.03	4201316.0
2013-08-21 13:30:00	SPY	ETF	165.03	165.2	165.01	165.17	4954368.0
2013-08-21 14:00:00	SPY	ETF	165.17	165.17	164.19	164.95	28750269.0
2013-08-21 14:30:00	SPY	ETF	164.955	166.03	164.91	165.7	18321650.0
2013-08-21 15:00:00	SPY	ETF	165.705	165.76	165.24	165.31	9875009.0
2013-08-21 15:30:00	SPY	ETF	165.31	165.475	164.49	164.58	22787045.0
2013-08-21 16:00:00	SPY	ETF	164.57	165.5331	164.15	164.26	11142114.0
2013-08-21 16:30:00	SPY	ETF	164.24	165.5336	164.05	164.1	8511345.0
2013-08-21 17:00:00	SPY	ETF	164.09	165.5336	163.97	164.0	1557012.0
2013-08-21 17:30:00	SPY	ETF	164.04	164.07	164.03	164.07	52898.0
2013-08-21 18:00:00	SPY	ETF	164.07	164.12	164.0	164.06	96943.0
2013-08-21 18:30:00	SPY	ETF	164.06	164.11	163.92	163.95	16662.0
2013-08-21 19:00:00	SPY	ETF	163.94	164.01	163.92	164.0	17332.0
2013-08-21 19:30:00	SPY	ETF	164.0	164.0	163.8	163.84	56369.0
2013-08-21 04:00:00	QQQ	ETF	75.49	75.52	75.46	75.52	12700.0
2013-08-21 04:30:00	QQQ	ETF	75.54	75.54	75.48	75.48	4400.0
2013-08-21 05:00:00	QQQ	ETF	75.46	75.46	75.34	75.34	7500.0
2013-08-21 05:30:00	QQQ	ETF	75.36	75.38	75.34	75.38	4500.0
2013-08-21 06:00:00	QQQ	ETF	75.4	75.4	75.38	75.38	2200.0
2013-08-21 06:30:00	QQQ	ETF	75.38	75.38	75.34	75.36	3700.0
2013-08-21 07:00:00	QQQ	ETF	75.38	75.44	75.36	75.44	6800.0
2013-08-21 07:30:00	QQQ	ETF	75.46	75.53	75.44	75.5	6700.0
2013-08-21 08:00:00	QQQ	ETF	75.52	75.55	75.4	75.55	7010.0
2013-08-21 08:30:00	QQQ	ETF	75.53	75.53	75.45	75.46	63390.0
2013-08-21 09:00:00	QQQ	ETF	75.46	75.52	75.44	75.46	123867.0
2013-08-21 09:30:00	QQQ	ETF	75.46	75.82	75.4099	75.75	2881576.0
2013-08-21 10:00:00	QQQ	ETF	75.74	75.88	75.67	75.7199	1923264.0
2013-08-21 10:30:00	QQQ	ETF	75.715	75.87	75.66	75.78	1728906.0
2013-08-21 11:00:00	QQQ	ETF	75.78	75.8	75.68	75.685	923476.0
2013-08-21 11:30:00	QQQ	ETF	75.69	75.72	75.39	75.49	2378617.0
2013-08-21 12:00:00	QQQ	ETF	75.489	75.55	75.48	75.51	683633.0
2013-08-21 12:30:00	QQQ	ETF	75.51	75.57	75.45	75.51	636493.0

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

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