PREVIEW / stock_30min / 2013-10-29

all stock 30-min files

  file:    by_date/stock_30min/2013/2013-10-29.parquet
  size:    1.5 MB
  rows:    80,294
  symbols: 3,546

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-10-29 04:00:00	AAPL	Stock	19.0575	19.0575	18.7143	18.8736	215040.0
2013-10-29 04:30:00	AAPL	Stock	18.8775	18.9179	18.8571	18.875	88200.0
2013-10-29 05:00:00	AAPL	Stock	18.9032	18.9089	18.8571	18.8929	56532.0
2013-10-29 05:30:00	AAPL	Stock	18.9039	18.9621	18.9	18.9621	167412.0
2013-10-29 06:00:00	AAPL	Stock	18.9089	19.0304	18.9057	19.0304	172844.0
2013-10-29 06:30:00	AAPL	Stock	19.0357	19.0407	18.9714	19.0004	166964.0
2013-10-29 07:00:00	AAPL	Stock	19.0029	19.0136	18.8993	18.9246	1812384.0
2013-10-29 07:30:00	AAPL	Stock	18.9143	19.15	18.8571	19.15	4961404.0
2013-10-29 08:00:00	AAPL	Stock	19.1386	19.15	18.7857	19.0139	5572028.0
2013-10-29 08:30:00	AAPL	Stock	19.0139	19.1071	18.9739	19.1004	5998580.0
2013-10-29 09:00:00	AAPL	Stock	19.0989	19.2418	19.0893	19.1532	14655956.0
2013-10-29 09:30:00	AAPL	Stock	19.1525	19.2589	18.9036	18.9929	149151268.0
2013-10-29 10:00:00	AAPL	Stock	18.9875	19.0246	18.7154	18.8907	73210732.0
2013-10-29 10:30:00	AAPL	Stock	18.8907	18.9071	18.75	18.7571	40902036.0
2013-10-29 11:00:00	AAPL	Stock	18.7543	18.8257	18.7239	18.7541	31051776.0
2013-10-29 11:30:00	AAPL	Stock	18.7514	18.7664	18.6018	18.7064	44231712.0
2013-10-29 12:00:00	AAPL	Stock	18.7104	18.8393	18.6907	18.8279	25147500.0
2013-10-29 12:30:00	AAPL	Stock	18.8289	18.8571	18.7929	18.8211	16472428.0
2013-10-29 13:00:00	AAPL	Stock	18.8211	18.8268	18.75	18.7689	13083308.0
2013-10-29 13:30:00	AAPL	Stock	18.7618	18.775	18.6989	18.7411	12539436.0
2013-10-29 14:00:00	AAPL	Stock	18.7457	18.7461	18.6064	18.6493	23982140.0
2013-10-29 14:30:00	AAPL	Stock	18.6493	18.6946	18.6182	18.6821	20662992.0
2013-10-29 15:00:00	AAPL	Stock	18.6821	18.6846	18.4143	18.5143	55342980.0
2013-10-29 15:30:00	AAPL	Stock	18.5122	18.5421	18.3764	18.4648	71049664.0
2013-10-29 16:00:00	AAPL	Stock	18.465	18.7855	18.4528	18.4768	10366664.0
2013-10-29 16:30:00	AAPL	Stock	18.4743	18.9144	18.4241	18.4643	2491048.0
2013-10-29 17:00:00	AAPL	Stock	18.4607	18.6959	18.4593	18.4696	278796.0
2013-10-29 17:30:00	AAPL	Stock	18.4661	18.47	18.4571	18.4571	372988.0
2013-10-29 18:00:00	AAPL	Stock	18.4539	18.4618	18.4404	18.4618	181776.0
2013-10-29 18:30:00	AAPL	Stock	18.4614	18.4639	18.4471	18.4511	675444.0
2013-10-29 19:00:00	AAPL	Stock	18.4561	18.4568	18.4429	18.4536	426888.0
2013-10-29 19:30:00	AAPL	Stock	18.4536	18.4568	18.4486	18.4518	141820.0
2013-10-29 06:30:00	MSFT	Stock	35.49	35.49	35.49	35.49	100.0
2013-10-29 07:00:00	MSFT	Stock	35.55	35.61	35.55	35.61	1000.0
2013-10-29 07:30:00	MSFT	Stock	35.64	35.64	35.61	35.61	350.0
2013-10-29 08:00:00	MSFT	Stock	35.6	35.7	35.555	35.65	24703.0
2013-10-29 08:30:00	MSFT	Stock	35.66	35.66	35.61	35.63	5526.0
2013-10-29 09:00:00	MSFT	Stock	35.65	35.66	35.61	35.64	2458.0
2013-10-29 09:30:00	MSFT	Stock	35.64	35.72	35.3	35.385	4292469.0
2013-10-29 10:00:00	MSFT	Stock	35.38	35.45	35.26	35.34	3761463.0
2013-10-29 10:30:00	MSFT	Stock	35.34	35.4	35.3	35.358	2407886.0
2013-10-29 11:00:00	MSFT	Stock	35.35	35.45	35.35	35.412	1283833.0
2013-10-29 11:30:00	MSFT	Stock	35.42	35.46	35.37	35.455	1337943.0
2013-10-29 12:00:00	MSFT	Stock	35.46	35.559	35.455	35.54	1208495.0
2013-10-29 12:30:00	MSFT	Stock	35.54	35.55	35.44	35.54	2036160.0
2013-10-29 13:00:00	MSFT	Stock	35.54	35.57	35.52	35.525	1381197.0
2013-10-29 13:30:00	MSFT	Stock	35.525	35.57	35.52	35.55	758985.0
2013-10-29 14:00:00	MSFT	Stock	35.56	35.6	35.54	35.56	1448843.0
2013-10-29 14:30:00	MSFT	Stock	35.55	35.63	35.54	35.61	1234587.0
2013-10-29 15:00:00	MSFT	Stock	35.61	35.62	35.5	35.533	2863633.0

> showing 50 of 80,294 rows — these rows as CSV

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