PREVIEW / stock_1hour / 2016-06-10

all stock 1-hour files

  file:    by_date/stock_1hour/2016/2016-06-10.parquet
  size:    1.0 MB
  rows:    48,422
  symbols: 3,262

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
2016-06-10 04:00:00	AAPL	Stock	24.875	24.875	24.6475	24.725	20332.0
2016-06-10 05:00:00	AAPL	Stock	24.73	24.7375	24.675	24.7375	8000.0
2016-06-10 06:00:00	AAPL	Stock	24.6875	24.7775	24.6875	24.7775	34724.0
2016-06-10 07:00:00	AAPL	Stock	24.765	24.8175	24.765	24.765	77460.0
2016-06-10 08:00:00	AAPL	Stock	24.7675	24.8175	24.7275	24.7375	299636.0
2016-06-10 09:00:00	AAPL	Stock	24.735	24.775	24.6275	24.6475	21028288.0
2016-06-10 10:00:00	AAPL	Stock	24.65	24.75	24.62	24.6975	19780136.0
2016-06-10 11:00:00	AAPL	Stock	24.6975	24.7825	24.6898	24.7575	11230612.0
2016-06-10 12:00:00	AAPL	Stock	24.7572	24.8365	24.7025	24.8225	11970072.0
2016-06-10 13:00:00	AAPL	Stock	24.8225	24.825	24.725	24.74	10662644.0
2016-06-10 14:00:00	AAPL	Stock	24.7375	24.7575	24.7175	24.7475	8492928.0
2016-06-10 15:00:00	AAPL	Stock	24.748	24.7775	24.6975	24.71	20462076.0
2016-06-10 16:00:00	AAPL	Stock	24.7075	24.745	24.7025	24.715	7596640.0
2016-06-10 17:00:00	AAPL	Stock	24.7125	24.745	24.7125	24.7125	100660.0
2016-06-10 18:00:00	AAPL	Stock	24.7125	24.7425	24.71	24.725	98360.0
2016-06-10 19:00:00	AAPL	Stock	24.725	24.7425	24.725	24.7375	52920.0
2016-06-10 05:00:00	MSFT	Stock	51.49	51.49	51.3	51.31	1587.0
2016-06-10 06:00:00	MSFT	Stock	51.31	51.31	51.1	51.1	7997.0
2016-06-10 07:00:00	MSFT	Stock	51.21	51.29	51.21	51.29	300.0
2016-06-10 08:00:00	MSFT	Stock	51.3	51.3	51.12	51.12	7385.0
2016-06-10 09:00:00	MSFT	Stock	51.1	51.52	51.03	51.463	2762529.0
2016-06-10 10:00:00	MSFT	Stock	51.47	52.05	51.444	51.92	4751372.0
2016-06-10 11:00:00	MSFT	Stock	51.91	51.96	51.815	51.94	2459358.0
2016-06-10 12:00:00	MSFT	Stock	51.93	51.953	51.73	51.735	1771294.0
2016-06-10 13:00:00	MSFT	Stock	51.732	51.85	51.49	51.515	2135247.0
2016-06-10 14:00:00	MSFT	Stock	51.51	51.53	51.27	51.28	3363409.0
2016-06-10 15:00:00	MSFT	Stock	51.28	51.53	51.23	51.49	4897336.0
2016-06-10 16:00:00	MSFT	Stock	51.49	51.595	51.44	51.44	2035288.0
2016-06-10 18:00:00	MSFT	Stock	51.45	51.45	51.45	51.45	100.0
2016-06-10 08:00:00	NVDA	Stock	1.175	1.1775	1.175	1.1775	44000.0
2016-06-10 09:00:00	NVDA	Stock	1.1725	1.181	1.1648	1.166	57750920.0
2016-06-10 10:00:00	NVDA	Stock	1.1658	1.1679	1.1613	1.1659	60508240.0
2016-06-10 11:00:00	NVDA	Stock	1.166	1.1708	1.1641	1.1681	56729440.0
2016-06-10 12:00:00	NVDA	Stock	1.1682	1.1682	1.1591	1.162	43116920.0
2016-06-10 13:00:00	NVDA	Stock	1.1622	1.1655	1.1553	1.1564	43264280.0
2016-06-10 14:00:00	NVDA	Stock	1.1562	1.157	1.1535	1.1548	45238400.0
2016-06-10 15:00:00	NVDA	Stock	1.1545	1.1565	1.1535	1.155	75345640.0
2016-06-10 16:00:00	NVDA	Stock	1.155	1.155	1.154	1.155	651640.0
2016-06-10 17:00:00	NVDA	Stock	1.157	1.1635	1.1562	1.1562	68000.0
2016-06-10 18:00:00	NVDA	Stock	1.1562	1.1562	1.1562	1.1562	12000.0
2016-06-10 07:00:00	AMZN	Stock	36.205	36.205	36.1165	36.14	82780.0
2016-06-10 08:00:00	AMZN	Stock	36.1275	36.225	36.1275	36.175	272840.0
2016-06-10 09:00:00	AMZN	Stock	36.1725	36.249	36.083	36.13	8386100.0
2016-06-10 10:00:00	AMZN	Stock	36.125	36.1435	35.8508	35.8535	14173560.0
2016-06-10 11:00:00	AMZN	Stock	35.8585	35.9415	35.8154	35.9258	6573500.0
2016-06-10 12:00:00	AMZN	Stock	35.9335	35.9745	35.8565	35.9395	5485060.0
2016-06-10 13:00:00	AMZN	Stock	35.9473	35.9485	35.8	35.8265	5620240.0
2016-06-10 14:00:00	AMZN	Stock	35.827	35.831	35.7105	35.7505	7392680.0
2016-06-10 15:00:00	AMZN	Stock	35.746	35.912	35.7405	35.901	12123240.0
2016-06-10 16:00:00	AMZN	Stock	35.8955	35.92	35.8875	35.9125	796600.0

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

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