PREVIEW / stock_30min / 2013-10-14

all stock 30-min files

  file:    by_date/stock_30min/2013/2013-10-14.parquet
  size:    1.5 MB
  rows:    79,876
  symbols: 3,512

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-14 04:00:00	AAPL	Stock	17.2789	17.5361	17.2789	17.5179	58380.0
2013-10-14 04:30:00	AAPL	Stock	17.5014	17.5054	17.4718	17.4732	126364.0
2013-10-14 05:00:00	AAPL	Stock	17.4746	17.4939	17.4739	17.4939	33600.0
2013-10-14 06:00:00	AAPL	Stock	17.5054	17.5118	17.4964	17.5118	30240.0
2013-10-14 07:00:00	AAPL	Stock	17.5054	17.5193	17.4946	17.5014	150976.0
2013-10-14 07:30:00	AAPL	Stock	17.5075	17.5075	17.4518	17.4839	340592.0
2013-10-14 08:00:00	AAPL	Stock	17.4714	17.5089	17.4196	17.4596	1530648.0
2013-10-14 08:30:00	AAPL	Stock	17.4589	17.5061	17.4518	17.4954	562184.0
2013-10-14 09:00:00	AAPL	Stock	17.4957	17.5004	17.4704	17.4832	708960.0
2013-10-14 09:30:00	AAPL	Stock	17.4911	17.7464	17.4768	17.7425	57722336.0
2013-10-14 10:00:00	AAPL	Stock	17.7425	17.76	17.6804	17.7014	31196312.0
2013-10-14 10:30:00	AAPL	Stock	17.7075	17.7357	17.6057	17.6186	23438856.0
2013-10-14 11:00:00	AAPL	Stock	17.6175	17.6721	17.5929	17.6259	15279544.0
2013-10-14 11:30:00	AAPL	Stock	17.6229	17.6914	17.6221	17.6814	9953496.0
2013-10-14 12:00:00	AAPL	Stock	17.6811	17.7043	17.6643	17.7029	7544768.0
2013-10-14 12:30:00	AAPL	Stock	17.7018	17.7446	17.6971	17.7411	11798556.0
2013-10-14 13:00:00	AAPL	Stock	17.7393	17.75	17.7182	17.7221	9157064.0
2013-10-14 13:30:00	AAPL	Stock	17.7218	17.7314	17.7068	17.7218	6573924.0
2013-10-14 14:00:00	AAPL	Stock	17.725	17.7564	17.7218	17.7432	15028412.0
2013-10-14 14:30:00	AAPL	Stock	17.7379	17.7482	17.6829	17.7073	12935216.0
2013-10-14 15:00:00	AAPL	Stock	17.7039	17.7654	17.6893	17.7554	15293684.0
2013-10-14 15:30:00	AAPL	Stock	17.7554	17.7707	17.6964	17.7171	28384804.0
2013-10-14 16:00:00	AAPL	Stock	17.7157	17.7289	17.6734	17.7268	9748228.0
2013-10-14 16:30:00	AAPL	Stock	17.7157	17.7397	17.7157	17.7268	490672.0
2013-10-14 17:00:00	AAPL	Stock	17.7279	17.7368	17.7157	17.7268	306824.0
2013-10-14 17:30:00	AAPL	Stock	17.7346	17.735	17.7125	17.7214	453096.0
2013-10-14 18:00:00	AAPL	Stock	17.7268	17.7318	17.7179	17.7179	51576.0
2013-10-14 18:30:00	AAPL	Stock	17.7257	17.7257	17.7189	17.7218	39200.0
2013-10-14 19:00:00	AAPL	Stock	17.7218	17.7232	17.7164	17.7164	88704.0
2013-10-14 19:30:00	AAPL	Stock	17.7171	17.7321	17.7157	17.7311	271656.0
2013-10-14 08:00:00	MSFT	Stock	33.9	34.0	33.89	33.89	2851.0
2013-10-14 08:30:00	MSFT	Stock	33.92	33.93	33.91	33.93	1847.0
2013-10-14 09:00:00	MSFT	Stock	33.93	33.95	33.92	33.95	14067.0
2013-10-14 09:30:00	MSFT	Stock	33.94	34.0	33.78	33.98	2514231.0
2013-10-14 10:00:00	MSFT	Stock	33.987	34.08	33.95	34.08	1854277.0
2013-10-14 10:30:00	MSFT	Stock	34.08	34.25	34.06	34.19	2504660.0
2013-10-14 11:00:00	MSFT	Stock	34.19	34.25	34.18	34.21	1213355.0
2013-10-14 11:30:00	MSFT	Stock	34.21	34.35	34.2	34.34	1419920.0
2013-10-14 12:00:00	MSFT	Stock	34.34	34.34	34.24	34.26	1369928.0
2013-10-14 12:30:00	MSFT	Stock	34.255	34.35	34.24	34.313	1462895.0
2013-10-14 13:00:00	MSFT	Stock	34.32	34.33	34.285	34.33	961537.0
2013-10-14 13:30:00	MSFT	Stock	34.325	34.38	34.3	34.37	1212352.0
2013-10-14 14:00:00	MSFT	Stock	34.37	34.46	34.35	34.46	1600672.0
2013-10-14 14:30:00	MSFT	Stock	34.455	34.495	34.41	34.435	1699690.0
2013-10-14 15:00:00	MSFT	Stock	34.437	34.5	34.42	34.49	1950729.0
2013-10-14 15:30:00	MSFT	Stock	34.485	34.5	34.38	34.46	4911566.0
2013-10-14 16:00:00	MSFT	Stock	34.47	34.47	34.161	34.46	1871268.0
2013-10-14 16:30:00	MSFT	Stock	34.462	34.49	34.45	34.47	91028.0
2013-10-14 17:00:00	MSFT	Stock	34.47	34.52	34.47	34.52	36800.0
2013-10-14 17:30:00	MSFT	Stock	34.52	34.52	34.48	34.48	800.0

> showing 50 of 79,876 rows — these rows as CSV

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