PREVIEW / stock_1hour / 2018-04-13

all stock 1-hour files

  file:    by_date/stock_1hour/2018/2018-04-13.parquet
  size:    1.1 MB
  rows:    48,642
  symbols: 2,854

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-13 04:00:00	AAPL	Stock	43.4975	43.4975	43.495	43.495	5592.0
2018-04-13 06:00:00	AAPL	Stock	43.58	43.6025	43.58	43.6025	9348.0
2018-04-13 07:00:00	AAPL	Stock	43.605	43.67	43.6	43.6375	100368.0
2018-04-13 08:00:00	AAPL	Stock	43.6625	43.7475	43.63	43.73	226916.0
2018-04-13 09:00:00	AAPL	Stock	43.7375	43.96	43.6875	43.8125	13271096.0
2018-04-13 10:00:00	AAPL	Stock	43.81	43.8225	43.4625	43.65	15317300.0
2018-04-13 11:00:00	AAPL	Stock	43.6475	43.83	43.5275	43.8	10538880.0
2018-04-13 12:00:00	AAPL	Stock	43.805	43.8375	43.6675	43.775	6313952.0
2018-04-13 13:00:00	AAPL	Stock	43.7775	43.87	43.7472	43.855	6270160.0
2018-04-13 14:00:00	AAPL	Stock	43.855	43.86	43.65	43.695	8319336.0
2018-04-13 15:00:00	AAPL	Stock	43.695	43.75	43.52	43.6825	13252928.0
2018-04-13 16:00:00	AAPL	Stock	43.68	43.7375	43.66	43.7025	10815444.0
2018-04-13 17:00:00	AAPL	Stock	43.7	43.7175	43.6925	43.7075	10456.0
2018-04-13 18:00:00	AAPL	Stock	43.725	43.725	43.695	43.695	54876.0
2018-04-13 19:00:00	AAPL	Stock	43.7025	43.7125	43.6925	43.6925	19360.0
2018-04-13 05:00:00	MSFT	Stock	93.6	93.6	93.6	93.6	1018.0
2018-04-13 06:00:00	MSFT	Stock	93.69	93.73	93.68	93.73	1832.0
2018-04-13 07:00:00	MSFT	Stock	93.62	93.94	93.53	93.79	13178.0
2018-04-13 08:00:00	MSFT	Stock	93.81	94.13	93.78	94.11	14593.0
2018-04-13 09:00:00	MSFT	Stock	94.08	94.18	93.24	93.45	2276636.0
2018-04-13 10:00:00	MSFT	Stock	93.44	93.5	92.7	93.02	2597185.0
2018-04-13 11:00:00	MSFT	Stock	93.01	93.293	92.7	93.052	2298604.0
2018-04-13 12:00:00	MSFT	Stock	93.046	93.25	92.78	93.225	1808098.0
2018-04-13 13:00:00	MSFT	Stock	93.222	93.566	93.17	93.44	1739810.0
2018-04-13 14:00:00	MSFT	Stock	93.445	93.62	93.18	93.23	1950334.0
2018-04-13 15:00:00	MSFT	Stock	93.24	93.36	92.44	93.08	5136364.0
2018-04-13 16:00:00	MSFT	Stock	93.08	93.12	92.99	93.05	3558509.0
2018-04-13 17:00:00	MSFT	Stock	93.05	93.1	93.05	93.1	2550.0
2018-04-13 18:00:00	MSFT	Stock	93.08	93.08	93.0	93.0	918.0
2018-04-13 19:00:00	MSFT	Stock	93.15	93.15	93.01	93.15	7630.0
2018-04-13 05:00:00	NVDA	Stock	5.8955	5.897	5.8955	5.897	16000.0
2018-04-13 06:00:00	NVDA	Stock	5.8972	5.9038	5.895	5.9038	43840.0
2018-04-13 07:00:00	NVDA	Stock	5.9053	5.9488	5.9025	5.945	553880.0
2018-04-13 08:00:00	NVDA	Stock	5.9397	5.961	5.9038	5.955	3007480.0
2018-04-13 09:00:00	NVDA	Stock	5.9535	5.9575	5.805	5.8164	90595240.0
2018-04-13 10:00:00	NVDA	Stock	5.8158	5.8395	5.771	5.7862	96062080.0
2018-04-13 11:00:00	NVDA	Stock	5.7862	5.824	5.765	5.801	41047880.0
2018-04-13 12:00:00	NVDA	Stock	5.8	5.8445	5.7958	5.838	27067440.0
2018-04-13 13:00:00	NVDA	Stock	5.8392	5.8596	5.832	5.8384	24743280.0
2018-04-13 14:00:00	NVDA	Stock	5.8375	5.8573	5.7968	5.8025	31180880.0
2018-04-13 15:00:00	NVDA	Stock	5.8018	5.8018	5.7388	5.7872	79614960.0
2018-04-13 16:00:00	NVDA	Stock	5.7875	5.7943	5.7725	5.785	12298800.0
2018-04-13 17:00:00	NVDA	Stock	5.7872	5.796	5.7825	5.792	295800.0
2018-04-13 18:00:00	NVDA	Stock	5.7915	5.7963	5.7913	5.7963	203240.0
2018-04-13 19:00:00	NVDA	Stock	5.7963	5.7963	5.7845	5.7948	221280.0
2018-04-13 04:00:00	AMZN	Stock	72.0055	72.0335	72.0055	72.0085	14280.0
2018-04-13 06:00:00	AMZN	Stock	72.15	72.25	72.15	72.25	16240.0
2018-04-13 07:00:00	AMZN	Stock	72.25	72.25	71.833	72.246	581220.0
2018-04-13 08:00:00	AMZN	Stock	72.2	72.645	71.95	72.62	1083840.0
2018-04-13 09:00:00	AMZN	Stock	72.555	72.989	72.446	72.67	14043940.0

> showing 50 of 48,642 rows — these rows as CSV

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