PREVIEW / stock_1hour / 2015-07-20

all stock 1-hour files

  file:    by_date/stock_1hour/2015/2015-07-20.parquet
  size:    1.0 MB
  rows:    49,036
  symbols: 3,507

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-07-20 04:00:00	AAPL	Stock	32.5	32.62	32.5	32.5775	88596.0
2015-07-20 05:00:00	AAPL	Stock	32.6225	32.625	32.575	32.625	53068.0
2015-07-20 06:00:00	AAPL	Stock	32.625	32.7075	32.625	32.6775	123960.0
2015-07-20 07:00:00	AAPL	Stock	32.6875	32.92	32.6875	32.9125	691472.0
2015-07-20 08:00:00	AAPL	Stock	32.92	32.92	32.6375	32.9042	1939552.0
2015-07-20 09:00:00	AAPL	Stock	32.9042	32.985	32.675	32.9225	41773292.0
2015-07-20 10:00:00	AAPL	Stock	32.9225	32.9975	32.7925	32.9825	32235384.0
2015-07-20 11:00:00	AAPL	Stock	32.9828	33.0375	32.94	33.025	25860548.0
2015-07-20 12:00:00	AAPL	Stock	33.023	33.07	33.0088	33.0188	17933144.0
2015-07-20 13:00:00	AAPL	Stock	33.0188	33.0865	33.0125	33.0475	15817460.0
2015-07-20 14:00:00	AAPL	Stock	33.045	33.2075	33.0425	33.185	22298468.0
2015-07-20 15:00:00	AAPL	Stock	33.1828	33.2425	32.955	33.0175	38175100.0
2015-07-20 16:00:00	AAPL	Stock	33.0175	33.0672	32.9975	33.01	6192436.0
2015-07-20 17:00:00	AAPL	Stock	33.0175	33.17	33.0125	33.16	9978724.0
2015-07-20 18:00:00	AAPL	Stock	33.1625	33.1675	33.075	33.125	376264.0
2015-07-20 19:00:00	AAPL	Stock	33.125	33.1425	33.1125	33.13	233768.0
2015-07-20 07:00:00	MSFT	Stock	46.85	46.85	46.59	46.7	4535.0
2015-07-20 08:00:00	MSFT	Stock	46.86	46.86	46.6	46.687	18046.0
2015-07-20 09:00:00	MSFT	Stock	46.69	46.77	46.44	46.51	3509930.0
2015-07-20 10:00:00	MSFT	Stock	46.5	46.65	46.47	46.611	3930232.0
2015-07-20 11:00:00	MSFT	Stock	46.614	46.83	46.59	46.81	3167585.0
2015-07-20 12:00:00	MSFT	Stock	46.81	46.86	46.63	46.64	2748790.0
2015-07-20 13:00:00	MSFT	Stock	46.64	46.885	46.62	46.815	3242533.0
2015-07-20 14:00:00	MSFT	Stock	46.815	47.13	46.81	47.04	4072773.0
2015-07-20 15:00:00	MSFT	Stock	47.04	47.08	46.89	46.92	4680497.0
2015-07-20 16:00:00	MSFT	Stock	46.92	46.92	46.74	46.9	3536076.0
2015-07-20 17:00:00	MSFT	Stock	46.93	47.0	46.87	46.87	10614.0
2015-07-20 18:00:00	MSFT	Stock	46.9	46.92	46.87	46.92	1360.0
2015-07-20 19:00:00	MSFT	Stock	46.88	46.9	46.88	46.9	2000.0
2015-07-20 07:00:00	NVDA	Stock	0.5075	0.5075	0.5075	0.5075	8000.0
2015-07-20 09:00:00	NVDA	Stock	0.5018	0.5038	0.5003	0.5006	20605920.0
2015-07-20 10:00:00	NVDA	Stock	0.5005	0.5011	0.498	0.5003	20360920.0
2015-07-20 11:00:00	NVDA	Stock	0.5003	0.5008	0.4958	0.4958	23933680.0
2015-07-20 12:00:00	NVDA	Stock	0.496	0.4968	0.4948	0.495	19414920.0
2015-07-20 13:00:00	NVDA	Stock	0.4951	0.4952	0.4923	0.4923	19170680.0
2015-07-20 14:00:00	NVDA	Stock	0.4923	0.4932	0.4915	0.4931	16458680.0
2015-07-20 15:00:00	NVDA	Stock	0.493	0.4942	0.4912	0.4925	49082680.0
2015-07-20 16:00:00	NVDA	Stock	0.4925	0.4925	0.4925	0.4925	387800.0
2015-07-20 17:00:00	NVDA	Stock	0.4928	0.4928	0.4928	0.4928	200000.0
2015-07-20 19:00:00	NVDA	Stock	0.494	0.494	0.494	0.494	4000.0
2015-07-20 06:00:00	AMZN	Stock	24.25	24.5	24.25	24.5	89460.0
2015-07-20 07:00:00	AMZN	Stock	24.5085	24.594	24.5	24.525	147860.0
2015-07-20 08:00:00	AMZN	Stock	24.5245	24.645	24.4445	24.575	1092180.0
2015-07-20 09:00:00	AMZN	Stock	24.5745	24.6745	24.414	24.527	25261720.0
2015-07-20 10:00:00	AMZN	Stock	24.5285	24.558	24.27	24.4585	18400580.0
2015-07-20 11:00:00	AMZN	Stock	24.4585	24.5145	24.4495	24.489	7624180.0
2015-07-20 12:00:00	AMZN	Stock	24.4855	24.4985	24.42	24.479	4447900.0
2015-07-20 13:00:00	AMZN	Stock	24.485	24.5045	24.424	24.4325	4556800.0
2015-07-20 14:00:00	AMZN	Stock	24.4298	24.521	24.425	24.5034	7761860.0
2015-07-20 15:00:00	AMZN	Stock	24.5035	24.5115	24.35	24.4015	12154320.0

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

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