PREVIEW / etf_30min / 2013-02-26

all etf 30-min files

  file:    by_date/etf_30min/2013/2013-02-26.parquet
  size:    312 KB
  rows:    10,586

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-26 04:00:00	SPY	ETF	149.47	149.62	149.47	149.51	15885.0
2013-02-26 04:30:00	SPY	ETF	149.51	149.71	149.39	149.7	15350.0
2013-02-26 05:00:00	SPY	ETF	149.51	149.59	149.5	149.53	1900.0
2013-02-26 05:30:00	SPY	ETF	149.47	149.48	149.34	149.4	23700.0
2013-02-26 06:00:00	SPY	ETF	149.38	149.54	149.38	149.48	23319.0
2013-02-26 06:30:00	SPY	ETF	149.47	149.48	149.37	149.38	93400.0
2013-02-26 07:00:00	SPY	ETF	149.35	149.67	149.28	149.64	325492.0
2013-02-26 07:30:00	SPY	ETF	149.59	149.67	149.52	149.61	284481.0
2013-02-26 08:00:00	SPY	ETF	149.59	149.85	149.38	149.4	368724.0
2013-02-26 08:30:00	SPY	ETF	149.38	149.82	149.37	149.81	858043.0
2013-02-26 09:00:00	SPY	ETF	149.81	149.91	149.685	149.73	1154307.0
2013-02-26 09:30:00	SPY	ETF	149.72	149.99	149.6	149.92	20348051.0
2013-02-26 10:00:00	SPY	ETF	149.92	150.14	149.29	149.3	29551357.0
2013-02-26 10:30:00	SPY	ETF	149.29	149.68	149.06	149.4	19427334.0
2013-02-26 11:00:00	SPY	ETF	149.405	149.46	148.91	149.03	15192359.0
2013-02-26 11:30:00	SPY	ETF	149.03	149.27	148.73	149.0999	11318851.0
2013-02-26 12:00:00	SPY	ETF	149.1	149.41	149.01	149.32	8626798.0
2013-02-26 12:30:00	SPY	ETF	149.32	149.72	149.1166	149.65	10748730.0
2013-02-26 13:00:00	SPY	ETF	149.65	149.84	149.32	149.45	9028059.0
2013-02-26 13:30:00	SPY	ETF	149.45	149.89	149.43	149.73	7567507.0
2013-02-26 14:00:00	SPY	ETF	149.73	150.01	149.67	150.01	6485572.0
2013-02-26 14:30:00	SPY	ETF	150.005	150.13	149.73	149.88	9315471.0
2013-02-26 15:00:00	SPY	ETF	149.88	150.05	149.68	149.94	8467553.0
2013-02-26 15:30:00	SPY	ETF	149.94	150.2	149.73	150.01	16492112.0
2013-02-26 16:00:00	SPY	ETF	150.01	150.05	148.87	149.75	6030524.0
2013-02-26 16:30:00	SPY	ETF	149.75	149.76	149.0596	149.74	886362.0
2013-02-26 17:00:00	SPY	ETF	149.75	150.02	149.67	149.7	1804478.0
2013-02-26 17:30:00	SPY	ETF	149.68	149.73	149.67	149.73	50035.0
2013-02-26 18:00:00	SPY	ETF	149.74	149.8	149.69	149.8	71946.0
2013-02-26 18:30:00	SPY	ETF	149.76	149.76	149.7	149.72	26082.0
2013-02-26 19:00:00	SPY	ETF	149.72	149.85	149.7	149.82	84225.0
2013-02-26 19:30:00	SPY	ETF	149.83	149.85	149.6	149.67	110026.0
2013-02-26 04:30:00	QQQ	ETF	66.38	66.38	66.38	66.38	100.0
2013-02-26 05:00:00	QQQ	ETF	66.46	66.46	66.39	66.39	300.0
2013-02-26 06:30:00	QQQ	ETF	66.41	66.41	66.39	66.39	1000.0
2013-02-26 07:00:00	QQQ	ETF	66.35	66.42	66.35	66.42	8500.0
2013-02-26 07:30:00	QQQ	ETF	66.43	66.47	66.4	66.44	26990.0
2013-02-26 08:00:00	QQQ	ETF	66.43	66.43	66.35	66.37	18130.0
2013-02-26 08:30:00	QQQ	ETF	66.36	66.49	66.36	66.49	124660.0
2013-02-26 09:00:00	QQQ	ETF	66.5	66.52	66.42	66.42	263364.0
2013-02-26 09:30:00	QQQ	ETF	66.42	66.53	66.28	66.508	4520758.0
2013-02-26 10:00:00	QQQ	ETF	66.51	66.68	66.25	66.28	4661783.0
2013-02-26 10:30:00	QQQ	ETF	66.28	66.5	66.18	66.36	4995630.0
2013-02-26 11:00:00	QQQ	ETF	66.34	66.38	66.1	66.14	4534396.0
2013-02-26 11:30:00	QQQ	ETF	66.14	66.23	65.96	66.072	3685269.0
2013-02-26 12:00:00	QQQ	ETF	66.079	66.2	66.02	66.17	1837870.0
2013-02-26 12:30:00	QQQ	ETF	66.16	66.3201	66.13	66.26	1609908.0
2013-02-26 13:00:00	QQQ	ETF	66.26	66.36	66.1501	66.21	2692071.0
2013-02-26 13:30:00	QQQ	ETF	66.2099	66.55	66.2	66.47	3160590.0
2013-02-26 14:00:00	QQQ	ETF	66.46	66.6	66.41	66.56	1142291.0

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

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