PREVIEW / stock_30min / 2012-09-05

all stock 30-min files

  file:    by_date/stock_30min/2012/2012-09-05.parquet
  size:    1.4 MB
  rows:    76,029
  symbols: 3,470

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
2012-09-05 04:00:00	AAPL	Stock	24.1061	24.1061	24.0421	24.0496	83412.0
2012-09-05 04:30:00	AAPL	Stock	24.0411	24.0414	24.0368	24.0368	33600.0
2012-09-05 05:00:00	AAPL	Stock	24.05	24.0607	24.0464	24.0607	66500.0
2012-09-05 05:30:00	AAPL	Stock	24.0714	24.1029	24.0714	24.1029	44800.0
2012-09-05 06:00:00	AAPL	Stock	24.0982	24.1425	24.0982	24.1425	11900.0
2012-09-05 06:30:00	AAPL	Stock	24.1496	24.1496	24.1429	24.1429	15708.0
2012-09-05 07:00:00	AAPL	Stock	24.1339	24.1554	24.1071	24.1386	240016.0
2012-09-05 07:30:00	AAPL	Stock	24.1161	24.1425	24.1161	24.125	369040.0
2012-09-05 08:00:00	AAPL	Stock	24.1243	24.1657	24.0357	24.0786	1894648.0
2012-09-05 08:30:00	AAPL	Stock	24.0779	24.1207	24.0771	24.1075	1343888.0
2012-09-05 09:00:00	AAPL	Stock	24.1079	24.1257	24.0964	24.1257	818356.0
2012-09-05 09:30:00	AAPL	Stock	24.1314	24.1554	23.9739	24.1046	72150288.0
2012-09-05 10:00:00	AAPL	Stock	24.1068	24.1221	24.0321	24.0495	30766400.0
2012-09-05 10:30:00	AAPL	Stock	24.0536	24.0654	23.9821	23.985	25381832.0
2012-09-05 11:00:00	AAPL	Stock	23.987	24.0529	23.9554	24.0454	21958720.0
2012-09-05 11:30:00	AAPL	Stock	24.0475	24.0686	24.0304	24.0357	11655644.0
2012-09-05 12:00:00	AAPL	Stock	24.0362	24.0757	24.0321	24.0607	8976772.0
2012-09-05 12:30:00	AAPL	Stock	24.0607	24.1382	24.0268	24.1061	16210656.0
2012-09-05 13:00:00	AAPL	Stock	24.1032	24.1179	24.0725	24.0971	11871328.0
2012-09-05 13:30:00	AAPL	Stock	24.0968	24.0989	23.9971	24.0411	20444144.0
2012-09-05 14:00:00	AAPL	Stock	24.0357	24.0412	23.9775	24.0048	14797440.0
2012-09-05 14:30:00	AAPL	Stock	24.0032	24.0411	23.9911	23.9993	13482532.0
2012-09-05 15:00:00	AAPL	Stock	24.0	24.0112	23.9611	23.9614	16508100.0
2012-09-05 15:30:00	AAPL	Stock	23.9611	23.9904	23.9143	23.9339	37878708.0
2012-09-05 16:00:00	AAPL	Stock	23.9297	24.0536	23.9297	23.9382	18004952.0
2012-09-05 16:30:00	AAPL	Stock	23.9386	24.0743	23.9386	23.9536	240044.0
2012-09-05 17:00:00	AAPL	Stock	23.9568	23.9643	23.9489	23.9589	124852.0
2012-09-05 17:30:00	AAPL	Stock	24.0645	24.0645	23.95	23.9586	110572.0
2012-09-05 18:00:00	AAPL	Stock	23.9586	23.9586	23.9461	23.9461	126336.0
2012-09-05 18:30:00	AAPL	Stock	23.9461	23.9461	23.9329	23.9382	62300.0
2012-09-05 19:00:00	AAPL	Stock	23.9425	23.9425	23.9336	23.935	74256.0
2012-09-05 19:30:00	AAPL	Stock	23.9343	23.9464	23.9314	23.9464	189252.0
2012-09-05 08:00:00	MSFT	Stock	30.36	30.36	30.36	30.36	5000.0
2012-09-05 08:30:00	MSFT	Stock	30.36	30.42	30.36	30.42	11000.0
2012-09-05 09:00:00	MSFT	Stock	30.44	30.468	30.22	30.22	28200.0
2012-09-05 09:30:00	MSFT	Stock	30.21	30.39	30.21	30.35	4100668.0
2012-09-05 10:00:00	MSFT	Stock	30.35	30.53	30.34	30.45	3407959.0
2012-09-05 10:30:00	MSFT	Stock	30.455	30.48	30.3	30.35	2975762.0
2012-09-05 11:00:00	MSFT	Stock	30.345	30.39	30.29	30.389	2520988.0
2012-09-05 11:30:00	MSFT	Stock	30.38	30.4	30.33	30.34	1908522.0
2012-09-05 12:00:00	MSFT	Stock	30.34	30.42	30.3	30.42	1351582.0
2012-09-05 12:30:00	MSFT	Stock	30.41	30.43	30.39	30.41	918847.0
2012-09-05 13:00:00	MSFT	Stock	30.41	30.42	30.37	30.405	1681289.0
2012-09-05 13:30:00	MSFT	Stock	30.409	30.41	30.27	30.28	1890369.0
2012-09-05 14:00:00	MSFT	Stock	30.29	30.33	30.25	30.33	1499585.0
2012-09-05 14:30:00	MSFT	Stock	30.33	30.39	30.32	30.355	1845449.0
2012-09-05 15:00:00	MSFT	Stock	30.355	30.36	30.25	30.29	2996536.0
2012-09-05 15:30:00	MSFT	Stock	30.3	30.39	30.28	30.38	4679946.0
2012-09-05 16:00:00	MSFT	Stock	30.39	30.428	30.356	30.4	1104151.0
2012-09-05 16:30:00	MSFT	Stock	30.305	30.4	30.305	30.36	16284.0

> showing 50 of 76,029 rows — these rows as CSV

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