PREVIEW / stock_1hour / 2019-02-12

all stock 1-hour files

  file:    by_date/stock_1hour/2019/2019-02-12.parquet
  size:    1.1 MB
  rows:    49,513
  symbols: 2,663

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-12 04:00:00	AAPL	Stock	42.62	42.6625	42.5825	42.65	6128.0
2019-02-12 05:00:00	AAPL	Stock	42.6725	42.6875	42.67	42.675	19136.0
2019-02-12 06:00:00	AAPL	Stock	42.6375	42.6825	42.6375	42.675	2508.0
2019-02-12 07:00:00	AAPL	Stock	42.65	42.7025	42.5975	42.6275	126764.0
2019-02-12 08:00:00	AAPL	Stock	42.67	42.7	42.5325	42.5475	301112.0
2019-02-12 09:00:00	AAPL	Stock	42.57	42.7375	42.4375	42.53	11800564.0
2019-02-12 10:00:00	AAPL	Stock	42.53	42.6625	42.425	42.6048	11583872.0
2019-02-12 11:00:00	AAPL	Stock	42.6025	42.67	42.4375	42.4675	10688432.0
2019-02-12 12:00:00	AAPL	Stock	42.4675	42.585	42.445	42.5025	7288592.0
2019-02-12 13:00:00	AAPL	Stock	42.4975	42.6625	42.48	42.63	5848844.0
2019-02-12 14:00:00	AAPL	Stock	42.6325	42.6625	42.5625	42.615	5786996.0
2019-02-12 15:00:00	AAPL	Stock	42.615	42.75	42.61	42.7225	12742064.0
2019-02-12 16:00:00	AAPL	Stock	42.7225	42.735	42.6625	42.71	9433060.0
2019-02-12 17:00:00	AAPL	Stock	42.72	42.7225	42.69	42.6925	27072.0
2019-02-12 18:00:00	AAPL	Stock	42.695	42.765	42.6925	42.765	69576.0
2019-02-12 19:00:00	AAPL	Stock	42.77	42.875	42.75	42.875	129660.0
2019-02-12 05:00:00	MSFT	Stock	106.0	106.12	106.0	106.12	2245.0
2019-02-12 06:00:00	MSFT	Stock	106.12	106.18	106.12	106.18	450.0
2019-02-12 07:00:00	MSFT	Stock	106.1	106.38	106.04	106.3	21951.0
2019-02-12 08:00:00	MSFT	Stock	106.24	106.4	106.02	106.15	56999.0
2019-02-12 09:00:00	MSFT	Stock	106.17	106.4	105.48	106.108	2766678.0
2019-02-12 10:00:00	MSFT	Stock	106.105	106.96	106.09	106.96	3705636.0
2019-02-12 11:00:00	MSFT	Stock	106.965	107.14	106.8	107.075	3194699.0
2019-02-12 12:00:00	MSFT	Stock	107.074	107.12	106.79	106.845	2181383.0
2019-02-12 13:00:00	MSFT	Stock	106.85	106.9	106.61	106.81	2119193.0
2019-02-12 14:00:00	MSFT	Stock	106.81	106.815	106.59	106.605	1840753.0
2019-02-12 15:00:00	MSFT	Stock	106.61	106.98	106.6	106.89	3785674.0
2019-02-12 16:00:00	MSFT	Stock	106.89	106.89	106.65	106.76	2813659.0
2019-02-12 17:00:00	MSFT	Stock	106.8	106.8	106.76	106.77	4885.0
2019-02-12 18:00:00	MSFT	Stock	106.83	106.96	106.83	106.96	3680.0
2019-02-12 19:00:00	MSFT	Stock	107.0	107.28	106.89	107.07	17963.0
2019-02-12 04:00:00	NVDA	Stock	3.7125	3.7125	3.7125	3.7125	4000.0
2019-02-12 06:00:00	NVDA	Stock	3.6982	3.6995	3.6982	3.699	31000.0
2019-02-12 07:00:00	NVDA	Stock	3.7	3.7065	3.6875	3.692	813240.0
2019-02-12 08:00:00	NVDA	Stock	3.69	3.7072	3.6702	3.6875	1483640.0
2019-02-12 09:00:00	NVDA	Stock	3.685	3.7725	3.6818	3.7513	102351000.0
2019-02-12 10:00:00	NVDA	Stock	3.751	3.7665	3.7288	3.757	84874800.0
2019-02-12 11:00:00	NVDA	Stock	3.7572	3.7621	3.7395	3.7498	51070120.0
2019-02-12 12:00:00	NVDA	Stock	3.7502	3.7658	3.7478	3.7528	49373200.0
2019-02-12 13:00:00	NVDA	Stock	3.7535	3.7568	3.7413	3.754	41366760.0
2019-02-12 14:00:00	NVDA	Stock	3.7538	3.7892	3.746	3.7786	87901000.0
2019-02-12 15:00:00	NVDA	Stock	3.7785	3.795	3.7738	3.7785	91657920.0
2019-02-12 16:00:00	NVDA	Stock	3.7792	3.7847	3.7752	3.7798	35844880.0
2019-02-12 17:00:00	NVDA	Stock	3.7788	3.78	3.7712	3.7712	321200.0
2019-02-12 18:00:00	NVDA	Stock	3.775	3.7822	3.7725	3.7812	203960.0
2019-02-12 19:00:00	NVDA	Stock	3.78	3.79	3.78	3.79	837920.0
2019-02-12 04:00:00	AMZN	Stock	80.0	80.0	80.0	80.0	9700.0
2019-02-12 06:00:00	AMZN	Stock	80.292	80.292	80.292	80.292	2000.0
2019-02-12 07:00:00	AMZN	Stock	80.367	80.4	80.1995	80.2	438320.0
2019-02-12 08:00:00	AMZN	Stock	80.2875	80.375	80.125	80.1505	340600.0

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

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