PREVIEW / stock_1hour / 2019-05-21

all stock 1-hour files

  file:    by_date/stock_1hour/2019/2019-05-21.parquet
  size:    1.1 MB
  rows:    49,452
  symbols: 2,594

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-05-21 04:00:00	AAPL	Stock	46.05	46.05	45.9525	45.9525	11764.0
2019-05-21 05:00:00	AAPL	Stock	45.995	46.3	45.94	46.3	63964.0
2019-05-21 06:00:00	AAPL	Stock	46.35	46.465	46.3275	46.3875	63448.0
2019-05-21 07:00:00	AAPL	Stock	46.405	46.41	46.0875	46.2	220144.0
2019-05-21 08:00:00	AAPL	Stock	46.2125	46.425	46.085	46.355	580776.0
2019-05-21 09:00:00	AAPL	Stock	46.34	46.58	46.175	46.515	16978532.0
2019-05-21 10:00:00	AAPL	Stock	46.515	46.93	46.3875	46.93	19057184.0
2019-05-21 11:00:00	AAPL	Stock	46.9325	46.9625	46.6675	46.7325	11425124.0
2019-05-21 12:00:00	AAPL	Stock	46.735	46.9425	46.7175	46.7975	8494548.0
2019-05-21 13:00:00	AAPL	Stock	46.7975	46.8895	46.78	46.885	5211360.0
2019-05-21 14:00:00	AAPL	Stock	46.885	47.0	46.8175	46.85	7020564.0
2019-05-21 15:00:00	AAPL	Stock	46.85	46.87	46.5875	46.6475	14469628.0
2019-05-21 16:00:00	AAPL	Stock	46.65	46.7745	46.53	46.5625	11725216.0
2019-05-21 17:00:00	AAPL	Stock	46.5575	46.6	46.5525	46.5525	21660.0
2019-05-21 18:00:00	AAPL	Stock	46.575	46.745	46.575	46.74	140992.0
2019-05-21 19:00:00	AAPL	Stock	46.735	46.745	46.69	46.7375	33412.0
2019-05-21 04:00:00	MSFT	Stock	127.0	128.0	127.0	127.5	1720.0
2019-05-21 05:00:00	MSFT	Stock	127.26	127.44	127.1	127.44	679.0
2019-05-21 06:00:00	MSFT	Stock	127.48	127.79	127.48	127.72	1875.0
2019-05-21 07:00:00	MSFT	Stock	127.65	127.7	127.0	127.25	13735.0
2019-05-21 08:00:00	MSFT	Stock	127.675	127.76	127.1	127.3	51857.0
2019-05-21 09:00:00	MSFT	Stock	127.4	127.67	126.86	126.936	1953799.0
2019-05-21 10:00:00	MSFT	Stock	126.93	127.46	126.58	127.295	2066672.0
2019-05-21 11:00:00	MSFT	Stock	127.3	127.385	126.74	126.85	1461236.0
2019-05-21 12:00:00	MSFT	Stock	126.87	127.13	126.76	127.01	1000485.0
2019-05-21 13:00:00	MSFT	Stock	127.02	127.105	126.835	127.083	804391.0
2019-05-21 14:00:00	MSFT	Stock	127.09	127.31	126.96	127.005	1048595.0
2019-05-21 15:00:00	MSFT	Stock	127.0	127.199	126.72	126.9	2211433.0
2019-05-21 16:00:00	MSFT	Stock	126.9	126.91	126.712	126.73	2801518.0
2019-05-21 17:00:00	MSFT	Stock	126.9	126.9	126.72	126.85	1535.0
2019-05-21 18:00:00	MSFT	Stock	126.85	126.95	126.85	126.95	5228.0
2019-05-21 19:00:00	MSFT	Stock	126.9	127.04	126.9	126.96	3721.0
2019-05-21 04:00:00	NVDA	Stock	3.841	3.841	3.841	3.841	4000.0
2019-05-21 06:00:00	NVDA	Stock	3.8598	3.8653	3.8548	3.8653	94240.0
2019-05-21 07:00:00	NVDA	Stock	3.8595	3.8595	3.841	3.85	799400.0
2019-05-21 08:00:00	NVDA	Stock	3.848	3.8649	3.8358	3.86	2385920.0
2019-05-21 09:00:00	NVDA	Stock	3.8605	3.8688	3.816	3.84	86477880.0
2019-05-21 10:00:00	NVDA	Stock	3.8388	3.8925	3.8232	3.8805	87418480.0
2019-05-21 11:00:00	NVDA	Stock	3.8806	3.892	3.8608	3.8668	40400840.0
2019-05-21 12:00:00	NVDA	Stock	3.867	3.88	3.8658	3.8738	26940200.0
2019-05-21 13:00:00	NVDA	Stock	3.8736	3.881	3.8675	3.8795	19944280.0
2019-05-21 14:00:00	NVDA	Stock	3.88	3.891	3.8778	3.8799	22774080.0
2019-05-21 15:00:00	NVDA	Stock	3.8795	3.8865	3.8695	3.8765	38911280.0
2019-05-21 16:00:00	NVDA	Stock	3.8765	3.8812	3.8712	3.8775	17490840.0
2019-05-21 17:00:00	NVDA	Stock	3.8775	3.8775	3.8703	3.8703	161520.0
2019-05-21 18:00:00	NVDA	Stock	3.8765	3.88	3.874	3.88	200120.0
2019-05-21 19:00:00	NVDA	Stock	3.88	3.88	3.875	3.8768	211600.0
2019-05-21 04:00:00	AMZN	Stock	93.478	93.54	93.478	93.54	5840.0
2019-05-21 05:00:00	AMZN	Stock	93.464	93.7	93.401	93.7	24560.0
2019-05-21 06:00:00	AMZN	Stock	94.09	94.09	94.09	94.09	3000.0

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

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