PREVIEW / stock_30min / 2014-06-04

all stock 30-min files

  file:    by_date/stock_30min/2014/2014-06-04.parquet
  size:    1.6 MB
  rows:    82,461
  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
2014-06-04 04:00:00	AAPL	Stock	22.8143	22.8143	22.8143	22.8143	2800.0
2014-06-04 04:30:00	AAPL	Stock	22.8289	22.8289	22.8161	22.8236	36904.0
2014-06-04 05:00:00	AAPL	Stock	22.8036	22.8036	22.7714	22.7854	22400.0
2014-06-04 05:30:00	AAPL	Stock	22.7625	22.7643	22.7625	22.7643	5600.0
2014-06-04 06:00:00	AAPL	Stock	22.7643	22.7732	22.7643	22.7732	10808.0
2014-06-04 06:30:00	AAPL	Stock	22.7854	22.7857	22.7739	22.7739	14840.0
2014-06-04 07:00:00	AAPL	Stock	22.8036	22.8196	22.7757	22.7857	175196.0
2014-06-04 07:30:00	AAPL	Stock	22.7857	22.7921	22.7418	22.7536	98168.0
2014-06-04 08:00:00	AAPL	Stock	22.7657	22.8196	22.7536	22.7536	498288.0
2014-06-04 08:30:00	AAPL	Stock	22.7607	22.7607	22.7146	22.7304	460460.0
2014-06-04 09:00:00	AAPL	Stock	22.7311	22.7661	22.7311	22.7468	359044.0
2014-06-04 09:30:00	AAPL	Stock	22.7657	22.9354	22.7182	22.9143	48340096.0
2014-06-04 10:00:00	AAPL	Stock	22.9164	22.9196	22.8361	22.8604	20493284.0
2014-06-04 10:30:00	AAPL	Stock	22.8557	22.9461	22.8532	22.9389	15000132.0
2014-06-04 11:00:00	AAPL	Stock	22.9429	23.0357	22.9389	23.025	22200640.0
2014-06-04 11:30:00	AAPL	Stock	23.0232	23.0362	22.9671	23.0075	15667988.0
2014-06-04 12:00:00	AAPL	Stock	23.0075	23.0393	22.9918	23.0332	16461536.0
2014-06-04 12:30:00	AAPL	Stock	23.035	23.0852	23.004	23.0754	15364888.0
2014-06-04 13:00:00	AAPL	Stock	23.0779	23.0946	23.0382	23.09	10156496.0
2014-06-04 13:30:00	AAPL	Stock	23.09	23.1186	23.0571	23.0979	16412256.0
2014-06-04 14:00:00	AAPL	Stock	23.0979	23.1389	23.0654	23.0893	17868844.0
2014-06-04 14:30:00	AAPL	Stock	23.0904	23.1014	23.0571	23.0857	13277208.0
2014-06-04 15:00:00	AAPL	Stock	23.0846	23.1	23.0179	23.0786	13375992.0
2014-06-04 15:30:00	AAPL	Stock	23.0789	23.1	23.0093	23.0293	26375300.0
2014-06-04 16:00:00	AAPL	Stock	23.0293	23.0364	22.9841	23.0293	13809600.0
2014-06-04 16:30:00	AAPL	Stock	23.0293	23.0293	23.0107	23.0261	249900.0
2014-06-04 17:00:00	AAPL	Stock	23.0268	23.0282	23.0143	23.0282	59668.0
2014-06-04 17:30:00	AAPL	Stock	23.0282	23.0375	22.9425	23.0375	151032.0
2014-06-04 18:00:00	AAPL	Stock	23.0396	23.0396	23.0232	23.0232	104552.0
2014-06-04 18:30:00	AAPL	Stock	23.0189	23.0346	23.0125	23.0346	60984.0
2014-06-04 19:00:00	AAPL	Stock	23.0314	23.0354	23.0304	23.0314	14000.0
2014-06-04 19:30:00	AAPL	Stock	23.0314	23.0354	23.0236	23.0321	44744.0
2014-06-04 06:30:00	MSFT	Stock	40.27	40.27	40.27	40.27	200.0
2014-06-04 08:00:00	MSFT	Stock	40.29	40.29	40.25	40.25	1800.0
2014-06-04 08:30:00	MSFT	Stock	40.19	40.21	40.16	40.2	5279.0
2014-06-04 09:00:00	MSFT	Stock	40.2	40.24	40.14	40.21	8045.0
2014-06-04 09:30:00	MSFT	Stock	40.21	40.33	40.09	40.114	1754687.0
2014-06-04 10:00:00	MSFT	Stock	40.11	40.135	39.94	39.94	1972052.0
2014-06-04 10:30:00	MSFT	Stock	39.94	40.0	39.86	39.978	2622584.0
2014-06-04 11:00:00	MSFT	Stock	39.975	40.1	39.97	40.08	1642784.0
2014-06-04 11:30:00	MSFT	Stock	40.075	40.168	40.05	40.1	1522757.0
2014-06-04 12:00:00	MSFT	Stock	40.095	40.22	40.09	40.19	975324.0
2014-06-04 12:30:00	MSFT	Stock	40.19	40.26	40.17	40.235	604041.0
2014-06-04 13:00:00	MSFT	Stock	40.235	40.28	40.19	40.2	1080255.0
2014-06-04 13:30:00	MSFT	Stock	40.19	40.29	40.19	40.28	1031398.0
2014-06-04 14:00:00	MSFT	Stock	40.276	40.28	40.195	40.25	1217275.0
2014-06-04 14:30:00	MSFT	Stock	40.25	40.25	40.17	40.215	1267721.0
2014-06-04 15:00:00	MSFT	Stock	40.215	40.29	40.21	40.285	1225755.0
2014-06-04 15:30:00	MSFT	Stock	40.29	40.37	40.27	40.32	3895297.0
2014-06-04 16:00:00	MSFT	Stock	40.32	40.34	40.167	40.32	1715554.0

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

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