PREVIEW / stock_1hour / 2018-09-20

all stock 1-hour files

  file:    by_date/stock_1hour/2018/2018-09-20.parquet
  size:    1.1 MB
  rows:    50,293
  symbols: 2,802

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-09-20 04:00:00	AAPL	Stock	54.75	54.7625	54.7375	54.7375	5928.0
2018-09-20 05:00:00	AAPL	Stock	54.7375	54.7375	54.7375	54.7375	2000.0
2018-09-20 06:00:00	AAPL	Stock	54.75	54.8775	54.75	54.8775	11804.0
2018-09-20 07:00:00	AAPL	Stock	54.8775	54.9625	54.7575	54.95	255460.0
2018-09-20 08:00:00	AAPL	Stock	54.8725	55.1725	54.785	55.1425	743460.0
2018-09-20 09:00:00	AAPL	Stock	55.15	55.425	54.7875	55.3125	16692672.0
2018-09-20 10:00:00	AAPL	Stock	55.3125	55.57	55.215	55.245	16352496.0
2018-09-20 11:00:00	AAPL	Stock	55.25	55.4225	55.1338	55.3225	9381112.0
2018-09-20 12:00:00	AAPL	Stock	55.3212	55.326	55.15	55.29	6487552.0
2018-09-20 13:00:00	AAPL	Stock	55.29	55.325	55.11	55.1875	6551164.0
2018-09-20 14:00:00	AAPL	Stock	55.1875	55.22	55.0175	55.1088	7024952.0
2018-09-20 15:00:00	AAPL	Stock	55.1088	55.1975	54.9975	55.01	15583752.0
2018-09-20 16:00:00	AAPL	Stock	55.01	55.1775	54.975	55.1075	12768716.0
2018-09-20 17:00:00	AAPL	Stock	55.1475	55.1625	55.0075	55.0625	372568.0
2018-09-20 18:00:00	AAPL	Stock	55.0625	55.0625	54.98	55.0025	43376.0
2018-09-20 19:00:00	AAPL	Stock	55.0025	55.0475	55.0	55.0475	53232.0
2018-09-20 07:00:00	MSFT	Stock	112.16	112.25	112.01	112.19	1343.0
2018-09-20 08:00:00	MSFT	Stock	112.18	112.48	111.99	112.4	20041.0
2018-09-20 09:00:00	MSFT	Stock	112.42	113.14	111.93	113.14	3202651.0
2018-09-20 10:00:00	MSFT	Stock	113.15	113.8	113.105	113.575	3615478.0
2018-09-20 11:00:00	MSFT	Stock	113.58	113.8	113.42	113.5	1982386.0
2018-09-20 12:00:00	MSFT	Stock	113.505	113.53	113.26	113.4	1345311.0
2018-09-20 13:00:00	MSFT	Stock	113.405	113.49	113.27	113.38	1278837.0
2018-09-20 14:00:00	MSFT	Stock	113.39	113.5	113.33	113.48	1229467.0
2018-09-20 15:00:00	MSFT	Stock	113.48	113.77	113.435	113.58	4642561.0
2018-09-20 16:00:00	MSFT	Stock	113.57	113.78	113.57	113.62	3570920.0
2018-09-20 17:00:00	MSFT	Stock	113.69	113.7	113.57	113.7	40724.0
2018-09-20 18:00:00	MSFT	Stock	113.62	113.62	113.58	113.62	1768.0
2018-09-20 19:00:00	MSFT	Stock	113.65	113.7	113.65	113.65	4695.0
2018-09-20 04:00:00	NVDA	Stock	6.785	6.787	6.785	6.785	139600.0
2018-09-20 05:00:00	NVDA	Stock	6.785	6.795	6.785	6.795	212000.0
2018-09-20 06:00:00	NVDA	Stock	6.8	6.8	6.7315	6.7315	203880.0
2018-09-20 07:00:00	NVDA	Stock	6.7608	6.7608	6.6935	6.7	1485280.0
2018-09-20 08:00:00	NVDA	Stock	6.7571	6.7655	6.6575	6.7	3883360.0
2018-09-20 09:00:00	NVDA	Stock	6.6963	6.719	6.6025	6.663	95260360.0
2018-09-20 10:00:00	NVDA	Stock	6.6675	6.7135	6.6532	6.67	64241000.0
2018-09-20 11:00:00	NVDA	Stock	6.6705	6.6845	6.6228	6.632	46488200.0
2018-09-20 12:00:00	NVDA	Stock	6.6331	6.6568	6.6172	6.6538	36037000.0
2018-09-20 13:00:00	NVDA	Stock	6.6532	6.6682	6.6318	6.6652	28113880.0
2018-09-20 14:00:00	NVDA	Stock	6.665	6.6716	6.6375	6.6545	23600040.0
2018-09-20 15:00:00	NVDA	Stock	6.6546	6.6695	6.6378	6.6568	63823800.0
2018-09-20 16:00:00	NVDA	Stock	6.657	6.6872	6.654	6.68	11976960.0
2018-09-20 17:00:00	NVDA	Stock	6.6575	6.665	6.6355	6.6392	473960.0
2018-09-20 18:00:00	NVDA	Stock	6.6392	6.6498	6.628	6.6475	246560.0
2018-09-20 19:00:00	NVDA	Stock	6.6475	6.6732	6.6475	6.649	145400.0
2018-09-20 04:00:00	AMZN	Stock	96.467	96.467	96.467	96.467	2060.0
2018-09-20 05:00:00	AMZN	Stock	96.35	96.55	96.35	96.55	8220.0
2018-09-20 06:00:00	AMZN	Stock	96.436	96.436	96.435	96.435	9140.0
2018-09-20 07:00:00	AMZN	Stock	96.45	96.7445	96.4465	96.7	231700.0
2018-09-20 08:00:00	AMZN	Stock	96.6665	97.166	96.55	97.025	465340.0

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

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