PREVIEW / stock_1hour / 2019-08-02

all stock 1-hour files

  file:    by_date/stock_1hour/2019/2019-08-02.parquet
  size:    1.1 MB
  rows:    49,409
  symbols: 2,561

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-08-02 04:00:00	AAPL	Stock	51.55	51.55	51.3775	51.4425	38336.0
2019-08-02 05:00:00	AAPL	Stock	51.385	51.4125	51.3725	51.4	11480.0
2019-08-02 06:00:00	AAPL	Stock	51.3875	51.66	51.3875	51.66	48636.0
2019-08-02 07:00:00	AAPL	Stock	51.5875	51.66	51.5025	51.53	226576.0
2019-08-02 08:00:00	AAPL	Stock	51.5275	52.1075	51.37	51.57	837828.0
2019-08-02 09:00:00	AAPL	Stock	51.5875	51.9475	50.9425	51.2375	25080848.0
2019-08-02 10:00:00	AAPL	Stock	51.235	51.37	50.4075	50.481	27770080.0
2019-08-02 11:00:00	AAPL	Stock	50.4825	50.925	50.425	50.7975	16567744.0
2019-08-02 12:00:00	AAPL	Stock	50.795	51.155	50.7152	50.8912	14701660.0
2019-08-02 13:00:00	AAPL	Stock	50.895	50.9175	50.6775	50.8825	9038856.0
2019-08-02 14:00:00	AAPL	Stock	50.885	51.12	50.8025	50.9825	9613684.0
2019-08-02 15:00:00	AAPL	Stock	50.9875	51.1875	50.745	51.0225	20537156.0
2019-08-02 16:00:00	AAPL	Stock	51.0225	51.0975	50.94	51.0625	8012544.0
2019-08-02 17:00:00	AAPL	Stock	51.0825	51.0825	51.0125	51.05	76488.0
2019-08-02 18:00:00	AAPL	Stock	51.0625	51.075	51.0425	51.06	9520.0
2019-08-02 19:00:00	AAPL	Stock	51.05	51.125	51.0375	51.125	71816.0
2019-08-02 04:00:00	MSFT	Stock	137.16	137.16	136.8	136.8	1400.0
2019-08-02 05:00:00	MSFT	Stock	136.97	136.97	136.7	136.7	1253.0
2019-08-02 06:00:00	MSFT	Stock	137.12	137.3	137.12	137.3	2028.0
2019-08-02 07:00:00	MSFT	Stock	137.34	137.43	137.2	137.25	11361.0
2019-08-02 08:00:00	MSFT	Stock	137.243	138.06	136.79	137.38	39693.0
2019-08-02 09:00:00	MSFT	Stock	137.37	138.4	136.59	136.79	3422476.0
2019-08-02 10:00:00	MSFT	Stock	136.82	137.11	135.53	135.54	4407723.0
2019-08-02 11:00:00	MSFT	Stock	135.54	136.18	135.49	135.909	3343657.0
2019-08-02 12:00:00	MSFT	Stock	135.9	136.416	135.75	135.8	2412305.0
2019-08-02 13:00:00	MSFT	Stock	135.785	135.9	135.26	135.5	2078440.0
2019-08-02 14:00:00	MSFT	Stock	135.51	136.51	135.34	136.24	2271927.0
2019-08-02 15:00:00	MSFT	Stock	136.25	137.08	135.93	136.9	5641339.0
2019-08-02 16:00:00	MSFT	Stock	136.9	136.99	135.668	136.97	2625446.0
2019-08-02 17:00:00	MSFT	Stock	136.914	136.97	136.914	136.94	2311.0
2019-08-02 18:00:00	MSFT	Stock	136.9	136.98	136.9	136.95	1692.0
2019-08-02 19:00:00	MSFT	Stock	136.9	136.96	136.9	136.95	4567.0
2019-08-02 04:00:00	NVDA	Stock	4.0478	4.0478	4.025	4.025	93120.0
2019-08-02 05:00:00	NVDA	Stock	4.0125	4.05	4.0125	4.0375	95520.0
2019-08-02 06:00:00	NVDA	Stock	4.035	4.0513	4.035	4.0513	63040.0
2019-08-02 07:00:00	NVDA	Stock	4.0375	4.075	4.0375	4.0475	504600.0
2019-08-02 08:00:00	NVDA	Stock	4.055	4.123	4.0325	4.05	1721800.0
2019-08-02 09:00:00	NVDA	Stock	4.0498	4.0995	4.0	4.055	72065440.0
2019-08-02 10:00:00	NVDA	Stock	4.0555	4.0655	3.982	3.989	74364440.0
2019-08-02 11:00:00	NVDA	Stock	3.989	4.0275	3.9868	4.0275	43122440.0
2019-08-02 12:00:00	NVDA	Stock	4.0265	4.0452	4.015	4.017	34052120.0
2019-08-02 13:00:00	NVDA	Stock	4.0168	4.0288	4.008	4.0148	21285400.0
2019-08-02 14:00:00	NVDA	Stock	4.0148	4.0298	4.0088	4.0208	24362920.0
2019-08-02 15:00:00	NVDA	Stock	4.0212	4.043	4.013	4.0292	64008160.0
2019-08-02 16:00:00	NVDA	Stock	4.0298	4.0344	4.024	4.0325	2261560.0
2019-08-02 17:00:00	NVDA	Stock	4.0298	4.0353	4.0298	4.035	175440.0
2019-08-02 18:00:00	NVDA	Stock	4.0353	4.0353	4.035	4.0353	54000.0
2019-08-02 19:00:00	NVDA	Stock	4.0315	4.0372	4.0303	4.0372	109760.0
2019-08-02 04:00:00	AMZN	Stock	91.905	91.905	91.695	91.8315	21520.0
2019-08-02 05:00:00	AMZN	Stock	91.808	91.808	91.808	91.808	2000.0

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

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