PREVIEW / etf_30min / 2013-02-21

all etf 30-min files

  file:    by_date/etf_30min/2013/2013-02-21.parquet
  size:    329 KB
  rows:    11,034

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-21 04:00:00	SPY	ETF	151.05	151.05	150.61	150.65	194871.0
2013-02-21 04:30:00	SPY	ETF	150.56	150.78	150.52	150.78	107050.0
2013-02-21 05:00:00	SPY	ETF	150.71	150.79	150.68	150.68	108640.0
2013-02-21 05:30:00	SPY	ETF	150.65	150.66	150.51	150.58	313157.0
2013-02-21 06:00:00	SPY	ETF	150.59	150.8	150.59	150.65	56940.0
2013-02-21 06:30:00	SPY	ETF	150.7	150.83	150.64	150.81	115000.0
2013-02-21 07:00:00	SPY	ETF	150.82	150.93	150.71	150.79	189783.0
2013-02-21 07:30:00	SPY	ETF	150.8	150.85	150.66	150.82	136098.0
2013-02-21 08:00:00	SPY	ETF	150.85	150.95	150.71	150.93	818647.0
2013-02-21 08:30:00	SPY	ETF	150.93	151.04	150.75	150.92	6605417.0
2013-02-21 09:00:00	SPY	ETF	150.92	151.1	150.85	150.96	834538.0
2013-02-21 09:30:00	SPY	ETF	150.96	150.96	150.3	150.48	26422104.0
2013-02-21 10:00:00	SPY	ETF	150.48	150.83	150.17	150.7801	19900490.0
2013-02-21 10:30:00	SPY	ETF	150.785	150.86	150.575	150.645	8662296.0
2013-02-21 11:00:00	SPY	ETF	150.65	150.73	150.44	150.48	6511981.0
2013-02-21 11:30:00	SPY	ETF	150.49	150.68	150.36	150.56	5656854.0
2013-02-21 12:00:00	SPY	ETF	150.56	150.6	150.25	150.37	5356660.0
2013-02-21 12:30:00	SPY	ETF	150.37	150.43	150.13	150.42	7856006.0
2013-02-21 13:00:00	SPY	ETF	150.42	150.5	150.23	150.2901	7061969.0
2013-02-21 13:30:00	SPY	ETF	150.29	150.39	150.15	150.25	5045534.0
2013-02-21 14:00:00	SPY	ETF	150.26	151.4218	149.94	150.1	9577858.0
2013-02-21 14:30:00	SPY	ETF	150.1	150.46	150.09	150.455	8202136.0
2013-02-21 15:00:00	SPY	ETF	150.4501	150.9	150.34	150.84	13286736.0
2013-02-21 15:30:00	SPY	ETF	150.84	150.9	150.32	150.41	23126610.0
2013-02-21 16:00:00	SPY	ETF	150.41	151.4218	150.4	150.52	13481586.0
2013-02-21 16:30:00	SPY	ETF	150.53	150.64	150.5079	150.64	1774726.0
2013-02-21 17:00:00	SPY	ETF	150.64	150.65	150.4	150.6	197375.0
2013-02-21 17:30:00	SPY	ETF	150.61	150.65	150.54	150.6	160966.0
2013-02-21 18:00:00	SPY	ETF	150.61	150.75	150.6	150.72	968374.0
2013-02-21 18:30:00	SPY	ETF	150.72	150.75	150.63	150.67	817497.0
2013-02-21 19:00:00	SPY	ETF	150.66	150.79	150.65	150.78	40667.0
2013-02-21 19:30:00	SPY	ETF	150.76	150.8	150.67	150.67	33882.0
2013-02-21 04:00:00	QQQ	ETF	66.9	66.9	66.9	66.9	325.0
2013-02-21 04:30:00	QQQ	ETF	66.88	66.9	66.88	66.9	300.0
2013-02-21 05:00:00	QQQ	ETF	66.92	66.92	66.92	66.92	400.0
2013-02-21 05:30:00	QQQ	ETF	66.9	66.9	66.82	66.82	10400.0
2013-02-21 06:30:00	QQQ	ETF	66.87	66.87	66.86	66.86	13000.0
2013-02-21 07:00:00	QQQ	ETF	66.88	66.91	66.86	66.91	10680.0
2013-02-21 07:30:00	QQQ	ETF	66.87	66.92	66.86	66.92	12850.0
2013-02-21 08:00:00	QQQ	ETF	66.93	66.95	66.87	66.95	65280.0
2013-02-21 08:30:00	QQQ	ETF	66.89	67.01	66.89	66.94	346172.0
2013-02-21 09:00:00	QQQ	ETF	66.95	67.02	66.92	66.96	593873.0
2013-02-21 09:30:00	QQQ	ETF	66.96	67.01	66.61	66.71	6205737.0
2013-02-21 10:00:00	QQQ	ETF	66.73	66.82	66.53	66.8	3873459.0
2013-02-21 10:30:00	QQQ	ETF	66.8	66.9	66.68	66.77	2437058.0
2013-02-21 11:00:00	QQQ	ETF	66.77	66.805	66.62	66.64	1744052.0
2013-02-21 11:30:00	QQQ	ETF	66.64	66.68	66.55	66.6001	1424437.0
2013-02-21 12:00:00	QQQ	ETF	66.6	66.61	66.4	66.44	2617404.0
2013-02-21 12:30:00	QQQ	ETF	66.44	66.4901	66.34	66.4801	1809476.0
2013-02-21 13:00:00	QQQ	ETF	66.4881	66.55	66.37	66.39	1771335.0

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

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