PREVIEW / stock_1hour / 2019-06-06

all stock 1-hour files

  file:    by_date/stock_1hour/2019/2019-06-06.parquet
  size:    1.1 MB
  rows:    49,519
  symbols: 2,606

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-06-06 04:00:00	AAPL	Stock	45.7575	45.85	45.7575	45.85	12352.0
2019-06-06 05:00:00	AAPL	Stock	45.8025	45.8775	45.79	45.865	8792.0
2019-06-06 06:00:00	AAPL	Stock	45.845	45.87	45.825	45.85	14460.0
2019-06-06 07:00:00	AAPL	Stock	45.85	45.9	45.7875	45.88	93784.0
2019-06-06 08:00:00	AAPL	Stock	45.865	45.9175	45.58	45.6875	339624.0
2019-06-06 09:00:00	AAPL	Stock	45.6975	45.975	45.55	45.5675	10098952.0
2019-06-06 10:00:00	AAPL	Stock	45.5675	45.8575	45.5372	45.725	9670416.0
2019-06-06 11:00:00	AAPL	Stock	45.7225	45.9675	45.6775	45.825	10199704.0
2019-06-06 12:00:00	AAPL	Stock	45.825	45.88	45.755	45.845	4341208.0
2019-06-06 13:00:00	AAPL	Stock	45.8475	45.9122	45.7925	45.845	3269244.0
2019-06-06 14:00:00	AAPL	Stock	45.8462	46.11	45.7875	46.005	8198200.0
2019-06-06 15:00:00	AAPL	Stock	46.015	46.3675	45.9912	46.3075	17345776.0
2019-06-06 16:00:00	AAPL	Stock	46.3325	46.3325	46.11	46.14	5613988.0
2019-06-06 17:00:00	AAPL	Stock	46.1875	46.25	46.155	46.1875	39704.0
2019-06-06 18:00:00	AAPL	Stock	46.19	46.2375	46.175	46.1875	22344.0
2019-06-06 19:00:00	AAPL	Stock	46.2425	46.3325	46.195	46.3325	56568.0
2019-06-06 04:00:00	MSFT	Stock	125.98	126.4	125.98	126.4	1052.0
2019-06-06 05:00:00	MSFT	Stock	126.22	126.22	126.2	126.2	300.0
2019-06-06 06:00:00	MSFT	Stock	126.45	126.5	126.45	126.5	2400.0
2019-06-06 07:00:00	MSFT	Stock	126.31	126.45	126.2	126.27	16608.0
2019-06-06 08:00:00	MSFT	Stock	126.38	126.5	125.7	125.877	25704.0
2019-06-06 09:00:00	MSFT	Stock	125.65	126.65	125.6	125.927	2337327.0
2019-06-06 10:00:00	MSFT	Stock	125.92	126.27	125.82	126.005	2235059.0
2019-06-06 11:00:00	MSFT	Stock	126.0	126.695	125.835	126.345	2185047.0
2019-06-06 12:00:00	MSFT	Stock	126.35	126.64	126.2	126.525	1272274.0
2019-06-06 13:00:00	MSFT	Stock	126.525	126.68	126.49	126.59	1049549.0
2019-06-06 14:00:00	MSFT	Stock	126.59	127.31	126.46	127.128	2064011.0
2019-06-06 15:00:00	MSFT	Stock	127.12	127.97	127.11	127.9	4336016.0
2019-06-06 16:00:00	MSFT	Stock	127.82	128.0	127.54	127.67	2976613.0
2019-06-06 17:00:00	MSFT	Stock	127.5	127.82	127.45	127.58	6942.0
2019-06-06 18:00:00	MSFT	Stock	127.58	127.7	127.53	127.67	5113.0
2019-06-06 19:00:00	MSFT	Stock	127.7	127.8	127.6	127.7	6699.0
2019-06-06 04:00:00	NVDA	Stock	3.5362	3.5368	3.5362	3.5368	40000.0
2019-06-06 05:00:00	NVDA	Stock	3.5575	3.5575	3.5575	3.5575	7960.0
2019-06-06 06:00:00	NVDA	Stock	3.5535	3.5535	3.55	3.55	29200.0
2019-06-06 07:00:00	NVDA	Stock	3.5495	3.55	3.5438	3.547	611640.0
2019-06-06 08:00:00	NVDA	Stock	3.549	3.55	3.5252	3.5318	1359800.0
2019-06-06 09:00:00	NVDA	Stock	3.532	3.5995	3.53	3.5489	67689000.0
2019-06-06 10:00:00	NVDA	Stock	3.5488	3.582	3.5485	3.559	60773880.0
2019-06-06 11:00:00	NVDA	Stock	3.5583	3.5745	3.5513	3.5574	61757320.0
2019-06-06 12:00:00	NVDA	Stock	3.5565	3.5678	3.549	3.5618	33281400.0
2019-06-06 13:00:00	NVDA	Stock	3.562	3.5662	3.5532	3.5598	21034280.0
2019-06-06 14:00:00	NVDA	Stock	3.5598	3.5852	3.5546	3.5778	37201440.0
2019-06-06 15:00:00	NVDA	Stock	3.5785	3.6193	3.5758	3.5948	95455960.0
2019-06-06 16:00:00	NVDA	Stock	3.5945	3.6	3.5768	3.5825	5710240.0
2019-06-06 17:00:00	NVDA	Stock	3.5825	3.5945	3.5772	3.5838	3009800.0
2019-06-06 18:00:00	NVDA	Stock	3.5838	3.5898	3.5825	3.5825	155360.0
2019-06-06 19:00:00	NVDA	Stock	3.5875	3.592	3.585	3.59	445160.0
2019-06-06 05:00:00	AMZN	Stock	87.141	87.154	87.141	87.154	7100.0
2019-06-06 07:00:00	AMZN	Stock	87.075	87.155	86.95	87.05	138440.0

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

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