PREVIEW / stock_30min / 2014-05-07

all stock 30-min files

  file:    by_date/stock_30min/2014/2014-05-07.parquet
  size:    1.6 MB
  rows:    83,226
  symbols: 3,552

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-05-07 04:00:00	AAPL	Stock	21.2368	21.2368	21.2368	21.2368	2800.0
2014-05-07 06:30:00	AAPL	Stock	21.275	21.275	21.2589	21.2589	11200.0
2014-05-07 07:00:00	AAPL	Stock	21.2654	21.3161	21.2654	21.3114	89376.0
2014-05-07 07:30:00	AAPL	Stock	21.2939	21.31	21.2857	21.2996	117488.0
2014-05-07 08:00:00	AAPL	Stock	21.2946	21.3454	21.1786	21.3393	946204.0
2014-05-07 08:30:00	AAPL	Stock	21.3393	21.3479	21.3218	21.3393	180320.0
2014-05-07 09:00:00	AAPL	Stock	21.3418	21.3429	21.2504	21.2589	833560.0
2014-05-07 09:30:00	AAPL	Stock	21.2589	21.3318	21.115	21.1586	36159816.0
2014-05-07 10:00:00	AAPL	Stock	21.1586	21.2357	20.9904	21.0929	39732448.0
2014-05-07 10:30:00	AAPL	Stock	21.0936	21.1432	21.0436	21.0982	15828232.0
2014-05-07 11:00:00	AAPL	Stock	21.0996	21.1064	21.0375	21.0904	13341020.0
2014-05-07 11:30:00	AAPL	Stock	21.0957	21.1964	21.0837	21.1682	11711420.0
2014-05-07 12:00:00	AAPL	Stock	21.1711	21.1903	21.0929	21.1021	8025528.0
2014-05-07 12:30:00	AAPL	Stock	21.1014	21.1118	21.0407	21.0429	8378440.0
2014-05-07 13:00:00	AAPL	Stock	21.0414	21.0618	21.0071	21.0504	8083208.0
2014-05-07 13:30:00	AAPL	Stock	21.0521	21.1168	21.04	21.0421	8223096.0
2014-05-07 14:00:00	AAPL	Stock	21.0421	21.1293	21.0339	21.1182	8899772.0
2014-05-07 14:30:00	AAPL	Stock	21.1232	21.1543	21.0871	21.1071	7601832.0
2014-05-07 15:00:00	AAPL	Stock	21.1089	21.1089	21.0761	21.0971	9079728.0
2014-05-07 15:30:00	AAPL	Stock	21.0971	21.1786	21.095	21.155	21336112.0
2014-05-07 16:00:00	AAPL	Stock	21.1546	21.1982	21.0882	21.1429	8969492.0
2014-05-07 16:30:00	AAPL	Stock	21.1375	21.1546	21.1311	21.1339	718004.0
2014-05-07 17:00:00	AAPL	Stock	21.1321	21.1418	21.125	21.1411	133336.0
2014-05-07 17:30:00	AAPL	Stock	21.1289	21.1393	21.1289	21.1389	80108.0
2014-05-07 18:00:00	AAPL	Stock	21.1389	21.1546	21.1321	21.1321	235312.0
2014-05-07 18:30:00	AAPL	Stock	21.1336	21.1429	21.1289	21.1425	94584.0
2014-05-07 19:00:00	AAPL	Stock	21.1404	21.15	21.1354	21.15	42252.0
2014-05-07 19:30:00	AAPL	Stock	21.1429	21.1429	21.1286	21.1286	167916.0
2014-05-07 07:30:00	MSFT	Stock	39.1	39.1	39.1	39.1	7200.0
2014-05-07 08:00:00	MSFT	Stock	39.1	39.25	39.1	39.25	4700.0
2014-05-07 08:30:00	MSFT	Stock	39.22	39.22	39.18	39.18	1308.0
2014-05-07 09:00:00	MSFT	Stock	39.16	39.22	39.12	39.22	8579.0
2014-05-07 09:30:00	MSFT	Stock	39.23	39.24	38.92	38.936	2956073.0
2014-05-07 10:00:00	MSFT	Stock	38.94	39.02	38.61	38.73	6068694.0
2014-05-07 10:30:00	MSFT	Stock	38.73	38.78	38.58	38.74	3344053.0
2014-05-07 11:00:00	MSFT	Stock	38.75	38.755	38.51	38.55	2437401.0
2014-05-07 11:30:00	MSFT	Stock	38.549	38.93	38.53	38.812	1967712.0
2014-05-07 12:00:00	MSFT	Stock	38.818	38.86	38.76	38.815	907382.0
2014-05-07 12:30:00	MSFT	Stock	38.81	38.83	38.66	38.69	957291.0
2014-05-07 13:00:00	MSFT	Stock	38.685	38.79	38.66	38.74	1577933.0
2014-05-07 13:30:00	MSFT	Stock	38.75	38.83	38.74	38.77	1723867.0
2014-05-07 14:00:00	MSFT	Stock	38.77	39.06	38.76	39.04	2407704.0
2014-05-07 14:30:00	MSFT	Stock	39.04	39.21	39.04	39.2	3961283.0
2014-05-07 15:00:00	MSFT	Stock	39.19	39.3	39.15	39.27	3037185.0
2014-05-07 15:30:00	MSFT	Stock	39.27	39.51	39.25	39.4	6643559.0
2014-05-07 16:00:00	MSFT	Stock	39.4	39.449	38.991	38.991	2437302.0
2014-05-07 16:30:00	MSFT	Stock	39.39	39.4	39.141	39.38	156547.0
2014-05-07 17:00:00	MSFT	Stock	39.36	39.36	39.36	39.36	950.0
2014-05-07 17:30:00	MSFT	Stock	39.36	39.4	39.35	39.4	10551.0
2014-05-07 18:00:00	MSFT	Stock	39.35	39.35	39.33	39.33	2138.0

> showing 50 of 83,226 rows — these rows as CSV

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