PREVIEW / stock_30min / 2013-10-01

all stock 30-min files

  file:    by_date/stock_30min/2013/2013-10-01.parquet
  size:    1.6 MB
  rows:    81,819
  symbols: 3,538

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-01 04:00:00	AAPL	Stock	17.0996	17.1029	17.0479	17.0893	42000.0
2013-10-01 04:30:00	AAPL	Stock	17.0893	17.0893	17.0839	17.0839	30800.0
2013-10-01 05:00:00	AAPL	Stock	17.0893	17.0893	17.0725	17.0882	30800.0
2013-10-01 06:00:00	AAPL	Stock	17.0714	17.0714	17.0571	17.0714	30800.0
2013-10-01 06:30:00	AAPL	Stock	17.0714	17.0714	17.0714	17.0714	2800.0
2013-10-01 07:00:00	AAPL	Stock	17.0904	17.1279	17.0904	17.0925	368676.0
2013-10-01 07:30:00	AAPL	Stock	17.0936	17.0936	17.0393	17.0507	236880.0
2013-10-01 08:00:00	AAPL	Stock	17.0482	17.1179	17.0268	17.0821	1001196.0
2013-10-01 08:30:00	AAPL	Stock	17.0821	17.0982	17.0539	17.0557	819868.0
2013-10-01 09:00:00	AAPL	Stock	17.0564	17.1004	17.055	17.0875	1568672.0
2013-10-01 09:30:00	AAPL	Stock	17.0875	17.2014	17.085	17.1239	42334572.0
2013-10-01 10:00:00	AAPL	Stock	17.1243	17.2621	17.1179	17.26	39431784.0
2013-10-01 10:30:00	AAPL	Stock	17.2557	17.3475	17.2557	17.3161	39352712.0
2013-10-01 11:00:00	AAPL	Stock	17.3246	17.3518	17.3068	17.3336	20350456.0
2013-10-01 11:30:00	AAPL	Stock	17.3336	17.375	17.3296	17.3614	16919448.0
2013-10-01 12:00:00	AAPL	Stock	17.3602	17.4611	17.3575	17.4521	31031476.0
2013-10-01 12:30:00	AAPL	Stock	17.4518	17.4693	17.4054	17.4589	18506544.0
2013-10-01 13:00:00	AAPL	Stock	17.46	17.4686	17.4036	17.4132	17916696.0
2013-10-01 13:30:00	AAPL	Stock	17.4125	17.4221	17.3657	17.3907	15327508.0
2013-10-01 14:00:00	AAPL	Stock	17.3921	17.4375	17.3772	17.3825	15312836.0
2013-10-01 14:30:00	AAPL	Stock	17.3814	17.4243	17.3768	17.3968	12313924.0
2013-10-01 15:00:00	AAPL	Stock	17.3946	17.4036	17.3318	17.3714	17006948.0
2013-10-01 15:30:00	AAPL	Stock	17.3721	17.4318	17.3661	17.4284	30193352.0
2013-10-01 16:00:00	AAPL	Stock	17.4268	17.4518	17.3256	17.4382	8668492.0
2013-10-01 16:30:00	AAPL	Stock	17.4382	17.4464	17.0268	17.0268	12637716.0
2013-10-01 17:00:00	AAPL	Stock	17.4464	17.4564	17.4296	17.4511	390264.0
2013-10-01 17:30:00	AAPL	Stock	17.4489	17.455	17.4289	17.4446	191380.0
2013-10-01 18:00:00	AAPL	Stock	17.445	17.4461	17.4157	17.4232	375956.0
2013-10-01 18:30:00	AAPL	Stock	17.4286	17.4393	17.4214	17.4393	217448.0
2013-10-01 19:00:00	AAPL	Stock	17.4429	17.4429	17.4293	17.4375	62356.0
2013-10-01 19:30:00	AAPL	Stock	17.4304	17.4464	17.4271	17.4429	206808.0
2013-10-01 04:00:00	MSFT	Stock	33.1	33.1	33.1	33.1	100.0
2013-10-01 06:00:00	MSFT	Stock	33.3	33.3	33.3	33.3	200.0
2013-10-01 07:00:00	MSFT	Stock	33.26	33.26	33.25	33.25	200.0
2013-10-01 07:30:00	MSFT	Stock	33.16	33.3	33.16	33.3	600.0
2013-10-01 08:00:00	MSFT	Stock	33.25	33.43	33.25	33.43	27147.0
2013-10-01 08:30:00	MSFT	Stock	33.42	33.44	33.31	33.37	46617.0
2013-10-01 09:00:00	MSFT	Stock	33.37	33.39	33.31	33.31	32905.0
2013-10-01 09:30:00	MSFT	Stock	33.35	33.55	33.3	33.41	5794525.0
2013-10-01 10:00:00	MSFT	Stock	33.41	33.46	33.33	33.43	3232906.0
2013-10-01 10:30:00	MSFT	Stock	33.435	33.6	33.43	33.59	3031251.0
2013-10-01 11:00:00	MSFT	Stock	33.58	33.61	33.45	33.5	2026318.0
2013-10-01 11:30:00	MSFT	Stock	33.5	33.52	33.45	33.51	1588670.0
2013-10-01 12:00:00	MSFT	Stock	33.51	33.565	33.48	33.541	1240717.0
2013-10-01 12:30:00	MSFT	Stock	33.545	33.55	33.35	33.409	1885947.0
2013-10-01 13:00:00	MSFT	Stock	33.41	33.52	33.395	33.51	1538078.0
2013-10-01 13:30:00	MSFT	Stock	33.52	33.52	33.365	33.38	931207.0
2013-10-01 14:00:00	MSFT	Stock	33.39	33.45	33.34	33.385	1397235.0
2013-10-01 14:30:00	MSFT	Stock	33.38	33.46	33.37	33.415	1395017.0
2013-10-01 15:00:00	MSFT	Stock	33.41	33.42	33.355	33.4	1814578.0

> showing 50 of 81,819 rows — these rows as CSV

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