PREVIEW / stock_30min / 2012-03-29

all stock 30-min files

  file:    by_date/stock_30min/2012/2012-03-29.parquet
  size:    1.4 MB
  rows:    74,733
  symbols: 3,536

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
2012-03-29 04:00:00	AAPL	Stock	22.0714	22.0979	22.0714	22.0857	42000.0
2012-03-29 04:30:00	AAPL	Stock	22.0718	22.0718	22.0718	22.0718	2800.0
2012-03-29 05:00:00	AAPL	Stock	22.0536	22.0536	22.0429	22.0429	51212.0
2012-03-29 05:30:00	AAPL	Stock	22.0446	22.0446	22.0411	22.0411	19600.0
2012-03-29 06:00:00	AAPL	Stock	22.0229	22.0229	22.0004	22.0004	39200.0
2012-03-29 06:30:00	AAPL	Stock	22.0357	22.0357	22.025	22.025	16800.0
2012-03-29 07:00:00	AAPL	Stock	22.0143	22.0304	22.0	22.0139	99680.0
2012-03-29 07:30:00	AAPL	Stock	22.0161	22.0429	22.0161	22.0346	361704.0
2012-03-29 08:00:00	AAPL	Stock	22.0311	22.0536	21.9507	21.9854	2200940.0
2012-03-29 08:30:00	AAPL	Stock	21.9839	21.9918	21.9404	21.9714	1863736.0
2012-03-29 09:00:00	AAPL	Stock	21.9714	21.9732	21.8571	21.885	3303328.0
2012-03-29 09:30:00	AAPL	Stock	21.8893	22.02	21.8304	21.9561	95083688.0
2012-03-29 10:00:00	AAPL	Stock	21.9561	21.985	21.89	21.9268	38263092.0
2012-03-29 10:30:00	AAPL	Stock	21.9296	21.9675	21.9025	21.9582	28089796.0
2012-03-29 11:00:00	AAPL	Stock	21.9582	21.9604	21.7879	21.7893	61301884.0
2012-03-29 11:30:00	AAPL	Stock	21.7879	21.865	21.7364	21.7493	61314036.0
2012-03-29 12:00:00	AAPL	Stock	21.7496	21.7993	21.6868	21.7568	56860104.0
2012-03-29 12:30:00	AAPL	Stock	21.7568	21.8568	21.7029	21.8425	38668616.0
2012-03-29 13:00:00	AAPL	Stock	21.8421	21.8468	21.7579	21.7746	24820544.0
2012-03-29 13:30:00	AAPL	Stock	21.7743	21.8015	21.7304	21.7471	22878520.0
2012-03-29 14:00:00	AAPL	Stock	21.7468	21.8379	21.7411	21.8293	27848072.0
2012-03-29 14:30:00	AAPL	Stock	21.8329	21.8421	21.7829	21.8018	20553344.0
2012-03-29 15:00:00	AAPL	Stock	21.8	21.8714	21.7486	21.8221	42029260.0
2012-03-29 15:30:00	AAPL	Stock	21.8243	21.8729	21.7446	21.7807	54134668.0
2012-03-29 16:00:00	AAPL	Stock	21.7768	21.8269	21.7679	21.8125	19431048.0
2012-03-29 16:30:00	AAPL	Stock	21.7807	21.8196	21.7807	21.8186	468272.0
2012-03-29 17:00:00	AAPL	Stock	21.8179	21.8196	21.6857	21.6879	2335480.0
2012-03-29 17:30:00	AAPL	Stock	21.6832	21.7279	21.6332	21.7279	1600116.0
2012-03-29 18:00:00	AAPL	Stock	21.7268	21.7429	21.7036	21.7089	550536.0
2012-03-29 18:30:00	AAPL	Stock	21.7054	21.7093	21.675	21.675	203532.0
2012-03-29 19:00:00	AAPL	Stock	21.675	21.6782	21.6571	21.6625	648788.0
2012-03-29 19:30:00	AAPL	Stock	21.6675	21.6875	21.6618	21.6721	630616.0
2012-03-29 07:00:00	MSFT	Stock	32.2	32.2	32.2	32.2	1000.0
2012-03-29 08:00:00	MSFT	Stock	32.19	32.19	32.14	32.14	4888.0
2012-03-29 08:30:00	MSFT	Stock	32.11	32.17	32.11	32.12	4540.0
2012-03-29 09:00:00	MSFT	Stock	32.12	32.14	32.0	32.03	9496.0
2012-03-29 09:30:00	MSFT	Stock	32.03	32.19	31.83	31.95	5628612.0
2012-03-29 10:00:00	MSFT	Stock	31.98	32.12	31.95	31.99	2503883.0
2012-03-29 10:30:00	MSFT	Stock	31.99	32.02	31.93	32.012	2078571.0
2012-03-29 11:00:00	MSFT	Stock	32.01	32.04	31.89	31.895	1974641.0
2012-03-29 11:30:00	MSFT	Stock	31.89	31.93	31.83	31.9	2242970.0
2012-03-29 12:00:00	MSFT	Stock	31.9	31.94	31.861	31.884	1073787.0
2012-03-29 12:30:00	MSFT	Stock	31.885	31.91	31.81	31.87	1618012.0
2012-03-29 13:00:00	MSFT	Stock	31.875	31.96	31.855	31.885	1468807.0
2012-03-29 13:30:00	MSFT	Stock	31.89	31.93	31.835	31.86	1627448.0
2012-03-29 14:00:00	MSFT	Stock	31.86	31.94	31.84	31.915	2251611.0
2012-03-29 14:30:00	MSFT	Stock	31.915	32.015	31.9	31.99	2494421.0
2012-03-29 15:00:00	MSFT	Stock	31.99	32.11	31.95	32.04	3309942.0
2012-03-29 15:30:00	MSFT	Stock	32.045	32.19	32.03	32.13	5400274.0
2012-03-29 16:00:00	MSFT	Stock	32.12	32.207	31.943	32.11	2156864.0

> showing 50 of 74,733 rows — these rows as CSV

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