PREVIEW / stock_30min / 2013-12-06

all stock 30-min files

  file:    by_date/stock_30min/2013/2013-12-06.parquet
  size:    1.6 MB
  rows:    81,092
  symbols: 3,528

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-06 04:00:00	AAPL	Stock	20.3214	20.3454	20.3214	20.3454	16520.0
2013-12-06 04:30:00	AAPL	Stock	20.3629	20.3629	20.3629	20.3629	2800.0
2013-12-06 05:00:00	AAPL	Stock	20.3721	20.3721	20.3429	20.3429	28112.0
2013-12-06 05:30:00	AAPL	Stock	20.3454	20.3571	20.3429	20.3429	22400.0
2013-12-06 06:00:00	AAPL	Stock	20.3482	20.3568	20.2857	20.2857	56056.0
2013-12-06 06:30:00	AAPL	Stock	20.2568	20.2568	20.2143	20.2411	99372.0
2013-12-06 07:00:00	AAPL	Stock	20.25	20.275	20.1875	20.1875	217644.0
2013-12-06 07:30:00	AAPL	Stock	20.1879	20.2318	20.1679	20.2318	389760.0
2013-12-06 08:00:00	AAPL	Stock	20.2432	20.3571	20.1971	20.2114	1017016.0
2013-12-06 08:30:00	AAPL	Stock	20.2036	20.2482	20.1814	20.2143	3200064.0
2013-12-06 09:00:00	AAPL	Stock	20.2164	20.2314	20.1736	20.2175	2195760.0
2013-12-06 09:30:00	AAPL	Stock	20.2061	20.2411	20.1286	20.1784	68508832.0
2013-12-06 10:00:00	AAPL	Stock	20.1786	20.2032	20.0811	20.0989	39039056.0
2013-12-06 10:30:00	AAPL	Stock	20.0971	20.1268	20.0461	20.1089	28050764.0
2013-12-06 11:00:00	AAPL	Stock	20.1104	20.1357	20.0836	20.1196	13324192.0
2013-12-06 11:30:00	AAPL	Stock	20.1229	20.1468	20.1154	20.1282	14123760.0
2013-12-06 12:00:00	AAPL	Stock	20.1293	20.175	20.1179	20.1336	18765432.0
2013-12-06 12:30:00	AAPL	Stock	20.1279	20.1296	20.0946	20.1118	14463316.0
2013-12-06 13:00:00	AAPL	Stock	20.1118	20.1314	20.0604	20.0711	14841848.0
2013-12-06 13:30:00	AAPL	Stock	20.0734	20.1061	20.0571	20.0754	10201576.0
2013-12-06 14:00:00	AAPL	Stock	20.0761	20.1443	20.0732	20.1089	11612692.0
2013-12-06 14:30:00	AAPL	Stock	20.1089	20.1089	20.0386	20.0589	11597348.0
2013-12-06 15:00:00	AAPL	Stock	20.0596	20.0902	20.0054	20.0089	20551076.0
2013-12-06 15:30:00	AAPL	Stock	20.0086	20.0257	19.9846	19.9975	38853640.0
2013-12-06 16:00:00	AAPL	Stock	20.0007	20.132	19.9889	20.132	14867972.0
2013-12-06 16:30:00	AAPL	Stock	19.9975	20.0011	19.9971	20.0011	686336.0
2013-12-06 17:00:00	AAPL	Stock	20.0004	20.0014	19.9986	20.0	1023680.0
2013-12-06 17:30:00	AAPL	Stock	20.0018	20.0018	19.9982	20.0004	108276.0
2013-12-06 18:00:00	AAPL	Stock	20.0	20.0036	20.0	20.0036	315980.0
2013-12-06 18:30:00	AAPL	Stock	20.0025	20.0068	19.9982	20.0036	79352.0
2013-12-06 19:00:00	AAPL	Stock	20.0043	20.0043	19.9982	20.0004	28000.0
2013-12-06 19:30:00	AAPL	Stock	20.0036	20.0089	20.0	20.0	159516.0
2013-12-06 07:00:00	MSFT	Stock	38.17	38.17	38.17	38.17	110.0
2013-12-06 07:30:00	MSFT	Stock	38.16	38.17	38.16	38.17	2570.0
2013-12-06 08:00:00	MSFT	Stock	38.17	38.3	38.1	38.2	19510.0
2013-12-06 08:30:00	MSFT	Stock	38.2	38.26	37.99	38.23	78870.0
2013-12-06 09:00:00	MSFT	Stock	38.21	38.46	38.21	38.41	106200.0
2013-12-06 09:30:00	MSFT	Stock	38.4	38.43	38.1	38.186	6575993.0
2013-12-06 10:00:00	MSFT	Stock	38.19	38.23	38.15	38.181	2537003.0
2013-12-06 10:30:00	MSFT	Stock	38.185	38.2	37.99	38.12	2581243.0
2013-12-06 11:00:00	MSFT	Stock	38.115	38.3	38.093	38.265	1456357.0
2013-12-06 11:30:00	MSFT	Stock	38.27	38.37	38.25	38.37	1148991.0
2013-12-06 12:00:00	MSFT	Stock	38.363	38.39	38.29	38.36	903761.0
2013-12-06 12:30:00	MSFT	Stock	38.357	38.545	38.34	38.54	2176447.0
2013-12-06 13:00:00	MSFT	Stock	38.54	38.55	38.293	38.3	1633465.0
2013-12-06 13:30:00	MSFT	Stock	38.3	38.34	38.26	38.26	1848334.0
2013-12-06 14:00:00	MSFT	Stock	38.265	38.33	38.264	38.295	1629605.0
2013-12-06 14:30:00	MSFT	Stock	38.3	38.31	38.22	38.27	1574989.0
2013-12-06 15:00:00	MSFT	Stock	38.263	38.3	38.23	38.235	1743557.0
2013-12-06 15:30:00	MSFT	Stock	38.236	38.38	38.21	38.35	4352017.0

> showing 50 of 81,092 rows — these rows as CSV

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