PREVIEW / stock_30min / 2011-02-17

all stock 30-min files

  file:    by_date/stock_30min/2011/2011-02-17.parquet
  size:    1.4 MB
  rows:    77,219
  symbols: 3,527

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-02-17 04:00:00	AAPL	Stock	12.7929	12.8571	12.7929	12.8054	72660.0
2011-02-17 04:30:00	AAPL	Stock	12.8054	12.8054	12.6793	12.7018	142128.0
2011-02-17 05:00:00	AAPL	Stock	12.7143	12.75	12.5496	12.5496	155988.0
2011-02-17 05:30:00	AAPL	Stock	12.6143	12.6939	12.5418	12.6939	150080.0
2011-02-17 06:00:00	AAPL	Stock	12.7036	12.7321	12.6786	12.7321	227724.0
2011-02-17 06:30:00	AAPL	Stock	12.7143	12.8029	12.69	12.7857	280840.0
2011-02-17 07:00:00	AAPL	Stock	12.7782	12.8664	12.7679	12.8036	1504104.0
2011-02-17 07:30:00	AAPL	Stock	12.8036	12.8314	12.7789	12.8071	1671740.0
2011-02-17 08:00:00	AAPL	Stock	12.8071	12.8911	12.7918	12.85	4708480.0
2011-02-17 08:30:00	AAPL	Stock	12.85	12.8571	12.8036	12.8054	3829560.0
2011-02-17 09:00:00	AAPL	Stock	12.8054	12.8171	12.7532	12.7596	7219548.0
2011-02-17 09:30:00	AAPL	Stock	12.7589	12.8571	12.75	12.8443	109246592.0
2011-02-17 10:00:00	AAPL	Stock	12.8439	12.8668	12.8139	12.83	48794872.0
2011-02-17 10:30:00	AAPL	Stock	12.83	12.8311	12.7496	12.7614	50287048.0
2011-02-17 11:00:00	AAPL	Stock	12.7614	12.8064	12.7329	12.8011	58129988.0
2011-02-17 11:30:00	AAPL	Stock	12.8011	12.8389	12.7857	12.8268	30376080.0
2011-02-17 12:00:00	AAPL	Stock	12.8275	12.8314	12.8057	12.8132	14681072.0
2011-02-17 12:30:00	AAPL	Stock	12.8132	12.8214	12.7786	12.7804	20449800.0
2011-02-17 13:00:00	AAPL	Stock	12.78	12.8093	12.7792	12.7992	17702104.0
2011-02-17 13:30:00	AAPL	Stock	12.8	12.8089	12.7679	12.7821	23570652.0
2011-02-17 14:00:00	AAPL	Stock	12.7829	12.8127	12.7768	12.7961	19095496.0
2011-02-17 14:30:00	AAPL	Stock	12.7968	12.8032	12.7725	12.7793	18103260.0
2011-02-17 15:00:00	AAPL	Stock	12.7818	12.787	12.7736	12.7777	20811476.0
2011-02-17 15:30:00	AAPL	Stock	12.7771	12.7964	12.75	12.7961	56510692.0
2011-02-17 16:00:00	AAPL	Stock	12.7927	12.8261	12.7716	12.8221	11779992.0
2011-02-17 16:30:00	AAPL	Stock	12.8186	12.8246	12.7697	12.8107	710752.0
2011-02-17 17:00:00	AAPL	Stock	12.815	12.8189	12.8036	12.8039	240184.0
2011-02-17 17:30:00	AAPL	Stock	12.8046	12.8143	12.8039	12.8143	245616.0
2011-02-17 18:00:00	AAPL	Stock	12.8157	12.8193	12.7964	12.8129	232064.0
2011-02-17 18:30:00	AAPL	Stock	12.8114	12.8132	12.8107	12.8132	51996.0
2011-02-17 19:00:00	AAPL	Stock	12.8168	12.8193	12.8036	12.8054	537964.0
2011-02-17 19:30:00	AAPL	Stock	12.8054	12.8068	12.7929	12.8036	203448.0
2011-02-17 06:30:00	MSFT	Stock	27.04	27.06	27.04	27.06	300.0
2011-02-17 07:00:00	MSFT	Stock	27.05	27.05	27.05	27.05	2100.0
2011-02-17 07:30:00	MSFT	Stock	27.05	27.05	27.05	27.05	1500.0
2011-02-17 08:00:00	MSFT	Stock	27.05	27.08	27.03	27.06	9444.0
2011-02-17 08:30:00	MSFT	Stock	27.06	27.06	26.96	27.02	27565.0
2011-02-17 09:00:00	MSFT	Stock	27.03	27.13	26.95	26.96	155692.0
2011-02-17 09:30:00	MSFT	Stock	26.96	27.19	26.91	27.18	5848563.0
2011-02-17 10:00:00	MSFT	Stock	27.19	27.26	27.16	27.23	5928709.0
2011-02-17 10:30:00	MSFT	Stock	27.24	27.3	27.2	27.24	4253970.0
2011-02-17 11:00:00	MSFT	Stock	27.239	27.29	27.21	27.275	3633911.0
2011-02-17 11:30:00	MSFT	Stock	27.275	27.37	27.26	27.35	4501618.0
2011-02-17 12:00:00	MSFT	Stock	27.35	27.36	27.3	27.325	2560853.0
2011-02-17 12:30:00	MSFT	Stock	27.33	27.37	27.2	27.22	6713638.0
2011-02-17 13:00:00	MSFT	Stock	27.22	27.3	27.22	27.25	1927073.0
2011-02-17 13:30:00	MSFT	Stock	27.25	27.26	27.22	27.26	1422654.0
2011-02-17 14:00:00	MSFT	Stock	27.26	27.28	27.24	27.28	2039814.0
2011-02-17 14:30:00	MSFT	Stock	27.272	27.3	27.24	27.26	3158664.0
2011-02-17 15:00:00	MSFT	Stock	27.26	27.3	27.21	27.225	4362487.0

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

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