PREVIEW / stock_30min / 2013-12-12

all stock 30-min files

  file:    by_date/stock_30min/2013/2013-12-12.parquet
  size:    1.6 MB
  rows:    82,122
  symbols: 3,533

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-12-12 04:00:00	AAPL	Stock	20.0357	20.0489	20.0096	20.0096	28000.0
2013-12-12 04:30:00	AAPL	Stock	20.0157	20.0157	20.0157	20.0157	5600.0
2013-12-12 05:30:00	AAPL	Stock	20.0157	20.0157	19.9929	19.9929	31640.0
2013-12-12 06:00:00	AAPL	Stock	20.0011	20.0114	20.0011	20.0114	18088.0
2013-12-12 06:30:00	AAPL	Stock	20.0057	20.0057	20.0057	20.0057	2800.0
2013-12-12 07:00:00	AAPL	Stock	20.0118	20.0364	20.0107	20.0357	77196.0
2013-12-12 07:30:00	AAPL	Stock	20.0493	20.1236	20.0432	20.1214	319452.0
2013-12-12 08:00:00	AAPL	Stock	20.1179	20.125	20.0321	20.1107	663180.0
2013-12-12 08:30:00	AAPL	Stock	20.1096	20.1525	20.1079	20.1361	612444.0
2013-12-12 09:00:00	AAPL	Stock	20.1375	20.1421	20.0729	20.0789	568708.0
2013-12-12 09:30:00	AAPL	Stock	20.0765	20.1521	20.0269	20.0775	38567424.0
2013-12-12 10:00:00	AAPL	Stock	20.0789	20.1046	20.0121	20.0811	21371700.0
2013-12-12 10:30:00	AAPL	Stock	20.0794	20.1586	20.0757	20.1464	16681280.0
2013-12-12 11:00:00	AAPL	Stock	20.1443	20.1907	20.1125	20.1239	20459516.0
2013-12-12 11:30:00	AAPL	Stock	20.1193	20.1239	20.0393	20.0436	15438080.0
2013-12-12 12:00:00	AAPL	Stock	20.0429	20.0818	20.025	20.0671	14106932.0
2013-12-12 12:30:00	AAPL	Stock	20.0671	20.0936	20.0279	20.0711	11696524.0
2013-12-12 13:00:00	AAPL	Stock	20.0696	20.1236	20.0632	20.0746	11113340.0
2013-12-12 13:30:00	AAPL	Stock	20.0793	20.0979	20.0461	20.0571	7088984.0
2013-12-12 14:00:00	AAPL	Stock	20.0604	20.1	20.0564	20.0857	7782236.0
2013-12-12 14:30:00	AAPL	Stock	20.0839	20.0932	20.0421	20.0643	7479500.0
2013-12-12 15:00:00	AAPL	Stock	20.0636	20.0761	20.0307	20.0562	10185308.0
2013-12-12 15:30:00	AAPL	Stock	20.0537	20.0664	20.0011	20.0239	21337484.0
2013-12-12 16:00:00	AAPL	Stock	20.0193	20.0817	20.0071	20.0193	10389848.0
2013-12-12 16:30:00	AAPL	Stock	20.0193	20.0394	20.0104	20.0104	276640.0
2013-12-12 17:00:00	AAPL	Stock	20.0121	20.0161	20.0043	20.0161	199108.0
2013-12-12 17:30:00	AAPL	Stock	20.0136	20.0161	20.0136	20.0161	8400.0
2013-12-12 18:00:00	AAPL	Stock	20.0179	20.0264	20.0139	20.0264	100828.0
2013-12-12 18:30:00	AAPL	Stock	20.0268	20.0314	20.0214	20.0286	66360.0
2013-12-12 19:00:00	AAPL	Stock	20.0332	20.0332	20.0214	20.0214	30520.0
2013-12-12 19:30:00	AAPL	Stock	20.0332	20.0336	20.0139	20.0286	76468.0
2013-12-12 07:00:00	MSFT	Stock	37.48	37.54	36.88	37.17	29718.0
2013-12-12 07:30:00	MSFT	Stock	37.25	37.39	37.25	37.3	7004.0
2013-12-12 08:00:00	MSFT	Stock	37.38	37.4	37.25	37.36	11397.0
2013-12-12 08:30:00	MSFT	Stock	37.36	37.59	37.36	37.54	23196.0
2013-12-12 09:00:00	MSFT	Stock	37.59	37.59	37.54	37.59	5730.0
2013-12-12 09:30:00	MSFT	Stock	37.59	37.64	37.3	37.39	4488196.0
2013-12-12 10:00:00	MSFT	Stock	37.39	37.45	37.37	37.43	2151134.0
2013-12-12 10:30:00	MSFT	Stock	37.433	37.51	37.405	37.42	3102912.0
2013-12-12 11:00:00	MSFT	Stock	37.42	37.51	37.42	37.45	2072399.0
2013-12-12 11:30:00	MSFT	Stock	37.445	37.465	37.42	37.44	1035908.0
2013-12-12 12:00:00	MSFT	Stock	37.444	37.46	37.4	37.425	1696565.0
2013-12-12 12:30:00	MSFT	Stock	37.425	37.46	37.41	37.42	1322642.0
2013-12-12 13:00:00	MSFT	Stock	37.42	37.47	37.4	37.41	2136019.0
2013-12-12 13:30:00	MSFT	Stock	37.42	37.44	37.4	37.439	1184809.0
2013-12-12 14:00:00	MSFT	Stock	37.43	37.49	37.37	37.43	2963066.0
2013-12-12 14:30:00	MSFT	Stock	37.435	37.456	37.42	37.435	1347477.0
2013-12-12 15:00:00	MSFT	Stock	37.43	37.44	37.37	37.415	1921855.0
2013-12-12 15:30:00	MSFT	Stock	37.415	37.43	37.18	37.23	6484079.0
2013-12-12 16:00:00	MSFT	Stock	37.22	37.434	37.21	37.22	3048165.0

> showing 50 of 82,122 rows — these rows as CSV

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