PREVIEW / stock_30min / 2011-12-12

all stock 30-min files

  file:    by_date/stock_30min/2011/2011-12-12.parquet
  size:    1.4 MB
  rows:    76,446
  symbols: 3,529

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-12-12 04:00:00	AAPL	Stock	14.0268	14.0268	14.0	14.0	33600.0
2011-12-12 04:30:00	AAPL	Stock	13.9821	13.9821	13.9643	13.9643	24640.0
2011-12-12 05:00:00	AAPL	Stock	13.9643	13.9643	13.9643	13.9643	11200.0
2011-12-12 05:30:00	AAPL	Stock	13.9714	13.9714	13.9714	13.9714	11200.0
2011-12-12 06:00:00	AAPL	Stock	13.9679	13.9714	13.9643	13.9714	17360.0
2011-12-12 07:00:00	AAPL	Stock	13.9682	14.0714	13.9682	14.0	213360.0
2011-12-12 07:30:00	AAPL	Stock	14.0	14.0143	13.9911	14.0071	321860.0
2011-12-12 08:00:00	AAPL	Stock	14.0071	14.0143	13.9929	14.0071	643160.0
2011-12-12 08:30:00	AAPL	Stock	14.0136	14.0393	14.0136	14.0179	713692.0
2011-12-12 09:00:00	AAPL	Stock	14.0179	14.0225	13.9821	13.9904	2152416.0
2011-12-12 09:30:00	AAPL	Stock	13.9904	14.0679	13.9879	14.0118	44771888.0
2011-12-12 10:00:00	AAPL	Stock	14.0114	14.0357	13.9643	13.9768	31028508.0
2011-12-12 10:30:00	AAPL	Stock	13.9761	14.0007	13.9646	13.9905	18714976.0
2011-12-12 11:00:00	AAPL	Stock	13.9904	14.0071	13.9757	13.9914	16068668.0
2011-12-12 11:30:00	AAPL	Stock	13.9911	14.0036	13.9368	13.9542	21152572.0
2011-12-12 12:00:00	AAPL	Stock	13.9518	13.9729	13.9329	13.9643	15726200.0
2011-12-12 12:30:00	AAPL	Stock	13.9643	13.9975	13.9625	13.9821	15587796.0
2011-12-12 13:00:00	AAPL	Stock	13.9825	13.9883	13.9418	13.9704	17111752.0
2011-12-12 13:30:00	AAPL	Stock	13.9707	13.9782	13.9538	13.9682	6307252.0
2011-12-12 14:00:00	AAPL	Stock	13.9664	13.9722	13.9404	13.9479	13968948.0
2011-12-12 14:30:00	AAPL	Stock	13.9479	13.9636	13.9368	13.9493	11157832.0
2011-12-12 15:00:00	AAPL	Stock	13.9489	13.9643	13.9089	13.9564	27740636.0
2011-12-12 15:30:00	AAPL	Stock	13.9557	14.0136	13.945	13.995	42074928.0
2011-12-12 16:00:00	AAPL	Stock	13.9986	14.0111	13.9595	14.0071	11380908.0
2011-12-12 16:30:00	AAPL	Stock	14.0071	14.0107	13.9524	14.0096	265160.0
2011-12-12 17:00:00	AAPL	Stock	14.0114	14.0214	14.01	14.0179	136668.0
2011-12-12 17:30:00	AAPL	Stock	14.0204	14.0204	14.0096	14.0182	67200.0
2011-12-12 18:00:00	AAPL	Stock	14.0243	14.0357	13.9943	14.0307	322700.0
2011-12-12 18:30:00	AAPL	Stock	14.0311	14.0375	14.02	14.02	199976.0
2011-12-12 19:00:00	AAPL	Stock	14.0232	14.0446	14.0179	14.0254	444668.0
2011-12-12 19:30:00	AAPL	Stock	14.02	14.03	13.9811	13.9857	945448.0
2011-12-12 04:00:00	MSFT	Stock	25.71	25.71	25.71	25.71	400.0
2011-12-12 07:30:00	MSFT	Stock	25.62	25.62	25.62	25.62	100.0
2011-12-12 08:00:00	MSFT	Stock	25.62	25.65	25.62	25.62	41010.0
2011-12-12 08:30:00	MSFT	Stock	25.6	25.7	25.58	25.6	36950.0
2011-12-12 09:00:00	MSFT	Stock	25.6	25.63	25.25	25.43	188193.0
2011-12-12 09:30:00	MSFT	Stock	25.41	25.5	25.29	25.35	4955647.0
2011-12-12 10:00:00	MSFT	Stock	25.34	25.44	25.3	25.321	3522405.0
2011-12-12 10:30:00	MSFT	Stock	25.325	25.42	25.32	25.381	2190784.0
2011-12-12 11:00:00	MSFT	Stock	25.39	25.57	25.37	25.451	3605295.0
2011-12-12 11:30:00	MSFT	Stock	25.45	25.48	25.34	25.4	2563623.0
2011-12-12 12:00:00	MSFT	Stock	25.4	25.5	25.38	25.45	2047364.0
2011-12-12 12:30:00	MSFT	Stock	25.445	25.46	25.385	25.4	1338747.0
2011-12-12 13:00:00	MSFT	Stock	25.402	25.46	25.37	25.44	1772405.0
2011-12-12 13:30:00	MSFT	Stock	25.44	25.47	25.415	25.42	1111226.0
2011-12-12 14:00:00	MSFT	Stock	25.43	25.43	25.36	25.4	1879451.0
2011-12-12 14:30:00	MSFT	Stock	25.395	25.44	25.365	25.402	1839794.0
2011-12-12 15:00:00	MSFT	Stock	25.4	25.46	25.36	25.445	2189809.0
2011-12-12 15:30:00	MSFT	Stock	25.44	25.57	25.43	25.55	6223513.0
2011-12-12 16:00:00	MSFT	Stock	25.55	25.57	25.348	25.55	2852004.0

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

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