PREVIEW / stock_30min / 2011-12-08

all stock 30-min files

  file:    by_date/stock_30min/2011/2011-12-08.parquet
  size:    1.4 MB
  rows:    73,756
  symbols: 3,492

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-12-08 04:00:00	AAPL	Stock	13.8786	13.8786	13.8786	13.8786	11200.0
2011-12-08 04:30:00	AAPL	Stock	13.8411	13.8411	13.8411	13.8411	5600.0
2011-12-08 06:30:00	AAPL	Stock	13.8786	13.8786	13.8786	13.8786	14000.0
2011-12-08 07:00:00	AAPL	Stock	13.9054	13.9682	13.9054	13.9643	251020.0
2011-12-08 07:30:00	AAPL	Stock	13.9643	14.0589	13.9571	14.0311	1088164.0
2011-12-08 08:00:00	AAPL	Stock	14.0214	14.0404	14.0096	14.0179	1138116.0
2011-12-08 08:30:00	AAPL	Stock	14.0179	14.0768	14.01	14.0229	3593408.0
2011-12-08 09:00:00	AAPL	Stock	14.0186	14.0229	13.9289	13.9854	2672152.0
2011-12-08 09:30:00	AAPL	Stock	13.9811	14.125	13.9714	14.0916	71969660.0
2011-12-08 10:00:00	AAPL	Stock	14.0889	14.1014	14.01	14.0281	36949612.0
2011-12-08 10:30:00	AAPL	Stock	14.0264	14.1071	14.0221	14.0664	31453408.0
2011-12-08 11:00:00	AAPL	Stock	14.0639	14.0664	14.0207	14.0361	23280992.0
2011-12-08 11:30:00	AAPL	Stock	14.0392	14.0675	14.0186	14.0607	17617348.0
2011-12-08 12:00:00	AAPL	Stock	14.0618	14.0689	14.0286	14.0464	11510632.0
2011-12-08 12:30:00	AAPL	Stock	14.0464	14.0561	14.0214	14.0504	11021248.0
2011-12-08 13:00:00	AAPL	Stock	14.0518	14.06	13.9889	14.0289	23252768.0
2011-12-08 13:30:00	AAPL	Stock	14.0286	14.05	14.0114	14.0464	14217112.0
2011-12-08 14:00:00	AAPL	Stock	14.0459	14.0571	14.0286	14.0339	13722128.0
2011-12-08 14:30:00	AAPL	Stock	14.0339	14.0429	14.0029	14.0118	15576596.0
2011-12-08 15:00:00	AAPL	Stock	14.0111	14.0714	14.005	14.0571	22199828.0
2011-12-08 15:30:00	AAPL	Stock	14.0571	14.0954	13.9368	13.9546	65975140.0
2011-12-08 16:00:00	AAPL	Stock	13.9521	14.0477	13.9468	13.9711	6838692.0
2011-12-08 16:30:00	AAPL	Stock	13.9671	14.0515	13.9036	13.9054	771540.0
2011-12-08 17:00:00	AAPL	Stock	13.9393	13.9393	13.9129	13.9282	101892.0
2011-12-08 17:30:00	AAPL	Stock	13.9232	13.9482	13.9157	13.9454	118524.0
2011-12-08 18:00:00	AAPL	Stock	13.9454	13.9521	13.9407	13.9486	50932.0
2011-12-08 18:30:00	AAPL	Stock	13.9471	13.9471	13.9304	13.9468	125020.0
2011-12-08 19:00:00	AAPL	Stock	13.9379	13.9496	13.9293	13.9314	116284.0
2011-12-08 19:30:00	AAPL	Stock	13.9393	13.9471	13.9286	13.9446	95228.0
2011-12-08 07:00:00	MSFT	Stock	25.65	25.65	25.65	25.65	500.0
2011-12-08 07:30:00	MSFT	Stock	25.66	25.66	25.64	25.64	10600.0
2011-12-08 08:00:00	MSFT	Stock	25.66	25.66	25.58	25.62	6950.0
2011-12-08 08:30:00	MSFT	Stock	25.68	25.78	25.5	25.52	43354.0
2011-12-08 09:00:00	MSFT	Stock	25.5	25.59	25.4	25.53	107025.0
2011-12-08 09:30:00	MSFT	Stock	25.51	25.57	25.395	25.48	4882060.0
2011-12-08 10:00:00	MSFT	Stock	25.48	25.51	25.4	25.481	5387779.0
2011-12-08 10:30:00	MSFT	Stock	25.49	25.72	25.48	25.62	5565024.0
2011-12-08 11:00:00	MSFT	Stock	25.628	25.66	25.55	25.6	3732774.0
2011-12-08 11:30:00	MSFT	Stock	25.605	25.67	25.58	25.64	3240054.0
2011-12-08 12:00:00	MSFT	Stock	25.64	25.67	25.6	25.605	2740537.0
2011-12-08 12:30:00	MSFT	Stock	25.605	25.67	25.59	25.608	2666700.0
2011-12-08 13:00:00	MSFT	Stock	25.6	25.618	25.5	25.57	3074383.0
2011-12-08 13:30:00	MSFT	Stock	25.56	25.59	25.49	25.58	2344161.0
2011-12-08 14:00:00	MSFT	Stock	25.59	25.598	25.515	25.56	2289194.0
2011-12-08 14:30:00	MSFT	Stock	25.56	25.58	25.49	25.54	3155153.0
2011-12-08 15:00:00	MSFT	Stock	25.54	25.565	25.505	25.53	4013434.0
2011-12-08 15:30:00	MSFT	Stock	25.54	25.59	25.37	25.4	13004451.0
2011-12-08 16:00:00	MSFT	Stock	25.4	25.646	25.37	25.4	3063371.0
2011-12-08 16:30:00	MSFT	Stock	25.38	25.54	25.37	25.4	26143.0
2011-12-08 17:00:00	MSFT	Stock	25.35	25.38	25.35	25.35	2050.0

> showing 50 of 73,756 rows — these rows as CSV

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