PREVIEW / etf_30min / 2012-08-15

all etf 30-min files

  file:    by_date/etf_30min/2012/2012-08-15.parquet
  size:    269 KB
  rows:    9,245

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
2012-08-15 04:00:00	SPY	ETF	140.5	140.53	140.39	140.53	17249.0
2012-08-15 04:30:00	SPY	ETF	140.54	140.54	140.54	140.54	300.0
2012-08-15 05:00:00	SPY	ETF	140.62	140.62	140.62	140.62	100.0
2012-08-15 05:30:00	SPY	ETF	140.56	140.56	140.51	140.51	7351.0
2012-08-15 06:00:00	SPY	ETF	140.51	140.58	140.41	140.5	43750.0
2012-08-15 06:30:00	SPY	ETF	140.54	140.54	140.49	140.49	4750.0
2012-08-15 07:00:00	SPY	ETF	140.46	140.58	140.46	140.48	52365.0
2012-08-15 07:30:00	SPY	ETF	140.45	140.54	140.41	140.48	95556.0
2012-08-15 08:00:00	SPY	ETF	140.46	140.6	140.35	140.35	222072.0
2012-08-15 08:30:00	SPY	ETF	140.36	140.65	140.35	140.51	460951.0
2012-08-15 09:00:00	SPY	ETF	140.51	140.64	140.46	140.64	402023.0
2012-08-15 09:30:00	SPY	ETF	140.64	141.07	140.55	140.97	9455937.0
2012-08-15 10:00:00	SPY	ETF	140.97	141.08	140.86	140.93	6802588.0
2012-08-15 10:30:00	SPY	ETF	140.94	141.01	140.69	140.879	8715067.0
2012-08-15 11:00:00	SPY	ETF	140.88	141.01	140.78	140.81	4058818.0
2012-08-15 11:30:00	SPY	ETF	140.81	140.98	140.8	140.95	3575726.0
2012-08-15 12:00:00	SPY	ETF	140.96	141.04	140.9	141.0	2324980.0
2012-08-15 12:30:00	SPY	ETF	141.01	141.04	140.93	140.96	1921106.0
2012-08-15 13:00:00	SPY	ETF	140.95	140.97	140.84	140.852	2594507.0
2012-08-15 13:30:00	SPY	ETF	140.85	140.9	140.8	140.81	2697454.0
2012-08-15 14:00:00	SPY	ETF	140.81	140.94	140.76	140.92	4816219.0
2012-08-15 14:30:00	SPY	ETF	140.92	141.19	140.85	141.0611	5129541.0
2012-08-15 15:00:00	SPY	ETF	141.065	141.11	140.9	140.96	3891756.0
2012-08-15 15:30:00	SPY	ETF	140.96	141.02	140.85	140.92	8127966.0
2012-08-15 16:00:00	SPY	ETF	140.93	141.1	140.7895	140.99	3822932.0
2012-08-15 16:30:00	SPY	ETF	140.99	141.1307	140.97	141.08	1320691.0
2012-08-15 17:00:00	SPY	ETF	141.08	141.08	140.98	141.0	20789.0
2012-08-15 17:30:00	SPY	ETF	141.0	141.07	141.0	141.05	45573.0
2012-08-15 18:00:00	SPY	ETF	141.04	141.05	140.98	141.03	34345.0
2012-08-15 18:30:00	SPY	ETF	141.04	141.06	141.04	141.06	4075.0
2012-08-15 19:00:00	SPY	ETF	141.02	141.06	141.02	141.02	9200.0
2012-08-15 19:30:00	SPY	ETF	141.01	141.04	141.0	141.04	30180.0
2012-08-15 06:00:00	QQQ	ETF	66.85	66.85	66.85	66.85	1533.0
2012-08-15 07:00:00	QQQ	ETF	66.92	66.94	66.9	66.9	13275.0
2012-08-15 07:30:00	QQQ	ETF	66.89	66.91	66.87	66.9	4500.0
2012-08-15 08:00:00	QQQ	ETF	66.92	66.96	66.85	66.96	23690.0
2012-08-15 08:30:00	QQQ	ETF	66.91	67.01	66.91	66.93	65655.0
2012-08-15 09:00:00	QQQ	ETF	66.95	67.01	66.93	67.0	58139.0
2012-08-15 09:30:00	QQQ	ETF	67.0	67.24	66.99	67.19	3296365.0
2012-08-15 10:00:00	QQQ	ETF	67.19	67.23	67.07	67.15	1717648.0
2012-08-15 10:30:00	QQQ	ETF	67.15	67.19	67.02	67.18	1747818.0
2012-08-15 11:00:00	QQQ	ETF	67.18	67.29	67.14	67.16	1110484.0
2012-08-15 11:30:00	QQQ	ETF	67.16	67.28	67.15	67.275	681347.0
2012-08-15 12:00:00	QQQ	ETF	67.279	67.3199	67.22	67.27	1029255.0
2012-08-15 12:30:00	QQQ	ETF	67.279	67.29	67.21	67.25	691746.0
2012-08-15 13:00:00	QQQ	ETF	67.2411	67.25	67.14	67.14	701385.0
2012-08-15 13:30:00	QQQ	ETF	67.14	67.16	67.08	67.087	845612.0
2012-08-15 14:00:00	QQQ	ETF	67.09	67.14	67.05	67.13	1097462.0
2012-08-15 14:30:00	QQQ	ETF	67.14	67.25	67.0999	67.22	1182104.0
2012-08-15 15:00:00	QQQ	ETF	67.23	67.29	67.19	67.219	866904.0

> showing 50 of 9,245 rows — these rows as CSV

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