PREVIEW / stock_1hour / 2019-02-20

all stock 1-hour files

  file:    by_date/stock_1hour/2019/2019-02-20.parquet
  size:    1.1 MB
  rows:    49,883
  symbols: 2,693

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
2019-02-20 04:00:00	AAPL	Stock	42.7375	42.7425	42.675	42.675	8688.0
2019-02-20 05:00:00	AAPL	Stock	42.69	42.7425	42.69	42.74	1200.0
2019-02-20 06:00:00	AAPL	Stock	42.6875	42.6875	42.58	42.58	11988.0
2019-02-20 07:00:00	AAPL	Stock	42.685	42.72	42.655	42.6675	66284.0
2019-02-20 08:00:00	AAPL	Stock	42.6625	42.8375	42.6075	42.725	182460.0
2019-02-20 09:00:00	AAPL	Stock	42.7325	43.055	42.695	43.02	12714560.0
2019-02-20 10:00:00	AAPL	Stock	43.0212	43.33	42.9675	43.18	15968448.0
2019-02-20 11:00:00	AAPL	Stock	43.1825	43.24	43.1325	43.16	7983388.0
2019-02-20 12:00:00	AAPL	Stock	43.1625	43.1825	42.9025	42.9775	7969932.0
2019-02-20 13:00:00	AAPL	Stock	42.9775	43.1175	42.97	43.0975	5302340.0
2019-02-20 14:00:00	AAPL	Stock	43.0965	43.2075	42.8375	43.0625	12813564.0
2019-02-20 15:00:00	AAPL	Stock	43.065	43.0925	42.91	43.0225	10100772.0
2019-02-20 16:00:00	AAPL	Stock	43.0075	43.0765	42.9475	42.9825	7025096.0
2019-02-20 17:00:00	AAPL	Stock	43.0	43.0075	42.9775	42.9975	3130436.0
2019-02-20 18:00:00	AAPL	Stock	43.0	43.0	42.975	42.9975	6144.0
2019-02-20 19:00:00	AAPL	Stock	42.995	42.9975	42.9725	42.9725	25024.0
2019-02-20 06:00:00	MSFT	Stock	107.79	107.85	107.76	107.76	850.0
2019-02-20 07:00:00	MSFT	Stock	107.79	107.88	107.79	107.85	6427.0
2019-02-20 08:00:00	MSFT	Stock	107.601	107.96	107.601	107.88	18198.0
2019-02-20 09:00:00	MSFT	Stock	107.92	107.95	107.36	107.69	1841916.0
2019-02-20 10:00:00	MSFT	Stock	107.71	107.79	107.447	107.47	2373971.0
2019-02-20 11:00:00	MSFT	Stock	107.48	107.58	107.25	107.325	1947316.0
2019-02-20 12:00:00	MSFT	Stock	107.321	107.39	106.29	106.56	2618188.0
2019-02-20 13:00:00	MSFT	Stock	106.56	107.04	106.54	106.985	1325094.0
2019-02-20 14:00:00	MSFT	Stock	106.98	107.31	106.34	107.03	2386116.0
2019-02-20 15:00:00	MSFT	Stock	107.03	107.32	106.93	107.2	2786208.0
2019-02-20 16:00:00	MSFT	Stock	107.18	107.335	106.98	107.15	3628832.0
2019-02-20 17:00:00	MSFT	Stock	107.15	107.15	107.02	107.05	1452.0
2019-02-20 18:00:00	MSFT	Stock	107.02	107.12	107.0	107.12	1438.0
2019-02-20 19:00:00	MSFT	Stock	107.0	107.07	107.0	107.07	1100.0
2019-02-20 04:00:00	NVDA	Stock	3.91	3.91	3.91	3.91	4000.0
2019-02-20 06:00:00	NVDA	Stock	3.9263	3.9263	3.9263	3.9263	4000.0
2019-02-20 07:00:00	NVDA	Stock	3.926	3.9448	3.925	3.9388	515120.0
2019-02-20 08:00:00	NVDA	Stock	3.925	3.945	3.925	3.9448	870720.0
2019-02-20 09:00:00	NVDA	Stock	3.9422	3.9968	3.9343	3.9868	79101160.0
2019-02-20 10:00:00	NVDA	Stock	3.9868	4.0315	3.9847	4.01	113094080.0
2019-02-20 11:00:00	NVDA	Stock	4.0085	4.0245	3.9955	3.9964	56827360.0
2019-02-20 12:00:00	NVDA	Stock	3.9966	4.0055	3.9644	3.9751	51618320.0
2019-02-20 13:00:00	NVDA	Stock	3.9745	4.0063	3.9745	4.0002	29608840.0
2019-02-20 14:00:00	NVDA	Stock	4.0013	4.0145	3.9718	3.9873	51849400.0
2019-02-20 15:00:00	NVDA	Stock	3.9873	3.9945	3.9553	3.9642	59579760.0
2019-02-20 16:00:00	NVDA	Stock	3.9638	3.9873	3.9602	3.9675	11821160.0
2019-02-20 17:00:00	NVDA	Stock	3.9725	3.975	3.9675	3.9748	527480.0
2019-02-20 18:00:00	NVDA	Stock	3.9722	3.9772	3.9722	3.9748	190280.0
2019-02-20 19:00:00	NVDA	Stock	3.977	3.9772	3.9688	3.97	236680.0
2019-02-20 05:00:00	AMZN	Stock	81.379	81.379	81.379	81.379	2700.0
2019-02-20 07:00:00	AMZN	Stock	81.3845	81.5	81.3845	81.445	27440.0
2019-02-20 08:00:00	AMZN	Stock	81.45	81.62	81.375	81.61	147140.0
2019-02-20 09:00:00	AMZN	Stock	81.61	81.7465	81.2	81.6855	5758180.0
2019-02-20 10:00:00	AMZN	Stock	81.6755	81.725	81.36	81.6366	3705360.0

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

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