PREVIEW / stock_30min / 2013-02-05

all stock 30-min files

  file:    by_date/stock_30min/2013/2013-02-05.parquet
  size:    1.4 MB
  rows:    76,468
  symbols: 3,491

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
2013-02-05 04:30:00	AAPL	Stock	15.8357	15.8536	15.8357	15.8536	48720.0
2013-02-05 05:00:00	AAPL	Stock	15.8696	15.8696	15.8304	15.8304	7560.0
2013-02-05 05:30:00	AAPL	Stock	15.8464	15.8743	15.8464	15.8743	24276.0
2013-02-05 06:00:00	AAPL	Stock	15.875	15.875	15.8571	15.8571	56000.0
2013-02-05 06:30:00	AAPL	Stock	15.8571	15.8571	15.8236	15.8304	70140.0
2013-02-05 07:00:00	AAPL	Stock	15.8389	15.9464	15.8389	15.9464	612892.0
2013-02-05 07:30:00	AAPL	Stock	15.925	15.9393	15.8929	15.9025	311472.0
2013-02-05 08:00:00	AAPL	Stock	15.8939	15.9411	15.8489	15.8489	1180060.0
2013-02-05 08:30:00	AAPL	Stock	15.8521	15.9171	15.8411	15.9154	1440600.0
2013-02-05 09:00:00	AAPL	Stock	15.9171	15.9282	15.8579	15.8625	1377152.0
2013-02-05 09:30:00	AAPL	Stock	15.8625	15.9721	15.7936	15.8546	68674872.0
2013-02-05 10:00:00	AAPL	Stock	15.8539	15.9225	15.7989	15.8989	43105300.0
2013-02-05 10:30:00	AAPL	Stock	15.8989	16.0261	15.885	15.9957	47267892.0
2013-02-05 11:00:00	AAPL	Stock	16.0	16.0536	15.9957	16.0349	28252700.0
2013-02-05 11:30:00	AAPL	Stock	16.0354	16.1321	16.025	16.11	40614140.0
2013-02-05 12:00:00	AAPL	Stock	16.1068	16.175	16.0893	16.1443	29604008.0
2013-02-05 12:30:00	AAPL	Stock	16.1436	16.2021	16.1321	16.2	22817704.0
2013-02-05 13:00:00	AAPL	Stock	16.1982	16.2754	16.1939	16.2735	42076496.0
2013-02-05 13:30:00	AAPL	Stock	16.2707	16.3539	16.2646	16.3004	48252036.0
2013-02-05 14:00:00	AAPL	Stock	16.3	16.3879	16.2993	16.36	36747312.0
2013-02-05 14:30:00	AAPL	Stock	16.3586	16.4054	16.3511	16.3764	37945460.0
2013-02-05 15:00:00	AAPL	Stock	16.3764	16.3886	16.3404	16.3786	33294128.0
2013-02-05 15:30:00	AAPL	Stock	16.3775	16.4193	16.3304	16.3507	65371096.0
2013-02-05 16:00:00	AAPL	Stock	16.3507	16.3643	16.0269	16.3554	16656136.0
2013-02-05 16:30:00	AAPL	Stock	16.3571	16.3813	16.3482	16.3525	329224.0
2013-02-05 17:00:00	AAPL	Stock	16.3525	16.3675	16.3507	16.3636	381108.0
2013-02-05 17:30:00	AAPL	Stock	16.3632	16.3679	16.3507	16.3571	368088.0
2013-02-05 18:00:00	AAPL	Stock	16.3564	16.375	16.3507	16.3682	744520.0
2013-02-05 18:30:00	AAPL	Stock	16.3589	16.375	16.3589	16.3625	80500.0
2013-02-05 19:00:00	AAPL	Stock	16.3625	16.3725	16.3614	16.3714	106960.0
2013-02-05 19:30:00	AAPL	Stock	16.3679	16.3893	16.3625	16.3893	189700.0
2013-02-05 07:30:00	MSFT	Stock	27.69	27.7	27.62	27.62	3900.0
2013-02-05 08:00:00	MSFT	Stock	27.56	27.65	27.5	27.62	11950.0
2013-02-05 08:30:00	MSFT	Stock	27.62	27.63	27.58	27.6	2275.0
2013-02-05 09:00:00	MSFT	Stock	27.59	27.62	27.59	27.62	25900.0
2013-02-05 09:30:00	MSFT	Stock	27.62	27.63	27.36	27.58	5039732.0
2013-02-05 10:00:00	MSFT	Stock	27.58	27.66	27.55	27.595	3144398.0
2013-02-05 10:30:00	MSFT	Stock	27.595	27.6	27.49	27.52	2260127.0
2013-02-05 11:00:00	MSFT	Stock	27.52	27.59	27.51	27.55	2244399.0
2013-02-05 11:30:00	MSFT	Stock	27.56	27.63	27.55	27.575	2080677.0
2013-02-05 12:00:00	MSFT	Stock	27.575	27.6	27.55	27.555	1867111.0
2013-02-05 12:30:00	MSFT	Stock	27.55	27.58	27.53	27.565	1597024.0
2013-02-05 13:00:00	MSFT	Stock	27.56	27.6	27.56	27.58	1402306.0
2013-02-05 13:30:00	MSFT	Stock	27.585	27.59	27.555	27.57	1036612.0
2013-02-05 14:00:00	MSFT	Stock	27.56	27.62	27.55	27.59	1829443.0
2013-02-05 14:30:00	MSFT	Stock	27.6	27.61	27.57	27.577	1699924.0
2013-02-05 15:00:00	MSFT	Stock	27.58	27.58	27.5	27.51	2227121.0
2013-02-05 15:30:00	MSFT	Stock	27.51	27.54	27.47	27.49	6176905.0
2013-02-05 16:00:00	MSFT	Stock	27.49	27.58	27.46	27.577	2521231.0
2013-02-05 16:30:00	MSFT	Stock	27.49	27.49	27.47	27.47	1801.0

> showing 50 of 76,468 rows — these rows as CSV

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