PREVIEW / etf_30min / 2014-02-21

all etf 30-min files

  file:    by_date/etf_30min/2014/2014-02-21.parquet
  size:    327 KB
  rows:    11,046

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-02-21 04:00:00	SPY	ETF	184.46	184.49	184.35	184.49	21859.0
2014-02-21 04:30:00	SPY	ETF	184.55	184.56	184.55	184.56	2400.0
2014-02-21 05:00:00	SPY	ETF	184.51	184.52	184.48	184.51	5317.0
2014-02-21 05:30:00	SPY	ETF	184.5	184.51	184.4	184.41	2541.0
2014-02-21 06:00:00	SPY	ETF	184.42	184.42	184.36	184.39	4470.0
2014-02-21 06:30:00	SPY	ETF	184.36	184.51	184.36	184.51	8569.0
2014-02-21 07:00:00	SPY	ETF	184.51	184.55	184.42	184.51	187923.0
2014-02-21 07:30:00	SPY	ETF	184.51	184.59	184.51	184.54	184619.0
2014-02-21 08:00:00	SPY	ETF	184.53	184.56	184.32	184.47	257988.0
2014-02-21 08:30:00	SPY	ETF	184.46	184.46	184.29	184.34	242818.0
2014-02-21 09:00:00	SPY	ETF	184.34	184.67	184.31	184.5	779706.0
2014-02-21 09:30:00	SPY	ETF	184.49	184.72	184.16	184.59	16092913.0
2014-02-21 10:00:00	SPY	ETF	184.59	184.8	184.24	184.36	10295005.0
2014-02-21 10:30:00	SPY	ETF	184.36	184.82	184.3501	184.73	6241332.0
2014-02-21 11:00:00	SPY	ETF	184.73	184.89	184.53	184.68	11397013.0
2014-02-21 11:30:00	SPY	ETF	184.69	184.855	184.64	184.67	6583770.0
2014-02-21 12:00:00	SPY	ETF	184.68	184.77	184.61	184.65	3169544.0
2014-02-21 12:30:00	SPY	ETF	184.65	184.685	184.36	184.54	4101282.0
2014-02-21 13:00:00	SPY	ETF	184.53	184.715	184.47	184.59	2030073.0
2014-02-21 13:30:00	SPY	ETF	184.6	184.65	184.37	184.455	3275662.0
2014-02-21 14:00:00	SPY	ETF	184.455	184.5	184.14	184.18	4250551.0
2014-02-21 14:30:00	SPY	ETF	184.17	184.24	183.952	184.15	11071596.0
2014-02-21 15:00:00	SPY	ETF	184.15	184.43	184.12	184.3601	7310455.0
2014-02-21 15:30:00	SPY	ETF	184.37	184.44	183.8	183.91	15978457.0
2014-02-21 16:00:00	SPY	ETF	183.91	184.4035	183.85	183.92	8954009.0
2014-02-21 16:30:00	SPY	ETF	183.93	183.98	183.92	183.92	780083.0
2014-02-21 17:00:00	SPY	ETF	183.92	184.73	183.77	183.81	231438.0
2014-02-21 17:30:00	SPY	ETF	183.79	183.85	183.7	183.85	84041.0
2014-02-21 18:00:00	SPY	ETF	183.82	183.88	183.8	183.86	10185.0
2014-02-21 18:30:00	SPY	ETF	183.85	183.85	183.8	183.83	2285.0
2014-02-21 19:00:00	SPY	ETF	183.85	183.88	183.8	183.8	4802.0
2014-02-21 19:30:00	SPY	ETF	183.86	183.87	183.81	183.87	6312.0
2014-02-21 04:00:00	QQQ	ETF	90.17	90.17	90.16	90.16	2500.0
2014-02-21 04:30:00	QQQ	ETF	90.26	90.27	90.25	90.27	2162.0
2014-02-21 05:00:00	QQQ	ETF	90.26	90.26	90.26	90.26	900.0
2014-02-21 06:00:00	QQQ	ETF	90.18	90.19	90.18	90.19	300.0
2014-02-21 06:30:00	QQQ	ETF	90.22	90.26	90.21	90.25	2700.0
2014-02-21 07:00:00	QQQ	ETF	90.26	90.27	90.23	90.27	58500.0
2014-02-21 07:30:00	QQQ	ETF	90.27	90.32	90.26	90.3	35800.0
2014-02-21 08:00:00	QQQ	ETF	90.32	90.32	90.23	90.24	99284.0
2014-02-21 08:30:00	QQQ	ETF	90.23	90.24	90.16	90.17	51579.0
2014-02-21 09:00:00	QQQ	ETF	90.21	90.39	90.21	90.34	339804.0
2014-02-21 09:30:00	QQQ	ETF	90.34	90.465	90.17	90.4	3712005.0
2014-02-21 10:00:00	QQQ	ETF	90.4	90.44	90.18	90.22	2408350.0
2014-02-21 10:30:00	QQQ	ETF	90.22	90.39	90.22	90.375	1661661.0
2014-02-21 11:00:00	QQQ	ETF	90.38	90.42	90.29	90.31	1235857.0
2014-02-21 11:30:00	QQQ	ETF	90.305	90.3689	90.265	90.28	1285299.0
2014-02-21 12:00:00	QQQ	ETF	90.29	90.33	90.24	90.24	576951.0
2014-02-21 12:30:00	QQQ	ETF	90.24	90.25	90.07	90.15	974456.0
2014-02-21 13:00:00	QQQ	ETF	90.1499	90.26	90.1	90.21	516227.0

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

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