PREVIEW / stock_1hour / 2017-08-16

all stock 1-hour files

  file:    by_date/stock_1hour/2017/2017-08-16.parquet
  size:    1.0 MB
  rows:    47,395
  symbols: 2,984

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
2017-08-16 04:00:00	AAPL	Stock	40.4625	40.5225	40.4625	40.5	26240.0
2017-08-16 05:00:00	AAPL	Stock	40.5	40.55	40.5	40.525	31244.0
2017-08-16 06:00:00	AAPL	Stock	40.5	40.5	40.4575	40.4575	35832.0
2017-08-16 07:00:00	AAPL	Stock	40.4525	40.475	40.3925	40.4325	143784.0
2017-08-16 08:00:00	AAPL	Stock	40.45	40.475	40.3025	40.455	549796.0
2017-08-16 09:00:00	AAPL	Stock	40.4625	40.5375	40.2325	40.3625	14453328.0
2017-08-16 10:00:00	AAPL	Stock	40.3625	40.5975	40.2775	40.5575	13067836.0
2017-08-16 11:00:00	AAPL	Stock	40.5562	40.5825	40.4425	40.5025	10456852.0
2017-08-16 12:00:00	AAPL	Stock	40.505	40.6275	40.406	40.4325	11658080.0
2017-08-16 13:00:00	AAPL	Stock	40.4325	40.4475	40.1725	40.215	14288376.0
2017-08-16 14:00:00	AAPL	Stock	40.215	40.34	40.0375	40.19	13892360.0
2017-08-16 15:00:00	AAPL	Stock	40.1882	40.2675	40.145	40.23	13479936.0
2017-08-16 16:00:00	AAPL	Stock	40.2375	40.615	40.225	40.2425	4850052.0
2017-08-16 17:00:00	AAPL	Stock	40.2325	40.2375	40.1625	40.1875	108608.0
2017-08-16 18:00:00	AAPL	Stock	40.1625	40.1975	40.125	40.1775	61180.0
2017-08-16 19:00:00	AAPL	Stock	40.165	40.2	40.1625	40.195	44504.0
2017-08-16 08:00:00	MSFT	Stock	73.41	73.45	73.41	73.45	5187.0
2017-08-16 09:00:00	MSFT	Stock	73.41	73.49	73.17	73.432	1882766.0
2017-08-16 10:00:00	MSFT	Stock	73.44	73.64	73.32	73.615	2187338.0
2017-08-16 11:00:00	MSFT	Stock	73.61	73.699	73.518	73.69	1555800.0
2017-08-16 12:00:00	MSFT	Stock	73.69	74.1	73.675	73.83	2482550.0
2017-08-16 13:00:00	MSFT	Stock	73.82	73.85	73.46	73.54	1868654.0
2017-08-16 14:00:00	MSFT	Stock	73.55	73.81	73.42	73.775	2298457.0
2017-08-16 15:00:00	MSFT	Stock	73.78	73.8	73.54	73.66	2951659.0
2017-08-16 16:00:00	MSFT	Stock	73.65	73.939	73.57	73.65	1684142.0
2017-08-16 17:00:00	MSFT	Stock	73.58	73.58	73.57	73.57	3725.0
2017-08-16 18:00:00	MSFT	Stock	73.45	73.45	73.45	73.45	440.0
2017-08-16 19:00:00	MSFT	Stock	73.55	73.55	73.55	73.55	380.0
2017-08-16 04:00:00	NVDA	Stock	4.1775	4.1775	4.1775	4.1775	16000.0
2017-08-16 05:00:00	NVDA	Stock	4.194	4.194	4.194	4.194	4000.0
2017-08-16 06:00:00	NVDA	Stock	4.193	4.1935	4.1875	4.19	121280.0
2017-08-16 07:00:00	NVDA	Stock	4.1875	4.1912	4.1875	4.19	45880.0
2017-08-16 08:00:00	NVDA	Stock	4.19	4.2075	4.185	4.1987	2422640.0
2017-08-16 09:00:00	NVDA	Stock	4.1987	4.2135	4.133	4.15	106745880.0
2017-08-16 10:00:00	NVDA	Stock	4.1495	4.185	4.135	4.1702	96240240.0
2017-08-16 11:00:00	NVDA	Stock	4.1702	4.1905	4.1675	4.1702	51782880.0
2017-08-16 12:00:00	NVDA	Stock	4.171	4.1845	4.1472	4.1523	39449600.0
2017-08-16 13:00:00	NVDA	Stock	4.1513	4.1615	4.1165	4.1315	73359000.0
2017-08-16 14:00:00	NVDA	Stock	4.1316	4.1475	4.096	4.119	78454320.0
2017-08-16 15:00:00	NVDA	Stock	4.1198	4.1385	4.1118	4.1283	74841080.0
2017-08-16 16:00:00	NVDA	Stock	4.1288	4.1645	4.1178	4.1212	19212520.0
2017-08-16 17:00:00	NVDA	Stock	4.1212	4.1248	4.1125	4.1192	373440.0
2017-08-16 18:00:00	NVDA	Stock	4.1148	4.1222	4.1145	4.1212	297000.0
2017-08-16 19:00:00	NVDA	Stock	4.1233	4.1233	4.1125	4.1125	837040.0
2017-08-16 06:00:00	AMZN	Stock	49.35	49.35	48.7885	48.7885	79720.0
2017-08-16 07:00:00	AMZN	Stock	48.793	49.0535	48.7575	48.845	585600.0
2017-08-16 08:00:00	AMZN	Stock	48.755	49.095	48.755	49.0	292940.0
2017-08-16 09:00:00	AMZN	Stock	49.0	49.0875	48.7625	48.826	7796920.0
2017-08-16 10:00:00	AMZN	Stock	48.8265	48.9995	48.661	48.9385	8372400.0
2017-08-16 11:00:00	AMZN	Stock	48.9383	49.1795	48.931	49.0995	4263700.0

> showing 50 of 47,395 rows — these rows as CSV

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