PREVIEW / etf_30min / 2013-02-20

all etf 30-min files

  file:    by_date/etf_30min/2013/2013-02-20.parquet
  size:    321 KB
  rows:    10,728

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-02-20 04:00:00	SPY	ETF	153.29	153.4	153.29	153.35	5215.0
2013-02-20 04:30:00	SPY	ETF	153.36	153.37	153.34	153.37	12450.0
2013-02-20 05:00:00	SPY	ETF	153.27	153.31	153.27	153.31	1535.0
2013-02-20 05:30:00	SPY	ETF	153.28	153.28	153.28	153.28	100.0
2013-02-20 06:00:00	SPY	ETF	153.22	153.23	153.22	153.23	202100.0
2013-02-20 06:30:00	SPY	ETF	153.23	153.24	153.18	153.18	3200.0
2013-02-20 07:00:00	SPY	ETF	153.18	153.22	153.07	153.11	120328.0
2013-02-20 07:30:00	SPY	ETF	153.1	153.18	153.05	153.18	74550.0
2013-02-20 08:00:00	SPY	ETF	153.15	153.21	153.08	153.12	183324.0
2013-02-20 08:30:00	SPY	ETF	153.1	153.25	153.02	153.22	594575.0
2013-02-20 09:00:00	SPY	ETF	153.22	153.29	153.13	153.15	626598.0
2013-02-20 09:30:00	SPY	ETF	153.14	153.19	152.885	152.919	10076854.0
2013-02-20 10:00:00	SPY	ETF	152.919	153.17	152.9	153.04	5902810.0
2013-02-20 10:30:00	SPY	ETF	153.03	153.13	152.83	152.84	10729795.0
2013-02-20 11:00:00	SPY	ETF	152.84	152.85	152.59	152.69	7843160.0
2013-02-20 11:30:00	SPY	ETF	152.69	152.7	152.4	152.54	9368608.0
2013-02-20 12:00:00	SPY	ETF	152.53	152.72	152.49	152.66	6548479.0
2013-02-20 12:30:00	SPY	ETF	152.655	152.76	152.58	152.69	6295883.0
2013-02-20 13:00:00	SPY	ETF	152.68	152.72	152.5	152.63	4347854.0
2013-02-20 13:30:00	SPY	ETF	152.625	152.625	152.47	152.52	3655830.0
2013-02-20 14:00:00	SPY	ETF	152.52	152.74	152.29	152.49	13242373.0
2013-02-20 14:30:00	SPY	ETF	152.49	152.55	151.88	151.96	10617842.0
2013-02-20 15:00:00	SPY	ETF	151.965	151.97	151.52	151.5901	15626554.0
2013-02-20 15:30:00	SPY	ETF	151.6	151.75	151.3	151.31	34624430.0
2013-02-20 16:00:00	SPY	ETF	151.33	153.2819	151.09	151.14	10095555.0
2013-02-20 16:30:00	SPY	ETF	151.14	152.66	151.11	151.22	3214535.0
2013-02-20 17:00:00	SPY	ETF	151.22	151.26	151.07	151.08	197856.0
2013-02-20 17:30:00	SPY	ETF	151.08	151.17	151.07	151.17	73971.0
2013-02-20 18:00:00	SPY	ETF	151.18	151.22	151.15	151.16	81387.0
2013-02-20 18:30:00	SPY	ETF	151.16	151.29	151.16	151.27	72293.0
2013-02-20 19:00:00	SPY	ETF	151.27	151.32	151.24	151.31	53140.0
2013-02-20 19:30:00	SPY	ETF	151.28	151.34	151.26	151.32	30818.0
2013-02-20 04:00:00	QQQ	ETF	68.33	68.33	68.33	68.33	100.0
2013-02-20 05:00:00	QQQ	ETF	68.29	68.29	68.27	68.27	400.0
2013-02-20 06:00:00	QQQ	ETF	68.27	68.27	68.27	68.27	3300.0
2013-02-20 06:30:00	QQQ	ETF	68.22	68.22	68.2	68.2	19000.0
2013-02-20 07:00:00	QQQ	ETF	68.18	68.2	68.1	68.12	103699.0
2013-02-20 07:30:00	QQQ	ETF	68.12	68.18	68.1	68.17	87300.0
2013-02-20 08:00:00	QQQ	ETF	68.18	68.21	68.14	68.19	52390.0
2013-02-20 08:30:00	QQQ	ETF	68.18	68.22	68.17	68.22	39610.0
2013-02-20 09:00:00	QQQ	ETF	68.21	68.25	68.19	68.24	135635.0
2013-02-20 09:30:00	QQQ	ETF	68.24	68.25	68.05	68.0543	3445142.0
2013-02-20 10:00:00	QQQ	ETF	68.05	68.1601	68.02	68.14	1413163.0
2013-02-20 10:30:00	QQQ	ETF	68.13	68.17	68.02	68.02	3690792.0
2013-02-20 11:00:00	QQQ	ETF	68.02	68.03	67.92	67.934	1540228.0
2013-02-20 11:30:00	QQQ	ETF	67.93	67.93	67.64	67.78	4106919.0
2013-02-20 12:00:00	QQQ	ETF	67.78	67.869	67.74	67.83	1251698.0
2013-02-20 12:30:00	QQQ	ETF	67.83	67.86	67.76	67.81	711293.0
2013-02-20 13:00:00	QQQ	ETF	67.8	67.81	67.69	67.78	740607.0
2013-02-20 13:30:00	QQQ	ETF	67.78	67.7865	67.7	67.74	618417.0

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

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