PREVIEW / stock_1hour / 2018-09-14

all stock 1-hour files

  file:    by_date/stock_1hour/2018/2018-09-14.parquet
  size:    1.1 MB
  rows:    51,398
  symbols: 2,782

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-14 04:00:00	AAPL	Stock	56.7625	56.975	56.7625	56.8375	22976.0
2018-09-14 05:00:00	AAPL	Stock	56.9375	56.975	56.9375	56.9475	3000.0
2018-09-14 06:00:00	AAPL	Stock	56.915	56.915	56.75	56.82	38844.0
2018-09-14 07:00:00	AAPL	Stock	56.825	56.85	56.765	56.8425	192052.0
2018-09-14 08:00:00	AAPL	Stock	56.8125	56.845	56.315	56.4225	951852.0
2018-09-14 09:00:00	AAPL	Stock	56.4225	56.71	56.0175	56.46	19930408.0
2018-09-14 10:00:00	AAPL	Stock	56.46	56.56	56.195	56.2625	15787944.0
2018-09-14 11:00:00	AAPL	Stock	56.2675	56.365	56.0625	56.125	12119952.0
2018-09-14 12:00:00	AAPL	Stock	56.125	56.15	55.6305	55.8478	18167156.0
2018-09-14 13:00:00	AAPL	Stock	55.8475	56.0775	55.695	56.0215	8152096.0
2018-09-14 14:00:00	AAPL	Stock	56.0225	56.0375	55.8175	55.9575	7254308.0
2018-09-14 15:00:00	AAPL	Stock	55.9575	56.0175	55.8325	55.91	13750760.0
2018-09-14 16:00:00	AAPL	Stock	55.905	56.0	55.8775	55.955	9408160.0
2018-09-14 17:00:00	AAPL	Stock	55.945	55.9625	55.925	55.925	96172.0
2018-09-14 18:00:00	AAPL	Stock	55.905	55.905	55.8375	55.8625	60296.0
2018-09-14 19:00:00	AAPL	Stock	55.875	55.8875	55.845	55.8625	35868.0
2018-09-14 04:00:00	MSFT	Stock	113.25	113.25	113.2	113.25	1938.0
2018-09-14 05:00:00	MSFT	Stock	113.25	113.29	113.25	113.29	600.0
2018-09-14 06:00:00	MSFT	Stock	113.29	113.29	113.29	113.29	100.0
2018-09-14 07:00:00	MSFT	Stock	113.25	113.38	113.11	113.28	5166.0
2018-09-14 08:00:00	MSFT	Stock	113.28	113.37	113.03	113.17	23474.0
2018-09-14 09:00:00	MSFT	Stock	113.1	113.58	112.89	113.24	1771729.0
2018-09-14 10:00:00	MSFT	Stock	113.245	113.73	113.13	113.605	2859699.0
2018-09-14 11:00:00	MSFT	Stock	113.605	113.608	113.03	113.47	2158203.0
2018-09-14 12:00:00	MSFT	Stock	113.47	113.49	112.57	112.825	2615727.0
2018-09-14 13:00:00	MSFT	Stock	112.822	113.29	112.44	113.23	1283757.0
2018-09-14 14:00:00	MSFT	Stock	113.225	113.34	113.04	113.185	986729.0
2018-09-14 15:00:00	MSFT	Stock	113.185	113.57	113.11	113.35	2379161.0
2018-09-14 16:00:00	MSFT	Stock	113.37	113.37	113.28	113.36	2420469.0
2018-09-14 17:00:00	MSFT	Stock	113.3	113.37	113.28	113.36	3251.0
2018-09-14 18:00:00	MSFT	Stock	113.36	113.36	113.26	113.26	1690.0
2018-09-14 19:00:00	MSFT	Stock	113.36	113.36	113.25	113.26	1222.0
2018-09-14 04:00:00	NVDA	Stock	6.809	6.809	6.809	6.809	10000.0
2018-09-14 06:00:00	NVDA	Stock	6.837	6.9088	6.837	6.8972	326880.0
2018-09-14 07:00:00	NVDA	Stock	6.8772	6.8968	6.8665	6.8873	683920.0
2018-09-14 08:00:00	NVDA	Stock	6.8875	6.8905	6.864	6.8782	1293000.0
2018-09-14 09:00:00	NVDA	Stock	6.8725	6.9475	6.8375	6.9441	79785640.0
2018-09-14 10:00:00	NVDA	Stock	6.944	6.9775	6.9058	6.9402	77859840.0
2018-09-14 11:00:00	NVDA	Stock	6.942	6.9548	6.9182	6.9365	31139960.0
2018-09-14 12:00:00	NVDA	Stock	6.9376	6.9402	6.8632	6.9048	46801960.0
2018-09-14 13:00:00	NVDA	Stock	6.9041	6.9078	6.873	6.8985	20129920.0
2018-09-14 14:00:00	NVDA	Stock	6.8988	6.92	6.8855	6.9192	22718840.0
2018-09-14 15:00:00	NVDA	Stock	6.9188	6.9195	6.8855	6.9112	46501640.0
2018-09-14 16:00:00	NVDA	Stock	6.9108	6.9108	6.9032	6.9073	8775480.0
2018-09-14 17:00:00	NVDA	Stock	6.908	6.9108	6.9043	6.9082	202000.0
2018-09-14 18:00:00	NVDA	Stock	6.9082	6.91	6.9045	6.91	160120.0
2018-09-14 19:00:00	NVDA	Stock	6.9125	6.9125	6.9075	6.9118	62360.0
2018-09-14 04:00:00	AMZN	Stock	99.955	100.0	99.95	99.955	17180.0
2018-09-14 05:00:00	AMZN	Stock	99.8625	99.8625	99.8625	99.8625	2000.0
2018-09-14 06:00:00	AMZN	Stock	99.893	99.9475	99.65	99.7	26000.0

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

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