PREVIEW / stock_30min / 2012-08-22

all stock 30-min files

  file:    by_date/stock_30min/2012/2012-08-22.parquet
  size:    1.4 MB
  rows:    72,495
  symbols: 3,460

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-08-22 04:00:00	AAPL	Stock	23.4286	23.4393	23.4286	23.4393	25200.0
2012-08-22 04:30:00	AAPL	Stock	23.5	23.5	23.5	23.5	8400.0
2012-08-22 05:00:00	AAPL	Stock	23.5	23.5	23.475	23.4875	47684.0
2012-08-22 06:00:00	AAPL	Stock	23.4696	23.4839	23.4679	23.4679	28000.0
2012-08-22 06:30:00	AAPL	Stock	23.4554	23.4554	23.4286	23.4286	23800.0
2012-08-22 07:00:00	AAPL	Stock	23.4143	23.4282	23.3611	23.3807	229096.0
2012-08-22 07:30:00	AAPL	Stock	23.3643	23.4464	23.3643	23.4136	398860.0
2012-08-22 08:00:00	AAPL	Stock	23.4057	23.5436	23.3918	23.5357	1733676.0
2012-08-22 08:30:00	AAPL	Stock	23.5357	23.5479	23.4821	23.5179	925400.0
2012-08-22 09:00:00	AAPL	Stock	23.5179	23.5179	23.3625	23.3754	2649472.0
2012-08-22 09:30:00	AAPL	Stock	23.375	23.3996	23.1468	23.3918	106936144.0
2012-08-22 10:00:00	AAPL	Stock	23.3918	23.5418	23.3571	23.5382	64615432.0
2012-08-22 10:30:00	AAPL	Stock	23.5389	23.5957	23.5043	23.5236	51433872.0
2012-08-22 11:00:00	AAPL	Stock	23.5221	23.625	23.515	23.5946	34364848.0
2012-08-22 11:30:00	AAPL	Stock	23.5936	23.6768	23.5571	23.6751	28189392.0
2012-08-22 12:00:00	AAPL	Stock	23.6764	23.7029	23.6029	23.6518	27552028.0
2012-08-22 12:30:00	AAPL	Stock	23.65	23.6554	23.5304	23.5346	23698612.0
2012-08-22 13:00:00	AAPL	Stock	23.5346	23.6529	23.5175	23.6243	18989460.0
2012-08-22 13:30:00	AAPL	Stock	23.6232	23.6661	23.5768	23.5804	16811620.0
2012-08-22 14:00:00	AAPL	Stock	23.5804	23.7104	23.5804	23.6893	31331300.0
2012-08-22 14:30:00	AAPL	Stock	23.6892	23.8093	23.6718	23.8079	38520916.0
2012-08-22 15:00:00	AAPL	Stock	23.8079	23.8929	23.7657	23.8568	53602080.0
2012-08-22 15:30:00	AAPL	Stock	23.8536	23.8929	23.8275	23.8886	46830476.0
2012-08-22 16:00:00	AAPL	Stock	23.8914	23.9089	23.2762	23.9089	8039752.0
2012-08-22 16:30:00	AAPL	Stock	23.9071	23.9175	23.867	23.9143	422212.0
2012-08-22 17:00:00	AAPL	Stock	23.9107	23.9107	23.8882	23.9054	287700.0
2012-08-22 17:30:00	AAPL	Stock	23.9054	23.9107	23.9021	23.9021	243236.0
2012-08-22 18:00:00	AAPL	Stock	23.9	23.9064	23.8839	23.8839	273644.0
2012-08-22 18:30:00	AAPL	Stock	23.8839	23.8889	23.8125	23.8125	635768.0
2012-08-22 19:00:00	AAPL	Stock	23.8036	23.875	23.7861	23.8714	292936.0
2012-08-22 19:30:00	AAPL	Stock	23.8711	23.8929	23.8571	23.89	270256.0
2012-08-22 08:00:00	MSFT	Stock	30.69	30.73	30.64	30.64	79035.0
2012-08-22 08:30:00	MSFT	Stock	30.68	30.68	30.65	30.65	2486.0
2012-08-22 09:00:00	MSFT	Stock	30.64	30.64	30.4	30.59	63354.0
2012-08-22 09:30:00	MSFT	Stock	30.59	30.74	30.53	30.67	3174037.0
2012-08-22 10:00:00	MSFT	Stock	30.67	30.76	30.61	30.65	2223003.0
2012-08-22 10:30:00	MSFT	Stock	30.665	30.68	30.6	30.655	3043722.0
2012-08-22 11:00:00	MSFT	Stock	30.655	30.69	30.57	30.61	2223839.0
2012-08-22 11:30:00	MSFT	Stock	30.6	30.62	30.575	30.59	1975188.0
2012-08-22 12:00:00	MSFT	Stock	30.6	30.61	30.54	30.58	1607022.0
2012-08-22 12:30:00	MSFT	Stock	30.572	30.58	30.5	30.53	1807200.0
2012-08-22 13:00:00	MSFT	Stock	30.53	30.56	30.49	30.555	1315682.0
2012-08-22 13:30:00	MSFT	Stock	30.54	30.55	30.465	30.53	2177506.0
2012-08-22 14:00:00	MSFT	Stock	30.53	30.63	30.47	30.56	3731383.0
2012-08-22 14:30:00	MSFT	Stock	30.555	30.65	30.53	30.64	1788863.0
2012-08-22 15:00:00	MSFT	Stock	30.635	30.69	30.55	30.57	1725618.0
2012-08-22 15:30:00	MSFT	Stock	30.57	30.61	30.53	30.54	3794287.0
2012-08-22 16:00:00	MSFT	Stock	30.57	30.619	30.54	30.57	2081335.0
2012-08-22 16:30:00	MSFT	Stock	30.57	30.57	30.57	30.57	14555.0
2012-08-22 17:00:00	MSFT	Stock	30.57	30.57	30.56	30.56	11691.0

> showing 50 of 72,495 rows — these rows as CSV

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