PREVIEW / stock_30min / 2011-03-03

all stock 30-min files

  file:    by_date/stock_30min/2011/2011-03-03.parquet
  size:    1.4 MB
  rows:    77,934
  symbols: 3,525

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
2011-03-03 04:00:00	AAPL	Stock	12.6721	12.6764	12.6721	12.6754	33600.0
2011-03-03 04:30:00	AAPL	Stock	12.6743	12.6743	12.6696	12.6696	11200.0
2011-03-03 05:00:00	AAPL	Stock	12.6743	12.675	12.6714	12.675	53200.0
2011-03-03 05:30:00	AAPL	Stock	12.6764	12.6764	12.6732	12.6732	134120.0
2011-03-03 06:00:00	AAPL	Stock	12.6732	12.6764	12.6643	12.6757	119840.0
2011-03-03 06:30:00	AAPL	Stock	12.675	12.6764	12.675	12.675	204428.0
2011-03-03 07:00:00	AAPL	Stock	12.675	12.6957	12.6561	12.6786	488180.0
2011-03-03 07:30:00	AAPL	Stock	12.6821	12.7036	12.6821	12.6964	566720.0
2011-03-03 08:00:00	AAPL	Stock	12.6946	12.6964	12.6718	12.6814	1673560.0
2011-03-03 08:30:00	AAPL	Stock	12.6814	12.725	12.6786	12.7175	3633840.0
2011-03-03 09:00:00	AAPL	Stock	12.7146	12.7511	12.7132	12.7439	3383016.0
2011-03-03 09:30:00	AAPL	Stock	12.7439	12.7921	12.7114	12.74	101459652.0
2011-03-03 10:00:00	AAPL	Stock	12.7393	12.7704	12.7357	12.7584	46859260.0
2011-03-03 10:30:00	AAPL	Stock	12.7614	12.8136	12.7544	12.8107	52968916.0
2011-03-03 11:00:00	AAPL	Stock	12.8105	12.8225	12.7939	12.8104	39305980.0
2011-03-03 11:30:00	AAPL	Stock	12.8111	12.8179	12.7814	12.8087	26556544.0
2011-03-03 12:00:00	AAPL	Stock	12.8096	12.8164	12.7993	12.8118	15506736.0
2011-03-03 12:30:00	AAPL	Stock	12.8118	12.815	12.7986	12.8043	12996732.0
2011-03-03 13:00:00	AAPL	Stock	12.805	12.8125	12.8	12.801	14796992.0
2011-03-03 13:30:00	AAPL	Stock	12.8007	12.8157	12.7939	12.8136	18136020.0
2011-03-03 14:00:00	AAPL	Stock	12.8129	12.8261	12.8089	12.8246	28102172.0
2011-03-03 14:30:00	AAPL	Stock	12.8246	12.8468	12.82	12.845	33247872.0
2011-03-03 15:00:00	AAPL	Stock	12.8454	12.8496	12.8186	12.8204	33290124.0
2011-03-03 15:30:00	AAPL	Stock	12.8214	12.8457	12.8154	12.8414	45964352.0
2011-03-03 16:00:00	AAPL	Stock	12.8386	12.843	12.7927	12.8375	15787632.0
2011-03-03 16:30:00	AAPL	Stock	12.8393	12.8414	12.8357	12.8393	144620.0
2011-03-03 17:00:00	AAPL	Stock	12.8375	12.8421	12.8375	12.8396	187236.0
2011-03-03 17:30:00	AAPL	Stock	12.8407	12.8482	12.744	12.8482	1415484.0
2011-03-03 18:00:00	AAPL	Stock	12.8479	12.85	12.8414	12.8496	176204.0
2011-03-03 18:30:00	AAPL	Stock	12.8446	12.8511	12.8446	12.8507	156744.0
2011-03-03 19:00:00	AAPL	Stock	12.8514	12.8554	12.8507	12.8511	184380.0
2011-03-03 19:30:00	AAPL	Stock	12.8536	12.8564	12.8536	12.8554	276360.0
2011-03-03 07:00:00	MSFT	Stock	26.27	26.27	26.2	26.25	1200.0
2011-03-03 07:30:00	MSFT	Stock	26.23	26.25	26.21	26.21	7000.0
2011-03-03 08:00:00	MSFT	Stock	26.21	26.22	26.19	26.2	37145.0
2011-03-03 08:30:00	MSFT	Stock	26.2	26.29	26.16	26.25	51450.0
2011-03-03 09:00:00	MSFT	Stock	26.26	26.27	26.19	26.25	37061.0
2011-03-03 09:30:00	MSFT	Stock	26.26	26.4	26.22	26.35	6031980.0
2011-03-03 10:00:00	MSFT	Stock	26.35	26.39	26.3	26.316	3443270.0
2011-03-03 10:30:00	MSFT	Stock	26.32	26.36	26.29	26.333	4300421.0
2011-03-03 11:00:00	MSFT	Stock	26.33	26.35	26.27	26.31	4800250.0
2011-03-03 11:30:00	MSFT	Stock	26.31	26.35	26.3	26.305	4508213.0
2011-03-03 12:00:00	MSFT	Stock	26.31	26.325	26.26	26.27	3463495.0
2011-03-03 12:30:00	MSFT	Stock	26.27	26.35	26.26	26.3	2919552.0
2011-03-03 13:00:00	MSFT	Stock	26.31	26.32	26.27	26.28	4596219.0
2011-03-03 13:30:00	MSFT	Stock	26.28	26.29	26.23	26.24	3922084.0
2011-03-03 14:00:00	MSFT	Stock	26.232	26.29	26.23	26.249	3835511.0
2011-03-03 14:30:00	MSFT	Stock	26.245	26.26	26.2	26.24	5082926.0
2011-03-03 15:00:00	MSFT	Stock	26.25	26.26	26.24	26.25	3862522.0
2011-03-03 15:30:00	MSFT	Stock	26.25	26.27	26.18	26.19	14370557.0

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

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