PREVIEW / stock_1hour / 2020-01-02

all stock 1-hour files

  file:    by_date/stock_1hour/2020/2020-01-02.parquet
  size:    1.2 MB
  rows:    51,893
  symbols: 2,467

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
2020-01-02 04:00:00	AAPL	Stock	73.7625	73.9375	73.7625	73.9325	86764.0
2020-01-02 05:00:00	AAPL	Stock	73.9375	74.0125	73.9375	74.0	52308.0
2020-01-02 06:00:00	AAPL	Stock	73.9375	73.9625	73.825	73.8775	46968.0
2020-01-02 07:00:00	AAPL	Stock	73.875	74.045	73.7825	74.025	441004.0
2020-01-02 08:00:00	AAPL	Stock	73.9725	74.1875	73.8588	74.17	714624.0
2020-01-02 09:00:00	AAPL	Stock	74.1725	74.5375	73.7975	74.4925	20827524.0
2020-01-02 10:00:00	AAPL	Stock	74.4975	74.6025	74.1488	74.5275	20747048.0
2020-01-02 11:00:00	AAPL	Stock	74.5325	74.6875	74.3625	74.6025	14588764.0
2020-01-02 12:00:00	AAPL	Stock	74.6025	74.7	74.5125	74.6752	8612528.0
2020-01-02 13:00:00	AAPL	Stock	74.6768	74.6825	74.525	74.61	7070732.0
2020-01-02 14:00:00	AAPL	Stock	74.61	74.7892	74.515	74.77	10410572.0
2020-01-02 15:00:00	AAPL	Stock	74.77	75.15	74.76	75.145	22792024.0
2020-01-02 16:00:00	AAPL	Stock	75.0875	75.2325	75.08	75.225	10459980.0
2020-01-02 17:00:00	AAPL	Stock	75.235	75.235	75.175	75.19	147540.0
2020-01-02 18:00:00	AAPL	Stock	75.2125	75.225	75.19	75.1925	48768.0
2020-01-02 19:00:00	AAPL	Stock	75.2	75.2975	75.195	75.2975	128220.0
2020-01-02 04:00:00	MSFT	Stock	158.7	158.99	158.7	158.98	6783.0
2020-01-02 05:00:00	MSFT	Stock	159.09	159.19	158.89	158.97	6522.0
2020-01-02 06:00:00	MSFT	Stock	158.98	158.98	158.82	158.86	9007.0
2020-01-02 07:00:00	MSFT	Stock	158.86	158.98	158.77	158.9	27069.0
2020-01-02 08:00:00	MSFT	Stock	158.89	159.19	157.7	159.1	68243.0
2020-01-02 09:00:00	MSFT	Stock	159.1	159.55	158.33	159.525	3234199.0
2020-01-02 10:00:00	MSFT	Stock	159.53	159.555	158.78	159.464	2495337.0
2020-01-02 11:00:00	MSFT	Stock	159.47	159.63	159.11	159.375	1776767.0
2020-01-02 12:00:00	MSFT	Stock	159.375	159.8	159.305	159.69	1338430.0
2020-01-02 13:00:00	MSFT	Stock	159.696	159.77	159.445	159.745	1234553.0
2020-01-02 14:00:00	MSFT	Stock	159.745	160.04	159.69	160.02	1685609.0
2020-01-02 15:00:00	MSFT	Stock	160.01	160.73	159.89	160.73	3484370.0
2020-01-02 16:00:00	MSFT	Stock	160.71	160.79	160.56	160.76	2972197.0
2020-01-02 17:00:00	MSFT	Stock	160.654	160.76	160.64	160.65	5043.0
2020-01-02 18:00:00	MSFT	Stock	160.7	160.79	160.63	160.7	3441.0
2020-01-02 19:00:00	MSFT	Stock	160.7	160.8	160.65	160.8	7936.0
2020-01-02 04:00:00	NVDA	Stock	5.9263	5.9743	5.9263	5.965	69960.0
2020-01-02 05:00:00	NVDA	Stock	5.965	5.9748	5.9633	5.971	38240.0
2020-01-02 06:00:00	NVDA	Stock	5.9748	5.9762	5.9698	5.9698	49640.0
2020-01-02 07:00:00	NVDA	Stock	5.959	5.9743	5.9503	5.9725	668800.0
2020-01-02 08:00:00	NVDA	Stock	5.9718	5.9888	5.9508	5.9818	1765640.0
2020-01-02 09:00:00	NVDA	Stock	5.981	5.9838	5.9222	5.975	39243240.0
2020-01-02 10:00:00	NVDA	Stock	5.975	5.976	5.9315	5.9453	37162440.0
2020-01-02 11:00:00	NVDA	Stock	5.945	5.9558	5.918	5.9538	26077000.0
2020-01-02 12:00:00	NVDA	Stock	5.9533	5.9812	5.944	5.976	19901640.0
2020-01-02 13:00:00	NVDA	Stock	5.9761	5.9842	5.9618	5.983	14978240.0
2020-01-02 14:00:00	NVDA	Stock	5.9833	5.997	5.9824	5.9869	21522240.0
2020-01-02 15:00:00	NVDA	Stock	5.9875	5.9978	5.9789	5.9965	27095920.0
2020-01-02 16:00:00	NVDA	Stock	5.9978	6.0028	5.9888	6.002	3916280.0
2020-01-02 17:00:00	NVDA	Stock	6.0002	6.0028	5.9978	6.002	250320.0
2020-01-02 18:00:00	NVDA	Stock	6.0	6.0022	6.0	6.0008	232680.0
2020-01-02 19:00:00	NVDA	Stock	6.0005	6.01	6.0	6.0013	181360.0
2020-01-02 04:00:00	AMZN	Stock	93.2055	93.25	93.2055	93.25	4000.0
2020-01-02 07:00:00	AMZN	Stock	93.24	93.434	93.24	93.4055	170020.0

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

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