PREVIEW / stock_30min / 2013-11-26

all stock 30-min files

  file:    by_date/stock_30min/2013/2013-11-26.parquet
  size:    1.6 MB
  rows:    80,807
  symbols: 3,561

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-11-26 06:00:00	AAPL	Stock	18.7175	18.7175	18.7175	18.7175	2800.0
2013-11-26 06:30:00	AAPL	Stock	18.7146	18.7232	18.7146	18.7204	19600.0
2013-11-26 07:00:00	AAPL	Stock	18.7004	18.7004	18.7	18.7	8400.0
2013-11-26 07:30:00	AAPL	Stock	18.7371	18.7475	18.7371	18.7475	73276.0
2013-11-26 08:00:00	AAPL	Stock	18.7357	18.7579	18.7071	18.7439	509264.0
2013-11-26 08:30:00	AAPL	Stock	18.7439	18.7696	18.7321	18.755	496804.0
2013-11-26 09:00:00	AAPL	Stock	18.7561	18.7643	18.7143	18.7143	569884.0
2013-11-26 09:30:00	AAPL	Stock	18.7193	18.8518	18.7143	18.8201	45227392.0
2013-11-26 10:00:00	AAPL	Stock	18.8139	18.9011	18.7964	18.895	38051160.0
2013-11-26 10:30:00	AAPL	Stock	18.8964	18.9046	18.8675	18.8893	17672564.0
2013-11-26 11:00:00	AAPL	Stock	18.8889	18.9157	18.8804	18.9004	19604564.0
2013-11-26 11:30:00	AAPL	Stock	18.9	18.9589	18.8954	18.9351	23734676.0
2013-11-26 12:00:00	AAPL	Stock	18.9364	19.0045	18.9343	18.9832	23151520.0
2013-11-26 12:30:00	AAPL	Stock	18.9843	19.0718	18.9732	19.04	31747856.0
2013-11-26 13:00:00	AAPL	Stock	19.0418	19.1071	19.0409	19.0979	23619120.0
2013-11-26 13:30:00	AAPL	Stock	19.0982	19.1361	19.0857	19.1225	26350156.0
2013-11-26 14:00:00	AAPL	Stock	19.1232	19.1479	19.0893	19.1179	20592320.0
2013-11-26 14:30:00	AAPL	Stock	19.1182	19.1371	19.0846	19.1293	13788712.0
2013-11-26 15:00:00	AAPL	Stock	19.1307	19.1464	19.1146	19.1339	17647560.0
2013-11-26 15:30:00	AAPL	Stock	19.1339	19.1379	19.0507	19.0571	43630328.0
2013-11-26 16:00:00	AAPL	Stock	19.05	19.1262	18.8957	19.0643	43163624.0
2013-11-26 16:30:00	AAPL	Stock	19.0501	19.1207	19.0501	19.065	200032.0
2013-11-26 17:00:00	AAPL	Stock	19.0593	19.085	19.0568	19.0821	2111228.0
2013-11-26 17:30:00	AAPL	Stock	19.0739	19.0964	19.05	19.0964	319844.0
2013-11-26 18:00:00	AAPL	Stock	19.1	19.1071	19.0893	19.0982	312592.0
2013-11-26 18:30:00	AAPL	Stock	19.1032	19.1129	19.0946	19.0961	477260.0
2013-11-26 19:00:00	AAPL	Stock	19.0946	19.105	19.0929	19.1036	112168.0
2013-11-26 19:30:00	AAPL	Stock	19.1032	19.1036	19.0925	19.0946	313572.0
2013-11-26 07:00:00	MSFT	Stock	37.6	37.63	37.6	37.63	346.0
2013-11-26 08:00:00	MSFT	Stock	37.6	37.67	37.6	37.67	800.0
2013-11-26 08:30:00	MSFT	Stock	37.7	37.71	37.64	37.64	47594.0
2013-11-26 09:00:00	MSFT	Stock	37.65	37.71	37.53	37.57	31114.0
2013-11-26 09:30:00	MSFT	Stock	37.57	37.65	37.457	37.51	3039945.0
2013-11-26 10:00:00	MSFT	Stock	37.52	37.575	37.49	37.515	1669570.0
2013-11-26 10:30:00	MSFT	Stock	37.51	37.56	37.43	37.535	2413906.0
2013-11-26 11:00:00	MSFT	Stock	37.54	37.61	37.51	37.51	1899800.0
2013-11-26 11:30:00	MSFT	Stock	37.51	37.55	37.49	37.5	1217859.0
2013-11-26 12:00:00	MSFT	Stock	37.5	37.57	37.495	37.555	779378.0
2013-11-26 12:30:00	MSFT	Stock	37.555	37.57	37.5	37.53	769468.0
2013-11-26 13:00:00	MSFT	Stock	37.53	37.58	37.51	37.555	913676.0
2013-11-26 13:30:00	MSFT	Stock	37.56	37.57	37.52	37.56	611823.0
2013-11-26 14:00:00	MSFT	Stock	37.55	37.6	37.54	37.6	781103.0
2013-11-26 14:30:00	MSFT	Stock	37.6	37.62	37.57	37.57	855287.0
2013-11-26 15:00:00	MSFT	Stock	37.58	37.6	37.54	37.585	1426064.0
2013-11-26 15:30:00	MSFT	Stock	37.58	37.59	37.35	37.36	6464973.0
2013-11-26 16:00:00	MSFT	Stock	37.36	37.592	37.334	37.339	8965984.0
2013-11-26 16:30:00	MSFT	Stock	37.352	37.478	37.352	37.42	6330.0
2013-11-26 17:00:00	MSFT	Stock	37.363	37.4	37.363	37.4	261409.0
2013-11-26 17:30:00	MSFT	Stock	37.35	37.552	37.35	37.42	3222.0
2013-11-26 19:30:00	MSFT	Stock	37.4	37.4	37.4	37.4	100.0

> showing 50 of 80,807 rows — these rows as CSV

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