PREVIEW / stock_30min / 2014-02-24

all stock 30-min files

  file:    by_date/stock_30min/2014/2014-02-24.parquet
  size:    1.6 MB
  rows:    84,493
  symbols: 3,548

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
2014-02-24 04:00:00	AAPL	Stock	18.7786	18.7786	18.7671	18.7754	58800.0
2014-02-24 04:30:00	AAPL	Stock	18.7714	18.7714	18.7143	18.7143	16800.0
2014-02-24 05:00:00	AAPL	Stock	18.6907	18.6907	18.6907	18.6907	2800.0
2014-02-24 06:00:00	AAPL	Stock	18.6907	18.6907	18.6446	18.6482	86800.0
2014-02-24 06:30:00	AAPL	Stock	18.6429	18.6643	18.6368	18.6643	56700.0
2014-02-24 07:00:00	AAPL	Stock	18.6711	18.7211	18.6711	18.6929	173964.0
2014-02-24 07:30:00	AAPL	Stock	18.6946	18.7157	18.6643	18.7143	376012.0
2014-02-24 08:00:00	AAPL	Stock	18.7143	18.7218	18.6521	18.7161	826812.0
2014-02-24 08:30:00	AAPL	Stock	18.7143	18.7157	18.6961	18.7107	305592.0
2014-02-24 09:00:00	AAPL	Stock	18.7057	18.7236	18.6814	18.6829	754936.0
2014-02-24 09:30:00	AAPL	Stock	18.6836	18.8864	18.6579	18.8768	49778400.0
2014-02-24 10:00:00	AAPL	Stock	18.8796	18.8839	18.8121	18.8389	16926616.0
2014-02-24 10:30:00	AAPL	Stock	18.8425	18.8496	18.7536	18.8093	18365116.0
2014-02-24 11:00:00	AAPL	Stock	18.8107	18.83	18.7543	18.7943	10514700.0
2014-02-24 11:30:00	AAPL	Stock	18.7932	18.8246	18.7589	18.7721	10538584.0
2014-02-24 12:00:00	AAPL	Stock	18.7736	18.7882	18.6889	18.7053	12286736.0
2014-02-24 12:30:00	AAPL	Stock	18.7054	18.7207	18.6607	18.6729	11989712.0
2014-02-24 13:00:00	AAPL	Stock	18.6725	18.7382	18.6682	18.7254	9285780.0
2014-02-24 13:30:00	AAPL	Stock	18.7253	18.775	18.7225	18.7482	8910272.0
2014-02-24 14:00:00	AAPL	Stock	18.7486	18.8639	18.7486	18.8575	16622200.0
2014-02-24 14:30:00	AAPL	Stock	18.8586	18.9257	18.8429	18.8905	17624460.0
2014-02-24 15:00:00	AAPL	Stock	18.8875	18.8964	18.8336	18.8336	10694796.0
2014-02-24 15:30:00	AAPL	Stock	18.8354	18.8936	18.8221	18.8407	21205576.0
2014-02-24 16:00:00	AAPL	Stock	18.8421	18.8617	18.8016	18.8482	20409004.0
2014-02-24 16:30:00	AAPL	Stock	18.8429	18.8461	18.8393	18.8393	60592.0
2014-02-24 17:00:00	AAPL	Stock	18.8382	18.8439	18.8368	18.8439	133476.0
2014-02-24 17:30:00	AAPL	Stock	18.8411	18.8411	18.8393	18.8411	69020.0
2014-02-24 18:00:00	AAPL	Stock	18.8404	18.8411	18.8364	18.8411	53340.0
2014-02-24 18:30:00	AAPL	Stock	18.8411	18.8411	18.8393	18.8393	82096.0
2014-02-24 19:00:00	AAPL	Stock	18.8446	18.8589	18.8446	18.8589	77084.0
2014-02-24 19:30:00	AAPL	Stock	18.8593	18.9007	18.8593	18.9007	246904.0
2014-02-24 04:00:00	MSFT	Stock	37.95	37.96	37.95	37.96	350.0
2014-02-24 06:00:00	MSFT	Stock	38.2	38.2	38.1	38.1	1700.0
2014-02-24 06:30:00	MSFT	Stock	38.1	38.2	38.0	38.2	3590.0
2014-02-24 07:00:00	MSFT	Stock	38.12	38.12	37.95	37.95	7700.0
2014-02-24 07:30:00	MSFT	Stock	37.97	38.05	37.96	38.0	1200.0
2014-02-24 08:00:00	MSFT	Stock	38.05	38.05	37.94	37.95	17300.0
2014-02-24 08:30:00	MSFT	Stock	37.95	37.98	37.85	37.9	67900.0
2014-02-24 09:00:00	MSFT	Stock	37.9	37.9	37.6	37.67	114685.0
2014-02-24 09:30:00	MSFT	Stock	37.67	37.94	37.54	37.84	3862516.0
2014-02-24 10:00:00	MSFT	Stock	37.84	37.9	37.77	37.839	2456648.0
2014-02-24 10:30:00	MSFT	Stock	37.84	37.91	37.83	37.865	1869787.0
2014-02-24 11:00:00	MSFT	Stock	37.86	37.93	37.82	37.93	1971163.0
2014-02-24 11:30:00	MSFT	Stock	37.93	37.94	37.82	37.82	2235848.0
2014-02-24 12:00:00	MSFT	Stock	37.825	37.86	37.81	37.825	1313070.0
2014-02-24 12:30:00	MSFT	Stock	37.82	37.91	37.82	37.89	1972059.0
2014-02-24 13:00:00	MSFT	Stock	37.89	37.975	37.88	37.925	1403053.0
2014-02-24 13:30:00	MSFT	Stock	37.925	37.94	37.76	37.79	1047839.0
2014-02-24 14:00:00	MSFT	Stock	37.8	37.85	37.78	37.8	1233156.0
2014-02-24 14:30:00	MSFT	Stock	37.8	37.85	37.78	37.78	1149097.0

> showing 50 of 84,493 rows — these rows as CSV

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