PREVIEW / stock_1hour / 2016-04-27

all stock 1-hour files

  file:    by_date/stock_1hour/2016/2016-04-27.parquet
  size:    1.0 MB
  rows:    48,422
  symbols: 3,327

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-04-27 04:00:00	AAPL	Stock	24.6875	24.6875	24.185	24.28	413384.0
2016-04-27 05:00:00	AAPL	Stock	24.2725	24.275	24.1675	24.1875	207016.0
2016-04-27 06:00:00	AAPL	Stock	24.18	24.1975	24.05	24.145	778164.0
2016-04-27 07:00:00	AAPL	Stock	24.1375	24.1725	23.895	23.95	2890772.0
2016-04-27 08:00:00	AAPL	Stock	23.95	24.1875	23.9125	24.0225	8042228.0
2016-04-27 09:00:00	AAPL	Stock	24.015	24.6775	23.92	24.1575	117155704.0
2016-04-27 10:00:00	AAPL	Stock	24.1592	24.4925	24.135	24.45	80618812.0
2016-04-27 11:00:00	AAPL	Stock	24.4513	24.675	24.41	24.5975	58677152.0
2016-04-27 12:00:00	AAPL	Stock	24.5975	24.6075	24.425	24.445	32367580.0
2016-04-27 13:00:00	AAPL	Stock	24.445	24.495	24.3638	24.44	25223372.0
2016-04-27 14:00:00	AAPL	Stock	24.4422	24.5475	24.3575	24.3875	33161096.0
2016-04-27 15:00:00	AAPL	Stock	24.385	24.4925	24.36	24.4525	42713224.0
2016-04-27 16:00:00	AAPL	Stock	24.455	24.558	24.385	24.45	15741660.0
2016-04-27 17:00:00	AAPL	Stock	24.4525	24.4925	24.445	24.475	348972.0
2016-04-27 18:00:00	AAPL	Stock	24.475	24.4925	24.475	24.475	164076.0
2016-04-27 19:00:00	AAPL	Stock	24.485	24.5	24.475	24.5	110900.0
2016-04-27 05:00:00	MSFT	Stock	51.31	51.31	51.31	51.31	900.0
2016-04-27 06:00:00	MSFT	Stock	51.2	51.2	51.2	51.2	100.0
2016-04-27 07:00:00	MSFT	Stock	51.29	51.3	51.22	51.24	7100.0
2016-04-27 08:00:00	MSFT	Stock	51.22	52.12	51.2	51.35	8482.0
2016-04-27 09:00:00	MSFT	Stock	51.34	51.5	51.07	51.109	4476727.0
2016-04-27 10:00:00	MSFT	Stock	51.1	51.15	50.55	50.805	7643690.0
2016-04-27 11:00:00	MSFT	Stock	50.81	51.035	50.69	50.97	4387678.0
2016-04-27 12:00:00	MSFT	Stock	50.97	50.97	50.7	50.873	3390854.0
2016-04-27 13:00:00	MSFT	Stock	50.875	50.9	50.58	50.7	3805901.0
2016-04-27 14:00:00	MSFT	Stock	50.715	50.94	50.56	50.7	5569043.0
2016-04-27 15:00:00	MSFT	Stock	50.7	51.1	50.665	50.94	7957293.0
2016-04-27 16:00:00	MSFT	Stock	50.94	51.44	50.91	50.96	3244850.0
2016-04-27 17:00:00	MSFT	Stock	50.94	51.0	50.94	50.99	126004.0
2016-04-27 18:00:00	MSFT	Stock	51.0	51.0	50.9	50.98	2416.0
2016-04-27 19:00:00	MSFT	Stock	50.97	51.0	50.96	51.0	2930.0
2016-04-27 09:00:00	NVDA	Stock	0.9098	0.924	0.9081	0.9123	29974240.0
2016-04-27 10:00:00	NVDA	Stock	0.9123	0.921	0.91	0.92	73638720.0
2016-04-27 11:00:00	NVDA	Stock	0.92	0.9262	0.9158	0.9249	39513080.0
2016-04-27 12:00:00	NVDA	Stock	0.9248	0.928	0.9238	0.9275	26368560.0
2016-04-27 13:00:00	NVDA	Stock	0.9275	0.9278	0.9228	0.9232	26093200.0
2016-04-27 14:00:00	NVDA	Stock	0.9235	0.9275	0.921	0.9265	40419920.0
2016-04-27 15:00:00	NVDA	Stock	0.9262	0.9332	0.9258	0.9325	74884440.0
2016-04-27 16:00:00	NVDA	Stock	0.9328	0.9328	0.912	0.9328	749560.0
2016-04-27 17:00:00	NVDA	Stock	0.9328	0.9338	0.9328	0.9338	11920.0
2016-04-27 18:00:00	NVDA	Stock	0.9338	0.935	0.9328	0.935	33480.0
2016-04-27 05:00:00	AMZN	Stock	30.59	30.59	30.59	30.59	2000.0
2016-04-27 07:00:00	AMZN	Stock	30.5745	30.5745	30.535	30.565	8800.0
2016-04-27 08:00:00	AMZN	Stock	30.55	30.6	30.5255	30.575	86420.0
2016-04-27 09:00:00	AMZN	Stock	30.575	30.7975	30.375	30.4084	10852140.0
2016-04-27 10:00:00	AMZN	Stock	30.4155	30.453	30.064	30.2355	16282080.0
2016-04-27 11:00:00	AMZN	Stock	30.239	30.4085	30.2248	30.3851	7893800.0
2016-04-27 12:00:00	AMZN	Stock	30.3715	30.428	30.315	30.3565	4922820.0
2016-04-27 13:00:00	AMZN	Stock	30.3575	30.3575	30.1595	30.205	4395760.0
2016-04-27 14:00:00	AMZN	Stock	30.2035	30.3295	30.101	30.219	7248040.0

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

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