PREVIEW / stock_30min / 2014-02-21

all stock 30-min files

  file:    by_date/stock_30min/2014/2014-02-21.parquet
  size:    1.6 MB
  rows:    82,798
  symbols: 3,541

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-21 04:00:00	AAPL	Stock	19.0	19.0	19.0	19.0	2800.0
2014-02-21 06:00:00	AAPL	Stock	19.0268	19.0268	19.0268	19.0268	2800.0
2014-02-21 06:30:00	AAPL	Stock	19.0357	19.0357	19.0214	19.0261	11200.0
2014-02-21 07:00:00	AAPL	Stock	19.0236	19.0236	19.0179	19.0229	32060.0
2014-02-21 07:30:00	AAPL	Stock	19.0336	19.035	19.0336	19.035	26124.0
2014-02-21 08:00:00	AAPL	Stock	19.0229	19.0411	19.0107	19.0268	347396.0
2014-02-21 08:30:00	AAPL	Stock	19.0286	19.0286	18.9764	18.9857	419300.0
2014-02-21 09:00:00	AAPL	Stock	18.9957	19.0329	18.9946	19.0257	612808.0
2014-02-21 09:30:00	AAPL	Stock	19.0283	19.0918	18.9857	19.022	52140256.0
2014-02-21 10:00:00	AAPL	Stock	19.0236	19.0357	18.9404	18.9604	19414584.0
2014-02-21 10:30:00	AAPL	Stock	18.9593	18.9907	18.9079	18.9079	14363552.0
2014-02-21 11:00:00	AAPL	Stock	18.9082	18.9082	18.7996	18.8057	25945836.0
2014-02-21 11:30:00	AAPL	Stock	18.81	18.9	18.8036	18.8639	16859584.0
2014-02-21 12:00:00	AAPL	Stock	18.8643	18.8789	18.8084	18.8107	9914912.0
2014-02-21 12:30:00	AAPL	Stock	18.81	18.8323	18.7793	18.8136	10313380.0
2014-02-21 13:00:00	AAPL	Stock	18.8136	18.8486	18.8079	18.8282	6018292.0
2014-02-21 13:30:00	AAPL	Stock	18.8307	18.8375	18.8036	18.8232	6368964.0
2014-02-21 14:00:00	AAPL	Stock	18.8257	18.8482	18.7939	18.8021	7949424.0
2014-02-21 14:30:00	AAPL	Stock	18.8021	18.8196	18.7825	18.8114	9193800.0
2014-02-21 15:00:00	AAPL	Stock	18.8132	18.815	18.7857	18.7946	9728012.0
2014-02-21 15:30:00	AAPL	Stock	18.7946	18.805	18.7357	18.7586	35165032.0
2014-02-21 16:00:00	AAPL	Stock	18.7589	18.8827	18.7502	18.7511	6432328.0
2014-02-21 16:30:00	AAPL	Stock	18.7521	18.9696	18.75	18.7529	319620.0
2014-02-21 17:00:00	AAPL	Stock	18.75	18.7518	18.7418	18.7486	410564.0
2014-02-21 17:30:00	AAPL	Stock	18.7464	18.7489	18.7439	18.7489	15176.0
2014-02-21 18:00:00	AAPL	Stock	18.7464	18.7482	18.7432	18.7432	21980.0
2014-02-21 18:30:00	AAPL	Stock	18.7589	18.7589	18.7446	18.7446	67368.0
2014-02-21 19:00:00	AAPL	Stock	18.7446	18.7464	18.7425	18.7425	30660.0
2014-02-21 19:30:00	AAPL	Stock	18.7443	18.7496	18.7425	18.7496	39060.0
2014-02-21 07:00:00	MSFT	Stock	37.9	37.91	37.9	37.91	1000.0
2014-02-21 07:30:00	MSFT	Stock	37.87	37.88	37.87	37.87	700.0
2014-02-21 08:00:00	MSFT	Stock	37.78	37.9	37.77	37.77	1850.0
2014-02-21 08:30:00	MSFT	Stock	37.85	37.85	37.65	37.7	13526.0
2014-02-21 09:00:00	MSFT	Stock	37.71	37.95	37.67	37.94	42530.0
2014-02-21 09:30:00	MSFT	Stock	37.94	38.18	37.86	38.09	10174403.0
2014-02-21 10:00:00	MSFT	Stock	38.09	38.17	38.05	38.14	2869193.0
2014-02-21 10:30:00	MSFT	Stock	38.14	38.3	38.14	38.27	2498127.0
2014-02-21 11:00:00	MSFT	Stock	38.27	38.35	38.22	38.22	2513842.0
2014-02-21 11:30:00	MSFT	Stock	38.22	38.28	38.09	38.095	2247444.0
2014-02-21 12:00:00	MSFT	Stock	38.095	38.14	38.06	38.14	1393535.0
2014-02-21 12:30:00	MSFT	Stock	38.135	38.14	38.03	38.1	1756583.0
2014-02-21 13:00:00	MSFT	Stock	38.1	38.23	38.1	38.175	1532544.0
2014-02-21 13:30:00	MSFT	Stock	38.174	38.18	38.11	38.15	1272784.0
2014-02-21 14:00:00	MSFT	Stock	38.15	38.18	38.08	38.1	1667968.0
2014-02-21 14:30:00	MSFT	Stock	38.1	38.1	37.97	37.999	1396774.0
2014-02-21 15:00:00	MSFT	Stock	37.99	38.03	37.96	38.012	1775878.0
2014-02-21 15:30:00	MSFT	Stock	38.012	38.06	37.95	37.98	3887506.0
2014-02-21 16:00:00	MSFT	Stock	37.99	38.17	37.978	38.02	1837905.0
2014-02-21 16:30:00	MSFT	Stock	37.98	37.98	37.98	37.98	9384.0
2014-02-21 17:00:00	MSFT	Stock	37.98	37.98	37.98	37.98	52864.0

> showing 50 of 82,798 rows — these rows as CSV

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