PREVIEW / stock_1hour / 2017-07-25

all stock 1-hour files

  file:    by_date/stock_1hour/2017/2017-07-25.parquet
  size:    1.1 MB
  rows:    49,422
  symbols: 3,008

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-07-25 04:00:00	AAPL	Stock	37.9825	37.9825	37.9725	37.9725	12548.0
2017-07-25 05:00:00	AAPL	Stock	38.0225	38.0475	38.0225	38.0475	11508.0
2017-07-25 06:00:00	AAPL	Stock	38.0575	38.0575	38.0575	38.0575	1736.0
2017-07-25 07:00:00	AAPL	Stock	38.05	38.1125	38.05	38.1	22684.0
2017-07-25 08:00:00	AAPL	Stock	38.095	38.15	38.0	38.0	174716.0
2017-07-25 09:00:00	AAPL	Stock	38.0025	38.4238	37.9375	38.4	16233200.0
2017-07-25 10:00:00	AAPL	Stock	38.4	38.4275	38.2825	38.3262	9765632.0
2017-07-25 11:00:00	AAPL	Stock	38.3275	38.46	38.31	38.42	8239180.0
2017-07-25 12:00:00	AAPL	Stock	38.419	38.4325	38.3188	38.3522	5355716.0
2017-07-25 13:00:00	AAPL	Stock	38.35	38.3825	38.2825	38.305	5373400.0
2017-07-25 14:00:00	AAPL	Stock	38.3025	38.3125	38.2175	38.27	5409392.0
2017-07-25 15:00:00	AAPL	Stock	38.27	38.2925	38.1625	38.1875	9947520.0
2017-07-25 16:00:00	AAPL	Stock	38.1925	38.225	38.0925	38.215	6205280.0
2017-07-25 17:00:00	AAPL	Stock	38.215	38.225	38.185	38.225	148756.0
2017-07-25 18:00:00	AAPL	Stock	38.225	38.2375	38.215	38.215	27084.0
2017-07-25 19:00:00	AAPL	Stock	38.215	38.2225	38.21	38.22	18684.0
2017-07-25 04:00:00	MSFT	Stock	73.48	73.58	73.48	73.58	1063.0
2017-07-25 06:00:00	MSFT	Stock	73.5	73.56	73.5	73.56	3500.0
2017-07-25 07:00:00	MSFT	Stock	73.6	73.6	73.6	73.6	7400.0
2017-07-25 08:00:00	MSFT	Stock	73.57	73.59	73.45	73.49	13610.0
2017-07-25 09:00:00	MSFT	Stock	73.49	74.01	73.48	73.96	2936927.0
2017-07-25 10:00:00	MSFT	Stock	73.95	73.98	73.63	73.76	2238503.0
2017-07-25 11:00:00	MSFT	Stock	73.76	73.93	73.76	73.89	1822877.0
2017-07-25 12:00:00	MSFT	Stock	73.88	74.01	73.79	73.985	1612525.0
2017-07-25 13:00:00	MSFT	Stock	73.99	74.14	73.95	74.14	1226715.0
2017-07-25 14:00:00	MSFT	Stock	74.14	74.3	74.12	74.197	2287329.0
2017-07-25 15:00:00	MSFT	Stock	74.2	74.31	74.12	74.199	5605141.0
2017-07-25 16:00:00	MSFT	Stock	74.19	74.28	74.18	74.18	2029711.0
2017-07-25 17:00:00	MSFT	Stock	74.18	74.19	74.11	74.11	78102.0
2017-07-25 18:00:00	MSFT	Stock	74.11	74.11	74.11	74.11	703.0
2017-07-25 19:00:00	MSFT	Stock	74.11	74.15	74.11	74.11	1757.0
2017-07-25 04:00:00	NVDA	Stock	4.1288	4.1375	4.1288	4.13	56400.0
2017-07-25 05:00:00	NVDA	Stock	4.1325	4.1325	4.1325	4.1325	5400.0
2017-07-25 06:00:00	NVDA	Stock	4.1325	4.1388	4.1325	4.1325	53200.0
2017-07-25 07:00:00	NVDA	Stock	4.13	4.1403	4.1252	4.1375	211240.0
2017-07-25 08:00:00	NVDA	Stock	4.1375	4.145	4.125	4.131	1445360.0
2017-07-25 09:00:00	NVDA	Stock	4.131	4.1462	4.0895	4.1205	89186040.0
2017-07-25 10:00:00	NVDA	Stock	4.1212	4.148	4.1155	4.1228	106393520.0
2017-07-25 11:00:00	NVDA	Stock	4.1224	4.1343	4.108	4.122	58520560.0
2017-07-25 12:00:00	NVDA	Stock	4.122	4.1359	4.1132	4.1313	46855080.0
2017-07-25 13:00:00	NVDA	Stock	4.131	4.1482	4.13	4.143	48269120.0
2017-07-25 14:00:00	NVDA	Stock	4.1424	4.1467	4.132	4.136	31501600.0
2017-07-25 15:00:00	NVDA	Stock	4.1352	4.1391	4.1235	4.1338	48993480.0
2017-07-25 16:00:00	NVDA	Stock	4.1338	4.194	4.1	4.1758	38209240.0
2017-07-25 17:00:00	NVDA	Stock	4.175	4.1925	4.175	4.185	3734280.0
2017-07-25 18:00:00	NVDA	Stock	4.1838	4.1875	4.1755	4.1862	1352440.0
2017-07-25 19:00:00	NVDA	Stock	4.187	4.1875	4.1775	4.1862	1132880.0
2017-07-25 04:00:00	AMZN	Stock	51.8	51.8	51.8	51.8	6200.0
2017-07-25 05:00:00	AMZN	Stock	51.9145	51.9145	51.9145	51.9145	5000.0
2017-07-25 06:00:00	AMZN	Stock	51.9465	51.9925	51.9085	51.9085	18120.0

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

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