PREVIEW / stock_1hour / 2018-05-17

all stock 1-hour files

  file:    by_date/stock_1hour/2018/2018-05-17.parquet
  size:    1.1 MB
  rows:    49,433
  symbols: 2,838

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-05-17 04:00:00	AAPL	Stock	46.9375	46.9375	46.9025	46.9025	1200.0
2018-05-17 05:00:00	AAPL	Stock	46.995	46.9975	46.995	46.9975	5528.0
2018-05-17 06:00:00	AAPL	Stock	46.875	46.875	46.85	46.85	5884.0
2018-05-17 07:00:00	AAPL	Stock	46.895	46.97	46.8675	46.925	37024.0
2018-05-17 08:00:00	AAPL	Stock	46.9	46.9825	46.85	46.9	147188.0
2018-05-17 09:00:00	AAPL	Stock	46.9125	47.055	46.82	46.84	8641448.0
2018-05-17 10:00:00	AAPL	Stock	46.845	47.225	46.83	47.215	10791780.0
2018-05-17 11:00:00	AAPL	Stock	47.215	47.2275	46.9275	46.9875	7561284.0
2018-05-17 12:00:00	AAPL	Stock	46.985	47.0325	46.815	46.875	6952496.0
2018-05-17 13:00:00	AAPL	Stock	46.874	46.92	46.7075	46.7192	5188416.0
2018-05-17 14:00:00	AAPL	Stock	46.7125	46.845	46.59	46.82	7348520.0
2018-05-17 15:00:00	AAPL	Stock	46.82	46.865	46.7	46.7475	9174084.0
2018-05-17 16:00:00	AAPL	Stock	46.75	46.75	46.6525	46.705	4890372.0
2018-05-17 17:00:00	AAPL	Stock	46.7125	46.72	46.695	46.71	22180.0
2018-05-17 18:00:00	AAPL	Stock	46.7125	46.7725	46.7025	46.755	96432.0
2018-05-17 19:00:00	AAPL	Stock	46.75	46.7875	46.7375	46.7375	28832.0
2018-05-17 04:00:00	MSFT	Stock	97.06	97.09	97.06	97.09	359.0
2018-05-17 05:00:00	MSFT	Stock	97.06	97.09	97.06	97.09	365.0
2018-05-17 06:00:00	MSFT	Stock	96.97	96.97	96.92	96.93	518.0
2018-05-17 07:00:00	MSFT	Stock	96.85	96.95	96.83	96.95	1120.0
2018-05-17 08:00:00	MSFT	Stock	96.98	96.98	96.76	96.8	10858.0
2018-05-17 09:00:00	MSFT	Stock	96.81	96.94	96.63	96.73	1415366.0
2018-05-17 10:00:00	MSFT	Stock	96.74	97.54	96.74	97.497	1863024.0
2018-05-17 11:00:00	MSFT	Stock	97.495	97.5	96.904	96.91	1293269.0
2018-05-17 12:00:00	MSFT	Stock	96.91	97.05	96.42	96.53	1413375.0
2018-05-17 13:00:00	MSFT	Stock	96.531	96.619	96.01	96.055	1333577.0
2018-05-17 14:00:00	MSFT	Stock	96.05	96.51	95.83	96.5	1861679.0
2018-05-17 15:00:00	MSFT	Stock	96.5	96.54	96.14	96.18	2849476.0
2018-05-17 16:00:00	MSFT	Stock	96.18	96.25	96.1	96.1	2298606.0
2018-05-17 17:00:00	MSFT	Stock	96.1	96.15	96.08	96.14	3166.0
2018-05-17 18:00:00	MSFT	Stock	96.15	96.16	96.15	96.15	862.0
2018-05-17 19:00:00	MSFT	Stock	96.3	96.3	96.22	96.25	4845.0
2018-05-17 04:00:00	NVDA	Stock	6.145	6.145	6.145	6.145	4000.0
2018-05-17 06:00:00	NVDA	Stock	6.13	6.1352	6.1078	6.13	48680.0
2018-05-17 07:00:00	NVDA	Stock	6.1295	6.145	6.125	6.143	235560.0
2018-05-17 08:00:00	NVDA	Stock	6.1251	6.1638	6.1163	6.1252	1168880.0
2018-05-17 09:00:00	NVDA	Stock	6.1255	6.241	6.1255	6.2359	84246360.0
2018-05-17 10:00:00	NVDA	Stock	6.2375	6.2875	6.2355	6.274	109205240.0
2018-05-17 11:00:00	NVDA	Stock	6.2745	6.2792	6.215	6.216	62228040.0
2018-05-17 12:00:00	NVDA	Stock	6.2159	6.2413	6.1958	6.2014	40497680.0
2018-05-17 13:00:00	NVDA	Stock	6.2011	6.2153	6.1638	6.166	34993800.0
2018-05-17 14:00:00	NVDA	Stock	6.166	6.2063	6.1358	6.1963	86985360.0
2018-05-17 15:00:00	NVDA	Stock	6.1973	6.2148	6.1792	6.1928	48303840.0
2018-05-17 16:00:00	NVDA	Stock	6.1928	6.2209	6.1882	6.201	12205800.0
2018-05-17 17:00:00	NVDA	Stock	6.1955	6.2013	6.1928	6.2013	189480.0
2018-05-17 18:00:00	NVDA	Stock	6.2	6.2063	6.2	6.2038	250920.0
2018-05-17 19:00:00	NVDA	Stock	6.2063	6.225	6.2	6.225	423760.0
2018-05-17 04:00:00	AMZN	Stock	79.35	79.351	79.35	79.351	8280.0
2018-05-17 06:00:00	AMZN	Stock	79.3495	79.3495	79.3495	79.3495	4120.0
2018-05-17 07:00:00	AMZN	Stock	79.3	79.3	79.182	79.3	75680.0

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

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