PREVIEW / stock_30min / 2013-05-06

all stock 30-min files

  file:    by_date/stock_30min/2013/2013-05-06.parquet
  size:    1.5 MB
  rows:    76,618
  symbols: 3,486

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-05-06 04:00:00	AAPL	Stock	16.1071	16.1261	16.1071	16.125	8400.0
2013-05-06 04:30:00	AAPL	Stock	16.1289	16.1386	16.1225	16.1354	14000.0
2013-05-06 05:00:00	AAPL	Stock	16.1375	16.1375	16.1375	16.1375	2800.0
2013-05-06 05:30:00	AAPL	Stock	16.105	16.105	16.105	16.105	2800.0
2013-05-06 06:00:00	AAPL	Stock	16.1071	16.1161	16.1071	16.1161	22064.0
2013-05-06 07:00:00	AAPL	Stock	16.1143	16.1646	16.1143	16.1518	184352.0
2013-05-06 07:30:00	AAPL	Stock	16.1518	16.21	16.1357	16.1964	439964.0
2013-05-06 08:00:00	AAPL	Stock	16.1914	16.2475	16.1246	16.2321	2104928.0
2013-05-06 08:30:00	AAPL	Stock	16.2321	16.345	16.2286	16.3164	3173156.0
2013-05-06 09:00:00	AAPL	Stock	16.3104	16.3364	16.2843	16.2843	3244304.0
2013-05-06 09:30:00	AAPL	Stock	16.2754	16.4714	16.2254	16.4514	111739376.0
2013-05-06 10:00:00	AAPL	Stock	16.4518	16.4582	16.3896	16.3989	48021904.0
2013-05-06 10:30:00	AAPL	Stock	16.4075	16.4257	16.345	16.3514	37468648.0
2013-05-06 11:00:00	AAPL	Stock	16.3475	16.4089	16.3236	16.3961	29263808.0
2013-05-06 11:30:00	AAPL	Stock	16.3961	16.4603	16.3893	16.4387	27672848.0
2013-05-06 12:00:00	AAPL	Stock	16.4382	16.4643	16.4361	16.4502	19901980.0
2013-05-06 12:30:00	AAPL	Stock	16.4502	16.5064	16.4343	16.4956	24239824.0
2013-05-06 13:00:00	AAPL	Stock	16.4975	16.5036	16.4711	16.4754	12728660.0
2013-05-06 13:30:00	AAPL	Stock	16.4754	16.4964	16.4654	16.48	11454940.0
2013-05-06 14:00:00	AAPL	Stock	16.48	16.4928	16.4657	16.4671	11655112.0
2013-05-06 14:30:00	AAPL	Stock	16.4687	16.4693	16.4261	16.4396	18046980.0
2013-05-06 15:00:00	AAPL	Stock	16.44	16.4836	16.4361	16.4732	17715796.0
2013-05-06 15:30:00	AAPL	Stock	16.4721	16.5071	16.4296	16.4559	46402776.0
2013-05-06 16:00:00	AAPL	Stock	16.4539	16.4796	16.4212	16.4539	32234776.0
2013-05-06 16:30:00	AAPL	Stock	16.4614	16.4821	16.4539	16.475	1209852.0
2013-05-06 17:00:00	AAPL	Stock	16.4661	16.4796	16.4607	16.4796	116872.0
2013-05-06 17:30:00	AAPL	Stock	16.4732	16.48	16.4714	16.4714	129220.0
2013-05-06 18:00:00	AAPL	Stock	16.4696	16.475	16.4696	16.4732	191268.0
2013-05-06 18:30:00	AAPL	Stock	16.4732	16.4764	16.4696	16.4764	113988.0
2013-05-06 19:00:00	AAPL	Stock	16.475	16.4786	16.4714	16.4714	61656.0
2013-05-06 19:30:00	AAPL	Stock	16.4761	16.4836	16.4696	16.475	202748.0
2013-05-06 04:00:00	MSFT	Stock	33.49	33.49	33.49	33.49	600.0
2013-05-06 05:00:00	MSFT	Stock	33.4	33.4	33.4	33.4	500.0
2013-05-06 06:30:00	MSFT	Stock	33.4	33.4	33.4	33.4	656.0
2013-05-06 07:00:00	MSFT	Stock	33.36	33.4	33.36	33.4	409.0
2013-05-06 08:00:00	MSFT	Stock	33.4	33.41	33.38	33.4	12603.0
2013-05-06 08:30:00	MSFT	Stock	33.4	33.41	33.38	33.39	17432.0
2013-05-06 09:00:00	MSFT	Stock	33.39	33.47	33.39	33.42	26804.0
2013-05-06 09:30:00	MSFT	Stock	33.42	33.45	33.25	33.37	4103702.0
2013-05-06 10:00:00	MSFT	Stock	33.38	33.43	33.27	33.375	2449429.0
2013-05-06 10:30:00	MSFT	Stock	33.37	33.45	33.37	33.4	1395425.0
2013-05-06 11:00:00	MSFT	Stock	33.4	33.47	33.38	33.44	1572000.0
2013-05-06 11:30:00	MSFT	Stock	33.449	33.46	33.39	33.448	1328537.0
2013-05-06 12:00:00	MSFT	Stock	33.45	33.73	33.44	33.71	2878659.0
2013-05-06 12:30:00	MSFT	Stock	33.71	33.73	33.62	33.72	3483722.0
2013-05-06 13:00:00	MSFT	Stock	33.715	33.846	33.67	33.845	2755760.0
2013-05-06 13:30:00	MSFT	Stock	33.84	33.91	33.815	33.91	2761350.0
2013-05-06 14:00:00	MSFT	Stock	33.9	33.91	33.79	33.805	1759554.0
2013-05-06 14:30:00	MSFT	Stock	33.81	33.84	33.75	33.825	3287301.0
2013-05-06 15:00:00	MSFT	Stock	33.825	33.84	33.65	33.693	2414193.0

> showing 50 of 76,618 rows — these rows as CSV

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