PREVIEW / stock_1hour / 2014-04-14

all stock 1-hour files

  file:    by_date/stock_1hour/2014/2014-04-14.parquet
  size:    1.0 MB
  rows:    49,249
  symbols: 3,558

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-14 04:00:00	AAPL	Stock	18.5375	18.5382	18.5375	18.5382	5600.0
2014-04-14 05:00:00	AAPL	Stock	18.5039	18.5039	18.4989	18.4989	8400.0
2014-04-14 06:00:00	AAPL	Stock	18.4825	18.5004	18.4643	18.5	83720.0
2014-04-14 07:00:00	AAPL	Stock	18.5357	18.6071	18.5107	18.6071	54992.0
2014-04-14 08:00:00	AAPL	Stock	18.5893	18.6696	18.5232	18.6668	467432.0
2014-04-14 09:00:00	AAPL	Stock	18.6579	18.6761	18.4821	18.4965	30365664.0
2014-04-14 10:00:00	AAPL	Stock	18.4964	18.555	18.4821	18.4896	29983100.0
2014-04-14 11:00:00	AAPL	Stock	18.4925	18.5964	18.4718	18.5582	21415940.0
2014-04-14 12:00:00	AAPL	Stock	18.5589	18.5936	18.5182	18.5686	12191564.0
2014-04-14 13:00:00	AAPL	Stock	18.5664	18.5857	18.5211	18.5268	9992668.0
2014-04-14 14:00:00	AAPL	Stock	18.5289	18.5786	18.5129	18.5507	12156144.0
2014-04-14 15:00:00	AAPL	Stock	18.5507	18.6486	18.4968	18.6319	32166316.0
2014-04-14 16:00:00	AAPL	Stock	18.6314	18.6511	18.5187	18.6379	15157856.0
2014-04-14 17:00:00	AAPL	Stock	18.6357	18.6357	18.6271	18.6321	248528.0
2014-04-14 18:00:00	AAPL	Stock	18.6268	18.6329	18.6125	18.6329	645960.0
2014-04-14 19:00:00	AAPL	Stock	18.6329	18.6339	18.6196	18.6321	68572.0
2014-04-14 04:00:00	MSFT	Stock	39.24	39.24	38.94	38.94	2660.0
2014-04-14 05:00:00	MSFT	Stock	38.9	38.9	38.9	38.9	300.0
2014-04-14 06:00:00	MSFT	Stock	38.9	38.9	38.88	38.88	700.0
2014-04-14 07:00:00	MSFT	Stock	38.9	38.93	38.9	38.93	3100.0
2014-04-14 08:00:00	MSFT	Stock	39.07	39.09	38.92	39.05	48517.0
2014-04-14 09:00:00	MSFT	Stock	39.04	39.4	38.9	38.92	5853002.0
2014-04-14 10:00:00	MSFT	Stock	38.93	39.19	38.9	39.18	5091119.0
2014-04-14 11:00:00	MSFT	Stock	39.19	39.41	39.17	39.26	4052024.0
2014-04-14 12:00:00	MSFT	Stock	39.26	39.35	39.2	39.32	1630878.0
2014-04-14 13:00:00	MSFT	Stock	39.32	39.326	39.104	39.11	1481331.0
2014-04-14 14:00:00	MSFT	Stock	39.11	39.21	39.05	39.075	3121473.0
2014-04-14 15:00:00	MSFT	Stock	39.08	39.22	38.9	39.18	7695582.0
2014-04-14 16:00:00	MSFT	Stock	39.18	39.22	39.097	39.207	2205862.0
2014-04-14 17:00:00	MSFT	Stock	39.22	39.22	39.18	39.2	9397.0
2014-04-14 18:00:00	MSFT	Stock	39.22	39.23	39.22	39.22	1140.0
2014-04-14 08:00:00	NVDA	Stock	0.453	0.453	0.453	0.453	632000.0
2014-04-14 09:00:00	NVDA	Stock	0.455	0.4588	0.453	0.4588	39182400.0
2014-04-14 10:00:00	NVDA	Stock	0.4588	0.4598	0.4562	0.459	38039200.0
2014-04-14 11:00:00	NVDA	Stock	0.459	0.4593	0.4566	0.4566	16013200.0
2014-04-14 12:00:00	NVDA	Stock	0.4565	0.458	0.4562	0.4572	28272560.0
2014-04-14 13:00:00	NVDA	Stock	0.4572	0.4582	0.4555	0.4555	20189480.0
2014-04-14 14:00:00	NVDA	Stock	0.4555	0.457	0.454	0.4544	34142440.0
2014-04-14 15:00:00	NVDA	Stock	0.4544	0.4582	0.4538	0.458	90210520.0
2014-04-14 16:00:00	NVDA	Stock	0.458	0.4585	0.458	0.4581	3824520.0
2014-04-14 17:00:00	NVDA	Stock	0.458	0.458	0.458	0.458	24840.0
2014-04-14 06:00:00	AMZN	Stock	15.5865	15.5865	15.5865	15.5865	2000.0
2014-04-14 07:00:00	AMZN	Stock	15.6025	15.6025	15.6025	15.6025	2000.0
2014-04-14 08:00:00	AMZN	Stock	15.665	15.85	15.665	15.8	81680.0
2014-04-14 09:00:00	AMZN	Stock	15.7795	15.925	15.7165	15.7649	12459780.0
2014-04-14 10:00:00	AMZN	Stock	15.7598	16.0105	15.622	15.9906	18251060.0
2014-04-14 11:00:00	AMZN	Stock	15.9915	16.024	15.775	15.7925	6819260.0
2014-04-14 12:00:00	AMZN	Stock	15.7905	15.844	15.75	15.7578	3977000.0
2014-04-14 13:00:00	AMZN	Stock	15.7655	15.77	15.6055	15.6055	6411580.0
2014-04-14 14:00:00	AMZN	Stock	15.606	15.7075	15.564	15.6485	9105200.0

> showing 50 of 49,249 rows — these rows as CSV

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