PREVIEW / stock_30min / 2011-08-16

all stock 30-min files

  file:    by_date/stock_30min/2011/2011-08-16.parquet
  size:    1.4 MB
  rows:    76,487
  symbols: 3,509

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-08-16 04:00:00	AAPL	Stock	13.5539	13.5539	13.5536	13.5536	8400.0
2011-08-16 04:30:00	AAPL	Stock	13.5711	13.5775	13.5711	13.5775	5600.0
2011-08-16 05:00:00	AAPL	Stock	13.5832	13.5832	13.5832	13.5832	2800.0
2011-08-16 06:00:00	AAPL	Stock	13.5714	13.5714	13.5714	13.5714	8400.0
2011-08-16 06:30:00	AAPL	Stock	13.5936	13.5936	13.5714	13.5714	14000.0
2011-08-16 07:00:00	AAPL	Stock	13.5707	13.6071	13.5707	13.5875	281988.0
2011-08-16 07:30:00	AAPL	Stock	13.5882	13.6032	13.5643	13.5804	237244.0
2011-08-16 08:00:00	AAPL	Stock	13.5804	13.5893	13.52	13.5671	1356460.0
2011-08-16 08:30:00	AAPL	Stock	13.5671	13.5961	13.5418	13.585	1990688.0
2011-08-16 09:00:00	AAPL	Stock	13.5832	13.6579	13.5804	13.625	2703316.0
2011-08-16 09:30:00	AAPL	Stock	13.6257	13.6507	13.5729	13.6054	62086864.0
2011-08-16 10:00:00	AAPL	Stock	13.6014	13.6432	13.5764	13.6361	43807344.0
2011-08-16 10:30:00	AAPL	Stock	13.6371	13.6764	13.6264	13.6746	35791616.0
2011-08-16 11:00:00	AAPL	Stock	13.6739	13.6786	13.6286	13.6518	21158984.0
2011-08-16 11:30:00	AAPL	Stock	13.6493	13.6729	13.6296	13.6525	14912100.0
2011-08-16 12:00:00	AAPL	Stock	13.6525	13.6918	13.5786	13.5895	43986712.0
2011-08-16 12:30:00	AAPL	Stock	13.5868	13.6132	13.5246	13.5246	35274484.0
2011-08-16 13:00:00	AAPL	Stock	13.5229	13.5311	13.4307	13.4857	61426764.0
2011-08-16 13:30:00	AAPL	Stock	13.4846	13.5714	13.4646	13.5543	31369548.0
2011-08-16 14:00:00	AAPL	Stock	13.5561	13.5871	13.505	13.5311	28286216.0
2011-08-16 14:30:00	AAPL	Stock	13.5327	13.5389	13.4875	13.5	22324876.0
2011-08-16 15:00:00	AAPL	Stock	13.4989	13.6054	13.4907	13.605	28860664.0
2011-08-16 15:30:00	AAPL	Stock	13.6018	13.6343	13.5679	13.5857	46204452.0
2011-08-16 16:00:00	AAPL	Stock	13.5857	13.5911	13.5425	13.5757	12088636.0
2011-08-16 16:30:00	AAPL	Stock	13.58	13.6006	13.5757	13.5821	2562728.0
2011-08-16 17:00:00	AAPL	Stock	13.5886	13.5886	13.5789	13.5821	219604.0
2011-08-16 17:30:00	AAPL	Stock	13.5886	13.5886	13.5746	13.5746	37772.0
2011-08-16 18:00:00	AAPL	Stock	13.5768	13.5886	13.5554	13.5554	230272.0
2011-08-16 18:30:00	AAPL	Stock	13.5589	13.5696	13.5589	13.5643	22400.0
2011-08-16 19:00:00	AAPL	Stock	13.5643	13.5643	13.5543	13.5543	21532.0
2011-08-16 19:30:00	AAPL	Stock	13.5532	13.5714	13.5357	13.5607	107716.0
2011-08-16 04:00:00	MSFT	Stock	25.11	25.11	25.11	25.11	1000.0
2011-08-16 04:30:00	MSFT	Stock	25.11	25.17	25.11	25.14	4400.0
2011-08-16 05:00:00	MSFT	Stock	25.17	25.17	25.17	25.17	1200.0
2011-08-16 05:30:00	MSFT	Stock	25.13	25.13	25.13	25.13	900.0
2011-08-16 07:00:00	MSFT	Stock	25.08	25.14	25.08	25.1	2300.0
2011-08-16 07:30:00	MSFT	Stock	25.08	25.08	25.08	25.08	32700.0
2011-08-16 08:00:00	MSFT	Stock	25.09	25.13	25.08	25.13	15930.0
2011-08-16 08:30:00	MSFT	Stock	25.12	25.18	25.1	25.12	16721.0
2011-08-16 09:00:00	MSFT	Stock	25.11	25.27	25.11	25.24	30734.0
2011-08-16 09:30:00	MSFT	Stock	25.24	25.47	25.17	25.4	5140313.0
2011-08-16 10:00:00	MSFT	Stock	25.4	25.58	25.38	25.536	5217007.0
2011-08-16 10:30:00	MSFT	Stock	25.53	25.59	25.47	25.56	3486403.0
2011-08-16 11:00:00	MSFT	Stock	25.56	25.56	25.43	25.52	3603745.0
2011-08-16 11:30:00	MSFT	Stock	25.51	25.519	25.41	25.45	2995044.0
2011-08-16 12:00:00	MSFT	Stock	25.45	25.53	25.27	25.301	6651139.0
2011-08-16 12:30:00	MSFT	Stock	25.3	25.37	25.23	25.25	3966542.0
2011-08-16 13:00:00	MSFT	Stock	25.25	25.27	25.05	25.15	3573097.0
2011-08-16 13:30:00	MSFT	Stock	25.155	25.27	25.13	25.2	2122581.0
2011-08-16 14:00:00	MSFT	Stock	25.2	25.299	25.19	25.29	2141071.0

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

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