PREVIEW / stock_30min / 2012-02-16

all stock 30-min files

  file:    by_date/stock_30min/2012/2012-02-16.parquet
  size:    1.4 MB
  rows:    76,313
  symbols: 3,526

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-02-16 04:00:00	AAPL	Stock	17.6079	17.665	17.6079	17.665	36400.0
2012-02-16 04:30:00	AAPL	Stock	17.6961	17.7071	17.6786	17.7071	38640.0
2012-02-16 05:00:00	AAPL	Stock	17.6843	17.7232	17.6786	17.7214	40152.0
2012-02-16 05:30:00	AAPL	Stock	17.7061	17.7061	17.7	17.7061	14000.0
2012-02-16 06:00:00	AAPL	Stock	17.7264	17.7314	17.7132	17.7314	30800.0
2012-02-16 06:30:00	AAPL	Stock	17.7314	17.7314	17.7146	17.7146	16800.0
2012-02-16 07:00:00	AAPL	Stock	17.7121	17.7121	17.6157	17.6714	659400.0
2012-02-16 07:30:00	AAPL	Stock	17.6471	17.6707	17.6257	17.6457	802900.0
2012-02-16 08:00:00	AAPL	Stock	17.6361	17.7061	17.5861	17.7054	3585148.0
2012-02-16 08:30:00	AAPL	Stock	17.7061	17.7857	17.6664	17.685	7157892.0
2012-02-16 09:00:00	AAPL	Stock	17.6786	17.715	17.5521	17.5536	9027676.0
2012-02-16 09:30:00	AAPL	Stock	17.5539	17.6196	17.3796	17.525	191164596.0
2012-02-16 10:00:00	AAPL	Stock	17.52	17.6693	17.5039	17.64	92368360.0
2012-02-16 10:30:00	AAPL	Stock	17.6393	17.6518	17.5215	17.5365	53459952.0
2012-02-16 11:00:00	AAPL	Stock	17.5393	17.5589	17.5011	17.5396	40374488.0
2012-02-16 11:30:00	AAPL	Stock	17.5421	17.5932	17.4643	17.5671	61015724.0
2012-02-16 12:00:00	AAPL	Stock	17.5679	17.7329	17.5575	17.6635	67531632.0
2012-02-16 12:30:00	AAPL	Stock	17.6561	17.7482	17.635	17.7068	48753712.0
2012-02-16 13:00:00	AAPL	Stock	17.7043	17.9179	17.6964	17.8839	89765872.0
2012-02-16 13:30:00	AAPL	Stock	17.8839	18.0318	17.8814	18.01	73152884.0
2012-02-16 14:00:00	AAPL	Stock	18.0096	18.0257	17.8761	17.9611	55709892.0
2012-02-16 14:30:00	AAPL	Stock	17.9587	17.9689	17.8868	17.9205	27415444.0
2012-02-16 15:00:00	AAPL	Stock	17.9232	18.0	17.9196	17.9709	39192300.0
2012-02-16 15:30:00	AAPL	Stock	17.9696	17.9832	17.9039	17.9464	52045672.0
2012-02-16 16:00:00	AAPL	Stock	17.9482	17.9607	17.5099	17.9607	11699156.0
2012-02-16 16:30:00	AAPL	Stock	17.9593	17.9676	17.7143	17.7143	8709148.0
2012-02-16 17:00:00	AAPL	Stock	17.9332	17.9457	17.9286	17.9375	138404.0
2012-02-16 17:30:00	AAPL	Stock	17.9336	17.9482	17.9321	17.9482	228648.0
2012-02-16 18:00:00	AAPL	Stock	17.955	17.9814	17.9536	17.9571	487844.0
2012-02-16 18:30:00	AAPL	Stock	17.9518	17.9732	17.9511	17.9732	134400.0
2012-02-16 19:00:00	AAPL	Stock	17.9732	17.9896	17.9689	17.9896	251692.0
2012-02-16 19:30:00	AAPL	Stock	17.9925	18.0107	17.9893	18.0	224700.0
2012-02-16 07:00:00	MSFT	Stock	30.01	30.08	30.01	30.08	7000.0
2012-02-16 07:30:00	MSFT	Stock	30.0	30.0	29.99	30.0	12000.0
2012-02-16 08:00:00	MSFT	Stock	30.04	30.08	30.0	30.05	24893.0
2012-02-16 08:30:00	MSFT	Stock	30.06	30.2	30.06	30.16	34600.0
2012-02-16 09:00:00	MSFT	Stock	30.17	30.31	30.17	30.31	80691.0
2012-02-16 09:30:00	MSFT	Stock	30.31	30.71	30.3	30.665	7198744.0
2012-02-16 10:00:00	MSFT	Stock	30.67	30.74	30.61	30.68	5321911.0
2012-02-16 10:30:00	MSFT	Stock	30.67	30.71	30.57	30.595	3021661.0
2012-02-16 11:00:00	MSFT	Stock	30.595	30.71	30.59	30.71	2572507.0
2012-02-16 11:30:00	MSFT	Stock	30.701	30.95	30.66	30.945	5354111.0
2012-02-16 12:00:00	MSFT	Stock	30.94	31.05	30.88	31.02	6504525.0
2012-02-16 12:30:00	MSFT	Stock	31.02	31.22	31.013	31.192	8130381.0
2012-02-16 13:00:00	MSFT	Stock	31.2	31.32	31.15	31.27	5098056.0
2012-02-16 13:30:00	MSFT	Stock	31.27	31.55	31.26	31.445	11993291.0
2012-02-16 14:00:00	MSFT	Stock	31.44	31.47	31.35	31.4	6069534.0
2012-02-16 14:30:00	MSFT	Stock	31.408	31.55	31.34	31.345	7764595.0
2012-02-16 15:00:00	MSFT	Stock	31.35	31.39	31.22	31.315	6756562.0
2012-02-16 15:30:00	MSFT	Stock	31.31	31.38	31.27	31.29	11327263.0

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

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