PREVIEW / stock_1hour / 2019-05-07

all stock 1-hour files

  file:    by_date/stock_1hour/2019/2019-05-07.parquet
  size:    1.1 MB
  rows:    49,562
  symbols: 2,598

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-05-07 04:00:00	AAPL	Stock	51.9675	51.9925	51.9	51.9	10908.0
2019-05-07 05:00:00	AAPL	Stock	51.8875	51.8875	51.83	51.85	10556.0
2019-05-07 06:00:00	AAPL	Stock	51.875	51.8925	51.81	51.8125	16716.0
2019-05-07 07:00:00	AAPL	Stock	51.81	51.845	51.635	51.6625	210592.0
2019-05-07 08:00:00	AAPL	Stock	51.7032	51.845	51.5575	51.6725	354296.0
2019-05-07 09:00:00	AAPL	Stock	51.6525	51.8545	51.3	51.45	16685176.0
2019-05-07 10:00:00	AAPL	Stock	51.4538	51.4675	51.1	51.185	20047776.0
2019-05-07 11:00:00	AAPL	Stock	51.18	51.19	50.921	50.975	15524328.0
2019-05-07 12:00:00	AAPL	Stock	50.975	51.24	50.8825	51.06	9467228.0
2019-05-07 13:00:00	AAPL	Stock	51.0575	51.08	50.3675	50.5125	18459244.0
2019-05-07 14:00:00	AAPL	Stock	50.51	50.7025	50.2125	50.4378	16638976.0
2019-05-07 15:00:00	AAPL	Stock	50.4375	50.7425	50.2062	50.715	25466044.0
2019-05-07 16:00:00	AAPL	Stock	50.7475	50.78	50.6925	50.7575	12750484.0
2019-05-07 17:00:00	AAPL	Stock	50.7575	50.7575	50.725	50.7475	79308.0
2019-05-07 18:00:00	AAPL	Stock	50.725	50.735	50.5525	50.735	61848.0
2019-05-07 19:00:00	AAPL	Stock	50.7225	50.7425	50.625	50.6875	65868.0
2019-05-07 04:00:00	MSFT	Stock	127.9	127.94	127.68	127.9	6100.0
2019-05-07 05:00:00	MSFT	Stock	127.8	127.8	127.64	127.64	1467.0
2019-05-07 06:00:00	MSFT	Stock	127.7	127.71	127.18	127.2	6304.0
2019-05-07 07:00:00	MSFT	Stock	127.5	127.76	127.0	127.13	22654.0
2019-05-07 08:00:00	MSFT	Stock	127.26	127.62	126.51	127.15	35945.0
2019-05-07 09:00:00	MSFT	Stock	127.07	127.18	126.07	126.25	2951143.0
2019-05-07 10:00:00	MSFT	Stock	126.25	126.293	125.227	125.41	4129007.0
2019-05-07 11:00:00	MSFT	Stock	125.4	125.9	124.91	125.481	3995077.0
2019-05-07 12:00:00	MSFT	Stock	125.485	125.965	125.28	125.46	2142618.0
2019-05-07 13:00:00	MSFT	Stock	125.45	125.505	124.65	125.02	3054201.0
2019-05-07 14:00:00	MSFT	Stock	125.01	125.28	124.3	124.89	3383005.0
2019-05-07 15:00:00	MSFT	Stock	124.89	125.67	124.22	125.57	6092311.0
2019-05-07 16:00:00	MSFT	Stock	125.64	125.83	125.52	125.83	5201885.0
2019-05-07 17:00:00	MSFT	Stock	125.66	125.76	125.66	125.75	4137.0
2019-05-07 18:00:00	MSFT	Stock	125.61	125.62	125.5	125.58	6136.0
2019-05-07 19:00:00	MSFT	Stock	125.6	125.64	125.52	125.52	4406.0
2019-05-07 05:00:00	NVDA	Stock	4.4715	4.475	4.4713	4.4713	98120.0
2019-05-07 06:00:00	NVDA	Stock	4.475	4.475	4.4682	4.4682	60360.0
2019-05-07 07:00:00	NVDA	Stock	4.4622	4.475	4.45	4.45	326360.0
2019-05-07 08:00:00	NVDA	Stock	4.4578	4.4725	4.445	4.4719	979120.0
2019-05-07 09:00:00	NVDA	Stock	4.4652	4.4652	4.395	4.4122	65677960.0
2019-05-07 10:00:00	NVDA	Stock	4.4118	4.412	4.363	4.3692	91009080.0
2019-05-07 11:00:00	NVDA	Stock	4.3703	4.3852	4.3465	4.3544	74283320.0
2019-05-07 12:00:00	NVDA	Stock	4.355	4.381	4.3445	4.3512	40546240.0
2019-05-07 13:00:00	NVDA	Stock	4.3508	4.3582	4.3072	4.3128	65794000.0
2019-05-07 14:00:00	NVDA	Stock	4.3123	4.318	4.2812	4.3006	55821080.0
2019-05-07 15:00:00	NVDA	Stock	4.3008	4.33	4.2792	4.33	112161720.0
2019-05-07 16:00:00	NVDA	Stock	4.3303	4.3525	4.3248	4.33	23891360.0
2019-05-07 17:00:00	NVDA	Stock	4.33	4.3413	4.3278	4.3375	476320.0
2019-05-07 18:00:00	NVDA	Stock	4.335	4.3368	4.3292	4.3368	316640.0
2019-05-07 19:00:00	NVDA	Stock	4.3318	4.3375	4.3002	4.31	307320.0
2019-05-07 04:00:00	AMZN	Stock	97.4	97.4	97.4	97.4	2000.0
2019-05-07 05:00:00	AMZN	Stock	97.006	97.172	97.0	97.11	8000.0
2019-05-07 07:00:00	AMZN	Stock	96.9865	97.1515	96.7995	96.7995	212620.0

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

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