PREVIEW / etf_30min / 2014-02-10

all etf 30-min files

  file:    by_date/etf_30min/2014/2014-02-10.parquet
  size:    334 KB
  rows:    11,284

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
2014-02-10 04:00:00	SPY	ETF	179.73	179.73	179.41	179.41	68493.0
2014-02-10 04:30:00	SPY	ETF	179.39	179.49	179.29	179.48	111496.0
2014-02-10 05:00:00	SPY	ETF	179.46	179.52	179.45	179.47	4810.0
2014-02-10 05:30:00	SPY	ETF	179.43	179.43	179.3	179.33	33808.0
2014-02-10 06:00:00	SPY	ETF	179.34	179.41	179.25	179.28	5724.0
2014-02-10 06:30:00	SPY	ETF	179.26	179.29	179.15	179.26	66506.0
2014-02-10 07:00:00	SPY	ETF	179.26	179.48	179.24	179.46	318363.0
2014-02-10 07:30:00	SPY	ETF	179.45	179.51	179.37	179.48	98329.0
2014-02-10 08:00:00	SPY	ETF	179.31	179.63	179.1	179.58	417298.0
2014-02-10 08:30:00	SPY	ETF	179.6	179.62	179.43	179.52	316559.0
2014-02-10 09:00:00	SPY	ETF	179.51	179.75	179.5	179.7	1159169.0
2014-02-10 09:30:00	SPY	ETF	179.7	179.84	179.34	179.73	13463134.0
2014-02-10 10:00:00	SPY	ETF	179.72	179.79	179.55	179.685	6555701.0
2014-02-10 10:30:00	SPY	ETF	179.69	179.72	179.22	179.38	7178854.0
2014-02-10 11:00:00	SPY	ETF	179.38	179.57	179.21	179.53	7036757.0
2014-02-10 11:30:00	SPY	ETF	179.54	179.77	179.47	179.6595	4383972.0
2014-02-10 12:00:00	SPY	ETF	179.66	179.72	179.53	179.56	2732271.0
2014-02-10 12:30:00	SPY	ETF	179.57	179.72	179.54	179.66	2597641.0
2014-02-10 13:00:00	SPY	ETF	179.66	179.72	179.52	179.6999	2012798.0
2014-02-10 13:30:00	SPY	ETF	179.69	179.78	179.62	179.71	3609970.0
2014-02-10 14:00:00	SPY	ETF	179.72	179.92	179.69	179.86	3727892.0
2014-02-10 14:30:00	SPY	ETF	179.862	180.07	179.86	179.945	4937427.0
2014-02-10 15:00:00	SPY	ETF	179.95	179.99	179.75	179.785	3994479.0
2014-02-10 15:30:00	SPY	ETF	179.79	180.02	179.77	180.0	10265083.0
2014-02-10 16:00:00	SPY	ETF	180.01	180.05	179.6564	180.01	9797089.0
2014-02-10 16:30:00	SPY	ETF	179.99	180.04	179.7483	180.04	6170334.0
2014-02-10 17:00:00	SPY	ETF	180.02	180.09	180.01	180.09	75780.0
2014-02-10 17:30:00	SPY	ETF	180.03	180.08	180.0	180.08	79264.0
2014-02-10 18:00:00	SPY	ETF	180.09	180.15	179.97	180.01	98908.0
2014-02-10 18:30:00	SPY	ETF	180.01	180.02	179.98	180.0	25273.0
2014-02-10 19:00:00	SPY	ETF	180.03	180.07	180.0	180.03	5651.0
2014-02-10 19:30:00	SPY	ETF	180.07	180.28	180.07	180.14	138315.0
2014-02-10 04:00:00	QQQ	ETF	87.3	87.3	87.3	87.3	4480.0
2014-02-10 04:30:00	QQQ	ETF	87.2	87.2	87.2	87.2	100.0
2014-02-10 05:30:00	QQQ	ETF	87.21	87.21	87.21	87.21	100.0
2014-02-10 06:30:00	QQQ	ETF	87.19	87.19	87.18	87.18	2400.0
2014-02-10 07:00:00	QQQ	ETF	87.18	87.26	87.15	87.26	9700.0
2014-02-10 07:30:00	QQQ	ETF	87.23	87.29	87.21	87.28	4979.0
2014-02-10 08:00:00	QQQ	ETF	87.21	87.34	87.21	87.34	84857.0
2014-02-10 08:30:00	QQQ	ETF	87.34	87.34	87.26	87.3	48761.0
2014-02-10 09:00:00	QQQ	ETF	87.31	87.36	87.24	87.26	214309.0
2014-02-10 09:30:00	QQQ	ETF	87.25	87.68	87.21	87.59	4885367.0
2014-02-10 10:00:00	QQQ	ETF	87.59	87.61	87.45	87.58	2301227.0
2014-02-10 10:30:00	QQQ	ETF	87.59	87.61	87.34	87.45	2213452.0
2014-02-10 11:00:00	QQQ	ETF	87.445	87.67	87.38	87.65	2251860.0
2014-02-10 11:30:00	QQQ	ETF	87.64	87.75	87.53	87.7	1129735.0
2014-02-10 12:00:00	QQQ	ETF	87.7	87.76	87.63	87.65	696918.0
2014-02-10 12:30:00	QQQ	ETF	87.653	87.75	87.6299	87.64	834411.0
2014-02-10 13:00:00	QQQ	ETF	87.63	87.6799	87.52	87.65	825134.0
2014-02-10 13:30:00	QQQ	ETF	87.641	87.6825	87.57	87.63	887729.0

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

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