PREVIEW / stock_1hour / 2019-09-17

all stock 1-hour files

  file:    by_date/stock_1hour/2019/2019-09-17.parquet
  size:    1.1 MB
  rows:    50,574
  symbols: 2,546

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-17 04:00:00	AAPL	Stock	54.975	54.975	54.8625	54.9075	3708.0
2019-09-17 05:00:00	AAPL	Stock	54.8975	54.99	54.85	54.85	7168.0
2019-09-17 06:00:00	AAPL	Stock	54.8375	54.8575	54.8	54.8	2712.0
2019-09-17 07:00:00	AAPL	Stock	54.845	55.0425	54.825	55.0125	56060.0
2019-09-17 08:00:00	AAPL	Stock	54.8495	55.045	54.8225	54.9975	297048.0
2019-09-17 09:00:00	AAPL	Stock	54.995	55.1475	54.78	54.8525	10774396.0
2019-09-17 10:00:00	AAPL	Stock	54.8525	55.0325	54.8125	54.9425	9017344.0
2019-09-17 11:00:00	AAPL	Stock	54.94	55.1475	54.9375	55.0525	6904312.0
2019-09-17 12:00:00	AAPL	Stock	55.0575	55.0825	54.89	54.9838	5948248.0
2019-09-17 13:00:00	AAPL	Stock	54.9825	55.0875	54.975	55.0	4576744.0
2019-09-17 14:00:00	AAPL	Stock	55.0	55.0482	54.95	55.005	5648576.0
2019-09-17 15:00:00	AAPL	Stock	55.0075	55.205	54.975	55.1625	8249880.0
2019-09-17 16:00:00	AAPL	Stock	55.175	55.2125	55.125	55.185	8154184.0
2019-09-17 17:00:00	AAPL	Stock	55.1925	55.1925	55.15	55.15	24528.0
2019-09-17 18:00:00	AAPL	Stock	55.15	55.2375	55.13	55.235	62176.0
2019-09-17 19:00:00	AAPL	Stock	55.225	55.2475	55.2	55.2475	29732.0
2019-09-17 06:00:00	MSFT	Stock	136.08	136.08	135.89	135.89	578.0
2019-09-17 07:00:00	MSFT	Stock	135.89	136.4	135.89	136.38	9179.0
2019-09-17 08:00:00	MSFT	Stock	136.2	136.33	136.13	136.2	55958.0
2019-09-17 09:00:00	MSFT	Stock	136.38	137.49	136.21	137.17	1881210.0
2019-09-17 10:00:00	MSFT	Stock	137.19	137.3	136.425	136.47	2035961.0
2019-09-17 11:00:00	MSFT	Stock	136.465	136.995	136.465	136.87	1515509.0
2019-09-17 12:00:00	MSFT	Stock	136.87	136.995	136.773	136.939	767816.0
2019-09-17 13:00:00	MSFT	Stock	136.94	137.06	136.8	136.895	1120956.0
2019-09-17 14:00:00	MSFT	Stock	136.9	136.99	136.71	136.9	1245745.0
2019-09-17 15:00:00	MSFT	Stock	136.9	137.52	136.844	137.39	2533484.0
2019-09-17 16:00:00	MSFT	Stock	137.39	137.66	136.97	137.26	2924616.0
2019-09-17 17:00:00	MSFT	Stock	137.22	137.3	137.2	137.26	3297.0
2019-09-17 18:00:00	MSFT	Stock	137.16	137.6	137.16	137.59	20791.0
2019-09-17 19:00:00	MSFT	Stock	137.55	137.55	137.45	137.5	4650.0
2019-09-17 04:00:00	NVDA	Stock	4.5148	4.5225	4.5078	4.512	297520.0
2019-09-17 05:00:00	NVDA	Stock	4.527	4.527	4.5078	4.5082	21480.0
2019-09-17 06:00:00	NVDA	Stock	4.5075	4.5102	4.5	4.5	32000.0
2019-09-17 07:00:00	NVDA	Stock	4.5063	4.5095	4.5063	4.5095	8000.0
2019-09-17 08:00:00	NVDA	Stock	4.505	4.5232	4.5013	4.5232	2300880.0
2019-09-17 09:00:00	NVDA	Stock	4.512	4.5235	4.475	4.4795	39823760.0
2019-09-17 10:00:00	NVDA	Stock	4.4812	4.4854	4.4652	4.473	26134280.0
2019-09-17 11:00:00	NVDA	Stock	4.4713	4.507	4.471	4.4912	24364560.0
2019-09-17 12:00:00	NVDA	Stock	4.4912	4.502	4.48	4.4938	15672640.0
2019-09-17 13:00:00	NVDA	Stock	4.494	4.5232	4.4925	4.5155	25265640.0
2019-09-17 14:00:00	NVDA	Stock	4.5168	4.5208	4.5068	4.518	15689600.0
2019-09-17 15:00:00	NVDA	Stock	4.5185	4.5309	4.5127	4.5255	35136440.0
2019-09-17 16:00:00	NVDA	Stock	4.5268	4.5315	4.5215	4.525	17473440.0
2019-09-17 17:00:00	NVDA	Stock	4.5243	4.525	4.5212	4.5238	83120.0
2019-09-17 18:00:00	NVDA	Stock	4.5238	4.525	4.5225	4.525	57200.0
2019-09-17 19:00:00	NVDA	Stock	4.525	4.525	4.522	4.525	50480.0
2019-09-17 06:00:00	AMZN	Stock	90.159	90.1875	90.159	90.1875	4000.0
2019-09-17 07:00:00	AMZN	Stock	90.23	90.5845	90.23	90.5	55220.0
2019-09-17 08:00:00	AMZN	Stock	90.175	90.5825	90.1005	90.35	149300.0
2019-09-17 09:00:00	AMZN	Stock	90.275	90.8215	90.205	90.7198	6719380.0

> showing 50 of 50,574 rows — these rows as CSV

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