PREVIEW / stock_30min / 2011-05-03

all stock 30-min files

  file:    by_date/stock_30min/2011/2011-05-03.parquet
  size:    1.5 MB
  rows:    77,648
  symbols: 3,560

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-05-03 04:00:00	AAPL	Stock	12.3493	12.3507	12.3493	12.3507	5600.0
2011-05-03 04:30:00	AAPL	Stock	12.34	12.3571	12.34	12.3571	8400.0
2011-05-03 05:30:00	AAPL	Stock	12.3571	12.3571	12.3571	12.3571	5600.0
2011-05-03 06:00:00	AAPL	Stock	12.3571	12.3571	12.3404	12.3404	11200.0
2011-05-03 06:30:00	AAPL	Stock	12.34	12.34	12.3214	12.3214	27160.0
2011-05-03 07:00:00	AAPL	Stock	12.3214	12.35	12.3214	12.3393	39200.0
2011-05-03 07:30:00	AAPL	Stock	12.3393	12.35	12.3393	12.3411	38332.0
2011-05-03 08:00:00	AAPL	Stock	12.35	12.4104	12.35	12.3964	832244.0
2011-05-03 08:30:00	AAPL	Stock	12.3964	12.4	12.3843	12.3946	556052.0
2011-05-03 09:00:00	AAPL	Stock	12.3929	12.4282	12.3811	12.4282	914452.0
2011-05-03 09:30:00	AAPL	Stock	12.4282	12.4961	12.4021	12.4796	64126328.0
2011-05-03 10:00:00	AAPL	Stock	12.4818	12.4939	12.4343	12.435	28942452.0
2011-05-03 10:30:00	AAPL	Stock	12.4358	12.4446	12.4029	12.4439	23538508.0
2011-05-03 11:00:00	AAPL	Stock	12.4439	12.4711	12.4396	12.4604	17551072.0
2011-05-03 11:30:00	AAPL	Stock	12.4605	12.4768	12.45	12.4564	10668700.0
2011-05-03 12:00:00	AAPL	Stock	12.4564	12.4661	12.4339	12.4357	7681856.0
2011-05-03 12:30:00	AAPL	Stock	12.4356	12.4375	12.4079	12.4104	10674580.0
2011-05-03 13:00:00	AAPL	Stock	12.4104	12.4321	12.3918	12.3936	13406652.0
2011-05-03 13:30:00	AAPL	Stock	12.3939	12.394	12.3436	12.3725	33398764.0
2011-05-03 14:00:00	AAPL	Stock	12.3715	12.4	12.3536	12.3939	18250176.0
2011-05-03 14:30:00	AAPL	Stock	12.3961	12.4	12.3653	12.3857	12669608.0
2011-05-03 15:00:00	AAPL	Stock	12.3861	12.4479	12.3843	12.4382	22694448.0
2011-05-03 15:30:00	AAPL	Stock	12.4393	12.4462	12.4082	12.4286	32680424.0
2011-05-03 16:00:00	AAPL	Stock	12.4271	12.4407	12.4245	12.4382	5806388.0
2011-05-03 16:30:00	AAPL	Stock	12.4343	12.466	12.4169	12.466	637308.0
2011-05-03 17:00:00	AAPL	Stock	12.4286	12.4286	12.4264	12.4268	70476.0
2011-05-03 17:30:00	AAPL	Stock	12.4286	12.4382	12.4268	12.4357	524496.0
2011-05-03 18:00:00	AAPL	Stock	12.4289	12.4357	12.4268	12.4268	105476.0
2011-05-03 18:30:00	AAPL	Stock	12.4261	12.4286	12.4261	12.4286	35000.0
2011-05-03 19:00:00	AAPL	Stock	12.4264	12.4264	12.4225	12.4225	35000.0
2011-05-03 19:30:00	AAPL	Stock	12.4221	12.4318	12.4221	12.4268	41860.0
2011-05-03 07:00:00	MSFT	Stock	25.58	25.58	25.57	25.57	500.0
2011-05-03 07:30:00	MSFT	Stock	25.59	25.63	25.57	25.62	1214.0
2011-05-03 08:00:00	MSFT	Stock	25.62	25.62	25.5	25.56	21721.0
2011-05-03 08:30:00	MSFT	Stock	25.57	25.59	25.55	25.58	10216.0
2011-05-03 09:00:00	MSFT	Stock	25.59	25.6	25.53	25.6	163719.0
2011-05-03 09:30:00	MSFT	Stock	25.6	25.66	25.52	25.61	8213275.0
2011-05-03 10:00:00	MSFT	Stock	25.61	25.62	25.55	25.56	5951016.0
2011-05-03 10:30:00	MSFT	Stock	25.555	25.62	25.54	25.57	4135015.0
2011-05-03 11:00:00	MSFT	Stock	25.58	25.6	25.55	25.56	4821666.0
2011-05-03 11:30:00	MSFT	Stock	25.56	25.61	25.56	25.575	2832540.0
2011-05-03 12:00:00	MSFT	Stock	25.58	25.59	25.54	25.57	1860354.0
2011-05-03 12:30:00	MSFT	Stock	25.567	25.57	25.51	25.524	3527202.0
2011-05-03 13:00:00	MSFT	Stock	25.52	25.57	25.5	25.505	4167068.0
2011-05-03 13:30:00	MSFT	Stock	25.5	25.58	25.49	25.56	4497904.0
2011-05-03 14:00:00	MSFT	Stock	25.559	25.63	25.55	25.611	5746757.0
2011-05-03 14:30:00	MSFT	Stock	25.62	25.79	25.61	25.76	7868868.0
2011-05-03 15:00:00	MSFT	Stock	25.77	25.85	25.76	25.82	5859927.0
2011-05-03 15:30:00	MSFT	Stock	25.82	25.85	25.78	25.82	9472223.0
2011-05-03 16:00:00	MSFT	Stock	25.82	25.85	25.633	25.84	1533390.0

> showing 50 of 77,648 rows — these rows as CSV

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