PREVIEW / etf_30min / 2013-04-11

all etf 30-min files

  file:    by_date/etf_30min/2013/2013-04-11.parquet
  size:    309 KB
  rows:    10,529

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-04-11 04:00:00	SPY	ETF	158.61	158.76	158.61	158.74	13449.0
2013-04-11 04:30:00	SPY	ETF	158.79	158.95	158.79	158.95	373223.0
2013-04-11 05:00:00	SPY	ETF	158.95	159.02	158.91	158.99	148915.0
2013-04-11 05:30:00	SPY	ETF	158.91	158.91	158.86	158.88	16800.0
2013-04-11 06:00:00	SPY	ETF	158.85	158.86	158.76	158.76	1200.0
2013-04-11 06:30:00	SPY	ETF	158.78	158.78	158.73	158.76	9603.0
2013-04-11 07:00:00	SPY	ETF	158.8	158.87	158.76	158.76	65639.0
2013-04-11 07:30:00	SPY	ETF	158.76	158.82	158.71	158.71	334507.0
2013-04-11 08:00:00	SPY	ETF	158.71	158.73	158.62	158.64	379867.0
2013-04-11 08:30:00	SPY	ETF	158.74	158.875	158.69	158.79	680977.0
2013-04-11 09:00:00	SPY	ETF	158.8	158.81	158.64	158.7	509754.0
2013-04-11 09:30:00	SPY	ETF	158.7	158.98	158.54	158.83	11245087.0
2013-04-11 10:00:00	SPY	ETF	158.82	159.19	158.82	159.165	8762665.0
2013-04-11 10:30:00	SPY	ETF	159.17	159.49	158.98	159.4597	10484544.0
2013-04-11 11:00:00	SPY	ETF	159.46	159.71	159.41	159.6	8223193.0
2013-04-11 11:30:00	SPY	ETF	159.6	159.6201	159.25	159.37	7677960.0
2013-04-11 12:00:00	SPY	ETF	159.38	159.38	159.17	159.22	5052439.0
2013-04-11 12:30:00	SPY	ETF	159.22	159.49	159.22	159.4699	4244866.0
2013-04-11 13:00:00	SPY	ETF	159.47	159.62	159.45	159.45	5429697.0
2013-04-11 13:30:00	SPY	ETF	159.4501	159.63	159.25	159.25	4492164.0
2013-04-11 14:00:00	SPY	ETF	159.251	159.3	159.06	159.24	7237895.0
2013-04-11 14:30:00	SPY	ETF	159.23	159.46	159.23	159.4301	4452113.0
2013-04-11 15:00:00	SPY	ETF	159.43	159.525	159.185	159.271	5151335.0
2013-04-11 15:30:00	SPY	ETF	159.27	159.42	159.03	159.21	13523595.0
2013-04-11 16:00:00	SPY	ETF	159.21	159.2791	158.7158	159.2	5246918.0
2013-04-11 16:30:00	SPY	ETF	159.21	159.3696	159.19	159.23	2412146.0
2013-04-11 17:00:00	SPY	ETF	159.22	159.27	159.22	159.26	19913.0
2013-04-11 17:30:00	SPY	ETF	159.26	159.27	159.21	159.23	18282.0
2013-04-11 18:00:00	SPY	ETF	159.23	159.25	159.2	159.25	22268.0
2013-04-11 18:30:00	SPY	ETF	159.24	159.37	159.23	159.31	40420.0
2013-04-11 19:00:00	SPY	ETF	159.31	159.37	159.28	159.28	16275.0
2013-04-11 19:30:00	SPY	ETF	159.28	159.28	159.21	159.21	38681.0
2013-04-11 04:30:00	QQQ	ETF	69.93	70.02	69.93	70.02	1300.0
2013-04-11 05:00:00	QQQ	ETF	70.05	70.05	70.02	70.02	7000.0
2013-04-11 05:30:00	QQQ	ETF	70.01	70.01	69.99	69.99	35000.0
2013-04-11 06:00:00	QQQ	ETF	69.97	69.97	69.9	69.9	66600.0
2013-04-11 06:30:00	QQQ	ETF	69.89	69.9	69.89	69.9	5200.0
2013-04-11 07:00:00	QQQ	ETF	69.94	69.94	69.88	69.88	14300.0
2013-04-11 07:30:00	QQQ	ETF	69.88	69.9	69.83	69.84	162610.0
2013-04-11 08:00:00	QQQ	ETF	69.85	70.11	69.8	69.83	177702.0
2013-04-11 08:30:00	QQQ	ETF	69.84	69.91	69.81	69.87	276140.0
2013-04-11 09:00:00	QQQ	ETF	69.87	69.87	69.78	69.85	490195.0
2013-04-11 09:30:00	QQQ	ETF	69.84	69.94	69.77	69.82	5339227.0
2013-04-11 10:00:00	QQQ	ETF	69.82	69.99	69.811	69.95	2948994.0
2013-04-11 10:30:00	QQQ	ETF	69.94	70.05	69.831	70.05	2323094.0
2013-04-11 11:00:00	QQQ	ETF	70.05	70.15	70.01	70.11	2334429.0
2013-04-11 11:30:00	QQQ	ETF	70.11	70.13	69.905	69.9601	1401888.0
2013-04-11 12:00:00	QQQ	ETF	69.96	69.97	69.9	69.9	832343.0
2013-04-11 12:30:00	QQQ	ETF	69.902	70.02	69.9	70.01	985153.0
2013-04-11 13:00:00	QQQ	ETF	70.01	70.07	69.99	69.995	1130323.0

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

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