PREVIEW / stock_1hour / 2017-08-03

all stock 1-hour files

  file:    by_date/stock_1hour/2017/2017-08-03.parquet
  size:    1.0 MB
  rows:    47,443
  symbols: 2,988

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-03 04:00:00	AAPL	Stock	39.2875	39.2875	39.265	39.285	3536.0
2017-08-03 05:00:00	AAPL	Stock	39.285	39.37	39.285	39.35	10548.0
2017-08-03 06:00:00	AAPL	Stock	39.35	39.35	39.29	39.325	32972.0
2017-08-03 07:00:00	AAPL	Stock	39.3	39.35	39.25	39.27	78180.0
2017-08-03 08:00:00	AAPL	Stock	39.2875	39.2875	39.19	39.2	291524.0
2017-08-03 09:00:00	AAPL	Stock	39.225	39.3025	38.9625	39.0625	17714496.0
2017-08-03 10:00:00	AAPL	Stock	39.06	39.0658	38.82	39.0475	18434360.0
2017-08-03 11:00:00	AAPL	Stock	39.045	39.205	38.9658	38.9885	12285060.0
2017-08-03 12:00:00	AAPL	Stock	38.9875	39.0475	38.915	38.9775	7072804.0
2017-08-03 13:00:00	AAPL	Stock	38.9775	38.98	38.8237	38.95	8655736.0
2017-08-03 14:00:00	AAPL	Stock	38.9545	39.0025	38.855	38.88	7137908.0
2017-08-03 15:00:00	AAPL	Stock	38.879	38.985	38.755	38.8775	17288016.0
2017-08-03 16:00:00	AAPL	Stock	38.84	38.9625	38.84	38.91	6496564.0
2017-08-03 17:00:00	AAPL	Stock	38.925	38.925	38.8875	38.8925	46128.0
2017-08-03 18:00:00	AAPL	Stock	38.89	38.9125	38.89	38.89	34824.0
2017-08-03 19:00:00	AAPL	Stock	38.8925	38.905	38.89	38.89	27880.0
2017-08-03 06:00:00	MSFT	Stock	72.2	72.25	72.2	72.25	780.0
2017-08-03 08:00:00	MSFT	Stock	72.0	72.28	72.0	72.28	2275.0
2017-08-03 09:00:00	MSFT	Stock	72.27	72.37	71.93	71.99	2002128.0
2017-08-03 10:00:00	MSFT	Stock	71.98	72.16	71.845	72.07	2277819.0
2017-08-03 11:00:00	MSFT	Stock	72.075	72.11	71.93	72.005	1988426.0
2017-08-03 12:00:00	MSFT	Stock	72.005	72.44	72.0	72.275	1845733.0
2017-08-03 13:00:00	MSFT	Stock	72.276	72.34	72.105	72.295	1270326.0
2017-08-03 14:00:00	MSFT	Stock	72.3	72.34	72.09	72.12	1587276.0
2017-08-03 15:00:00	MSFT	Stock	72.125	72.22	71.94	72.14	3887966.0
2017-08-03 16:00:00	MSFT	Stock	72.15	72.34	72.13	72.16	2279946.0
2017-08-03 17:00:00	MSFT	Stock	72.17	72.25	72.15	72.25	1522.0
2017-08-03 18:00:00	MSFT	Stock	72.25	72.25	72.25	72.25	200.0
2017-08-03 19:00:00	MSFT	Stock	72.16	72.22	72.15	72.17	2470.0
2017-08-03 06:00:00	NVDA	Stock	4.1125	4.1125	4.1125	4.1125	15200.0
2017-08-03 07:00:00	NVDA	Stock	4.1172	4.1172	4.1095	4.1095	128760.0
2017-08-03 08:00:00	NVDA	Stock	4.1092	4.1125	4.1008	4.1075	813160.0
2017-08-03 09:00:00	NVDA	Stock	4.1088	4.134	4.088	4.113	67246640.0
2017-08-03 10:00:00	NVDA	Stock	4.1118	4.1498	4.108	4.1376	84588320.0
2017-08-03 11:00:00	NVDA	Stock	4.1375	4.1615	4.135	4.1415	59918560.0
2017-08-03 12:00:00	NVDA	Stock	4.1418	4.1615	4.139	4.1512	35352840.0
2017-08-03 13:00:00	NVDA	Stock	4.1512	4.1565	4.1408	4.151	36547800.0
2017-08-03 14:00:00	NVDA	Stock	4.1505	4.1658	4.146	4.1595	43030120.0
2017-08-03 15:00:00	NVDA	Stock	4.1592	4.1638	4.1373	4.162	79858120.0
2017-08-03 16:00:00	NVDA	Stock	4.162	4.1667	4.1565	4.165	3709680.0
2017-08-03 17:00:00	NVDA	Stock	4.1625	4.1638	4.162	4.1625	2252960.0
2017-08-03 18:00:00	NVDA	Stock	4.1603	4.1648	4.1583	4.1625	233120.0
2017-08-03 19:00:00	NVDA	Stock	4.1648	4.1648	4.1595	4.1595	171120.0
2017-08-03 04:00:00	AMZN	Stock	49.774	49.774	49.774	49.774	11860.0
2017-08-03 06:00:00	AMZN	Stock	49.8945	49.895	49.858	49.858	11020.0
2017-08-03 07:00:00	AMZN	Stock	49.8995	49.8995	49.871	49.871	6000.0
2017-08-03 08:00:00	AMZN	Stock	49.8535	49.9	49.825	49.899	135280.0
2017-08-03 09:00:00	AMZN	Stock	49.893	49.975	49.4525	49.5103	8784720.0
2017-08-03 10:00:00	AMZN	Stock	49.524	49.6128	49.2295	49.5623	15377180.0
2017-08-03 11:00:00	AMZN	Stock	49.5825	49.6095	49.368	49.4285	8041040.0

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

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