PREVIEW / stock_1hour / 2015-05-20

all stock 1-hour files

  file:    by_date/stock_1hour/2015/2015-05-20.parquet
  size:    1.0 MB
  rows:    48,766
  symbols: 3,517

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-05-20 04:00:00	AAPL	Stock	32.575	32.61	32.5575	32.5625	20652.0
2015-05-20 05:00:00	AAPL	Stock	32.575	32.5825	32.5575	32.5575	10864.0
2015-05-20 06:00:00	AAPL	Stock	32.58	32.6225	32.56	32.6	30324.0
2015-05-20 07:00:00	AAPL	Stock	32.6	32.6	32.5375	32.575	45820.0
2015-05-20 08:00:00	AAPL	Stock	32.575	32.6	32.515	32.565	309428.0
2015-05-20 09:00:00	AAPL	Stock	32.56	32.5825	32.335	32.4275	19296744.0
2015-05-20 10:00:00	AAPL	Stock	32.43	32.57	32.405	32.5075	20983836.0
2015-05-20 11:00:00	AAPL	Stock	32.5062	32.555	32.4252	32.49	11783452.0
2015-05-20 12:00:00	AAPL	Stock	32.4925	32.5175	32.4275	32.47	6256980.0
2015-05-20 13:00:00	AAPL	Stock	32.47	32.4975	32.4275	32.483	7203300.0
2015-05-20 14:00:00	AAPL	Stock	32.485	32.745	32.47	32.6625	30102628.0
2015-05-20 15:00:00	AAPL	Stock	32.6625	32.6925	32.4875	32.5175	26528576.0
2015-05-20 16:00:00	AAPL	Stock	32.515	32.53	32.4478	32.5125	14197148.0
2015-05-20 17:00:00	AAPL	Stock	32.515	32.5225	32.5075	32.515	237120.0
2015-05-20 18:00:00	AAPL	Stock	32.51	32.5125	32.4625	32.4825	329752.0
2015-05-20 19:00:00	AAPL	Stock	32.48	32.4925	32.43	32.445	188328.0
2015-05-20 08:00:00	MSFT	Stock	47.49	47.56	47.47	47.49	2250.0
2015-05-20 09:00:00	MSFT	Stock	47.49	47.62	47.27	47.38	2547897.0
2015-05-20 10:00:00	MSFT	Stock	47.385	47.62	47.34	47.55	2415424.0
2015-05-20 11:00:00	MSFT	Stock	47.545	47.58	47.43	47.48	2212575.0
2015-05-20 12:00:00	MSFT	Stock	47.49	47.64	47.47	47.597	1252406.0
2015-05-20 13:00:00	MSFT	Stock	47.59	47.64	47.482	47.615	2068421.0
2015-05-20 14:00:00	MSFT	Stock	47.61	47.93	47.49	47.8	3941689.0
2015-05-20 15:00:00	MSFT	Stock	47.8	47.82	47.5	47.58	3996225.0
2015-05-20 16:00:00	MSFT	Stock	47.58	47.6	47.54	47.54	4116141.0
2015-05-20 17:00:00	MSFT	Stock	47.54	47.58	47.54	47.58	1200592.0
2015-05-20 18:00:00	MSFT	Stock	47.58	47.63	47.47	47.55	11593.0
2015-05-20 19:00:00	MSFT	Stock	47.5	47.5	47.5	47.5	500.0
2015-05-20 09:00:00	NVDA	Stock	0.5262	0.532	0.5258	0.5298	23425760.0
2015-05-20 10:00:00	NVDA	Stock	0.53	0.5325	0.5293	0.5302	13279720.0
2015-05-20 11:00:00	NVDA	Stock	0.53	0.5302	0.5265	0.5289	16497480.0
2015-05-20 12:00:00	NVDA	Stock	0.5287	0.5298	0.5262	0.5265	19025040.0
2015-05-20 13:00:00	NVDA	Stock	0.5266	0.527	0.526	0.5264	21111880.0
2015-05-20 14:00:00	NVDA	Stock	0.5262	0.5305	0.5262	0.5287	28101760.0
2015-05-20 15:00:00	NVDA	Stock	0.5287	0.529	0.5255	0.526	45661600.0
2015-05-20 16:00:00	NVDA	Stock	0.526	0.526	0.526	0.526	665080.0
2015-05-20 08:00:00	AMZN	Stock	21.1	21.1	21.1	21.1	2000.0
2015-05-20 09:00:00	AMZN	Stock	21.075	21.075	20.918	21.009	6704700.0
2015-05-20 10:00:00	AMZN	Stock	21.006	21.232	20.9505	21.2015	8991520.0
2015-05-20 11:00:00	AMZN	Stock	21.1945	21.214	21.093	21.1128	3124260.0
2015-05-20 12:00:00	AMZN	Stock	21.117	21.14	21.068	21.08	2833540.0
2015-05-20 13:00:00	AMZN	Stock	21.0795	21.154	21.0725	21.154	2090640.0
2015-05-20 14:00:00	AMZN	Stock	21.1555	21.355	21.1465	21.2955	6625360.0
2015-05-20 15:00:00	AMZN	Stock	21.2965	21.3245	21.1885	21.194	5898720.0
2015-05-20 16:00:00	AMZN	Stock	21.193	21.237	21.1845	21.2335	3030700.0
2015-05-20 17:00:00	AMZN	Stock	21.193	21.1975	21.193	21.1975	4000.0
2015-05-20 18:00:00	AMZN	Stock	21.2325	21.2325	21.15	21.15	10600.0
2015-05-20 19:00:00	AMZN	Stock	21.15	21.15	21.15	21.15	4000.0
2015-05-20 08:00:00	GOOGL	Stock	27.5	27.52	27.5	27.52	5600.0
2015-05-20 09:00:00	GOOGL	Stock	27.5505	27.5895	27.255	27.35	2939740.0

> showing 50 of 48,766 rows — these rows as CSV

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