PREVIEW / etf_30min / 2014-05-23

all etf 30-min files

  file:    by_date/etf_30min/2014/2014-05-23.parquet
  size:    312 KB
  rows:    10,920

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
2014-05-23 04:00:00	SPY	ETF	189.75	189.75	189.69	189.7	26850.0
2014-05-23 04:30:00	SPY	ETF	189.7	189.77	189.7	189.77	5621.0
2014-05-23 05:30:00	SPY	ETF	189.64	189.83	189.64	189.83	10139.0
2014-05-23 06:00:00	SPY	ETF	189.84	189.88	189.76	189.76	2795.0
2014-05-23 06:30:00	SPY	ETF	189.72	189.76	189.72	189.76	1241.0
2014-05-23 07:00:00	SPY	ETF	189.77	189.83	189.75	189.78	45832.0
2014-05-23 07:30:00	SPY	ETF	189.8	189.81	189.72	189.76	80178.0
2014-05-23 08:00:00	SPY	ETF	189.75	189.76	189.7	189.73	122954.0
2014-05-23 08:30:00	SPY	ETF	189.74	189.75	189.7	189.7	108270.0
2014-05-23 09:00:00	SPY	ETF	189.69	189.77	189.58	189.75	291570.0
2014-05-23 09:30:00	SPY	ETF	189.75	189.92	189.68	189.8599	6861486.0
2014-05-23 10:00:00	SPY	ETF	189.85	190.13	189.8	190.12	6295751.0
2014-05-23 10:30:00	SPY	ETF	190.12	190.21	190.08	190.18	4807674.0
2014-05-23 11:00:00	SPY	ETF	190.18	190.26	190.09	190.12	3731516.0
2014-05-23 11:30:00	SPY	ETF	190.12	190.26	190.1	190.2	2426709.0
2014-05-23 12:00:00	SPY	ETF	190.19	190.28	190.18	190.24	2074019.0
2014-05-23 12:30:00	SPY	ETF	190.24	190.34	190.23	190.27	1806531.0
2014-05-23 13:00:00	SPY	ETF	190.27	190.28	190.15	190.21	1957941.0
2014-05-23 13:30:00	SPY	ETF	190.21	190.29	190.16	190.24	1649338.0
2014-05-23 14:00:00	SPY	ETF	190.24	190.3	190.18	190.275	2100810.0
2014-05-23 14:30:00	SPY	ETF	190.27	190.34	190.24	190.32	2439869.0
2014-05-23 15:00:00	SPY	ETF	190.32	190.44	190.3	190.415	5374996.0
2014-05-23 15:30:00	SPY	ETF	190.415	190.48	190.37	190.37	9313455.0
2014-05-23 16:00:00	SPY	ETF	190.38	190.3886	190.199	190.29	7765684.0
2014-05-23 16:30:00	SPY	ETF	190.28	190.32	190.21	190.32	331050.0
2014-05-23 17:00:00	SPY	ETF	190.32	190.32	190.23	190.29	92295.0
2014-05-23 17:30:00	SPY	ETF	190.32	190.32	190.25	190.26	15700.0
2014-05-23 18:00:00	SPY	ETF	190.25	190.25	190.24	190.24	6350.0
2014-05-23 18:30:00	SPY	ETF	190.24	190.25	190.23	190.24	22645.0
2014-05-23 19:00:00	SPY	ETF	190.25	190.26	190.22	190.24	9750.0
2014-05-23 19:30:00	SPY	ETF	190.25	190.26	190.22	190.22	8892.0
2014-05-23 05:30:00	QQQ	ETF	89.39	89.39	89.39	89.39	200.0
2014-05-23 06:00:00	QQQ	ETF	89.4	89.44	89.4	89.44	200.0
2014-05-23 07:00:00	QQQ	ETF	89.35	89.35	89.3	89.32	12690.0
2014-05-23 07:30:00	QQQ	ETF	89.32	89.33	89.3	89.3	29600.0
2014-05-23 08:00:00	QQQ	ETF	89.23	89.31	89.23	89.31	6699.0
2014-05-23 08:30:00	QQQ	ETF	89.31	89.33	89.3	89.3	38453.0
2014-05-23 09:00:00	QQQ	ETF	89.27	89.35	89.25	89.33	154256.0
2014-05-23 09:30:00	QQQ	ETF	89.33	89.48	89.12	89.35	3888222.0
2014-05-23 10:00:00	QQQ	ETF	89.37	89.48	89.3	89.45	2339323.0
2014-05-23 10:30:00	QQQ	ETF	89.45	89.48	89.38	89.43	915826.0
2014-05-23 11:00:00	QQQ	ETF	89.43	89.55	89.41	89.51	1002146.0
2014-05-23 11:30:00	QQQ	ETF	89.51	89.605	89.51	89.57	933766.0
2014-05-23 12:00:00	QQQ	ETF	89.57	89.63	89.56	89.59	808515.0
2014-05-23 12:30:00	QQQ	ETF	89.6	89.66	89.58	89.64	600010.0
2014-05-23 13:00:00	QQQ	ETF	89.64	89.66	89.6	89.63	405371.0
2014-05-23 13:30:00	QQQ	ETF	89.63	89.73	89.601	89.69	840919.0
2014-05-23 14:00:00	QQQ	ETF	89.69	89.765	89.69	89.76	764230.0
2014-05-23 14:30:00	QQQ	ETF	89.755	89.83	89.75	89.805	720822.0
2014-05-23 15:00:00	QQQ	ETF	89.802	89.88	89.8	89.87	1108327.0

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

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