PREVIEW / stock_30min / 2011-01-24

all stock 30-min files

  file:    by_date/stock_30min/2011/2011-01-24.parquet
  size:    1.4 MB
  rows:    76,798
  symbols: 3,538

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-01-24 04:00:00	AAPL	Stock	11.7218	11.7229	11.7218	11.7229	5600.0
2011-01-24 04:30:00	AAPL	Stock	11.7136	11.7136	11.7136	11.7136	5600.0
2011-01-24 05:30:00	AAPL	Stock	11.7214	11.7214	11.6786	11.6786	30744.0
2011-01-24 06:00:00	AAPL	Stock	11.7179	11.7393	11.7179	11.725	53200.0
2011-01-24 06:30:00	AAPL	Stock	11.725	11.725	11.725	11.725	5600.0
2011-01-24 07:00:00	AAPL	Stock	11.7321	11.7325	11.7	11.7	389620.0
2011-01-24 07:30:00	AAPL	Stock	11.7	11.7171	11.6964	11.7157	209020.0
2011-01-24 08:00:00	AAPL	Stock	11.7143	11.7161	11.6782	11.7007	1258684.0
2011-01-24 08:30:00	AAPL	Stock	11.7029	11.7104	11.6996	11.7036	1050308.0
2011-01-24 09:00:00	AAPL	Stock	11.7036	11.7089	11.6725	11.6739	1737820.0
2011-01-24 09:30:00	AAPL	Stock	11.6729	11.8529	11.6686	11.7936	115791928.0
2011-01-24 10:00:00	AAPL	Stock	11.7954	11.8386	11.7625	11.8211	51686068.0
2011-01-24 10:30:00	AAPL	Stock	11.82	11.8643	11.8154	11.8529	39564700.0
2011-01-24 11:00:00	AAPL	Stock	11.8532	11.9354	11.8443	11.9275	51955456.0
2011-01-24 11:30:00	AAPL	Stock	11.9277	11.9396	11.9039	11.9279	34800948.0
2011-01-24 12:00:00	AAPL	Stock	11.9271	11.9739	11.9236	11.9511	36251880.0
2011-01-24 12:30:00	AAPL	Stock	11.9514	11.9718	11.9468	11.9643	17545304.0
2011-01-24 13:00:00	AAPL	Stock	11.9643	11.9868	11.9382	11.9804	22747284.0
2011-01-24 13:30:00	AAPL	Stock	11.9796	11.9943	11.9679	11.975	22436652.0
2011-01-24 14:00:00	AAPL	Stock	11.9757	11.9925	11.9693	11.9875	19156844.0
2011-01-24 14:30:00	AAPL	Stock	11.9882	12.0389	11.9868	12.0089	42477568.0
2011-01-24 15:00:00	AAPL	Stock	12.0082	12.0171	11.975	11.984	31593156.0
2011-01-24 15:30:00	AAPL	Stock	11.985	12.0507	11.9843	12.0493	53654132.0
2011-01-24 16:00:00	AAPL	Stock	12.0518	12.0679	11.6683	12.0518	15668940.0
2011-01-24 16:30:00	AAPL	Stock	12.0696	12.0714	11.6901	12.0411	905996.0
2011-01-24 17:00:00	AAPL	Stock	11.9322	12.0518	11.9322	12.0429	449008.0
2011-01-24 17:30:00	AAPL	Stock	12.0429	12.0518	12.0393	12.0393	909132.0
2011-01-24 18:00:00	AAPL	Stock	12.0393	12.0518	12.0393	12.0446	222152.0
2011-01-24 18:30:00	AAPL	Stock	12.0446	12.0475	12.0421	12.0421	66388.0
2011-01-24 19:00:00	AAPL	Stock	12.0429	12.0446	12.0421	12.0446	63812.0
2011-01-24 19:30:00	AAPL	Stock	12.0421	12.0668	12.0421	12.0661	382452.0
2011-01-24 07:30:00	MSFT	Stock	28.11	28.12	28.11	28.12	200.0
2011-01-24 08:00:00	MSFT	Stock	28.05	28.15	28.04	28.14	32685.0
2011-01-24 08:30:00	MSFT	Stock	28.15	28.15	28.09	28.09	15863.0
2011-01-24 09:00:00	MSFT	Stock	28.09	28.15	28.0	28.0	117597.0
2011-01-24 09:30:00	MSFT	Stock	28.02	28.185	27.99	28.17	5146765.0
2011-01-24 10:00:00	MSFT	Stock	28.175	28.35	28.12	28.31	4333514.0
2011-01-24 10:30:00	MSFT	Stock	28.31	28.33	28.26	28.31	2592811.0
2011-01-24 11:00:00	MSFT	Stock	28.305	28.5	28.3	28.46	6606981.0
2011-01-24 11:30:00	MSFT	Stock	28.47	28.49	28.38	28.45	3221933.0
2011-01-24 12:00:00	MSFT	Stock	28.45	28.5	28.44	28.5	2654818.0
2011-01-24 12:30:00	MSFT	Stock	28.5	28.53	28.48	28.49	2397670.0
2011-01-24 13:00:00	MSFT	Stock	28.495	28.55	28.48	28.5	2184350.0
2011-01-24 13:30:00	MSFT	Stock	28.5	28.54	28.45	28.476	2607007.0
2011-01-24 14:00:00	MSFT	Stock	28.48	28.54	28.46	28.501	1633519.0
2011-01-24 14:30:00	MSFT	Stock	28.505	28.55	28.5	28.51	2003916.0
2011-01-24 15:00:00	MSFT	Stock	28.51	28.56	28.47	28.48	3039853.0
2011-01-24 15:30:00	MSFT	Stock	28.47	28.48	28.32	28.38	8399898.0
2011-01-24 16:00:00	MSFT	Stock	28.37	28.388	28.3	28.38	2080825.0
2011-01-24 16:30:00	MSFT	Stock	28.35	28.469	28.35	28.37	53059.0

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

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