PREVIEW / etf_30min / 2013-02-05

all etf 30-min files

  file:    by_date/etf_30min/2013/2013-02-05.parquet
  size:    310 KB
  rows:    10,607

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-05 04:00:00	SPY	ETF	150.09	150.23	150.09	150.23	37310.0
2013-02-05 04:30:00	SPY	ETF	150.18	150.23	150.18	150.23	900.0
2013-02-05 05:00:00	SPY	ETF	150.11	150.26	150.09	150.26	39700.0
2013-02-05 05:30:00	SPY	ETF	150.24	150.33	150.24	150.29	30500.0
2013-02-05 06:00:00	SPY	ETF	150.33	150.49	150.3	150.43	96949.0
2013-02-05 06:30:00	SPY	ETF	150.46	150.49	150.43	150.43	120326.0
2013-02-05 07:00:00	SPY	ETF	150.43	150.56	150.43	150.45	573718.0
2013-02-05 07:30:00	SPY	ETF	150.45	150.51	150.41	150.41	329909.0
2013-02-05 08:00:00	SPY	ETF	150.42	150.53	150.2	150.28	866236.0
2013-02-05 08:30:00	SPY	ETF	150.28	150.38	150.21	150.37	418057.0
2013-02-05 09:00:00	SPY	ETF	150.37	150.44	150.34	150.35	1853065.0
2013-02-05 09:30:00	SPY	ETF	150.35	150.81	150.29	150.72	14366191.0
2013-02-05 10:00:00	SPY	ETF	150.73	150.87	150.62	150.73	11528734.0
2013-02-05 10:30:00	SPY	ETF	150.732	150.99	150.62	150.87	7341981.0
2013-02-05 11:00:00	SPY	ETF	150.87	150.99	150.81	150.895	6214231.0
2013-02-05 11:30:00	SPY	ETF	150.89	150.99	150.79	150.87	6015553.0
2013-02-05 12:00:00	SPY	ETF	150.86	150.91	150.75	150.76	4627634.0
2013-02-05 12:30:00	SPY	ETF	150.759	150.91	150.74	150.8805	4323932.0
2013-02-05 13:00:00	SPY	ETF	150.88	151.13	150.88	151.111	5537407.0
2013-02-05 13:30:00	SPY	ETF	151.12	151.21	151.09	151.148	5157542.0
2013-02-05 14:00:00	SPY	ETF	151.145	151.31	151.12	151.27	5340725.0
2013-02-05 14:30:00	SPY	ETF	151.265	151.48	151.26	151.35	6449769.0
2013-02-05 15:00:00	SPY	ETF	151.35	151.44	151.28	151.3	5948538.0
2013-02-05 15:30:00	SPY	ETF	151.3	151.37	151.01	151.06	17676657.0
2013-02-05 16:00:00	SPY	ETF	151.06	151.2	149.5424	151.0	5346647.0
2013-02-05 16:30:00	SPY	ETF	150.99	151.18	150.99	151.18	811974.0
2013-02-05 17:00:00	SPY	ETF	151.17	151.2	151.11	151.12	65659.0
2013-02-05 17:30:00	SPY	ETF	151.14	151.15	151.1	151.12	32360.0
2013-02-05 18:00:00	SPY	ETF	151.1	151.1	151.01	151.06	32590.0
2013-02-05 18:30:00	SPY	ETF	151.06	151.09	151.03	151.03	11015.0
2013-02-05 19:00:00	SPY	ETF	151.04	151.11	151.03	151.11	9675.0
2013-02-05 19:30:00	SPY	ETF	151.07	151.07	151.02	151.04	23303.0
2013-02-05 05:00:00	QQQ	ETF	66.65	66.68	66.65	66.68	300.0
2013-02-05 05:30:00	QQQ	ETF	66.68	66.68	66.68	66.68	8000.0
2013-02-05 06:00:00	QQQ	ETF	66.72	66.72	66.72	66.72	8000.0
2013-02-05 06:30:00	QQQ	ETF	66.8	66.8	66.78	66.78	12805.0
2013-02-05 07:00:00	QQQ	ETF	66.84	66.85	66.8	66.8	18800.0
2013-02-05 07:30:00	QQQ	ETF	66.81	66.85	66.8	66.8	20227.0
2013-02-05 08:00:00	QQQ	ETF	66.85	66.85	66.75	66.76	565121.0
2013-02-05 08:30:00	QQQ	ETF	66.75	66.81	66.75	66.81	105619.0
2013-02-05 09:00:00	QQQ	ETF	66.83	66.85	66.75	66.75	321030.0
2013-02-05 09:30:00	QQQ	ETF	66.76	67.02	66.61	66.955	4674700.0
2013-02-05 10:00:00	QQQ	ETF	66.96	67.11	66.88	67.05	3477633.0
2013-02-05 10:30:00	QQQ	ETF	67.05	67.19	66.97	67.16	1632125.0
2013-02-05 11:00:00	QQQ	ETF	67.16	67.25	67.15	67.185	2125823.0
2013-02-05 11:30:00	QQQ	ETF	67.18	67.25	67.12	67.21	2679301.0
2013-02-05 12:00:00	QQQ	ETF	67.2	67.31	67.1799	67.22	1383560.0
2013-02-05 12:30:00	QQQ	ETF	67.21	67.28	67.2	67.27	657150.0
2013-02-05 13:00:00	QQQ	ETF	67.27	67.4	67.26	67.381	1560477.0
2013-02-05 13:30:00	QQQ	ETF	67.3899	67.465	67.36	67.41	1393713.0

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

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