PREVIEW / stock_1hour / 2020-05-14

all stock 1-hour files

  file:    by_date/stock_1hour/2020/2020-05-14.parquet
  size:    1.2 MB
  rows:    55,233
  symbols: 2,397

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
2020-05-14 04:00:00	AAPL	Stock	77.0	77.0	76.8275	76.925	33012.0
2020-05-14 05:00:00	AAPL	Stock	76.9675	77.28	76.965	77.2525	26236.0
2020-05-14 06:00:00	AAPL	Stock	77.2	77.2	76.7825	76.7825	36588.0
2020-05-14 07:00:00	AAPL	Stock	76.8175	77.0	76.1275	76.1675	267852.0
2020-05-14 08:00:00	AAPL	Stock	76.9	77.0	75.5575	75.8125	1001352.0
2020-05-14 09:00:00	AAPL	Stock	75.825	76.755	75.3825	75.6465	18022600.0
2020-05-14 10:00:00	AAPL	Stock	75.6625	76.144	75.395	75.91	22637564.0
2020-05-14 11:00:00	AAPL	Stock	75.915	76.665	75.8575	76.0625	17947444.0
2020-05-14 12:00:00	AAPL	Stock	76.0675	76.5925	75.735	76.5188	13091608.0
2020-05-14 13:00:00	AAPL	Stock	76.5225	76.88	76.3922	76.5325	14263964.0
2020-05-14 14:00:00	AAPL	Stock	76.5225	76.66	76.165	76.485	12776780.0
2020-05-14 15:00:00	AAPL	Stock	76.4912	77.4475	76.445	77.425	24774556.0
2020-05-14 16:00:00	AAPL	Stock	77.385	77.6	76.3278	77.475	10153048.0
2020-05-14 17:00:00	AAPL	Stock	77.475	77.56	77.4	77.4	110048.0
2020-05-14 18:00:00	AAPL	Stock	77.465	77.5375	77.31	77.3975	87256.0
2020-05-14 19:00:00	AAPL	Stock	77.3625	77.5725	77.34	77.55	169792.0
2020-05-14 04:00:00	MSFT	Stock	180.25	180.25	180.0	180.0	5019.0
2020-05-14 05:00:00	MSFT	Stock	180.42	181.4	180.42	180.6	4367.0
2020-05-14 06:00:00	MSFT	Stock	180.4	180.75	179.95	179.95	2185.0
2020-05-14 07:00:00	MSFT	Stock	180.31	180.35	178.52	178.75	30947.0
2020-05-14 08:00:00	MSFT	Stock	179.26	180.305	177.31	178.0	99981.0
2020-05-14 09:00:00	MSFT	Stock	178.01	178.89	176.61	177.0	4079951.0
2020-05-14 10:00:00	MSFT	Stock	177.01	178.03	175.68	176.37	5982486.0
2020-05-14 11:00:00	MSFT	Stock	176.36	178.17	176.3	176.58	4600134.0
2020-05-14 12:00:00	MSFT	Stock	176.59	177.64	176.0	177.497	3603129.0
2020-05-14 13:00:00	MSFT	Stock	177.5	178.32	177.15	177.706	2552042.0
2020-05-14 14:00:00	MSFT	Stock	177.705	178.27	177.02	177.934	2785257.0
2020-05-14 15:00:00	MSFT	Stock	177.93	180.69	177.74	180.61	6082059.0
2020-05-14 16:00:00	MSFT	Stock	180.53	181.0	177.631	180.73	4512119.0
2020-05-14 17:00:00	MSFT	Stock	180.75	180.85	180.65	180.75	12408.0
2020-05-14 18:00:00	MSFT	Stock	180.76	180.79	180.45	180.46	18602.0
2020-05-14 19:00:00	MSFT	Stock	180.46	181.0	180.35	181.0	24946.0
2020-05-14 04:00:00	NVDA	Stock	7.845	7.845	7.8252	7.8252	14880.0
2020-05-14 05:00:00	NVDA	Stock	7.8912	7.8975	7.8912	7.8975	54800.0
2020-05-14 06:00:00	NVDA	Stock	7.8925	7.8925	7.8675	7.875	55960.0
2020-05-14 07:00:00	NVDA	Stock	7.8625	7.875	7.765	7.775	1213320.0
2020-05-14 08:00:00	NVDA	Stock	7.8625	7.875	7.7	7.7675	3871960.0
2020-05-14 09:00:00	NVDA	Stock	7.7635	7.9442	7.72	7.7485	77099680.0
2020-05-14 10:00:00	NVDA	Stock	7.7493	7.8698	7.6875	7.768	87869800.0
2020-05-14 11:00:00	NVDA	Stock	7.7718	7.8875	7.7434	7.7532	65847760.0
2020-05-14 12:00:00	NVDA	Stock	7.7558	7.8602	7.7335	7.8482	50625440.0
2020-05-14 13:00:00	NVDA	Stock	7.8495	7.8782	7.8139	7.8438	51096680.0
2020-05-14 14:00:00	NVDA	Stock	7.8428	7.9358	7.8058	7.9345	50456000.0
2020-05-14 15:00:00	NVDA	Stock	7.9331	8.036	7.9202	8.0335	104375160.0
2020-05-14 16:00:00	NVDA	Stock	8.0305	8.0492	8.0305	8.0492	16896800.0
2020-05-14 17:00:00	NVDA	Stock	8.0492	8.0875	8.047	8.0638	1115240.0
2020-05-14 18:00:00	NVDA	Stock	8.0632	8.0675	8.0263	8.0412	369400.0
2020-05-14 19:00:00	NVDA	Stock	8.0412	8.065	8.0325	8.0625	491600.0
2020-05-14 05:00:00	AMZN	Stock	118.5	118.5	118.5	118.5	2000.0
2020-05-14 06:00:00	AMZN	Stock	118.275	118.275	118.225	118.25	23300.0

> showing 50 of 55,233 rows — these rows as CSV

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