PREVIEW / stock_30min / 2013-04-26

all stock 30-min files

  file:    by_date/stock_30min/2013/2013-04-26.parquet
  size:    1.5 MB
  rows:    77,974
  symbols: 3,454

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-04-26 04:00:00	AAPL	Stock	14.5996	14.5996	14.5996	14.5996	11200.0
2013-04-26 04:30:00	AAPL	Stock	14.57	14.57	14.57	14.57	5600.0
2013-04-26 06:00:00	AAPL	Stock	14.5386	14.5386	14.5386	14.5386	5600.0
2013-04-26 06:30:00	AAPL	Stock	14.5357	14.5357	14.5357	14.5357	25200.0
2013-04-26 07:00:00	AAPL	Stock	14.5296	14.5536	14.5296	14.5536	201544.0
2013-04-26 07:30:00	AAPL	Stock	14.5539	14.5714	14.5496	14.5504	81200.0
2013-04-26 08:00:00	AAPL	Stock	14.5621	14.585	14.5218	14.5693	1426292.0
2013-04-26 08:30:00	AAPL	Stock	14.5604	14.6957	14.5368	14.6607	1424220.0
2013-04-26 09:00:00	AAPL	Stock	14.6679	14.6679	14.6071	14.6375	1104684.0
2013-04-26 09:30:00	AAPL	Stock	14.6364	14.7939	14.5804	14.7929	85560888.0
2013-04-26 10:00:00	AAPL	Stock	14.7929	14.8175	14.7057	14.7711	46242364.0
2013-04-26 10:30:00	AAPL	Stock	14.7721	14.7971	14.7411	14.7843	35083776.0
2013-04-26 11:00:00	AAPL	Stock	14.7855	14.8304	14.7325	14.7649	39643464.0
2013-04-26 11:30:00	AAPL	Stock	14.7671	14.7904	14.7161	14.7379	23753100.0
2013-04-26 12:00:00	AAPL	Stock	14.7379	14.7589	14.7189	14.7389	16928772.0
2013-04-26 12:30:00	AAPL	Stock	14.74	14.7918	14.7293	14.7809	14322560.0
2013-04-26 13:00:00	AAPL	Stock	14.7768	14.8193	14.775	14.8026	15804236.0
2013-04-26 13:30:00	AAPL	Stock	14.8032	14.8614	14.7796	14.8393	33224996.0
2013-04-26 14:00:00	AAPL	Stock	14.8379	14.8675	14.8218	14.8468	22856932.0
2013-04-26 14:30:00	AAPL	Stock	14.8479	14.9243	14.844	14.8943	41105120.0
2013-04-26 15:00:00	AAPL	Stock	14.8936	14.956	14.8936	14.935	39163376.0
2013-04-26 15:30:00	AAPL	Stock	14.935	14.9496	14.8946	14.8975	50970920.0
2013-04-26 16:00:00	AAPL	Stock	14.8968	14.9142	14.7732	14.8918	129671472.0
2013-04-26 16:30:00	AAPL	Stock	14.8968	14.934	14.8571	14.8721	548800.0
2013-04-26 17:00:00	AAPL	Stock	14.8775	14.9	14.8732	14.8871	256396.0
2013-04-26 17:30:00	AAPL	Stock	14.8857	14.8893	14.8821	14.8854	113400.0
2013-04-26 18:00:00	AAPL	Stock	14.8861	14.8893	14.8796	14.8796	92540.0
2013-04-26 18:30:00	AAPL	Stock	14.8857	14.8857	14.8793	14.8793	14000.0
2013-04-26 19:00:00	AAPL	Stock	14.8821	14.8893	14.8821	14.8893	49560.0
2013-04-26 19:30:00	AAPL	Stock	14.8857	14.8893	14.875	14.8854	95732.0
2013-04-26 06:30:00	MSFT	Stock	31.76	31.76	31.76	31.76	1000.0
2013-04-26 07:00:00	MSFT	Stock	31.8	31.84	31.8	31.84	1415.0
2013-04-26 07:30:00	MSFT	Stock	31.83	31.87	31.83	31.85	1900.0
2013-04-26 08:00:00	MSFT	Stock	31.85	31.91	31.84	31.91	5947.0
2013-04-26 08:30:00	MSFT	Stock	31.91	31.91	31.82	31.82	28055.0
2013-04-26 09:00:00	MSFT	Stock	31.85	31.9	31.85	31.89	150700.0
2013-04-26 09:30:00	MSFT	Stock	31.89	31.965	31.64	31.65	5417198.0
2013-04-26 10:00:00	MSFT	Stock	31.655	31.67	31.45	31.56	8243772.0
2013-04-26 10:30:00	MSFT	Stock	31.57	31.67	31.49	31.635	3555216.0
2013-04-26 11:00:00	MSFT	Stock	31.63	31.71	31.58	31.6	2917165.0
2013-04-26 11:30:00	MSFT	Stock	31.605	31.65	31.53	31.585	1859515.0
2013-04-26 12:00:00	MSFT	Stock	31.58	31.68	31.52	31.67	1828184.0
2013-04-26 12:30:00	MSFT	Stock	31.67	31.72	31.63	31.711	1819712.0
2013-04-26 13:00:00	MSFT	Stock	31.71	31.88	31.7	31.814	2137901.0
2013-04-26 13:30:00	MSFT	Stock	31.82	31.89	31.79	31.88	1196267.0
2013-04-26 14:00:00	MSFT	Stock	31.88	31.89	31.81	31.87	1460466.0
2013-04-26 14:30:00	MSFT	Stock	31.865	31.97	31.845	31.95	1713504.0
2013-04-26 15:00:00	MSFT	Stock	31.955	31.98	31.905	31.955	1873270.0
2013-04-26 15:30:00	MSFT	Stock	31.95	31.97	31.77	31.79	5231374.0
2013-04-26 16:00:00	MSFT	Stock	31.79	31.81	31.525	31.79	6989324.0

> showing 50 of 77,974 rows — these rows as CSV

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