PREVIEW / stock_1hour / 2019-09-10

all stock 1-hour files

  file:    by_date/stock_1hour/2019/2019-09-10.parquet
  size:    1.1 MB
  rows:    49,854
  symbols: 2,558

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-09-10 04:00:00	AAPL	Stock	53.255	53.2875	53.15	53.205	21512.0
2019-09-10 05:00:00	AAPL	Stock	53.2875	53.35	53.23	53.35	28380.0
2019-09-10 06:00:00	AAPL	Stock	53.35	53.4175	53.35	53.4	47820.0
2019-09-10 07:00:00	AAPL	Stock	53.43	53.5725	53.3625	53.425	113292.0
2019-09-10 08:00:00	AAPL	Stock	53.4375	53.6	53.4	53.4	205452.0
2019-09-10 09:00:00	AAPL	Stock	53.405	53.6375	52.9275	53.305	11812580.0
2019-09-10 10:00:00	AAPL	Stock	53.3	53.4	53.19	53.2625	8107676.0
2019-09-10 11:00:00	AAPL	Stock	53.2628	53.605	53.2575	53.4825	7363404.0
2019-09-10 12:00:00	AAPL	Stock	53.4925	53.6575	53.3225	53.605	7092020.0
2019-09-10 13:00:00	AAPL	Stock	53.6075	53.95	53.35	53.45	21958220.0
2019-09-10 14:00:00	AAPL	Stock	53.4488	53.7	53.2925	53.57	14232784.0
2019-09-10 15:00:00	AAPL	Stock	53.5662	54.195	53.5662	54.1925	16627864.0
2019-09-10 16:00:00	AAPL	Stock	54.1925	54.2375	54.1275	54.2375	9600152.0
2019-09-10 17:00:00	AAPL	Stock	54.2375	54.375	54.2125	54.37	693716.0
2019-09-10 18:00:00	AAPL	Stock	54.3675	54.3675	54.2	54.2275	317352.0
2019-09-10 19:00:00	AAPL	Stock	54.2375	54.2625	54.2175	54.2175	85504.0
2019-09-10 04:00:00	MSFT	Stock	136.75	136.75	136.55	136.55	200.0
2019-09-10 06:00:00	MSFT	Stock	137.0	137.27	136.97	136.97	3844.0
2019-09-10 07:00:00	MSFT	Stock	136.97	137.25	136.83	136.83	5907.0
2019-09-10 08:00:00	MSFT	Stock	137.03	137.3	136.697	136.72	18933.0
2019-09-10 09:00:00	MSFT	Stock	136.8	136.886	134.71	135.02	3816333.0
2019-09-10 10:00:00	MSFT	Stock	135.03	135.59	134.77	135.105	4100812.0
2019-09-10 11:00:00	MSFT	Stock	135.08	135.43	134.51	135.246	3100364.0
2019-09-10 12:00:00	MSFT	Stock	135.248	136.19	135.07	136.04	1754390.0
2019-09-10 13:00:00	MSFT	Stock	136.04	136.07	135.41	135.58	1516175.0
2019-09-10 14:00:00	MSFT	Stock	135.575	135.63	135.065	135.295	1679129.0
2019-09-10 15:00:00	MSFT	Stock	135.31	136.15	135.1	136.15	3564456.0
2019-09-10 16:00:00	MSFT	Stock	136.08	136.18	135.9	136.0	3677731.0
2019-09-10 17:00:00	MSFT	Stock	135.99	136.0	135.9	136.0	3784.0
2019-09-10 18:00:00	MSFT	Stock	135.95	135.99	135.85	135.85	8300.0
2019-09-10 19:00:00	MSFT	Stock	135.85	136.01	135.84	135.95	3071.0
2019-09-10 04:00:00	NVDA	Stock	4.4805	4.4805	4.4785	4.4785	24000.0
2019-09-10 05:00:00	NVDA	Stock	4.4788	4.4912	4.4788	4.4912	30080.0
2019-09-10 06:00:00	NVDA	Stock	4.4932	4.4962	4.4835	4.4948	239640.0
2019-09-10 07:00:00	NVDA	Stock	4.4948	4.5095	4.4822	4.4912	592080.0
2019-09-10 08:00:00	NVDA	Stock	4.51	4.51	4.4775	4.482	820360.0
2019-09-10 09:00:00	NVDA	Stock	4.482	4.5095	4.4698	4.507	62365040.0
2019-09-10 10:00:00	NVDA	Stock	4.5063	4.5542	4.5033	4.522	54510760.0
2019-09-10 11:00:00	NVDA	Stock	4.521	4.5798	4.5188	4.5715	39219400.0
2019-09-10 12:00:00	NVDA	Stock	4.5724	4.6062	4.5528	4.5812	43228040.0
2019-09-10 13:00:00	NVDA	Stock	4.5815	4.5852	4.5588	4.5594	30228920.0
2019-09-10 14:00:00	NVDA	Stock	4.5597	4.575	4.5562	4.5678	23188160.0
2019-09-10 15:00:00	NVDA	Stock	4.569	4.5828	4.5498	4.581	40279680.0
2019-09-10 16:00:00	NVDA	Stock	4.5795	4.5818	4.5532	4.5788	24793000.0
2019-09-10 17:00:00	NVDA	Stock	4.5752	4.58	4.5752	4.5775	76800.0
2019-09-10 18:00:00	NVDA	Stock	4.5737	4.575	4.5737	4.5737	138680.0
2019-09-10 19:00:00	NVDA	Stock	4.5737	4.5818	4.5737	4.5818	159240.0
2019-09-10 04:00:00	AMZN	Stock	91.0	91.0	91.0	91.0	4400.0
2019-09-10 06:00:00	AMZN	Stock	91.2525	91.2525	91.2525	91.2525	2000.0
2019-09-10 07:00:00	AMZN	Stock	91.424	91.424	91.229	91.229	19620.0

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

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