PREVIEW / stock_30min / 2015-11-12

all stock 30-min files

  file:    by_date/stock_30min/2015/2015-11-12.parquet
  size:    1.6 MB
  rows:    81,717
  symbols: 3,403

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
2015-11-12 04:00:00	AAPL	Stock	29.11	29.1175	29.04	29.1175	1248.0
2015-11-12 05:00:00	AAPL	Stock	29.0325	29.0325	29.0	29.0	800.0
2015-11-12 05:30:00	AAPL	Stock	29.0975	29.0975	29.0225	29.0225	5200.0
2015-11-12 06:30:00	AAPL	Stock	29.025	29.025	29.025	29.025	800.0
2015-11-12 07:30:00	AAPL	Stock	28.97	29.0	28.96	29.0	9956.0
2015-11-12 08:00:00	AAPL	Stock	28.9725	29.0125	28.9475	28.9925	140536.0
2015-11-12 08:30:00	AAPL	Stock	28.9825	29.019	28.9625	28.99	62384.0
2015-11-12 09:00:00	AAPL	Stock	28.9975	29.08	28.875	29.06	447088.0
2015-11-12 09:30:00	AAPL	Stock	29.0725	29.125	28.9275	29.0825	22347652.0
2015-11-12 10:00:00	AAPL	Stock	29.08	29.205	29.0	29.0372	14896124.0
2015-11-12 10:30:00	AAPL	Stock	29.035	29.11	28.97	29.09	8441024.0
2015-11-12 11:00:00	AAPL	Stock	29.09	29.125	29.01	29.0192	6536272.0
2015-11-12 11:30:00	AAPL	Stock	29.0175	29.0335	28.9795	29.0225	5319948.0
2015-11-12 12:00:00	AAPL	Stock	29.0225	29.0275	28.915	28.965	5565020.0
2015-11-12 12:30:00	AAPL	Stock	28.9638	29.0225	28.935	28.9625	5706772.0
2015-11-12 13:00:00	AAPL	Stock	28.9625	29.015	28.9325	28.98	5334480.0
2015-11-12 13:30:00	AAPL	Stock	28.98	29.025	28.955	28.9825	4252896.0
2015-11-12 14:00:00	AAPL	Stock	28.9825	29.0375	28.9438	29.035	5996376.0
2015-11-12 14:30:00	AAPL	Stock	29.0375	29.0575	28.9388	28.9525	7111444.0
2015-11-12 15:00:00	AAPL	Stock	28.9525	29.0462	28.9125	29.0175	8250076.0
2015-11-12 15:30:00	AAPL	Stock	29.0188	29.0275	28.9325	28.935	14287916.0
2015-11-12 16:00:00	AAPL	Stock	28.93	29.0398	28.9175	28.9325	4371012.0
2015-11-12 16:30:00	AAPL	Stock	28.935	29.017	28.9125	28.9275	85448.0
2015-11-12 17:00:00	AAPL	Stock	28.9275	28.9325	28.9125	28.9125	33928.0
2015-11-12 17:30:00	AAPL	Stock	28.9125	28.9125	28.9	28.905	35808.0
2015-11-12 18:00:00	AAPL	Stock	28.9075	28.92	28.895	28.895	32064.0
2015-11-12 18:30:00	AAPL	Stock	28.8975	28.9175	28.8975	28.9025	43260.0
2015-11-12 19:00:00	AAPL	Stock	28.915	28.93	28.9025	28.9125	26036.0
2015-11-12 19:30:00	AAPL	Stock	28.9025	28.9025	28.8925	28.8975	20552.0
2015-11-12 04:00:00	MSFT	Stock	53.77	53.77	53.77	53.77	1000.0
2015-11-12 05:00:00	MSFT	Stock	53.65	53.65	53.65	53.65	167.0
2015-11-12 07:00:00	MSFT	Stock	53.69	53.69	53.69	53.69	200.0
2015-11-12 07:30:00	MSFT	Stock	53.67	53.67	53.67	53.67	500.0
2015-11-12 08:00:00	MSFT	Stock	53.53	53.6	53.41	53.57	2100.0
2015-11-12 08:30:00	MSFT	Stock	53.4	53.53	53.4	53.4	8022.0
2015-11-12 09:00:00	MSFT	Stock	53.414	53.43	53.25	53.4	9258.0
2015-11-12 09:30:00	MSFT	Stock	53.48	53.5	53.19	53.37	4575093.0
2015-11-12 10:00:00	MSFT	Stock	53.375	53.51	53.3	53.375	3881116.0
2015-11-12 10:30:00	MSFT	Stock	53.37	53.535	53.32	53.47	2792388.0
2015-11-12 11:00:00	MSFT	Stock	53.47	53.555	53.42	53.47	1863266.0
2015-11-12 11:30:00	MSFT	Stock	53.46	53.57	53.415	53.555	1624671.0
2015-11-12 12:00:00	MSFT	Stock	53.55	53.62	53.48	53.57	1268293.0
2015-11-12 12:30:00	MSFT	Stock	53.57	53.88	53.53	53.84	1421962.0
2015-11-12 13:00:00	MSFT	Stock	53.845	53.97	53.74	53.97	1641302.0
2015-11-12 13:30:00	MSFT	Stock	53.97	53.979	53.8	53.885	1433233.0
2015-11-12 14:00:00	MSFT	Stock	53.88	53.91	53.67	53.753	1804457.0
2015-11-12 14:30:00	MSFT	Stock	53.76	53.81	53.44	53.575	1702531.0
2015-11-12 15:00:00	MSFT	Stock	53.56	53.635	53.53	53.57	1756774.0
2015-11-12 15:30:00	MSFT	Stock	53.574	53.61	53.3	53.32	3680189.0
2015-11-12 16:00:00	MSFT	Stock	53.32	53.753	53.2	53.2	3117347.0

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

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