PREVIEW / stock_1hour / 2014-04-16

all stock 1-hour files

  file:    by_date/stock_1hour/2014/2014-04-16.parquet
  size:    1.0 MB
  rows:    48,187
  symbols: 3,545

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
2014-04-16 04:00:00	AAPL	Stock	18.5436	18.5464	18.5436	18.5464	5600.0
2014-04-16 05:00:00	AAPL	Stock	18.5464	18.5714	18.5464	18.5714	20972.0
2014-04-16 06:00:00	AAPL	Stock	18.5714	18.5714	18.5536	18.5536	15680.0
2014-04-16 07:00:00	AAPL	Stock	18.5693	18.5793	18.55	18.5736	103544.0
2014-04-16 08:00:00	AAPL	Stock	18.5764	18.5875	18.485	18.4886	559552.0
2014-04-16 09:00:00	AAPL	Stock	18.4886	18.5429	18.3989	18.4064	28257488.0
2014-04-16 10:00:00	AAPL	Stock	18.4007	18.4593	18.362	18.38	29151248.0
2014-04-16 11:00:00	AAPL	Stock	18.3864	18.4982	18.3714	18.4925	20190912.0
2014-04-16 12:00:00	AAPL	Stock	18.4925	18.6104	18.4918	18.5104	33227824.0
2014-04-16 13:00:00	AAPL	Stock	18.5086	18.5425	18.4736	18.5299	14671076.0
2014-04-16 14:00:00	AAPL	Stock	18.5329	18.5329	18.4682	18.5179	11720184.0
2014-04-16 15:00:00	AAPL	Stock	18.5239	18.5386	18.5014	18.5348	24534832.0
2014-04-16 16:00:00	AAPL	Stock	18.5361	18.5398	18.4175	18.5361	7851984.0
2014-04-16 17:00:00	AAPL	Stock	18.5361	18.5361	18.4814	18.4975	904876.0
2014-04-16 18:00:00	AAPL	Stock	18.4875	18.5361	18.4643	18.4807	301784.0
2014-04-16 19:00:00	AAPL	Stock	18.4646	18.4646	18.4357	18.4464	113288.0
2014-04-16 07:00:00	MSFT	Stock	40.0	40.0	40.0	40.0	200.0
2014-04-16 08:00:00	MSFT	Stock	40.05	40.1	39.95	39.95	18478.0
2014-04-16 09:00:00	MSFT	Stock	39.99	40.35	39.94	40.07	5733029.0
2014-04-16 10:00:00	MSFT	Stock	40.07	40.305	39.95	39.985	3411119.0
2014-04-16 11:00:00	MSFT	Stock	39.985	40.13	39.905	40.08	3178991.0
2014-04-16 12:00:00	MSFT	Stock	40.082	40.35	40.06	40.07	3056705.0
2014-04-16 13:00:00	MSFT	Stock	40.06	40.17	39.98	40.17	2473713.0
2014-04-16 14:00:00	MSFT	Stock	40.17	40.215	40.01	40.17	2389849.0
2014-04-16 15:00:00	MSFT	Stock	40.16	40.415	40.06	40.39	7027857.0
2014-04-16 16:00:00	MSFT	Stock	40.4	40.44	40.06	40.4	1679527.0
2014-04-16 17:00:00	MSFT	Stock	40.15	40.4	40.15	40.15	278364.0
2014-04-16 18:00:00	MSFT	Stock	40.18	40.4	40.1	40.4	22283.0
2014-04-16 19:00:00	MSFT	Stock	40.15	40.2	40.15	40.2	342.0
2014-04-16 08:00:00	NVDA	Stock	0.4612	0.4612	0.4612	0.4612	484000.0
2014-04-16 09:00:00	NVDA	Stock	0.4612	0.464	0.4564	0.4578	32436880.0
2014-04-16 10:00:00	NVDA	Stock	0.4578	0.461	0.4565	0.4569	64514480.0
2014-04-16 11:00:00	NVDA	Stock	0.4569	0.46	0.4568	0.4598	19673040.0
2014-04-16 12:00:00	NVDA	Stock	0.46	0.4633	0.4593	0.4593	24211960.0
2014-04-16 13:00:00	NVDA	Stock	0.4593	0.4611	0.4585	0.4604	19135680.0
2014-04-16 14:00:00	NVDA	Stock	0.4603	0.4615	0.459	0.4608	13851000.0
2014-04-16 15:00:00	NVDA	Stock	0.4608	0.4628	0.4605	0.462	45661360.0
2014-04-16 16:00:00	NVDA	Stock	0.4622	0.463	0.4594	0.4622	2225720.0
2014-04-16 17:00:00	NVDA	Stock	0.4622	0.4622	0.4622	0.4622	749280.0
2014-04-16 04:00:00	AMZN	Stock	15.9515	15.9515	15.9515	15.9515	2000.0
2014-04-16 05:00:00	AMZN	Stock	16.0185	16.0185	16.0185	16.0185	2000.0
2014-04-16 06:00:00	AMZN	Stock	15.975	15.975	15.975	15.975	2000.0
2014-04-16 07:00:00	AMZN	Stock	15.97	16.002	15.97	15.97	31600.0
2014-04-16 08:00:00	AMZN	Stock	15.97	16.027	15.97	16.001	281880.0
2014-04-16 09:00:00	AMZN	Stock	16.023	16.0985	15.8065	15.9265	13853620.0
2014-04-16 10:00:00	AMZN	Stock	15.922	15.9815	15.7505	15.775	11754260.0
2014-04-16 11:00:00	AMZN	Stock	15.7805	15.9275	15.7355	15.9275	7251040.0
2014-04-16 12:00:00	AMZN	Stock	15.9215	16.0335	15.8705	15.8705	9026880.0
2014-04-16 13:00:00	AMZN	Stock	15.875	15.9145	15.8075	15.9038	5120080.0
2014-04-16 14:00:00	AMZN	Stock	15.9125	16.035	15.8445	16.0325	5613720.0

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

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