PREVIEW / stock_30min / 2013-01-08

all stock 30-min files

  file:    by_date/stock_30min/2013/2013-01-08.parquet
  size:    1.4 MB
  rows:    77,340
  symbols: 3,448

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-01-08 04:30:00	AAPL	Stock	18.6743	18.6743	18.6743	18.6743	2800.0
2013-01-08 05:00:00	AAPL	Stock	18.6864	18.6864	18.6864	18.6864	2800.0
2013-01-08 05:30:00	AAPL	Stock	18.6911	18.7143	18.6911	18.7143	45668.0
2013-01-08 06:00:00	AAPL	Stock	18.7325	18.7493	18.7325	18.7493	29400.0
2013-01-08 06:30:00	AAPL	Stock	18.7514	18.8214	18.7514	18.7929	51436.0
2013-01-08 07:00:00	AAPL	Stock	18.7846	18.8107	18.7143	18.75	441560.0
2013-01-08 07:30:00	AAPL	Stock	18.7386	18.77	18.7386	18.7543	213668.0
2013-01-08 08:00:00	AAPL	Stock	18.7539	18.8025	18.725	18.775	312032.0
2013-01-08 08:30:00	AAPL	Stock	18.7679	18.9911	18.7679	18.9054	5918640.0
2013-01-08 09:00:00	AAPL	Stock	18.9054	18.9054	18.835	18.9014	2549176.0
2013-01-08 09:30:00	AAPL	Stock	18.9	18.9961	18.7657	18.7905	83308372.0
2013-01-08 10:00:00	AAPL	Stock	18.7864	18.8525	18.7282	18.7961	44554328.0
2013-01-08 10:30:00	AAPL	Stock	18.7957	18.8039	18.6721	18.7114	36290436.0
2013-01-08 11:00:00	AAPL	Stock	18.7114	18.7586	18.6161	18.6482	38532396.0
2013-01-08 11:30:00	AAPL	Stock	18.6446	18.7003	18.6214	18.6849	23341108.0
2013-01-08 12:00:00	AAPL	Stock	18.685	18.7375	18.6654	18.6718	20069280.0
2013-01-08 12:30:00	AAPL	Stock	18.6679	18.6946	18.625	18.6607	17088932.0
2013-01-08 13:00:00	AAPL	Stock	18.6607	18.7282	18.6604	18.7024	13689704.0
2013-01-08 13:30:00	AAPL	Stock	18.6975	18.8068	18.6968	18.8025	25232816.0
2013-01-08 14:00:00	AAPL	Stock	18.8055	18.8371	18.7593	18.7686	24216528.0
2013-01-08 14:30:00	AAPL	Stock	18.7714	18.8036	18.715	18.74	21217140.0
2013-01-08 15:00:00	AAPL	Stock	18.7391	18.8643	18.7368	18.8388	31227616.0
2013-01-08 15:30:00	AAPL	Stock	18.8382	18.8496	18.7368	18.7568	41346872.0
2013-01-08 16:00:00	AAPL	Stock	18.7575	18.7716	18.7321	18.7321	11541880.0
2013-01-08 16:30:00	AAPL	Stock	18.7459	18.8406	18.7318	18.7464	314216.0
2013-01-08 17:00:00	AAPL	Stock	18.7461	18.7611	18.7396	18.7446	223440.0
2013-01-08 17:30:00	AAPL	Stock	18.7536	18.7557	18.7446	18.7446	103796.0
2013-01-08 18:00:00	AAPL	Stock	18.7464	18.7654	18.7464	18.7607	173488.0
2013-01-08 18:30:00	AAPL	Stock	18.7654	18.7654	18.7579	18.7629	35028.0
2013-01-08 19:00:00	AAPL	Stock	18.7639	18.7993	18.7639	18.7993	254520.0
2013-01-08 19:30:00	AAPL	Stock	18.7954	18.7957	18.7814	18.7925	302176.0
2013-01-08 06:00:00	MSFT	Stock	26.71	26.71	26.71	26.71	400.0
2013-01-08 07:30:00	MSFT	Stock	26.74	26.75	26.74	26.74	5360.0
2013-01-08 08:00:00	MSFT	Stock	26.74	26.76	26.74	26.76	9100.0
2013-01-08 08:30:00	MSFT	Stock	26.76	26.79	26.72	26.77	13963.0
2013-01-08 09:00:00	MSFT	Stock	26.75	26.8	26.74	26.75	76764.0
2013-01-08 09:30:00	MSFT	Stock	26.75	26.79	26.52	26.52	5324241.0
2013-01-08 10:00:00	MSFT	Stock	26.52	26.6	26.5	26.56	3673771.0
2013-01-08 10:30:00	MSFT	Stock	26.565	26.58	26.505	26.517	2673124.0
2013-01-08 11:00:00	MSFT	Stock	26.511	26.52	26.48	26.51	3216796.0
2013-01-08 11:30:00	MSFT	Stock	26.505	26.58	26.5	26.52	2479729.0
2013-01-08 12:00:00	MSFT	Stock	26.525	26.53	26.48	26.485	1659838.0
2013-01-08 12:30:00	MSFT	Stock	26.49	26.51	26.46	26.485	1726252.0
2013-01-08 13:00:00	MSFT	Stock	26.485	26.56	26.48	26.53	2250381.0
2013-01-08 13:30:00	MSFT	Stock	26.535	26.59	26.51	26.52	2339971.0
2013-01-08 14:00:00	MSFT	Stock	26.52	26.59	26.51	26.58	1588677.0
2013-01-08 14:30:00	MSFT	Stock	26.575	26.61	26.53	26.55	1747634.0
2013-01-08 15:00:00	MSFT	Stock	26.547	26.63	26.53	26.6	3383901.0
2013-01-08 15:30:00	MSFT	Stock	26.6	26.61	26.51	26.54	7811081.0
2013-01-08 16:00:00	MSFT	Stock	26.55	26.65	26.54	26.62	1791694.0

> showing 50 of 77,340 rows — these rows as CSV

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