PREVIEW / stock_30min / 2011-07-21

all stock 30-min files

  file:    by_date/stock_30min/2011/2011-07-21.parquet
  size:    1.4 MB
  rows:    74,783
  symbols: 3,544

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-07-21 04:00:00	AAPL	Stock	13.8071	13.8071	13.7857	13.7857	30800.0
2011-07-21 04:30:00	AAPL	Stock	13.7746	13.7754	13.7746	13.7754	5600.0
2011-07-21 05:00:00	AAPL	Stock	13.7736	13.7736	13.7	13.7089	44800.0
2011-07-21 05:30:00	AAPL	Stock	13.7143	13.7143	13.6911	13.7143	42420.0
2011-07-21 06:00:00	AAPL	Stock	13.6993	13.7	13.6982	13.7	33320.0
2011-07-21 06:30:00	AAPL	Stock	13.7039	13.7321	13.7014	13.7321	36400.0
2011-07-21 07:00:00	AAPL	Stock	13.7696	13.8136	13.7561	13.8036	179256.0
2011-07-21 07:30:00	AAPL	Stock	13.8054	13.8236	13.7857	13.8236	352520.0
2011-07-21 08:00:00	AAPL	Stock	13.8214	13.8786	13.8179	13.8607	3626168.0
2011-07-21 08:30:00	AAPL	Stock	13.8579	13.8986	13.8489	13.8818	1003548.0
2011-07-21 09:00:00	AAPL	Stock	13.8804	13.8804	13.8196	13.8214	1280468.0
2011-07-21 09:30:00	AAPL	Stock	13.8214	13.8429	13.7107	13.7636	105560224.0
2011-07-21 10:00:00	AAPL	Stock	13.7636	13.9179	13.7507	13.9054	74223016.0
2011-07-21 10:30:00	AAPL	Stock	13.9039	13.9307	13.885	13.9071	45644480.0
2011-07-21 11:00:00	AAPL	Stock	13.9064	13.9125	13.8314	13.8431	30906820.0
2011-07-21 11:30:00	AAPL	Stock	13.8429	13.8643	13.7975	13.8482	34394192.0
2011-07-21 12:00:00	AAPL	Stock	13.8468	13.8571	13.8046	13.8186	19940704.0
2011-07-21 12:30:00	AAPL	Stock	13.8179	13.8929	13.8129	13.8554	37886156.0
2011-07-21 13:00:00	AAPL	Stock	13.8564	13.865	13.825	13.8489	19572084.0
2011-07-21 13:30:00	AAPL	Stock	13.8486	13.8736	13.8218	13.8675	18514664.0
2011-07-21 14:00:00	AAPL	Stock	13.8679	13.87	13.8368	13.8518	15812356.0
2011-07-21 14:30:00	AAPL	Stock	13.8511	13.8568	13.8296	13.8507	17476928.0
2011-07-21 15:00:00	AAPL	Stock	13.8496	13.8804	13.8425	13.8804	24888136.0
2011-07-21 15:30:00	AAPL	Stock	13.8799	13.88	13.8261	13.8314	41331528.0
2011-07-21 16:00:00	AAPL	Stock	13.8332	13.8589	13.8145	13.8364	10910200.0
2011-07-21 16:30:00	AAPL	Stock	13.8375	13.879	13.8375	13.8475	275744.0
2011-07-21 17:00:00	AAPL	Stock	13.8396	13.8732	13.8396	13.8607	286188.0
2011-07-21 17:30:00	AAPL	Stock	13.8611	13.8629	13.8436	13.8436	100884.0
2011-07-21 18:00:00	AAPL	Stock	13.8443	13.85	13.8318	13.85	75880.0
2011-07-21 18:30:00	AAPL	Stock	13.8521	13.8532	13.85	13.85	19600.0
2011-07-21 19:00:00	AAPL	Stock	13.8546	13.8568	13.8511	13.8568	72660.0
2011-07-21 19:30:00	AAPL	Stock	13.8514	13.8786	13.8511	13.8786	361564.0
2011-07-21 07:00:00	MSFT	Stock	27.04	27.04	27.04	27.04	280.0
2011-07-21 07:30:00	MSFT	Stock	26.95	27.03	26.95	27.0	460.0
2011-07-21 08:00:00	MSFT	Stock	27.0	27.11	26.95	27.09	559153.0
2011-07-21 08:30:00	MSFT	Stock	27.09	27.13	27.09	27.12	30338.0
2011-07-21 09:00:00	MSFT	Stock	27.12	27.12	27.03	27.03	33939.0
2011-07-21 09:30:00	MSFT	Stock	27.03	27.125	26.65	26.95	10647716.0
2011-07-21 10:00:00	MSFT	Stock	26.95	27.29	26.9	27.285	5980341.0
2011-07-21 10:30:00	MSFT	Stock	27.285	27.31	27.21	27.24	4420676.0
2011-07-21 11:00:00	MSFT	Stock	27.238	27.24	27.02	27.04	4761784.0
2011-07-21 11:30:00	MSFT	Stock	27.035	27.06	26.935	27.03	4105045.0
2011-07-21 12:00:00	MSFT	Stock	27.02	27.08	27.01	27.075	1911715.0
2011-07-21 12:30:00	MSFT	Stock	27.07	27.25	27.07	27.165	4982860.0
2011-07-21 13:00:00	MSFT	Stock	27.16	27.19	27.07	27.13	3083932.0
2011-07-21 13:30:00	MSFT	Stock	27.125	27.13	27.02	27.09	3176282.0
2011-07-21 14:00:00	MSFT	Stock	27.09	27.12	27.04	27.08	3597876.0
2011-07-21 14:30:00	MSFT	Stock	27.085	27.21	27.07	27.17	4524182.0
2011-07-21 15:00:00	MSFT	Stock	27.17	27.22	27.13	27.14	5462127.0
2011-07-21 15:30:00	MSFT	Stock	27.14	27.17	27.06	27.1	12166373.0

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

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