PREVIEW / stock_1hour / 2019-11-21

all stock 1-hour files

  file:    by_date/stock_1hour/2019/2019-11-21.parquet
  size:    1.1 MB
  rows:    49,630
  symbols: 2,488

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-11-21 04:00:00	AAPL	Stock	65.8375	66.005	65.825	65.9125	5108.0
2019-11-21 05:00:00	AAPL	Stock	66.075	66.1275	65.9625	66.0725	21816.0
2019-11-21 06:00:00	AAPL	Stock	66.05	66.1375	66.05	66.125	7644.0
2019-11-21 07:00:00	AAPL	Stock	66.1	66.25	66.035	66.11	107560.0
2019-11-21 08:00:00	AAPL	Stock	66.204	66.375	66.025	66.1425	363256.0
2019-11-21 09:00:00	AAPL	Stock	66.14	66.1625	65.713	65.8712	12093844.0
2019-11-21 10:00:00	AAPL	Stock	65.8725	66.0012	65.55	65.6118	10665280.0
2019-11-21 11:00:00	AAPL	Stock	65.615	65.7	65.2975	65.3175	8505716.0
2019-11-21 12:00:00	AAPL	Stock	65.315	65.6125	65.295	65.5475	5881784.0
2019-11-21 13:00:00	AAPL	Stock	65.5475	65.62	65.46	65.48	4254344.0
2019-11-21 14:00:00	AAPL	Stock	65.4838	65.65	65.375	65.59	5041176.0
2019-11-21 15:00:00	AAPL	Stock	65.5875	65.6378	65.3175	65.5025	11936036.0
2019-11-21 16:00:00	AAPL	Stock	65.5025	65.6	65.4625	65.5225	15823512.0
2019-11-21 17:00:00	AAPL	Stock	65.525	65.5325	65.5025	65.5225	24428.0
2019-11-21 18:00:00	AAPL	Stock	65.525	65.5625	65.5125	65.5625	30432.0
2019-11-21 19:00:00	AAPL	Stock	65.5125	65.61	65.5025	65.565	55732.0
2019-11-21 04:00:00	MSFT	Stock	149.3	149.34	149.3	149.34	1150.0
2019-11-21 05:00:00	MSFT	Stock	149.35	149.78	149.35	149.78	1014.0
2019-11-21 06:00:00	MSFT	Stock	149.41	149.41	149.41	149.41	100.0
2019-11-21 07:00:00	MSFT	Stock	149.5	149.5	149.32	149.4	3868.0
2019-11-21 08:00:00	MSFT	Stock	149.49	149.78	149.28	149.6	25846.0
2019-11-21 09:00:00	MSFT	Stock	149.55	149.77	149.1	149.17	1673338.0
2019-11-21 10:00:00	MSFT	Stock	149.16	149.33	148.501	148.965	2042602.0
2019-11-21 11:00:00	MSFT	Stock	148.97	149.385	148.93	149.03	1326280.0
2019-11-21 12:00:00	MSFT	Stock	149.04	149.57	148.99	149.564	950521.0
2019-11-21 13:00:00	MSFT	Stock	149.57	149.66	149.25	149.31	784719.0
2019-11-21 14:00:00	MSFT	Stock	149.314	149.8	149.245	149.695	996167.0
2019-11-21 15:00:00	MSFT	Stock	149.693	149.705	149.2	149.49	2621964.0
2019-11-21 16:00:00	MSFT	Stock	149.48	149.71	149.48	149.55	4199912.0
2019-11-21 17:00:00	MSFT	Stock	149.53	149.56	149.48	149.48	5136.0
2019-11-21 18:00:00	MSFT	Stock	149.55	149.55	149.48	149.52	1173.0
2019-11-21 19:00:00	MSFT	Stock	149.5	149.69	149.5	149.69	5272.0
2019-11-21 04:00:00	NVDA	Stock	5.271	5.271	5.271	5.271	4000.0
2019-11-21 05:00:00	NVDA	Stock	5.2508	5.2748	5.25	5.272	40000.0
2019-11-21 06:00:00	NVDA	Stock	5.2725	5.2825	5.271	5.2825	67440.0
2019-11-21 07:00:00	NVDA	Stock	5.2788	5.3025	5.2788	5.3025	309640.0
2019-11-21 08:00:00	NVDA	Stock	5.2938	5.3242	5.2825	5.3	1613240.0
2019-11-21 09:00:00	NVDA	Stock	5.2978	5.3285	5.2433	5.3053	47782160.0
2019-11-21 10:00:00	NVDA	Stock	5.3045	5.331	5.27	5.291	56183160.0
2019-11-21 11:00:00	NVDA	Stock	5.2907	5.3028	5.2625	5.2628	32064800.0
2019-11-21 12:00:00	NVDA	Stock	5.2636	5.283	5.2465	5.2597	28097840.0
2019-11-21 13:00:00	NVDA	Stock	5.2598	5.266	5.2328	5.2657	25289760.0
2019-11-21 14:00:00	NVDA	Stock	5.266	5.2855	5.2513	5.2773	20721280.0
2019-11-21 15:00:00	NVDA	Stock	5.2775	5.2798	5.2395	5.2548	34088560.0
2019-11-21 16:00:00	NVDA	Stock	5.2545	5.2545	5.243	5.25	3842040.0
2019-11-21 17:00:00	NVDA	Stock	5.2538	5.2538	5.2488	5.2499	41240.0
2019-11-21 18:00:00	NVDA	Stock	5.253	5.2538	5.25	5.25	17000.0
2019-11-21 19:00:00	NVDA	Stock	5.2518	5.2572	5.244	5.2545	279920.0
2019-11-21 05:00:00	AMZN	Stock	87.15	87.15	87.1	87.1	21000.0
2019-11-21 06:00:00	AMZN	Stock	86.95	86.95	86.95	86.95	6040.0

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

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