PREVIEW / stock_30min / 2016-07-14

all stock 30-min files

  file:    by_date/stock_30min/2016/2016-07-14.parquet
  size:    1.6 MB
  rows:    82,703
  symbols: 3,287

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
2016-07-14 04:00:00	AAPL	Stock	24.2425	24.3625	24.2425	24.3625	3000.0
2016-07-14 04:30:00	AAPL	Stock	24.35	24.35	24.34	24.35	4608.0
2016-07-14 05:00:00	AAPL	Stock	24.35	24.35	24.34	24.34	3076.0
2016-07-14 05:30:00	AAPL	Stock	24.34	24.3625	24.34	24.3625	4380.0
2016-07-14 06:00:00	AAPL	Stock	24.3625	24.41	24.3625	24.3775	5008.0
2016-07-14 06:30:00	AAPL	Stock	24.38	24.3825	24.3625	24.375	7560.0
2016-07-14 07:00:00	AAPL	Stock	24.3925	24.3925	24.3425	24.37	71672.0
2016-07-14 07:30:00	AAPL	Stock	24.3725	24.3875	24.35	24.3675	45740.0
2016-07-14 08:00:00	AAPL	Stock	24.375	24.375	24.325	24.33	109892.0
2016-07-14 08:30:00	AAPL	Stock	24.325	24.35	24.31	24.345	139208.0
2016-07-14 09:00:00	AAPL	Stock	24.33	24.3575	24.3125	24.34	146700.0
2016-07-14 09:30:00	AAPL	Stock	24.35	24.4475	24.33	24.4225	19847360.0
2016-07-14 10:00:00	AAPL	Stock	24.4225	24.585	24.4175	24.578	18018884.0
2016-07-14 10:30:00	AAPL	Stock	24.58	24.645	24.5712	24.5988	15895488.0
2016-07-14 11:00:00	AAPL	Stock	24.5975	24.6425	24.595	24.62	8236660.0
2016-07-14 11:30:00	AAPL	Stock	24.6192	24.636	24.5875	24.603	7229308.0
2016-07-14 12:00:00	AAPL	Stock	24.605	24.62	24.5825	24.5968	5848596.0
2016-07-14 12:30:00	AAPL	Stock	24.597	24.655	24.595	24.615	6479420.0
2016-07-14 13:00:00	AAPL	Stock	24.615	24.62	24.545	24.5825	5896412.0
2016-07-14 13:30:00	AAPL	Stock	24.5825	24.625	24.5725	24.605	5284372.0
2016-07-14 14:00:00	AAPL	Stock	24.6075	24.6775	24.5862	24.6748	10442268.0
2016-07-14 14:30:00	AAPL	Stock	24.6725	24.72	24.6475	24.6938	7563616.0
2016-07-14 15:00:00	AAPL	Stock	24.6945	24.7475	24.685	24.7118	10014288.0
2016-07-14 15:30:00	AAPL	Stock	24.7112	24.735	24.6925	24.6975	15306412.0
2016-07-14 16:00:00	AAPL	Stock	24.6975	24.7225	24.67	24.6975	7847312.0
2016-07-14 16:30:00	AAPL	Stock	24.6975	24.7025	24.6925	24.6975	32784.0
2016-07-14 17:00:00	AAPL	Stock	24.6975	24.7025	24.69	24.69	2101612.0
2016-07-14 17:30:00	AAPL	Stock	24.6875	24.6975	24.675	24.6775	20844.0
2016-07-14 18:00:00	AAPL	Stock	24.6825	24.6875	24.68	24.68	23100.0
2016-07-14 18:30:00	AAPL	Stock	24.68	24.68	24.655	24.655	5300.0
2016-07-14 19:00:00	AAPL	Stock	24.655	24.6575	24.63	24.645	20912.0
2016-07-14 19:30:00	AAPL	Stock	24.65	24.65	24.635	24.65	48764.0
2016-07-14 04:00:00	MSFT	Stock	53.76	53.76	53.76	53.76	100.0
2016-07-14 04:30:00	MSFT	Stock	53.9	53.9	53.9	53.9	962.0
2016-07-14 05:00:00	MSFT	Stock	53.9	54.0	53.9	54.0	1803.0
2016-07-14 05:30:00	MSFT	Stock	53.99	54.07	53.99	54.07	1535.0
2016-07-14 06:30:00	MSFT	Stock	54.14	54.14	54.14	54.14	100.0
2016-07-14 07:00:00	MSFT	Stock	53.91	53.91	53.89	53.91	2356.0
2016-07-14 07:30:00	MSFT	Stock	53.91	54.04	53.91	54.04	2822.0
2016-07-14 08:00:00	MSFT	Stock	54.0	54.06	53.95	54.01	5442.0
2016-07-14 08:30:00	MSFT	Stock	53.99	54.02	53.98	54.02	7380.0
2016-07-14 09:00:00	MSFT	Stock	54.02	54.07	53.84	53.85	36936.0
2016-07-14 09:30:00	MSFT	Stock	53.84	53.97	53.58	53.76	3149862.0
2016-07-14 10:00:00	MSFT	Stock	53.77	53.95	53.72	53.841	1749145.0
2016-07-14 10:30:00	MSFT	Stock	53.85	53.99	53.81	53.895	1217939.0
2016-07-14 11:00:00	MSFT	Stock	53.9	53.96	53.815	53.86	1204992.0
2016-07-14 11:30:00	MSFT	Stock	53.865	53.865	53.74	53.755	1279151.0
2016-07-14 12:00:00	MSFT	Stock	53.75	53.8	53.7	53.728	1404006.0
2016-07-14 12:30:00	MSFT	Stock	53.72	53.81	53.72	53.76	909186.0
2016-07-14 13:00:00	MSFT	Stock	53.76	53.77	53.66	53.695	889944.0

> showing 50 of 82,703 rows — these rows as CSV

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