PREVIEW / stock_1hour / 2017-09-08

all stock 1-hour files

  file:    by_date/stock_1hour/2017/2017-09-08.parquet
  size:    1.0 MB
  rows:    47,720
  symbols: 2,963

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-09-08 04:00:00	AAPL	Stock	40.285	40.3225	40.25	40.25	5796.0
2017-09-08 05:00:00	AAPL	Stock	40.305	40.325	40.305	40.3225	2000.0
2017-09-08 06:00:00	AAPL	Stock	40.3275	40.365	40.2825	40.2825	9660.0
2017-09-08 07:00:00	AAPL	Stock	40.2825	40.305	40.265	40.3	20636.0
2017-09-08 08:00:00	AAPL	Stock	40.2975	40.315	40.2125	40.2625	992816.0
2017-09-08 09:00:00	AAPL	Stock	40.2625	40.2875	40.12	40.1775	9453016.0
2017-09-08 10:00:00	AAPL	Stock	40.1765	40.1875	39.9	39.974	18435800.0
2017-09-08 11:00:00	AAPL	Stock	39.975	40.075	39.825	39.9525	11967348.0
2017-09-08 12:00:00	AAPL	Stock	39.9525	40.045	39.885	39.9225	7792272.0
2017-09-08 13:00:00	AAPL	Stock	39.9225	39.9325	39.7875	39.7975	7757496.0
2017-09-08 14:00:00	AAPL	Stock	39.7975	39.815	39.695	39.74	11390400.0
2017-09-08 15:00:00	AAPL	Stock	39.7375	39.7488	39.6325	39.6575	17871992.0
2017-09-08 16:00:00	AAPL	Stock	39.6575	39.6925	39.6375	39.6425	18935788.0
2017-09-08 17:00:00	AAPL	Stock	39.6475	39.675	39.6375	39.6475	664500.0
2017-09-08 18:00:00	AAPL	Stock	39.6475	39.665	39.6475	39.6525	36384.0
2017-09-08 19:00:00	AAPL	Stock	39.6575	39.6725	39.635	39.6475	69312.0
2017-09-08 04:00:00	MSFT	Stock	74.67	74.67	74.67	74.67	120.0
2017-09-08 07:00:00	MSFT	Stock	74.22	74.22	74.22	74.22	1122.0
2017-09-08 08:00:00	MSFT	Stock	74.34	74.34	74.0	74.27	331911.0
2017-09-08 09:00:00	MSFT	Stock	74.27	74.44	74.12	74.29	1539685.0
2017-09-08 10:00:00	MSFT	Stock	74.3	74.34	74.125	74.22	1428653.0
2017-09-08 11:00:00	MSFT	Stock	74.22	74.38	74.19	74.22	1387189.0
2017-09-08 12:00:00	MSFT	Stock	74.215	74.27	74.03	74.04	969469.0
2017-09-08 13:00:00	MSFT	Stock	74.04	74.229	74.02	74.125	1212265.0
2017-09-08 14:00:00	MSFT	Stock	74.13	74.13	73.88	73.9	1025444.0
2017-09-08 15:00:00	MSFT	Stock	73.895	74.08	73.84	74.0	3403188.0
2017-09-08 16:00:00	MSFT	Stock	73.98	74.106	73.95	73.98	2601216.0
2017-09-08 05:00:00	NVDA	Stock	4.15	4.15	4.15	4.15	4000.0
2017-09-08 06:00:00	NVDA	Stock	4.15	4.15	4.15	4.15	4000.0
2017-09-08 07:00:00	NVDA	Stock	4.1502	4.1538	4.1502	4.1523	48320.0
2017-09-08 08:00:00	NVDA	Stock	4.145	4.1645	4.1375	4.1558	1760040.0
2017-09-08 09:00:00	NVDA	Stock	4.155	4.1678	4.1128	4.1198	63917840.0
2017-09-08 10:00:00	NVDA	Stock	4.12	4.1313	4.0778	4.0995	123007040.0
2017-09-08 11:00:00	NVDA	Stock	4.0985	4.1123	4.089	4.0995	58013200.0
2017-09-08 12:00:00	NVDA	Stock	4.0993	4.1075	4.0852	4.0993	36769080.0
2017-09-08 13:00:00	NVDA	Stock	4.0998	4.1028	4.0852	4.0924	30322240.0
2017-09-08 14:00:00	NVDA	Stock	4.0923	4.1042	4.0838	4.0857	33622880.0
2017-09-08 15:00:00	NVDA	Stock	4.0855	4.1	4.0678	4.092	81827280.0
2017-09-08 16:00:00	NVDA	Stock	4.0922	4.0981	4.0875	4.0875	21643240.0
2017-09-08 17:00:00	NVDA	Stock	4.0913	4.0922	4.0875	4.0922	1995480.0
2017-09-08 18:00:00	NVDA	Stock	4.0925	4.0925	4.0915	4.0915	125640.0
2017-09-08 19:00:00	NVDA	Stock	4.0922	4.0925	4.0875	4.0875	142600.0
2017-09-08 08:00:00	AMZN	Stock	48.8335	48.9735	48.778	48.875	471940.0
2017-09-08 09:00:00	AMZN	Stock	48.8825	48.994	48.755	48.8261	5732300.0
2017-09-08 10:00:00	AMZN	Stock	48.833	48.84	48.677	48.75	6120220.0
2017-09-08 11:00:00	AMZN	Stock	48.7347	48.8385	48.6245	48.6575	3342700.0
2017-09-08 12:00:00	AMZN	Stock	48.677	48.6915	48.575	48.6432	3622520.0
2017-09-08 13:00:00	AMZN	Stock	48.649	48.6835	48.531	48.548	3377820.0
2017-09-08 14:00:00	AMZN	Stock	48.5535	48.567	48.332	48.34	5107860.0
2017-09-08 15:00:00	AMZN	Stock	48.3375	48.35	48.1735	48.29	12478700.0

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

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