PREVIEW / stock_1hour / 2019-04-12

all stock 1-hour files

  file:    by_date/stock_1hour/2019/2019-04-12.parquet
  size:    1.1 MB
  rows:    49,927
  symbols: 2,624

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-04-12 04:00:00	AAPL	Stock	49.82	50.0	49.82	50.0	2848.0
2019-04-12 05:00:00	AAPL	Stock	49.9975	50.0375	49.975	50.0375	16996.0
2019-04-12 06:00:00	AAPL	Stock	50.0	50.075	49.5	49.7	125088.0
2019-04-12 07:00:00	AAPL	Stock	49.75	49.925	49.65	49.86	227836.0
2019-04-12 08:00:00	AAPL	Stock	49.7498	50.0325	49.6875	49.9525	502288.0
2019-04-12 09:00:00	AAPL	Stock	49.96	50.035	49.755	49.955	13472896.0
2019-04-12 10:00:00	AAPL	Stock	49.9575	49.9725	49.1675	49.25	24685896.0
2019-04-12 11:00:00	AAPL	Stock	49.2525	49.425	49.0525	49.421	13929388.0
2019-04-12 12:00:00	AAPL	Stock	49.42	49.4925	49.375	49.45	7670388.0
2019-04-12 13:00:00	AAPL	Stock	49.45	49.615	49.42	49.5838	7477392.0
2019-04-12 14:00:00	AAPL	Stock	49.585	49.785	49.5725	49.6605	9794472.0
2019-04-12 15:00:00	AAPL	Stock	49.665	49.7625	49.605	49.72	13163876.0
2019-04-12 16:00:00	AAPL	Stock	49.7225	49.75	49.5965	49.6975	8877260.0
2019-04-12 17:00:00	AAPL	Stock	49.6975	49.7175	49.6775	49.6925	31972.0
2019-04-12 18:00:00	AAPL	Stock	49.7	49.735	49.6925	49.735	30036.0
2019-04-12 19:00:00	AAPL	Stock	49.735	49.7575	49.715	49.7575	30368.0
2019-04-12 04:00:00	MSFT	Stock	120.5	121.0	120.5	120.99	748.0
2019-04-12 05:00:00	MSFT	Stock	121.0	121.0	120.95	120.98	1300.0
2019-04-12 06:00:00	MSFT	Stock	120.9	121.17	120.9	121.17	4301.0
2019-04-12 07:00:00	MSFT	Stock	121.01	121.19	120.93	121.0	14445.0
2019-04-12 08:00:00	MSFT	Stock	120.91	121.2	120.9	120.932	43822.0
2019-04-12 09:00:00	MSFT	Stock	120.97	121.05	120.37	120.625	2444574.0
2019-04-12 10:00:00	MSFT	Stock	120.625	120.92	120.41	120.65	2459124.0
2019-04-12 11:00:00	MSFT	Stock	120.66	120.81	120.39	120.74	1384967.0
2019-04-12 12:00:00	MSFT	Stock	120.74	120.77	120.56	120.647	1655175.0
2019-04-12 13:00:00	MSFT	Stock	120.645	120.68	120.471	120.471	1178835.0
2019-04-12 14:00:00	MSFT	Stock	120.477	120.676	120.43	120.582	1502250.0
2019-04-12 15:00:00	MSFT	Stock	120.582	120.98	120.545	120.96	2858960.0
2019-04-12 16:00:00	MSFT	Stock	120.95	120.95	120.81	120.86	3153214.0
2019-04-12 17:00:00	MSFT	Stock	120.95	120.96	120.85	120.85	10773.0
2019-04-12 18:00:00	MSFT	Stock	120.86	120.93	120.85	120.93	392.0
2019-04-12 19:00:00	MSFT	Stock	120.9	120.95	120.85	120.94	1700.0
2019-04-12 04:00:00	NVDA	Stock	4.735	4.7938	4.735	4.7938	59800.0
2019-04-12 05:00:00	NVDA	Stock	4.7828	4.7925	4.7828	4.7925	18440.0
2019-04-12 06:00:00	NVDA	Stock	4.7992	4.7992	4.7885	4.7885	83880.0
2019-04-12 07:00:00	NVDA	Stock	4.7992	4.8225	4.7913	4.815	515720.0
2019-04-12 08:00:00	NVDA	Stock	4.805	4.8368	4.79	4.8251	1716440.0
2019-04-12 09:00:00	NVDA	Stock	4.8275	4.8315	4.778	4.8169	63300240.0
2019-04-12 10:00:00	NVDA	Stock	4.8175	4.818	4.7645	4.7688	60976800.0
2019-04-12 11:00:00	NVDA	Stock	4.7682	4.7828	4.7542	4.7784	42643040.0
2019-04-12 12:00:00	NVDA	Stock	4.778	4.815	4.7632	4.7655	27656240.0
2019-04-12 13:00:00	NVDA	Stock	4.7653	4.7794	4.7513	4.7544	99411120.0
2019-04-12 14:00:00	NVDA	Stock	4.7538	4.7665	4.7462	4.7638	27356880.0
2019-04-12 15:00:00	NVDA	Stock	4.7635	4.7698	4.7415	4.75	55861120.0
2019-04-12 16:00:00	NVDA	Stock	4.7502	4.7513	4.745	4.7468	38060560.0
2019-04-12 17:00:00	NVDA	Stock	4.7512	4.7512	4.7465	4.7465	106520.0
2019-04-12 18:00:00	NVDA	Stock	4.7432	4.7522	4.7425	4.7475	97600.0
2019-04-12 19:00:00	NVDA	Stock	4.7442	4.7475	4.7395	4.7395	201640.0
2019-04-12 04:00:00	AMZN	Stock	92.3	92.4945	92.3	92.4945	35100.0
2019-04-12 05:00:00	AMZN	Stock	92.49	92.49	92.45	92.46	31820.0

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

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