PREVIEW / stock_30min / 2013-08-26

all stock 30-min files

  file:    by_date/stock_30min/2013/2013-08-26.parquet
  size:    1.5 MB
  rows:    78,390
  symbols: 3,527

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-08-26 04:00:00	AAPL	Stock	17.9971	17.9982	17.9864	17.9864	30156.0
2013-08-26 04:30:00	AAPL	Stock	17.9618	17.9618	17.9618	17.9618	5600.0
2013-08-26 05:00:00	AAPL	Stock	17.9643	17.9643	17.9643	17.9643	14000.0
2013-08-26 05:30:00	AAPL	Stock	17.9561	17.9561	17.9561	17.9561	2800.0
2013-08-26 06:00:00	AAPL	Stock	17.9561	17.9561	17.9561	17.9561	2800.0
2013-08-26 06:30:00	AAPL	Stock	17.9411	17.9411	17.9411	17.9411	2800.0
2013-08-26 07:00:00	AAPL	Stock	17.9411	17.9411	17.9361	17.9361	8400.0
2013-08-26 07:30:00	AAPL	Stock	17.9321	17.9321	17.9071	17.9175	275548.0
2013-08-26 08:00:00	AAPL	Stock	17.9429	17.9429	17.8882	17.9125	622328.0
2013-08-26 08:30:00	AAPL	Stock	17.9107	17.9286	17.9018	17.9043	460740.0
2013-08-26 09:00:00	AAPL	Stock	17.9107	17.9182	17.8839	17.885	412328.0
2013-08-26 09:30:00	AAPL	Stock	17.8875	18.067	17.875	18.0279	53362736.0
2013-08-26 10:00:00	AAPL	Stock	18.0279	18.0514	17.9871	18.035	24370528.0
2013-08-26 10:30:00	AAPL	Stock	18.0379	18.0568	18.0193	18.0477	12705952.0
2013-08-26 11:00:00	AAPL	Stock	18.0511	18.1057	18.0304	18.1007	18331908.0
2013-08-26 11:30:00	AAPL	Stock	18.1007	18.1592	18.09	18.1343	24899784.0
2013-08-26 12:00:00	AAPL	Stock	18.1375	18.1864	18.1311	18.1823	16045344.0
2013-08-26 12:30:00	AAPL	Stock	18.1825	18.2214	18.1646	18.1696	22200388.0
2013-08-26 13:00:00	AAPL	Stock	18.1629	18.2179	18.1596	18.1732	12794712.0
2013-08-26 13:30:00	AAPL	Stock	18.1729	18.1757	18.1036	18.1371	15040396.0
2013-08-26 14:00:00	AAPL	Stock	18.1369	18.1625	18.1218	18.1539	8249696.0
2013-08-26 14:30:00	AAPL	Stock	18.1543	18.1571	18.1143	18.1493	8781920.0
2013-08-26 15:00:00	AAPL	Stock	18.15	18.1518	17.9525	18.0189	33197528.0
2013-08-26 15:30:00	AAPL	Stock	18.0175	18.0439	17.9425	17.9618	35346920.0
2013-08-26 16:00:00	AAPL	Stock	17.9632	18.2019	17.8787	17.9632	40353208.0
2013-08-26 16:30:00	AAPL	Stock	17.9639	18.0149	17.9589	17.9643	181664.0
2013-08-26 17:00:00	AAPL	Stock	17.9696	17.9811	17.9643	17.9643	107408.0
2013-08-26 17:30:00	AAPL	Stock	17.9696	17.9714	17.9632	17.9714	166572.0
2013-08-26 18:00:00	AAPL	Stock	17.9732	17.9811	17.9725	17.9732	68180.0
2013-08-26 18:30:00	AAPL	Stock	17.975	17.975	17.9707	17.9718	36540.0
2013-08-26 19:00:00	AAPL	Stock	17.9718	17.9718	17.9643	17.9643	84280.0
2013-08-26 19:30:00	AAPL	Stock	17.9661	17.9675	17.9561	17.9561	110460.0
2013-08-26 04:00:00	MSFT	Stock	34.61	34.61	34.61	34.61	400.0
2013-08-26 05:00:00	MSFT	Stock	34.56	34.56	34.56	34.56	100.0
2013-08-26 05:30:00	MSFT	Stock	34.55	34.56	34.53	34.53	1150.0
2013-08-26 06:00:00	MSFT	Stock	34.51	34.63	34.51	34.63	863.0
2013-08-26 06:30:00	MSFT	Stock	34.64	34.64	34.55	34.56	1286.0
2013-08-26 07:00:00	MSFT	Stock	34.58	34.67	34.56	34.62	6900.0
2013-08-26 07:30:00	MSFT	Stock	34.62	34.75	34.55	34.6	20332.0
2013-08-26 08:00:00	MSFT	Stock	34.6	34.69	34.43	34.53	114617.0
2013-08-26 08:30:00	MSFT	Stock	34.52	34.71	34.5	34.7	66388.0
2013-08-26 09:00:00	MSFT	Stock	34.7	34.7	34.35	34.4	373253.0
2013-08-26 09:30:00	MSFT	Stock	34.41	34.5	34.05	34.22	13202065.0
2013-08-26 10:00:00	MSFT	Stock	34.215	34.29	34.09	34.115	7007628.0
2013-08-26 10:30:00	MSFT	Stock	34.11	34.18	34.03	34.155	6880437.0
2013-08-26 11:00:00	MSFT	Stock	34.15	34.35	34.15	34.22	5600363.0
2013-08-26 11:30:00	MSFT	Stock	34.222	34.41	34.22	34.355	3641398.0
2013-08-26 12:00:00	MSFT	Stock	34.36	34.43	34.33	34.36	3147068.0
2013-08-26 12:30:00	MSFT	Stock	34.36	34.64	34.35	34.64	3552861.0
2013-08-26 13:00:00	MSFT	Stock	34.634	34.65	34.5	34.537	3470347.0

> showing 50 of 78,390 rows — these rows as CSV

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