PREVIEW / stock_30min / 2011-04-07

all stock 30-min files

  file:    by_date/stock_30min/2011/2011-04-07.parquet
  size:    1.4 MB
  rows:    73,738
  symbols: 3,512

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-04-07 06:00:00	AAPL	Stock	12.0857	12.0857	12.0857	12.0857	11200.0
2011-04-07 06:30:00	AAPL	Stock	12.0929	12.0932	12.0929	12.0932	5600.0
2011-04-07 07:00:00	AAPL	Stock	12.0775	12.0964	12.0771	12.0964	36400.0
2011-04-07 07:30:00	AAPL	Stock	12.0932	12.1171	12.0932	12.1125	353976.0
2011-04-07 08:00:00	AAPL	Stock	12.1111	12.1339	12.1071	12.1107	805448.0
2011-04-07 08:30:00	AAPL	Stock	12.1079	12.1107	12.0879	12.0946	469700.0
2011-04-07 09:00:00	AAPL	Stock	12.0989	12.1193	12.0746	12.0746	770196.0
2011-04-07 09:30:00	AAPL	Stock	12.0743	12.1582	12.0454	12.1511	64816164.0
2011-04-07 10:00:00	AAPL	Stock	12.1504	12.1575	12.1004	12.1036	32511416.0
2011-04-07 10:30:00	AAPL	Stock	12.1046	12.1125	12.0011	12.0568	56558600.0
2011-04-07 11:00:00	AAPL	Stock	12.0582	12.0929	12.0454	12.0789	27246744.0
2011-04-07 11:30:00	AAPL	Stock	12.0811	12.0821	12.0179	12.0557	31756592.0
2011-04-07 12:00:00	AAPL	Stock	12.0566	12.085	12.0411	12.0666	14520212.0
2011-04-07 12:30:00	AAPL	Stock	12.0671	12.1046	12.06	12.1021	16899708.0
2011-04-07 13:00:00	AAPL	Stock	12.1004	12.1025	12.0579	12.0657	13334636.0
2011-04-07 13:30:00	AAPL	Stock	12.0655	12.0679	12.0357	12.0493	12197528.0
2011-04-07 14:00:00	AAPL	Stock	12.05	12.0679	12.0225	12.0244	15984976.0
2011-04-07 14:30:00	AAPL	Stock	12.0238	12.0536	12.0236	12.0461	13438684.0
2011-04-07 15:00:00	AAPL	Stock	12.0457	12.0575	12.025	12.0285	17796716.0
2011-04-07 15:30:00	AAPL	Stock	12.0285	12.0786	12.0214	12.0743	35002436.0
2011-04-07 16:00:00	AAPL	Stock	12.0743	12.0781	12.0571	12.0604	14037212.0
2011-04-07 16:30:00	AAPL	Stock	12.0604	12.0714	12.0524	12.0661	165256.0
2011-04-07 17:00:00	AAPL	Stock	12.0657	12.0661	12.0657	12.0661	31500.0
2011-04-07 17:30:00	AAPL	Stock	12.0696	12.0729	12.0661	12.0718	43652.0
2011-04-07 18:00:00	AAPL	Stock	12.0729	12.0743	12.0718	12.0718	165228.0
2011-04-07 18:30:00	AAPL	Stock	12.0732	12.0732	12.0682	12.0682	18900.0
2011-04-07 19:00:00	AAPL	Stock	12.0711	12.0714	12.0671	12.0714	11200.0
2011-04-07 19:30:00	AAPL	Stock	12.0643	12.0679	12.0571	12.0661	120568.0
2011-04-07 06:30:00	MSFT	Stock	26.3	26.3	26.28	26.29	2000.0
2011-04-07 07:00:00	MSFT	Stock	26.2	26.24	26.16	26.2	6950.0
2011-04-07 07:30:00	MSFT	Stock	26.2	26.2	26.19	26.2	9400.0
2011-04-07 08:00:00	MSFT	Stock	26.2	26.2	26.17	26.2	23449.0
2011-04-07 08:30:00	MSFT	Stock	26.23	26.25	26.21	26.21	20665.0
2011-04-07 09:00:00	MSFT	Stock	26.21	26.24	26.19	26.2	23915.0
2011-04-07 09:30:00	MSFT	Stock	26.19	26.26	26.13	26.22	6162378.0
2011-04-07 10:00:00	MSFT	Stock	26.224	26.25	26.16	26.19	4418115.0
2011-04-07 10:30:00	MSFT	Stock	26.2	26.2	25.97	26.13	6059342.0
2011-04-07 11:00:00	MSFT	Stock	26.13	26.17	26.06	26.12	3514579.0
2011-04-07 11:30:00	MSFT	Stock	26.125	26.127	25.97	26.01	3748812.0
2011-04-07 12:00:00	MSFT	Stock	26.01	26.16	25.99	26.16	2433032.0
2011-04-07 12:30:00	MSFT	Stock	26.16	26.25	26.155	26.2	1861863.0
2011-04-07 13:00:00	MSFT	Stock	26.2	26.21	26.12	26.13	1538108.0
2011-04-07 13:30:00	MSFT	Stock	26.12	26.22	26.11	26.19	3175733.0
2011-04-07 14:00:00	MSFT	Stock	26.19	26.2	26.08	26.08	1369207.0
2011-04-07 14:30:00	MSFT	Stock	26.082	26.2	26.07	26.2	2589115.0
2011-04-07 15:00:00	MSFT	Stock	26.2	26.2	26.13	26.14	1816292.0
2011-04-07 15:30:00	MSFT	Stock	26.15	26.19	26.11	26.19	4340843.0
2011-04-07 16:00:00	MSFT	Stock	26.19	26.22	26.141	26.141	2695357.0
2011-04-07 16:30:00	MSFT	Stock	26.22	26.22	26.16	26.21	3085.0
2011-04-07 17:00:00	MSFT	Stock	26.21	26.21	26.21	26.21	100.0

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

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