PREVIEW / stock_1hour / 2015-07-10

all stock 1-hour files

  file:    by_date/stock_1hour/2015/2015-07-10.parquet
  size:    1.0 MB
  rows:    48,966
  symbols: 3,493

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-10 04:00:00	AAPL	Stock	30.45	30.45	30.31	30.31	45692.0
2015-07-10 05:00:00	AAPL	Stock	30.3125	30.375	30.305	30.375	23584.0
2015-07-10 06:00:00	AAPL	Stock	30.3725	30.425	30.3525	30.425	98056.0
2015-07-10 07:00:00	AAPL	Stock	30.4325	30.5	30.35	30.395	476460.0
2015-07-10 08:00:00	AAPL	Stock	30.385	30.5	30.3625	30.455	1512340.0
2015-07-10 09:00:00	AAPL	Stock	30.455	30.555	30.3025	30.5125	43082644.0
2015-07-10 10:00:00	AAPL	Stock	30.51	30.785	30.5075	30.723	58532392.0
2015-07-10 11:00:00	AAPL	Stock	30.7262	30.8175	30.7175	30.7725	27656388.0
2015-07-10 12:00:00	AAPL	Stock	30.7725	30.7875	30.6	30.76	20414552.0
2015-07-10 13:00:00	AAPL	Stock	30.76	30.7925	30.71	30.7818	12521168.0
2015-07-10 14:00:00	AAPL	Stock	30.78	30.9562	30.7675	30.9148	22335188.0
2015-07-10 15:00:00	AAPL	Stock	30.915	30.9625	30.8125	30.815	32044432.0
2015-07-10 16:00:00	AAPL	Stock	30.815	30.8575	30.66	30.79	11677016.0
2015-07-10 17:00:00	AAPL	Stock	30.78	30.8175	30.77	30.8175	141620.0
2015-07-10 18:00:00	AAPL	Stock	30.8125	30.8375	30.8	30.8375	81368.0
2015-07-10 19:00:00	AAPL	Stock	30.8275	30.835	30.82	30.83	74968.0
2015-07-10 04:00:00	MSFT	Stock	45.04	45.04	45.02	45.02	300.0
2015-07-10 06:00:00	MSFT	Stock	45.0	45.0	44.95	44.95	300.0
2015-07-10 07:00:00	MSFT	Stock	45.0	45.01	45.0	45.01	3300.0
2015-07-10 08:00:00	MSFT	Stock	44.95	45.05	44.85	45.0	34329.0
2015-07-10 09:00:00	MSFT	Stock	45.0	45.17	44.8	44.81	2629158.0
2015-07-10 10:00:00	MSFT	Stock	44.81	44.96	44.63	44.83	3188858.0
2015-07-10 11:00:00	MSFT	Stock	44.83	45.11	44.82	45.01	3062004.0
2015-07-10 12:00:00	MSFT	Stock	45.015	45.09	44.875	44.93	2702475.0
2015-07-10 13:00:00	MSFT	Stock	44.93	44.96	44.67	44.746	2534517.0
2015-07-10 14:00:00	MSFT	Stock	44.75	44.92	44.72	44.885	2730466.0
2015-07-10 15:00:00	MSFT	Stock	44.89	44.92	44.57	44.59	5514890.0
2015-07-10 16:00:00	MSFT	Stock	44.59	45.055	44.59	44.6	1891935.0
2015-07-10 17:00:00	MSFT	Stock	44.58	44.677	44.58	44.677	350.0
2015-07-10 18:00:00	MSFT	Stock	44.61	44.697	44.57	44.697	600.0
2015-07-10 08:00:00	NVDA	Stock	0.4975	0.4975	0.4975	0.4975	4000.0
2015-07-10 09:00:00	NVDA	Stock	0.497	0.4972	0.4902	0.4972	29778920.0
2015-07-10 10:00:00	NVDA	Stock	0.4971	0.4982	0.4942	0.496	39493720.0
2015-07-10 11:00:00	NVDA	Stock	0.4958	0.4975	0.4945	0.496	27155120.0
2015-07-10 12:00:00	NVDA	Stock	0.496	0.4963	0.4945	0.4955	19691960.0
2015-07-10 13:00:00	NVDA	Stock	0.4958	0.496	0.4945	0.4948	22817320.0
2015-07-10 14:00:00	NVDA	Stock	0.4949	0.4968	0.4945	0.495	15858400.0
2015-07-10 15:00:00	NVDA	Stock	0.4952	0.4958	0.493	0.4938	47444200.0
2015-07-10 16:00:00	NVDA	Stock	0.4938	0.4938	0.4938	0.4938	9780360.0
2015-07-10 19:00:00	NVDA	Stock	0.4963	0.4963	0.4963	0.4963	52000.0
2015-07-10 07:00:00	AMZN	Stock	21.95	21.989	21.95	21.989	12080.0
2015-07-10 08:00:00	AMZN	Stock	21.975	21.999	21.95	21.9874	108200.0
2015-07-10 09:00:00	AMZN	Stock	21.971	22.05	21.955	21.9635	5862140.0
2015-07-10 10:00:00	AMZN	Stock	21.968	22.0625	21.95	22.0625	6629640.0
2015-07-10 11:00:00	AMZN	Stock	22.0615	22.236	22.056	22.176	7081640.0
2015-07-10 12:00:00	AMZN	Stock	22.1855	22.2133	22.1655	22.184	3239640.0
2015-07-10 13:00:00	AMZN	Stock	22.184	22.192	22.102	22.134	2607300.0
2015-07-10 14:00:00	AMZN	Stock	22.13	22.22	22.121	22.199	4188900.0
2015-07-10 15:00:00	AMZN	Stock	22.1995	22.207	22.1475	22.1755	8156720.0
2015-07-10 16:00:00	AMZN	Stock	22.1755	22.2088	21.9917	22.1915	2700140.0

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

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