PREVIEW / stock_1hour / 2019-01-22

all stock 1-hour files

  file:    by_date/stock_1hour/2019/2019-01-22.parquet
  size:    1.1 MB
  rows:    50,220
  symbols: 2,690

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-01-22 04:00:00	AAPL	Stock	39.05	39.05	38.875	38.95	26348.0
2019-01-22 05:00:00	AAPL	Stock	38.9175	38.9175	38.8275	38.8475	17204.0
2019-01-22 06:00:00	AAPL	Stock	38.8475	38.8575	38.7875	38.8575	16260.0
2019-01-22 07:00:00	AAPL	Stock	38.8375	38.9475	38.8375	38.875	91724.0
2019-01-22 08:00:00	AAPL	Stock	38.8775	39.205	38.8375	38.97	668500.0
2019-01-22 09:00:00	AAPL	Stock	38.98	39.205	38.8075	38.8525	12168956.0
2019-01-22 10:00:00	AAPL	Stock	38.8538	38.8875	38.695	38.7975	12589976.0
2019-01-22 11:00:00	AAPL	Stock	38.7925	38.92	38.6125	38.645	10339456.0
2019-01-22 12:00:00	AAPL	Stock	38.645	38.8325	38.6075	38.6882	8262840.0
2019-01-22 13:00:00	AAPL	Stock	38.6875	38.6875	38.485	38.5808	10052168.0
2019-01-22 14:00:00	AAPL	Stock	38.5775	38.6025	38.2188	38.2985	13485908.0
2019-01-22 15:00:00	AAPL	Stock	38.2975	38.505	38.155	38.4225	22906160.0
2019-01-22 16:00:00	AAPL	Stock	38.4225	38.4225	38.2875	38.3	15070376.0
2019-01-22 17:00:00	AAPL	Stock	38.3225	38.36	38.3225	38.36	21676.0
2019-01-22 18:00:00	AAPL	Stock	38.3325	38.3325	38.265	38.325	31872.0
2019-01-22 19:00:00	AAPL	Stock	38.325	38.375	38.325	38.3725	31712.0
2019-01-22 04:00:00	MSFT	Stock	107.48	107.48	106.86	107.0	3277.0
2019-01-22 05:00:00	MSFT	Stock	107.0	107.0	106.61	106.78	3204.0
2019-01-22 06:00:00	MSFT	Stock	106.65	106.65	106.61	106.61	200.0
2019-01-22 07:00:00	MSFT	Stock	106.82	107.15	106.7	106.92	7389.0
2019-01-22 08:00:00	MSFT	Stock	106.9	107.07	106.63	106.79	31344.0
2019-01-22 09:00:00	MSFT	Stock	106.81	107.1	106.44	106.95	2769939.0
2019-01-22 10:00:00	MSFT	Stock	106.945	107.05	106.55	106.78	3504105.0
2019-01-22 11:00:00	MSFT	Stock	106.76	106.79	106.11	106.15	2116583.0
2019-01-22 12:00:00	MSFT	Stock	106.13	106.37	105.89	106.065	2454228.0
2019-01-22 13:00:00	MSFT	Stock	106.07	106.075	105.42	105.69	3038490.0
2019-01-22 14:00:00	MSFT	Stock	105.69	105.72	104.97	105.13	2804491.0
2019-01-22 15:00:00	MSFT	Stock	105.13	105.97	104.86	105.82	5262772.0
2019-01-22 16:00:00	MSFT	Stock	105.68	105.99	105.54	105.75	6792622.0
2019-01-22 17:00:00	MSFT	Stock	105.78	105.87	105.765	105.87	4368.0
2019-01-22 18:00:00	MSFT	Stock	105.83	105.83	105.5	105.75	6780.0
2019-01-22 19:00:00	MSFT	Stock	105.84	105.98	105.83	105.94	7801.0
2019-01-22 04:00:00	NVDA	Stock	3.9	3.9075	3.8752	3.9013	94440.0
2019-01-22 05:00:00	NVDA	Stock	3.8975	3.8975	3.8805	3.89	24560.0
2019-01-22 06:00:00	NVDA	Stock	3.8778	3.8778	3.8575	3.8625	76720.0
2019-01-22 07:00:00	NVDA	Stock	3.8838	3.904	3.8628	3.8938	856040.0
2019-01-22 08:00:00	NVDA	Stock	3.8916	3.9013	3.8626	3.8905	1109640.0
2019-01-22 09:00:00	NVDA	Stock	3.8875	3.9232	3.7604	3.8009	128214040.0
2019-01-22 10:00:00	NVDA	Stock	3.8013	3.8038	3.7428	3.7764	105973560.0
2019-01-22 11:00:00	NVDA	Stock	3.7773	3.7958	3.7545	3.7662	48288520.0
2019-01-22 12:00:00	NVDA	Stock	3.7646	3.7788	3.754	3.7578	34333240.0
2019-01-22 13:00:00	NVDA	Stock	3.7578	3.7578	3.7138	3.737	63437840.0
2019-01-22 14:00:00	NVDA	Stock	3.7362	3.7425	3.6892	3.713	73557120.0
2019-01-22 15:00:00	NVDA	Stock	3.7112	3.7222	3.6888	3.721	109998920.0
2019-01-22 16:00:00	NVDA	Stock	3.7193	3.9208	3.7163	3.7302	21582600.0
2019-01-22 17:00:00	NVDA	Stock	3.7285	3.7322	3.7258	3.7258	217680.0
2019-01-22 18:00:00	NVDA	Stock	3.725	3.7258	3.7163	3.724	293440.0
2019-01-22 19:00:00	NVDA	Stock	3.7245	3.7395	3.7245	3.7395	365640.0
2019-01-22 04:00:00	AMZN	Stock	84.3505	84.355	84.3505	84.355	6000.0
2019-01-22 05:00:00	AMZN	Stock	84.3105	84.355	84.025	84.0255	15000.0

> showing 50 of 50,220 rows — these rows as CSV

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