PREVIEW / stock_1hour / 2018-04-26

all stock 1-hour files

  file:    by_date/stock_1hour/2018/2018-04-26.parquet
  size:    1.1 MB
  rows:    49,398
  symbols: 2,878

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-04-26 04:00:00	AAPL	Stock	41.125	41.15	41.0675	41.105	12060.0
2018-04-26 05:00:00	AAPL	Stock	41.0375	41.125	41.0375	41.125	3920.0
2018-04-26 06:00:00	AAPL	Stock	41.1775	41.2225	41.1	41.1	43104.0
2018-04-26 07:00:00	AAPL	Stock	41.195	41.195	40.9625	40.9625	118224.0
2018-04-26 08:00:00	AAPL	Stock	41.0	41.1625	40.955	41.075	436744.0
2018-04-26 09:00:00	AAPL	Stock	41.075	41.265	40.925	41.2225	12600496.0
2018-04-26 10:00:00	AAPL	Stock	41.2212	41.3975	41.1325	41.395	13793004.0
2018-04-26 11:00:00	AAPL	Stock	41.3962	41.4325	41.0875	41.14	10676876.0
2018-04-26 12:00:00	AAPL	Stock	41.14	41.16	40.9125	41.022	12295240.0
2018-04-26 13:00:00	AAPL	Stock	41.0225	41.12	40.985	41.0388	8010020.0
2018-04-26 14:00:00	AAPL	Stock	41.0388	41.075	40.8425	41.0475	11948368.0
2018-04-26 15:00:00	AAPL	Stock	41.05	41.1025	40.9275	41.055	17864484.0
2018-04-26 16:00:00	AAPL	Stock	41.055	41.2475	41.045	41.2125	10718820.0
2018-04-26 17:00:00	AAPL	Stock	41.225	41.295	41.055	41.225	396364.0
2018-04-26 18:00:00	AAPL	Stock	41.225	41.2375	41.1875	41.2	90404.0
2018-04-26 19:00:00	AAPL	Stock	41.2125	41.25	41.1925	41.2075	40824.0
2018-04-26 04:00:00	MSFT	Stock	93.5	93.5	93.2	93.3	7706.0
2018-04-26 05:00:00	MSFT	Stock	93.32	93.66	93.3	93.64	6096.0
2018-04-26 06:00:00	MSFT	Stock	93.67	93.67	93.54	93.62	810.0
2018-04-26 07:00:00	MSFT	Stock	93.68	93.78	93.55	93.65	33353.0
2018-04-26 08:00:00	MSFT	Stock	93.732	94.03	93.6	94.0	174311.0
2018-04-26 09:00:00	MSFT	Stock	94.0	94.18	93.1	93.955	3812999.0
2018-04-26 10:00:00	MSFT	Stock	93.96	94.56	93.867	94.36	3987368.0
2018-04-26 11:00:00	MSFT	Stock	94.36	94.57	94.0	94.34	2806010.0
2018-04-26 12:00:00	MSFT	Stock	94.33	94.74	94.317	94.534	2326981.0
2018-04-26 13:00:00	MSFT	Stock	94.54	94.96	94.54	94.74	2422015.0
2018-04-26 14:00:00	MSFT	Stock	94.74	95.06	94.6	95.06	3183229.0
2018-04-26 15:00:00	MSFT	Stock	95.05	95.15	94.17	94.27	7455224.0
2018-04-26 16:00:00	MSFT	Stock	94.26	95.5	91.52	94.26	10390305.0
2018-04-26 17:00:00	MSFT	Stock	94.36	95.0	93.75	94.5	522632.0
2018-04-26 18:00:00	MSFT	Stock	94.5	97.99	94.45	97.01	1079012.0
2018-04-26 19:00:00	MSFT	Stock	97.11	97.5	96.15	96.49	106893.0
2018-04-26 04:00:00	NVDA	Stock	5.5198	5.5198	5.5102	5.5125	82240.0
2018-04-26 05:00:00	NVDA	Stock	5.5132	5.525	5.5102	5.525	44400.0
2018-04-26 06:00:00	NVDA	Stock	5.535	5.535	5.5255	5.5255	35200.0
2018-04-26 07:00:00	NVDA	Stock	5.537	5.5628	5.5348	5.55	755200.0
2018-04-26 08:00:00	NVDA	Stock	5.55	5.565	5.5342	5.5625	2046720.0
2018-04-26 09:00:00	NVDA	Stock	5.5653	5.604	5.5132	5.5563	82358400.0
2018-04-26 10:00:00	NVDA	Stock	5.5593	5.6105	5.5468	5.6088	74432480.0
2018-04-26 11:00:00	NVDA	Stock	5.6096	5.613	5.554	5.5678	48370120.0
2018-04-26 12:00:00	NVDA	Stock	5.5675	5.5888	5.561	5.5658	25307920.0
2018-04-26 13:00:00	NVDA	Stock	5.5688	5.6128	5.5675	5.612	18672840.0
2018-04-26 14:00:00	NVDA	Stock	5.6106	5.6252	5.595	5.6237	21902080.0
2018-04-26 15:00:00	NVDA	Stock	5.6245	5.6388	5.6175	5.6288	42837920.0
2018-04-26 16:00:00	NVDA	Stock	5.6305	5.7188	5.6034	5.71	26055280.0
2018-04-26 17:00:00	NVDA	Stock	5.7088	5.7125	5.6305	5.7028	1249800.0
2018-04-26 18:00:00	NVDA	Stock	5.707	5.7125	5.7028	5.7095	588120.0
2018-04-26 19:00:00	NVDA	Stock	5.7098	5.7145	5.7075	5.7145	1537320.0
2018-04-26 04:00:00	AMZN	Stock	74.245	74.245	74.1	74.1	40020.0
2018-04-26 05:00:00	AMZN	Stock	74.096	74.096	74.0	74.0	13080.0

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

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