PREVIEW / etf_30min / 2013-09-30

all etf 30-min files

  file:    by_date/etf_30min/2013/2013-09-30.parquet
  size:    329 KB
  rows:    11,038

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-09-30 04:00:00	SPY	ETF	167.98	167.98	167.74	167.9	110879.0
2013-09-30 04:30:00	SPY	ETF	167.92	168.0	167.91	167.91	12516.0
2013-09-30 05:00:00	SPY	ETF	167.93	168.01	167.89	167.91	9604.0
2013-09-30 05:30:00	SPY	ETF	167.89	167.9	167.8	167.81	17042.0
2013-09-30 06:00:00	SPY	ETF	167.84	167.87	167.74	167.74	18080.0
2013-09-30 06:30:00	SPY	ETF	167.73	167.73	167.55	167.65	60746.0
2013-09-30 07:00:00	SPY	ETF	167.64	167.79	167.61	167.75	173875.0
2013-09-30 07:30:00	SPY	ETF	167.77	167.82	167.51	167.53	408820.0
2013-09-30 08:00:00	SPY	ETF	167.55	167.74	167.53	167.62	389858.0
2013-09-30 08:30:00	SPY	ETF	167.61	167.65	167.43	167.57	711049.0
2013-09-30 09:00:00	SPY	ETF	167.57	167.63	167.42	167.47	633201.0
2013-09-30 09:30:00	SPY	ETF	167.48	167.84	167.15	167.6	20295229.0
2013-09-30 10:00:00	SPY	ETF	167.61	168.13	167.601	168.0	9752219.0
2013-09-30 10:30:00	SPY	ETF	168.01	168.29	167.93	168.16	7174808.0
2013-09-30 11:00:00	SPY	ETF	168.17	168.2537	167.89	168.04	5836282.0
2013-09-30 11:30:00	SPY	ETF	168.04	168.29	168.04	168.27	5903123.0
2013-09-30 12:00:00	SPY	ETF	168.27	168.29	167.92	167.995	5050124.0
2013-09-30 12:30:00	SPY	ETF	167.99	168.21	167.97	168.07	2839950.0
2013-09-30 13:00:00	SPY	ETF	168.07	168.54	168.07	168.26	7365261.0
2013-09-30 13:30:00	SPY	ETF	168.27	168.54	167.92	168.1	7101193.0
2013-09-30 14:00:00	SPY	ETF	168.09	168.28	168.01	168.13	5555449.0
2013-09-30 14:30:00	SPY	ETF	168.13	168.38	168.12	168.14	6310964.0
2013-09-30 15:00:00	SPY	ETF	168.14	168.14	167.66	167.8601	11177084.0
2013-09-30 15:30:00	SPY	ETF	167.86	168.04	167.59	168.01	29772292.0
2013-09-30 16:00:00	SPY	ETF	168.01	168.9739	167.5	168.25	9011875.0
2013-09-30 16:30:00	SPY	ETF	168.25	168.9738	168.11	168.25	1536394.0
2013-09-30 17:00:00	SPY	ETF	168.24	168.34	167.8963	168.33	441175.0
2013-09-30 17:30:00	SPY	ETF	168.33	168.35	168.3	168.34	35069.0
2013-09-30 18:00:00	SPY	ETF	168.3	168.41	168.25	168.27	168630.0
2013-09-30 18:30:00	SPY	ETF	168.24	168.34	168.23	168.23	106934.0
2013-09-30 19:00:00	SPY	ETF	168.23	168.31	168.23	168.29	11350.0
2013-09-30 19:30:00	SPY	ETF	168.29	168.29	168.21	168.22	30346.0
2013-09-30 04:00:00	QQQ	ETF	78.94	78.94	78.57	78.57	1300.0
2013-09-30 04:30:00	QQQ	ETF	78.65	78.69	78.64	78.64	43300.0
2013-09-30 05:00:00	QQQ	ETF	78.65	78.66	78.62	78.62	4800.0
2013-09-30 05:30:00	QQQ	ETF	78.61	78.61	78.57	78.57	5400.0
2013-09-30 06:00:00	QQQ	ETF	78.56	78.58	78.53	78.53	8000.0
2013-09-30 06:30:00	QQQ	ETF	78.52	78.52	78.45	78.5	12700.0
2013-09-30 07:00:00	QQQ	ETF	78.49	78.55	78.49	78.53	31670.0
2013-09-30 07:30:00	QQQ	ETF	78.52	78.55	78.44	78.45	40195.0
2013-09-30 08:00:00	QQQ	ETF	78.45	78.47	78.42	78.45	72221.0
2013-09-30 08:30:00	QQQ	ETF	78.44	78.45	78.3	78.36	329810.0
2013-09-30 09:00:00	QQQ	ETF	78.36	78.38	78.25	78.27	198508.0
2013-09-30 09:30:00	QQQ	ETF	78.27	78.51	78.0	78.44	4278814.0
2013-09-30 10:00:00	QQQ	ETF	78.44	78.82	78.44	78.76	2925863.0
2013-09-30 10:30:00	QQQ	ETF	78.77	78.9201	78.7	78.875	1853723.0
2013-09-30 11:00:00	QQQ	ETF	78.88	78.925	78.73	78.82	931382.0
2013-09-30 11:30:00	QQQ	ETF	78.82	79.05	78.82	79.032	1250566.0
2013-09-30 12:00:00	QQQ	ETF	79.03	79.03	78.8	78.83	797649.0
2013-09-30 12:30:00	QQQ	ETF	78.84	78.95	78.823	78.889	508462.0

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

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