PREVIEW / stock_1hour / 2018-11-02

all stock 1-hour files

  file:    by_date/stock_1hour/2018/2018-11-02.parquet
  size:    1.1 MB
  rows:    49,789
  symbols: 2,747

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-11-02 04:00:00	AAPL	Stock	52.495	53.05	52.3525	52.7125	438136.0
2018-11-02 05:00:00	AAPL	Stock	52.7475	52.92	52.5	52.6875	371672.0
2018-11-02 06:00:00	AAPL	Stock	52.6975	52.9125	52.35	52.6375	810576.0
2018-11-02 07:00:00	AAPL	Stock	52.5925	52.8	52.025	52.4	2757108.0
2018-11-02 08:00:00	AAPL	Stock	52.4	52.8	51.92	52.025	4897624.0
2018-11-02 09:00:00	AAPL	Stock	52.025	53.4125	51.7925	52.5175	75744176.0
2018-11-02 10:00:00	AAPL	Stock	52.5285	52.61	51.6	52.0	66716992.0
2018-11-02 11:00:00	AAPL	Stock	52.0	52.12	51.595	51.815	33007076.0
2018-11-02 12:00:00	AAPL	Stock	51.8175	52.0025	51.47	51.57	29708208.0
2018-11-02 13:00:00	AAPL	Stock	51.576	51.815	51.4125	51.6287	18655764.0
2018-11-02 14:00:00	AAPL	Stock	51.6275	51.86	51.3575	51.8	21515764.0
2018-11-02 15:00:00	AAPL	Stock	51.8	51.8675	51.375	51.8675	39209188.0
2018-11-02 16:00:00	AAPL	Stock	51.8675	51.87	51.3775	51.7	16984052.0
2018-11-02 17:00:00	AAPL	Stock	51.6975	51.71	51.54	51.63	219876.0
2018-11-02 18:00:00	AAPL	Stock	51.63	51.6725	51.6	51.6375	166068.0
2018-11-02 19:00:00	AAPL	Stock	51.65	51.6725	51.6025	51.625	139476.0
2018-11-02 04:00:00	MSFT	Stock	107.0	107.75	106.82	107.34	15871.0
2018-11-02 05:00:00	MSFT	Stock	107.3	107.3	106.85	107.0	8069.0
2018-11-02 06:00:00	MSFT	Stock	106.92	107.17	106.9	107.17	900.0
2018-11-02 07:00:00	MSFT	Stock	107.07	107.25	106.85	107.06	50531.0
2018-11-02 08:00:00	MSFT	Stock	107.1	107.25	106.59	106.76	91597.0
2018-11-02 09:00:00	MSFT	Stock	106.76	107.32	105.95	106.568	4176162.0
2018-11-02 10:00:00	MSFT	Stock	106.56	106.9	105.19	105.835	4617308.0
2018-11-02 11:00:00	MSFT	Stock	105.85	106.11	105.22	105.9	3666779.0
2018-11-02 12:00:00	MSFT	Stock	105.89	106.025	105.17	105.34	3262938.0
2018-11-02 13:00:00	MSFT	Stock	105.36	106.01	105.03	105.74	2845743.0
2018-11-02 14:00:00	MSFT	Stock	105.745	106.215	104.975	106.1	3953166.0
2018-11-02 15:00:00	MSFT	Stock	106.09	106.64	105.71	106.15	6451606.0
2018-11-02 16:00:00	MSFT	Stock	106.16	106.3	105.98	106.17	5096185.0
2018-11-02 17:00:00	MSFT	Stock	106.1	106.17	106.03	106.07	3025.0
2018-11-02 18:00:00	MSFT	Stock	106.1	106.12	106.06	106.12	900.0
2018-11-02 19:00:00	MSFT	Stock	106.1	106.22	106.1	106.19	2154.0
2018-11-02 04:00:00	NVDA	Stock	5.5145	5.5548	5.5	5.5525	194920.0
2018-11-02 05:00:00	NVDA	Stock	5.555	5.5555	5.5162	5.5345	123960.0
2018-11-02 06:00:00	NVDA	Stock	5.525	5.525	5.515	5.5242	224040.0
2018-11-02 07:00:00	NVDA	Stock	5.525	5.58	5.4528	5.5648	2474520.0
2018-11-02 08:00:00	NVDA	Stock	5.5498	5.5778	5.475	5.5125	4451800.0
2018-11-02 09:00:00	NVDA	Stock	5.507	5.55	5.3875	5.44	80362840.0
2018-11-02 10:00:00	NVDA	Stock	5.4447	5.4718	5.3352	5.4058	76550800.0
2018-11-02 11:00:00	NVDA	Stock	5.4058	5.4061	5.35	5.3995	31466400.0
2018-11-02 12:00:00	NVDA	Stock	5.4002	5.408	5.2775	5.316	34694040.0
2018-11-02 13:00:00	NVDA	Stock	5.315	5.3598	5.2858	5.3028	34511760.0
2018-11-02 14:00:00	NVDA	Stock	5.3005	5.343	5.2553	5.3264	40144040.0
2018-11-02 15:00:00	NVDA	Stock	5.3283	5.3848	5.2948	5.3718	57610360.0
2018-11-02 16:00:00	NVDA	Stock	5.3728	5.3785	5.357	5.372	34897120.0
2018-11-02 17:00:00	NVDA	Stock	5.3725	5.3798	5.3725	5.3798	211840.0
2018-11-02 18:00:00	NVDA	Stock	5.3795	5.3798	5.3738	5.375	66080.0
2018-11-02 19:00:00	NVDA	Stock	5.375	5.3935	5.375	5.385	93400.0
2018-11-02 04:00:00	AMZN	Stock	83.65	84.2	83.65	84.1	74440.0
2018-11-02 05:00:00	AMZN	Stock	84.05	84.05	83.55	83.6	23980.0

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

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