PREVIEW / etf_30min / 2014-02-26

all etf 30-min files

  file:    by_date/etf_30min/2014/2014-02-26.parquet
  size:    337 KB
  rows:    11,312

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-26 04:00:00	SPY	ETF	185.57	185.57	185.44	185.44	25554.0
2014-02-26 04:30:00	SPY	ETF	185.42	185.44	185.38	185.39	3641.0
2014-02-26 05:00:00	SPY	ETF	185.47	185.56	185.47	185.48	8539.0
2014-02-26 05:30:00	SPY	ETF	185.47	185.48	185.47	185.48	420.0
2014-02-26 06:00:00	SPY	ETF	185.47	185.51	185.47	185.51	1917.0
2014-02-26 06:30:00	SPY	ETF	185.5	185.56	185.42	185.45	3067.0
2014-02-26 07:00:00	SPY	ETF	185.47	185.51	185.42	185.42	171096.0
2014-02-26 07:30:00	SPY	ETF	185.41	185.45	185.28	185.41	115464.0
2014-02-26 08:00:00	SPY	ETF	185.48	185.64	185.28	185.3	305574.0
2014-02-26 08:30:00	SPY	ETF	185.32	185.46	185.27	185.32	271129.0
2014-02-26 09:00:00	SPY	ETF	185.32	185.35	185.07	185.12	792234.0
2014-02-26 09:30:00	SPY	ETF	185.11	185.36	184.54	184.64	9770357.0
2014-02-26 10:00:00	SPY	ETF	184.64	185.46	184.63	185.38	10425386.0
2014-02-26 10:30:00	SPY	ETF	185.385	185.6	185.17	185.25	6983011.0
2014-02-26 11:00:00	SPY	ETF	185.25	185.54	185.17	185.52	4129027.0
2014-02-26 11:30:00	SPY	ETF	185.52	185.58	185.11	185.26	4248237.0
2014-02-26 12:00:00	SPY	ETF	185.25	185.43	185.24	185.36	2676172.0
2014-02-26 12:30:00	SPY	ETF	185.365	185.53	185.36	185.37	2778709.0
2014-02-26 13:00:00	SPY	ETF	185.38	185.38	185.09	185.35	3801830.0
2014-02-26 13:30:00	SPY	ETF	185.36	185.495	185.11	185.16	3663103.0
2014-02-26 14:00:00	SPY	ETF	185.16	185.26	184.42	184.43	8770733.0
2014-02-26 14:30:00	SPY	ETF	184.42	184.7576	184.33	184.73	7244856.0
2014-02-26 15:00:00	SPY	ETF	184.73	184.79	184.35	184.615	7580311.0
2014-02-26 15:30:00	SPY	ETF	184.61	184.92	184.6	184.83	12537990.0
2014-02-26 16:00:00	SPY	ETF	184.82	184.86	184.65	184.72	7520675.0
2014-02-26 16:30:00	SPY	ETF	184.71	184.81	184.65	184.81	638980.0
2014-02-26 17:00:00	SPY	ETF	184.81	185.01	184.81	185.0	2633325.0
2014-02-26 17:30:00	SPY	ETF	185.0	185.01	184.96	184.98	36807.0
2014-02-26 18:00:00	SPY	ETF	184.96	184.96	184.79	184.87	59848.0
2014-02-26 18:30:00	SPY	ETF	184.88	184.88	184.82	184.88	14750.0
2014-02-26 19:00:00	SPY	ETF	184.89	184.9	184.79	184.87	61461.0
2014-02-26 19:30:00	SPY	ETF	184.84	184.89	184.75	184.86	242505.0
2014-02-26 04:00:00	QQQ	ETF	90.62	90.62	90.61	90.61	2700.0
2014-02-26 06:00:00	QQQ	ETF	90.63	90.63	90.62	90.63	5000.0
2014-02-26 06:30:00	QQQ	ETF	90.68	90.69	90.63	90.63	4000.0
2014-02-26 07:00:00	QQQ	ETF	90.64	90.65	90.62	90.64	6915.0
2014-02-26 07:30:00	QQQ	ETF	90.61	90.65	90.55	90.63	27400.0
2014-02-26 08:00:00	QQQ	ETF	90.63	90.63	90.58	90.61	32265.0
2014-02-26 08:30:00	QQQ	ETF	90.6	90.67	90.6	90.6	57643.0
2014-02-26 09:00:00	QQQ	ETF	90.61	90.63	90.53	90.55	277065.0
2014-02-26 09:30:00	QQQ	ETF	90.56	90.6999	90.245	90.3299	3323778.0
2014-02-26 10:00:00	QQQ	ETF	90.33	90.7	90.31	90.68	4705638.0
2014-02-26 10:30:00	QQQ	ETF	90.68	90.81	90.59	90.6299	1784505.0
2014-02-26 11:00:00	QQQ	ETF	90.63	90.822	90.611	90.8	1443963.0
2014-02-26 11:30:00	QQQ	ETF	90.81	90.84	90.62	90.675	1491545.0
2014-02-26 12:00:00	QQQ	ETF	90.675	90.7274	90.63	90.6899	814095.0
2014-02-26 12:30:00	QQQ	ETF	90.69	90.77	90.66	90.68	916360.0
2014-02-26 13:00:00	QQQ	ETF	90.6899	90.6899	90.51	90.639	1126355.0
2014-02-26 13:30:00	QQQ	ETF	90.64	90.68	90.45	90.48	1449953.0
2014-02-26 14:00:00	QQQ	ETF	90.47	90.51	89.94	89.94	2802804.0

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

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