PREVIEW / stock_1hour / 2015-07-15

all stock 1-hour files

  file:    by_date/stock_1hour/2015/2015-07-15.parquet
  size:    1.0 MB
  rows:    48,943
  symbols: 3,489

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-15 04:00:00	AAPL	Stock	31.4825	31.5875	31.4825	31.5075	6800.0
2015-07-15 05:00:00	AAPL	Stock	31.505	31.505	31.4725	31.4725	3252.0
2015-07-15 06:00:00	AAPL	Stock	31.4075	31.4875	31.4075	31.42	5052.0
2015-07-15 07:00:00	AAPL	Stock	31.4875	31.5025	31.45	31.5	72204.0
2015-07-15 08:00:00	AAPL	Stock	31.4975	31.505	31.4075	31.4775	332132.0
2015-07-15 09:00:00	AAPL	Stock	31.475	31.5475	31.395	31.504	19852608.0
2015-07-15 10:00:00	AAPL	Stock	31.505	31.735	31.4925	31.73	26412104.0
2015-07-15 11:00:00	AAPL	Stock	31.7302	31.7875	31.6275	31.6775	19797048.0
2015-07-15 12:00:00	AAPL	Stock	31.6775	31.7275	31.65	31.6775	8144376.0
2015-07-15 13:00:00	AAPL	Stock	31.6758	31.7025	31.6525	31.6948	6862876.0
2015-07-15 14:00:00	AAPL	Stock	31.6948	31.7675	31.6025	31.659	16722072.0
2015-07-15 15:00:00	AAPL	Stock	31.6575	31.7225	31.635	31.7075	18776576.0
2015-07-15 16:00:00	AAPL	Stock	31.705	31.7875	31.695	31.7592	8163064.0
2015-07-15 17:00:00	AAPL	Stock	31.75	31.7775	31.75	31.75	61436.0
2015-07-15 18:00:00	AAPL	Stock	31.7625	31.795	31.7375	31.795	154212.0
2015-07-15 19:00:00	AAPL	Stock	31.8075	31.835	31.795	31.825	146844.0
2015-07-15 08:00:00	MSFT	Stock	45.8	45.8	45.74	45.74	1700.0
2015-07-15 09:00:00	MSFT	Stock	45.72	45.74	45.43	45.655	2925245.0
2015-07-15 10:00:00	MSFT	Stock	45.66	45.826	45.6	45.78	2877611.0
2015-07-15 11:00:00	MSFT	Stock	45.78	45.82	45.66	45.74	2118526.0
2015-07-15 12:00:00	MSFT	Stock	45.73	45.835	45.73	45.82	2279694.0
2015-07-15 13:00:00	MSFT	Stock	45.82	45.89	45.78	45.81	1944192.0
2015-07-15 14:00:00	MSFT	Stock	45.82	45.89	45.7	45.78	3154792.0
2015-07-15 15:00:00	MSFT	Stock	45.785	45.85	45.7	45.77	4272605.0
2015-07-15 16:00:00	MSFT	Stock	45.76	46.317	45.76	46.2	2159711.0
2015-07-15 17:00:00	MSFT	Stock	46.13	46.15	46.0	46.1	38260.0
2015-07-15 18:00:00	MSFT	Stock	46.02	46.12	45.92	46.12	5019.0
2015-07-15 19:00:00	MSFT	Stock	46.1	46.19	46.1	46.17	4232.0
2015-07-15 09:00:00	NVDA	Stock	0.4995	0.4998	0.4945	0.4961	19630800.0
2015-07-15 10:00:00	NVDA	Stock	0.4961	0.4985	0.4955	0.4974	25482160.0
2015-07-15 11:00:00	NVDA	Stock	0.4975	0.498	0.4923	0.493	27260440.0
2015-07-15 12:00:00	NVDA	Stock	0.4932	0.495	0.4918	0.4926	36584440.0
2015-07-15 13:00:00	NVDA	Stock	0.4925	0.4935	0.4923	0.4925	24647120.0
2015-07-15 14:00:00	NVDA	Stock	0.4925	0.4926	0.4892	0.491	37241400.0
2015-07-15 15:00:00	NVDA	Stock	0.4909	0.4942	0.4905	0.4938	72878920.0
2015-07-15 16:00:00	NVDA	Stock	0.4938	0.5025	0.4938	0.5	3958960.0
2015-07-15 17:00:00	NVDA	Stock	0.499	0.499	0.4975	0.4975	60000.0
2015-07-15 18:00:00	NVDA	Stock	0.4963	0.4963	0.4963	0.4963	4000.0
2015-07-15 19:00:00	NVDA	Stock	0.495	0.495	0.495	0.495	40000.0
2015-07-15 06:00:00	AMZN	Stock	23.325	23.325	23.3	23.3	9240.0
2015-07-15 07:00:00	AMZN	Stock	23.3	23.325	23.295	23.3245	34400.0
2015-07-15 08:00:00	AMZN	Stock	23.3935	23.3935	23.2	23.225	300300.0
2015-07-15 09:00:00	AMZN	Stock	23.2142	23.2425	23.049	23.1495	13602180.0
2015-07-15 10:00:00	AMZN	Stock	23.1595	23.2018	23.0325	23.1925	10211780.0
2015-07-15 11:00:00	AMZN	Stock	23.187	23.22	23.115	23.1295	4340720.0
2015-07-15 12:00:00	AMZN	Stock	23.134	23.165	23.0645	23.103	4384980.0
2015-07-15 13:00:00	AMZN	Stock	23.102	23.1975	23.0835	23.143	5598480.0
2015-07-15 14:00:00	AMZN	Stock	23.144	23.1667	23.01	23.049	6086780.0
2015-07-15 15:00:00	AMZN	Stock	23.0485	23.111	23.014	23.0615	11730920.0
2015-07-15 16:00:00	AMZN	Stock	23.0595	23.15	23.0	23.129	633780.0

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

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