PREVIEW / stock_30min / 2014-02-05

all stock 30-min files

  file:    by_date/stock_30min/2014/2014-02-05.parquet
  size:    1.6 MB
  rows:    83,345
  symbols: 3,536

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-05 04:00:00	AAPL	Stock	18.1786	18.1786	18.1786	18.1786	2800.0
2014-02-05 05:00:00	AAPL	Stock	18.1646	18.17	18.1575	18.17	16800.0
2014-02-05 06:00:00	AAPL	Stock	18.1089	18.125	18.1071	18.125	59388.0
2014-02-05 06:30:00	AAPL	Stock	18.1429	18.1429	18.1161	18.1161	5600.0
2014-02-05 07:00:00	AAPL	Stock	18.1143	18.1407	18.1107	18.1121	35392.0
2014-02-05 07:30:00	AAPL	Stock	18.1143	18.125	18.0882	18.0882	59276.0
2014-02-05 08:00:00	AAPL	Stock	18.0993	18.1393	18.0382	18.0625	1070160.0
2014-02-05 08:30:00	AAPL	Stock	18.0636	18.1279	18.0539	18.125	537460.0
2014-02-05 09:00:00	AAPL	Stock	18.1264	18.1711	18.0836	18.0836	503580.0
2014-02-05 09:30:00	AAPL	Stock	18.0904	18.2454	18.0804	18.1786	38784032.0
2014-02-05 10:00:00	AAPL	Stock	18.1786	18.2946	18.14	18.2011	38089016.0
2014-02-05 10:30:00	AAPL	Stock	18.1979	18.2529	18.1682	18.2303	18423440.0
2014-02-05 11:00:00	AAPL	Stock	18.2282	18.2721	18.2143	18.2663	12050136.0
2014-02-05 11:30:00	AAPL	Stock	18.2643	18.3314	18.2421	18.3262	17866100.0
2014-02-05 12:00:00	AAPL	Stock	18.3261	18.3761	18.3229	18.3305	21338856.0
2014-02-05 12:30:00	AAPL	Stock	18.3325	18.3707	18.33	18.3604	10117464.0
2014-02-05 13:00:00	AAPL	Stock	18.3586	18.4	18.3502	18.3625	11921952.0
2014-02-05 13:30:00	AAPL	Stock	18.3615	18.4029	18.3529	18.3857	8686496.0
2014-02-05 14:00:00	AAPL	Stock	18.3761	18.3961	18.3536	18.3696	8775900.0
2014-02-05 14:30:00	AAPL	Stock	18.3711	18.3914	18.3336	18.3411	10309264.0
2014-02-05 15:00:00	AAPL	Stock	18.3429	18.3711	18.3218	18.3604	11574556.0
2014-02-05 15:30:00	AAPL	Stock	18.3614	18.3725	18.3036	18.3075	25312112.0
2014-02-05 16:00:00	AAPL	Stock	18.3068	18.3362	18.142	18.31	15032472.0
2014-02-05 16:30:00	AAPL	Stock	18.3068	18.3161	18.3032	18.3082	177688.0
2014-02-05 17:00:00	AAPL	Stock	18.3086	18.3161	18.3036	18.3036	347424.0
2014-02-05 17:30:00	AAPL	Stock	18.3054	18.3125	18.2893	18.2961	153524.0
2014-02-05 18:00:00	AAPL	Stock	18.2929	18.3036	18.29	18.2911	39928.0
2014-02-05 18:30:00	AAPL	Stock	18.2918	18.3082	18.2893	18.2893	164108.0
2014-02-05 19:00:00	AAPL	Stock	18.2961	18.3029	18.2921	18.3029	184744.0
2014-02-05 19:30:00	AAPL	Stock	18.2946	18.3036	18.2946	18.3032	298284.0
2014-02-05 04:30:00	MSFT	Stock	36.4	36.42	36.39	36.42	1850.0
2014-02-05 05:00:00	MSFT	Stock	36.42	36.42	36.42	36.42	100.0
2014-02-05 05:30:00	MSFT	Stock	36.46	36.46	36.46	36.46	400.0
2014-02-05 06:00:00	MSFT	Stock	36.42	36.42	36.4	36.4	2588.0
2014-02-05 06:30:00	MSFT	Stock	36.21	36.21	36.21	36.21	100.0
2014-02-05 07:00:00	MSFT	Stock	36.3	36.4	36.3	36.4	1100.0
2014-02-05 07:30:00	MSFT	Stock	36.4	36.4	36.25	36.3	17450.0
2014-02-05 08:00:00	MSFT	Stock	36.3	36.3	36.21	36.22	9679.0
2014-02-05 08:30:00	MSFT	Stock	36.26	36.4	36.26	36.4	12173.0
2014-02-05 09:00:00	MSFT	Stock	36.43	36.49	36.23	36.29	90466.0
2014-02-05 09:30:00	MSFT	Stock	36.29	36.47	36.17	36.28	5151694.0
2014-02-05 10:00:00	MSFT	Stock	36.27	36.43	35.85	36.04	6168747.0
2014-02-05 10:30:00	MSFT	Stock	36.035	36.16	35.96	35.97	3805099.0
2014-02-05 11:00:00	MSFT	Stock	35.97	35.975	35.8	35.88	5881313.0
2014-02-05 11:30:00	MSFT	Stock	35.875	36.04	35.8	35.95	5424688.0
2014-02-05 12:00:00	MSFT	Stock	35.96	36.13	35.955	36.045	2077496.0
2014-02-05 12:30:00	MSFT	Stock	36.04	36.16	36.035	36.155	1328159.0
2014-02-05 13:00:00	MSFT	Stock	36.155	36.24	36.03	36.035	2166537.0
2014-02-05 13:30:00	MSFT	Stock	36.04	36.11	35.95	35.99	1697956.0
2014-02-05 14:00:00	MSFT	Stock	35.98	36.05	35.88	36.015	1753971.0

> showing 50 of 83,345 rows — these rows as CSV

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