PREVIEW / stock_30min / 2013-08-30

all stock 30-min files

  file:    by_date/stock_30min/2013/2013-08-30.parquet
  size:    1.5 MB
  rows:    77,572
  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-08-30 04:00:00	AAPL	Stock	17.5893	17.5893	17.5893	17.5893	8400.0
2013-08-30 05:00:00	AAPL	Stock	17.5864	17.5864	17.5864	17.5864	3360.0
2013-08-30 05:30:00	AAPL	Stock	17.6071	17.6071	17.6071	17.6071	2800.0
2013-08-30 07:00:00	AAPL	Stock	17.6107	17.6393	17.6089	17.6089	104636.0
2013-08-30 07:30:00	AAPL	Stock	17.5861	17.6036	17.5714	17.6036	118804.0
2013-08-30 08:00:00	AAPL	Stock	17.6018	17.625	17.5846	17.5914	673708.0
2013-08-30 08:30:00	AAPL	Stock	17.5954	17.5993	17.5732	17.5811	474712.0
2013-08-30 09:00:00	AAPL	Stock	17.5864	17.5982	17.5714	17.5714	324408.0
2013-08-30 09:30:00	AAPL	Stock	17.5714	17.6054	17.5125	17.5404	40666668.0
2013-08-30 10:00:00	AAPL	Stock	17.5404	17.5404	17.4214	17.4457	34090616.0
2013-08-30 10:30:00	AAPL	Stock	17.4446	17.5036	17.4111	17.4218	22583596.0
2013-08-30 11:00:00	AAPL	Stock	17.42	17.4514	17.3768	17.4157	20854988.0
2013-08-30 11:30:00	AAPL	Stock	17.4139	17.4286	17.3786	17.3839	14118524.0
2013-08-30 12:00:00	AAPL	Stock	17.3825	17.4554	17.375	17.4325	15472744.0
2013-08-30 12:30:00	AAPL	Stock	17.4325	17.4439	17.4136	17.4414	6515264.0
2013-08-30 13:00:00	AAPL	Stock	17.4389	17.4461	17.375	17.4429	17633280.0
2013-08-30 13:30:00	AAPL	Stock	17.4429	17.4543	17.4033	17.4146	10906028.0
2013-08-30 14:00:00	AAPL	Stock	17.4129	17.4396	17.3989	17.4332	8526840.0
2013-08-30 14:30:00	AAPL	Stock	17.4304	17.4521	17.4143	17.4307	8666084.0
2013-08-30 15:00:00	AAPL	Stock	17.4289	17.4457	17.4136	17.425	8822464.0
2013-08-30 15:30:00	AAPL	Stock	17.425	17.4296	17.3796	17.4029	32623780.0
2013-08-30 16:00:00	AAPL	Stock	17.3946	17.4481	17.3877	17.4243	26337752.0
2013-08-30 16:30:00	AAPL	Stock	17.3912	17.4392	17.3912	17.4114	624316.0
2013-08-30 17:00:00	AAPL	Stock	17.4143	17.4268	17.4143	17.4268	25340.0
2013-08-30 17:30:00	AAPL	Stock	17.4107	17.4207	17.4107	17.4207	26320.0
2013-08-30 18:00:00	AAPL	Stock	17.4082	17.4082	17.4018	17.4018	29876.0
2013-08-30 18:30:00	AAPL	Stock	17.4064	17.4196	17.4064	17.4189	39480.0
2013-08-30 19:00:00	AAPL	Stock	17.4125	17.4125	17.4107	17.4114	21196.0
2013-08-30 19:30:00	AAPL	Stock	17.4139	17.4196	17.4139	17.4196	42420.0
2013-08-30 04:30:00	MSFT	Stock	33.49	33.49	33.49	33.49	300.0
2013-08-30 05:00:00	MSFT	Stock	33.49	33.49	33.49	33.49	500.0
2013-08-30 05:30:00	MSFT	Stock	33.49	33.49	33.49	33.49	100.0
2013-08-30 06:00:00	MSFT	Stock	33.49	33.49	33.49	33.49	700.0
2013-08-30 06:30:00	MSFT	Stock	33.49	33.49	33.49	33.49	4587.0
2013-08-30 07:30:00	MSFT	Stock	33.49	33.54	33.49	33.54	1900.0
2013-08-30 08:00:00	MSFT	Stock	33.52	33.54	33.5	33.5	3400.0
2013-08-30 08:30:00	MSFT	Stock	33.5	33.52	33.45	33.52	8439.0
2013-08-30 09:00:00	MSFT	Stock	33.46	33.52	33.2	33.38	118487.0
2013-08-30 09:30:00	MSFT	Stock	33.37	33.48	33.25	33.295	4631909.0
2013-08-30 10:00:00	MSFT	Stock	33.29	33.34	33.22	33.23	3502273.0
2013-08-30 10:30:00	MSFT	Stock	33.23	33.26	33.09	33.203	2426647.0
2013-08-30 11:00:00	MSFT	Stock	33.2	33.31	33.185	33.245	1709599.0
2013-08-30 11:30:00	MSFT	Stock	33.24	33.29	33.19	33.26	1733138.0
2013-08-30 12:00:00	MSFT	Stock	33.255	33.29	33.215	33.265	1247029.0
2013-08-30 12:30:00	MSFT	Stock	33.27	33.27	33.165	33.22	1633130.0
2013-08-30 13:00:00	MSFT	Stock	33.22	33.46	33.13	33.46	2748288.0
2013-08-30 13:30:00	MSFT	Stock	33.455	33.46	33.37	33.385	1491165.0
2013-08-30 14:00:00	MSFT	Stock	33.38	33.39	33.34	33.37	1591669.0
2013-08-30 14:30:00	MSFT	Stock	33.36	33.45	33.36	33.39	1285624.0
2013-08-30 15:00:00	MSFT	Stock	33.39	33.44	33.37	33.4	2005491.0

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

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