PREVIEW / stock_30min / 2013-11-11

all stock 30-min files

  file:    by_date/stock_30min/2013/2013-11-11.parquet
  size:    1.5 MB
  rows:    78,241
  symbols: 3,523

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
2013-11-11 04:00:00	AAPL	Stock	18.6071	18.6071	18.5918	18.5918	13076.0
2013-11-11 04:30:00	AAPL	Stock	18.5893	18.5893	18.5714	18.5714	8400.0
2013-11-11 05:00:00	AAPL	Stock	18.5843	18.5843	18.5714	18.5714	30800.0
2013-11-11 05:30:00	AAPL	Stock	18.5714	18.5714	18.5714	18.5714	16800.0
2013-11-11 06:00:00	AAPL	Stock	18.5714	18.5714	18.5543	18.5543	78400.0
2013-11-11 06:30:00	AAPL	Stock	18.555	18.555	18.5393	18.5393	26600.0
2013-11-11 07:00:00	AAPL	Stock	18.5707	18.6029	18.5696	18.6029	80528.0
2013-11-11 07:30:00	AAPL	Stock	18.6071	18.6789	18.5825	18.6746	214088.0
2013-11-11 08:00:00	AAPL	Stock	18.6714	18.6746	18.5714	18.6079	1615880.0
2013-11-11 08:30:00	AAPL	Stock	18.6179	18.6246	18.5786	18.5786	813876.0
2013-11-11 09:00:00	AAPL	Stock	18.5786	18.5932	18.5575	18.5575	673344.0
2013-11-11 09:30:00	AAPL	Stock	18.5711	18.6311	18.4564	18.4786	40577404.0
2013-11-11 10:00:00	AAPL	Stock	18.4821	18.5057	18.3896	18.4393	24219160.0
2013-11-11 10:30:00	AAPL	Stock	18.4393	18.4846	18.3843	18.4332	25434948.0
2013-11-11 11:00:00	AAPL	Stock	18.4368	18.4404	18.3718	18.4357	21982996.0
2013-11-11 11:30:00	AAPL	Stock	18.4343	18.5257	18.4161	18.5168	19395292.0
2013-11-11 12:00:00	AAPL	Stock	18.5146	18.5321	18.4707	18.4954	8818208.0
2013-11-11 12:30:00	AAPL	Stock	18.4979	18.5304	18.4779	18.5211	6750016.0
2013-11-11 13:00:00	AAPL	Stock	18.5225	18.5368	18.4943	18.51	9300060.0
2013-11-11 13:30:00	AAPL	Stock	18.5089	18.5171	18.4739	18.505	6444956.0
2013-11-11 14:00:00	AAPL	Stock	18.5036	18.5432	18.4846	18.5321	7820540.0
2013-11-11 14:30:00	AAPL	Stock	18.5325	18.5725	18.5307	18.5483	9383304.0
2013-11-11 15:00:00	AAPL	Stock	18.55	18.6014	18.5436	18.5861	12088804.0
2013-11-11 15:30:00	AAPL	Stock	18.5867	18.5875	18.5325	18.5437	18962300.0
2013-11-11 16:00:00	AAPL	Stock	18.5461	18.5525	18.4896	18.5471	9988524.0
2013-11-11 16:30:00	AAPL	Stock	18.5475	18.5518	18.5375	18.5461	260064.0
2013-11-11 17:00:00	AAPL	Stock	18.5368	18.5457	18.5357	18.5436	47600.0
2013-11-11 17:30:00	AAPL	Stock	18.5429	18.5446	18.5275	18.5321	76272.0
2013-11-11 18:00:00	AAPL	Stock	18.5343	18.5461	18.5179	18.5179	321328.0
2013-11-11 18:30:00	AAPL	Stock	18.5286	18.5286	18.5286	18.5286	5376.0
2013-11-11 19:00:00	AAPL	Stock	18.5286	18.5286	18.525	18.525	19600.0
2013-11-11 19:30:00	AAPL	Stock	18.525	18.5261	18.5218	18.5218	40348.0
2013-11-11 04:00:00	MSFT	Stock	37.8	37.8	37.8	37.8	250.0
2013-11-11 07:30:00	MSFT	Stock	37.72	37.72	37.7	37.7	3050.0
2013-11-11 08:00:00	MSFT	Stock	37.78	37.8	37.71	37.78	450.0
2013-11-11 08:30:00	MSFT	Stock	37.78	37.78	37.75	37.78	2566.0
2013-11-11 09:00:00	MSFT	Stock	37.71	37.75	37.67	37.7	9018.0
2013-11-11 09:30:00	MSFT	Stock	37.69	37.77	37.525	37.63	3475446.0
2013-11-11 10:00:00	MSFT	Stock	37.63	37.64	37.4	37.45	2390739.0
2013-11-11 10:30:00	MSFT	Stock	37.45	37.58	37.355	37.575	2237588.0
2013-11-11 11:00:00	MSFT	Stock	37.575	37.6	37.397	37.55	4248233.0
2013-11-11 11:30:00	MSFT	Stock	37.55	37.605	37.5	37.575	2427974.0
2013-11-11 12:00:00	MSFT	Stock	37.57	37.58	37.5	37.55	1242925.0
2013-11-11 12:30:00	MSFT	Stock	37.55	37.566	37.5	37.53	830653.0
2013-11-11 13:00:00	MSFT	Stock	37.536	37.56	37.5	37.56	622482.0
2013-11-11 13:30:00	MSFT	Stock	37.57	37.775	37.55	37.7	1570060.0
2013-11-11 14:00:00	MSFT	Stock	37.7	37.74	37.69	37.715	796664.0
2013-11-11 14:30:00	MSFT	Stock	37.715	37.72	37.66	37.685	928712.0
2013-11-11 15:00:00	MSFT	Stock	37.69	37.705	37.64	37.645	1164799.0
2013-11-11 15:30:00	MSFT	Stock	37.645	37.656	37.57	37.58	3063661.0

> showing 50 of 78,241 rows — these rows as CSV

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