PREVIEW / stock_30min / 2011-03-14

all stock 30-min files

  file:    by_date/stock_30min/2011/2011-03-14.parquet
  size:    1.4 MB
  rows:    74,799
  symbols: 3,516

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
2011-03-14 04:00:00	AAPL	Stock	12.25	12.2679	12.25	12.2679	22400.0
2011-03-14 04:30:00	AAPL	Stock	12.2961	12.3589	12.295	12.3571	72100.0
2011-03-14 05:00:00	AAPL	Stock	12.3482	12.3879	12.3482	12.3879	30800.0
2011-03-14 05:30:00	AAPL	Stock	12.3879	12.4321	12.3786	12.4321	137564.0
2011-03-14 06:00:00	AAPL	Stock	12.4107	12.4821	12.4107	12.4643	58800.0
2011-03-14 06:30:00	AAPL	Stock	12.4629	12.4661	12.4629	12.4643	19600.0
2011-03-14 07:00:00	AAPL	Stock	12.4682	12.5339	12.4682	12.5111	492156.0
2011-03-14 07:30:00	AAPL	Stock	12.5	12.5604	12.4946	12.5071	542640.0
2011-03-14 08:00:00	AAPL	Stock	12.5064	12.6007	12.5036	12.5918	2438800.0
2011-03-14 08:30:00	AAPL	Stock	12.5893	12.6161	12.5714	12.6161	981456.0
2011-03-14 09:00:00	AAPL	Stock	12.6143	12.6589	12.6029	12.6075	3031280.0
2011-03-14 09:30:00	AAPL	Stock	12.6086	12.7143	12.5971	12.7087	77117348.0
2011-03-14 10:00:00	AAPL	Stock	12.7075	12.7316	12.6482	12.6811	50295364.0
2011-03-14 10:30:00	AAPL	Stock	12.6814	12.6818	12.6225	12.6275	36229340.0
2011-03-14 11:00:00	AAPL	Stock	12.6279	12.66	12.5829	12.5936	42009184.0
2011-03-14 11:30:00	AAPL	Stock	12.5936	12.6107	12.5632	12.5868	27648404.0
2011-03-14 12:00:00	AAPL	Stock	12.5886	12.6143	12.5714	12.5804	20707400.0
2011-03-14 12:30:00	AAPL	Stock	12.5804	12.6029	12.5468	12.5996	22857128.0
2011-03-14 13:00:00	AAPL	Stock	12.5982	12.6189	12.5893	12.5929	16777264.0
2011-03-14 13:30:00	AAPL	Stock	12.5939	12.6121	12.575	12.5971	14851200.0
2011-03-14 14:00:00	AAPL	Stock	12.5961	12.6429	12.5914	12.639	21876904.0
2011-03-14 14:30:00	AAPL	Stock	12.6407	12.6414	12.5946	12.6114	16613492.0
2011-03-14 15:00:00	AAPL	Stock	12.6114	12.6461	12.6071	12.6229	18643492.0
2011-03-14 15:30:00	AAPL	Stock	12.6229	12.6564	12.6168	12.6271	41709108.0
2011-03-14 16:00:00	AAPL	Stock	12.6271	12.7244	12.5986	12.6107	10975020.0
2011-03-14 16:30:00	AAPL	Stock	12.6161	12.6517	12.6083	12.6168	1603000.0
2011-03-14 17:00:00	AAPL	Stock	12.6182	12.6211	12.6168	12.6171	93240.0
2011-03-14 17:30:00	AAPL	Stock	12.6186	12.6204	12.6168	12.6175	30800.0
2011-03-14 18:00:00	AAPL	Stock	12.6175	12.63	12.6175	12.63	99428.0
2011-03-14 18:30:00	AAPL	Stock	12.6271	12.6318	12.6271	12.6282	115948.0
2011-03-14 19:00:00	AAPL	Stock	12.6318	12.6321	12.6164	12.6179	172676.0
2011-03-14 19:30:00	AAPL	Stock	12.6164	12.6164	12.5714	12.5889	328216.0
2011-03-14 04:00:00	MSFT	Stock	25.89	25.89	25.36	25.37	1530.0
2011-03-14 05:00:00	MSFT	Stock	25.3	25.3	25.3	25.3	200.0
2011-03-14 05:30:00	MSFT	Stock	25.38	25.38	25.38	25.38	100.0
2011-03-14 06:00:00	MSFT	Stock	25.37	25.37	25.37	25.37	100.0
2011-03-14 06:30:00	MSFT	Stock	25.4	25.41	25.4	25.41	2000.0
2011-03-14 07:00:00	MSFT	Stock	25.42	25.47	25.42	25.46	1800.0
2011-03-14 07:30:00	MSFT	Stock	25.46	25.51	25.44	25.49	6900.0
2011-03-14 08:00:00	MSFT	Stock	25.55	25.6	25.45	25.6	21585.0
2011-03-14 08:30:00	MSFT	Stock	25.54	25.54	25.52	25.54	1818.0
2011-03-14 09:00:00	MSFT	Stock	25.53	25.53	25.45	25.48	4833.0
2011-03-14 09:30:00	MSFT	Stock	25.5	25.52	25.4	25.485	5342256.0
2011-03-14 10:00:00	MSFT	Stock	25.485	25.61	25.41	25.433	3318812.0
2011-03-14 10:30:00	MSFT	Stock	25.439	25.47	25.35	25.4	3901013.0
2011-03-14 11:00:00	MSFT	Stock	25.405	25.47	25.38	25.39	3900648.0
2011-03-14 11:30:00	MSFT	Stock	25.39	25.44	25.36	25.43	2783492.0
2011-03-14 12:00:00	MSFT	Stock	25.435	25.47	25.4	25.415	1810003.0
2011-03-14 12:30:00	MSFT	Stock	25.413	25.42	25.38	25.42	1490991.0
2011-03-14 13:00:00	MSFT	Stock	25.42	25.46	25.38	25.44	2143577.0

> showing 50 of 74,799 rows — these rows as CSV

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