PREVIEW / stock_30min / 2010-08-31

all stock 30-min files

  file:    by_date/stock_30min/2010/2010-08-31.parquet
  size:    1.4 MB
  rows:    75,134
  symbols: 3,459

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
2010-08-31 04:30:00	AAPL	Stock	8.6786	8.6786	8.6786	8.6786	2800.0
2010-08-31 06:00:00	AAPL	Stock	8.6725	8.6786	8.6714	8.6714	8400.0
2010-08-31 06:30:00	AAPL	Stock	8.6711	8.6711	8.6607	8.6607	9352.0
2010-08-31 07:00:00	AAPL	Stock	8.6479	8.6568	8.615	8.615	152684.0
2010-08-31 07:30:00	AAPL	Stock	8.6246	8.6493	8.6246	8.6493	21980.0
2010-08-31 08:00:00	AAPL	Stock	8.6396	8.6536	8.6214	8.6357	722848.0
2010-08-31 08:30:00	AAPL	Stock	8.6293	8.6321	8.5893	8.6161	1014664.0
2010-08-31 09:00:00	AAPL	Stock	8.6161	8.6607	8.6161	8.6343	1802808.0
2010-08-31 09:30:00	AAPL	Stock	8.635	8.6936	8.5839	8.6704	62582520.0
2010-08-31 10:00:00	AAPL	Stock	8.6718	8.7343	8.6696	8.6993	52390660.0
2010-08-31 10:30:00	AAPL	Stock	8.6986	8.7107	8.6532	8.675	27480544.0
2010-08-31 11:00:00	AAPL	Stock	8.675	8.6907	8.6443	8.6732	24510360.0
2010-08-31 11:30:00	AAPL	Stock	8.6725	8.6993	8.6689	8.6893	15991696.0
2010-08-31 12:00:00	AAPL	Stock	8.6896	8.7021	8.6868	8.6968	11172896.0
2010-08-31 12:30:00	AAPL	Stock	8.6975	8.7128	8.6768	8.6768	16499028.0
2010-08-31 13:00:00	AAPL	Stock	8.6764	8.7071	8.6668	8.7036	14596652.0
2010-08-31 13:30:00	AAPL	Stock	8.7036	8.7225	8.7036	8.7093	18105024.0
2010-08-31 14:00:00	AAPL	Stock	8.7093	8.7343	8.6796	8.6875	30787792.0
2010-08-31 14:30:00	AAPL	Stock	8.6879	8.6904	8.6354	8.6589	35764568.0
2010-08-31 15:00:00	AAPL	Stock	8.6568	8.6718	8.6379	8.6514	22649340.0
2010-08-31 15:30:00	AAPL	Stock	8.6511	8.7054	8.6496	8.6918	50482684.0
2010-08-31 16:00:00	AAPL	Stock	8.6918	8.705	8.6332	8.6914	20679036.0
2010-08-31 16:30:00	AAPL	Stock	8.7011	8.7132	8.6861	8.7125	1714104.0
2010-08-31 17:00:00	AAPL	Stock	8.6918	8.7214	8.6879	8.7107	1411452.0
2010-08-31 17:30:00	AAPL	Stock	8.7118	8.7214	8.7096	8.7196	229880.0
2010-08-31 18:00:00	AAPL	Stock	8.7196	8.7214	8.7154	8.7207	175196.0
2010-08-31 18:30:00	AAPL	Stock	8.7211	8.7286	8.7207	8.7261	268576.0
2010-08-31 19:00:00	AAPL	Stock	8.725	8.7257	8.7193	8.7257	86576.0
2010-08-31 19:30:00	AAPL	Stock	8.7257	8.7293	8.7243	8.7264	92400.0
2010-08-31 08:00:00	MSFT	Stock	23.63	23.63	23.55	23.56	5400.0
2010-08-31 08:30:00	MSFT	Stock	23.56	23.56	23.56	23.56	1550.0
2010-08-31 09:00:00	MSFT	Stock	23.56	23.67	23.53	23.57	56240.0
2010-08-31 09:30:00	MSFT	Stock	23.59	23.67	23.53	23.59	7602977.0
2010-08-31 10:00:00	MSFT	Stock	23.58	23.69	23.568	23.64	3437022.0
2010-08-31 10:30:00	MSFT	Stock	23.65	23.65	23.54	23.56	4476101.0
2010-08-31 11:00:00	MSFT	Stock	23.555	23.64	23.52	23.62	5096205.0
2010-08-31 11:30:00	MSFT	Stock	23.615	23.73	23.6	23.687	3633066.0
2010-08-31 12:00:00	MSFT	Stock	23.68	23.71	23.6	23.6	1830979.0
2010-08-31 12:30:00	MSFT	Stock	23.6	23.63	23.54	23.56	1667137.0
2010-08-31 13:00:00	MSFT	Stock	23.551	23.62	23.55	23.57	1637961.0
2010-08-31 13:30:00	MSFT	Stock	23.565	23.62	23.55	23.57	1625115.0
2010-08-31 14:00:00	MSFT	Stock	23.57	23.59	23.49	23.51	5171826.0
2010-08-31 14:30:00	MSFT	Stock	23.5	23.51	23.39	23.4	5000629.0
2010-08-31 15:00:00	MSFT	Stock	23.4	23.44	23.32	23.395	4430958.0
2010-08-31 15:30:00	MSFT	Stock	23.39	23.57	23.39	23.48	11628513.0
2010-08-31 16:00:00	MSFT	Stock	23.48	23.744	23.45	23.495	6898966.0
2010-08-31 16:30:00	MSFT	Stock	23.47	23.55	23.47	23.47	680933.0
2010-08-31 17:00:00	MSFT	Stock	23.48	23.55	23.469	23.48	526440.0
2010-08-31 17:30:00	MSFT	Stock	23.54	23.55	23.54	23.55	4300.0
2010-08-31 18:00:00	MSFT	Stock	23.565	23.565	23.54	23.55	2539.0

> showing 50 of 75,134 rows — these rows as CSV

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