PREVIEW / stock_1hour / 2018-01-29

all stock 1-hour files

  file:    by_date/stock_1hour/2018/2018-01-29.parquet
  size:    1.1 MB
  rows:    50,482
  symbols: 2,913

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
2018-01-29 04:00:00	AAPL	Stock	42.8725	43.15	42.8725	42.9975	98096.0
2018-01-29 05:00:00	AAPL	Stock	42.9525	43.05	42.705	42.7275	133968.0
2018-01-29 06:00:00	AAPL	Stock	42.7125	42.7275	42.615	42.7275	88752.0
2018-01-29 07:00:00	AAPL	Stock	42.73	42.7375	42.63	42.685	419824.0
2018-01-29 08:00:00	AAPL	Stock	42.665	42.7375	42.5125	42.535	949748.0
2018-01-29 09:00:00	AAPL	Stock	42.5325	42.575	41.81	42.1662	35401404.0
2018-01-29 10:00:00	AAPL	Stock	42.1675	42.181	41.7675	42.08	38249664.0
2018-01-29 11:00:00	AAPL	Stock	42.081	42.3175	41.98	42.298	20685540.0
2018-01-29 12:00:00	AAPL	Stock	42.3	42.3025	42.11	42.195	11363960.0
2018-01-29 13:00:00	AAPL	Stock	42.1975	42.25	42.1125	42.1252	10166716.0
2018-01-29 14:00:00	AAPL	Stock	42.125	42.135	41.94	42.0525	15010360.0
2018-01-29 15:00:00	AAPL	Stock	42.0513	42.135	41.9517	41.99	25069436.0
2018-01-29 16:00:00	AAPL	Stock	42.0125	42.3062	41.955	41.9775	10914640.0
2018-01-29 17:00:00	AAPL	Stock	41.9775	41.995	41.9375	41.955	155860.0
2018-01-29 18:00:00	AAPL	Stock	41.95	42.0275	41.95	42.025	125192.0
2018-01-29 19:00:00	AAPL	Stock	42.02	42.05	42.0	42.0225	30564.0
2018-01-29 04:00:00	MSFT	Stock	94.23	94.53	94.0	94.3	16980.0
2018-01-29 05:00:00	MSFT	Stock	94.3	94.32	94.3	94.32	2727.0
2018-01-29 06:00:00	MSFT	Stock	94.43	94.49	94.2	94.49	8793.0
2018-01-29 07:00:00	MSFT	Stock	94.48	95.32	94.42	95.26	69157.0
2018-01-29 08:00:00	MSFT	Stock	94.5	95.5	94.25	95.07	213678.0
2018-01-29 09:00:00	MSFT	Stock	95.07	95.47	94.02	94.465	4964074.0
2018-01-29 10:00:00	MSFT	Stock	94.47	94.52	93.76	93.96	4632105.0
2018-01-29 11:00:00	MSFT	Stock	93.96	94.13	93.77	93.94	2642503.0
2018-01-29 12:00:00	MSFT	Stock	93.94	94.07	93.78	93.96	1907189.0
2018-01-29 13:00:00	MSFT	Stock	93.96	94.13	93.898	94.055	1814445.0
2018-01-29 14:00:00	MSFT	Stock	94.055	94.28	93.93	94.08	2311177.0
2018-01-29 15:00:00	MSFT	Stock	94.08	94.13	93.72	93.87	4420196.0
2018-01-29 16:00:00	MSFT	Stock	93.92	94.089	93.82	93.87	4829723.0
2018-01-29 17:00:00	MSFT	Stock	93.88	93.97	93.83	93.9	8202.0
2018-01-29 18:00:00	MSFT	Stock	93.92	94.27	93.92	94.25	9038.0
2018-01-29 19:00:00	MSFT	Stock	94.18	94.29	94.18	94.2	5241.0
2018-01-29 04:00:00	NVDA	Stock	6.0678	6.0678	6.05	6.05	18120.0
2018-01-29 05:00:00	NVDA	Stock	6.0498	6.0612	6.0322	6.0612	93480.0
2018-01-29 06:00:00	NVDA	Stock	6.0455	6.06	6.0435	6.06	234760.0
2018-01-29 07:00:00	NVDA	Stock	6.0648	6.0748	6.0585	6.0625	889160.0
2018-01-29 08:00:00	NVDA	Stock	6.062	6.075	6.0575	6.0588	1873920.0
2018-01-29 09:00:00	NVDA	Stock	6.0612	6.1375	6.0153	6.1322	82192640.0
2018-01-29 10:00:00	NVDA	Stock	6.1365	6.1713	6.1005	6.123	71520400.0
2018-01-29 11:00:00	NVDA	Stock	6.1215	6.1852	6.093	6.175	71456200.0
2018-01-29 12:00:00	NVDA	Stock	6.175	6.1923	6.152	6.1875	25831040.0
2018-01-29 13:00:00	NVDA	Stock	6.188	6.2028	6.164	6.1816	23133880.0
2018-01-29 14:00:00	NVDA	Stock	6.1815	6.1862	6.1322	6.154	26979440.0
2018-01-29 15:00:00	NVDA	Stock	6.154	6.1905	6.1338	6.1695	54586760.0
2018-01-29 16:00:00	NVDA	Stock	6.1713	6.1887	6.1663	6.175	38762600.0
2018-01-29 17:00:00	NVDA	Stock	6.17	6.175	6.1675	6.1675	119280.0
2018-01-29 18:00:00	NVDA	Stock	6.1705	6.177	6.1705	6.1725	376320.0
2018-01-29 19:00:00	NVDA	Stock	6.1768	6.18	6.1725	6.18	155880.0
2018-01-29 04:00:00	AMZN	Stock	70.4	70.4925	70.294	70.294	33800.0
2018-01-29 05:00:00	AMZN	Stock	70.1805	70.281	70.175	70.235	41280.0

> showing 50 of 50,482 rows — these rows as CSV

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