PREVIEW / stock_30min / 2011-05-20

all stock 30-min files

  file:    by_date/stock_30min/2011/2011-05-20.parquet
  size:    1.4 MB
  rows:    73,405
  symbols: 3,534

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-05-20 04:30:00	AAPL	Stock	12.1664	12.1664	12.1664	12.1664	2800.0
2011-05-20 05:00:00	AAPL	Stock	12.1643	12.1643	12.1429	12.1429	14000.0
2011-05-20 07:00:00	AAPL	Stock	12.1429	12.165	12.1429	12.1429	66920.0
2011-05-20 07:30:00	AAPL	Stock	12.1432	12.1432	12.1346	12.1346	8400.0
2011-05-20 08:00:00	AAPL	Stock	12.1375	12.1618	12.1286	12.1393	278880.0
2011-05-20 08:30:00	AAPL	Stock	12.1393	12.1429	12.1357	12.1429	30436.0
2011-05-20 09:00:00	AAPL	Stock	12.1432	12.1432	12.1189	12.1332	1149680.0
2011-05-20 09:30:00	AAPL	Stock	12.1271	12.1768	12.0986	12.1114	44193688.0
2011-05-20 10:00:00	AAPL	Stock	12.1114	12.1286	12.0986	12.1193	26709536.0
2011-05-20 10:30:00	AAPL	Stock	12.1179	12.125	12.0368	12.0618	36449140.0
2011-05-20 11:00:00	AAPL	Stock	12.0618	12.0779	12.0536	12.0682	15378020.0
2011-05-20 11:30:00	AAPL	Stock	12.0679	12.0907	12.0629	12.0643	15817004.0
2011-05-20 12:00:00	AAPL	Stock	12.0643	12.0836	12.0507	12.0836	17786020.0
2011-05-20 12:30:00	AAPL	Stock	12.0836	12.1029	12.0732	12.0764	17037608.0
2011-05-20 13:00:00	AAPL	Stock	12.075	12.1029	12.075	12.0868	11968432.0
2011-05-20 13:30:00	AAPL	Stock	12.0875	12.1061	12.0757	12.0876	14791588.0
2011-05-20 14:00:00	AAPL	Stock	12.0879	12.09	12.0489	12.0657	13331556.0
2011-05-20 14:30:00	AAPL	Stock	12.0654	12.0725	12.0071	12.0075	17243352.0
2011-05-20 15:00:00	AAPL	Stock	12.0071	12.0296	11.9971	12.0239	31689140.0
2011-05-20 15:30:00	AAPL	Stock	12.0223	12.0282	11.965	11.9696	56296688.0
2011-05-20 16:00:00	AAPL	Stock	11.9725	12.0655	11.9625	11.9729	8591576.0
2011-05-20 16:30:00	AAPL	Stock	11.9657	12.0168	11.9607	11.9639	955976.0
2011-05-20 17:00:00	AAPL	Stock	11.9643	11.9654	11.9607	11.9643	187740.0
2011-05-20 17:30:00	AAPL	Stock	11.9625	11.9679	11.96	11.9679	57736.0
2011-05-20 18:00:00	AAPL	Stock	11.9646	12.0	11.9646	11.9714	147868.0
2011-05-20 18:30:00	AAPL	Stock	11.9721	11.9721	11.965	11.965	8400.0
2011-05-20 19:00:00	AAPL	Stock	11.9643	11.9679	11.9607	11.9643	21588.0
2011-05-20 19:30:00	AAPL	Stock	11.9704	11.9704	11.9625	11.9625	46620.0
2011-05-20 07:30:00	MSFT	Stock	24.7	24.7	24.65	24.65	200.0
2011-05-20 08:00:00	MSFT	Stock	24.61	24.61	24.61	24.61	300.0
2011-05-20 08:30:00	MSFT	Stock	24.67	24.7	24.67	24.7	1100.0
2011-05-20 09:00:00	MSFT	Stock	24.7	24.71	24.67	24.7	9482.0
2011-05-20 09:30:00	MSFT	Stock	24.7	24.87	24.66	24.765	6375564.0
2011-05-20 10:00:00	MSFT	Stock	24.765	24.77	24.62	24.69	4527246.0
2011-05-20 10:30:00	MSFT	Stock	24.69	24.72	24.63	24.67	3235795.0
2011-05-20 11:00:00	MSFT	Stock	24.67	24.69	24.62	24.62	1844474.0
2011-05-20 11:30:00	MSFT	Stock	24.62	24.67	24.53	24.54	2867988.0
2011-05-20 12:00:00	MSFT	Stock	24.54	24.65	24.52	24.645	2501875.0
2011-05-20 12:30:00	MSFT	Stock	24.65	24.698	24.61	24.61	2373996.0
2011-05-20 13:00:00	MSFT	Stock	24.615	24.74	24.61	24.68	1934487.0
2011-05-20 13:30:00	MSFT	Stock	24.68	24.74	24.68	24.698	2136929.0
2011-05-20 14:00:00	MSFT	Stock	24.7	24.71	24.63	24.655	1399042.0
2011-05-20 14:30:00	MSFT	Stock	24.655	24.7	24.62	24.63	1443097.0
2011-05-20 15:00:00	MSFT	Stock	24.63	24.64	24.51	24.51	3801445.0
2011-05-20 15:30:00	MSFT	Stock	24.51	24.56	24.44	24.49	8343544.0
2011-05-20 16:00:00	MSFT	Stock	24.5	24.635	24.4	24.45	1839656.0
2011-05-20 16:30:00	MSFT	Stock	24.45	24.548	24.42	24.45	9670.0
2011-05-20 17:00:00	MSFT	Stock	24.45	24.45	24.44	24.44	3911.0
2011-05-20 17:30:00	MSFT	Stock	24.42	24.45	24.42	24.44	3492.0
2011-05-20 18:00:00	MSFT	Stock	24.43	24.49	24.43	24.45	8350.0

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

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