PREVIEW / stock_1hour / 2019-09-27

all stock 1-hour files

  file:    by_date/stock_1hour/2019/2019-09-27.parquet
  size:    1.1 MB
  rows:    49,501
  symbols: 2,540

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-27 04:00:00	AAPL	Stock	54.975	55.025	54.975	55.025	2800.0
2019-09-27 05:00:00	AAPL	Stock	55.0975	55.1	55.0725	55.0725	6400.0
2019-09-27 06:00:00	AAPL	Stock	55.0725	55.16	55.0725	55.16	10952.0
2019-09-27 07:00:00	AAPL	Stock	55.1025	55.15	55.075	55.145	37568.0
2019-09-27 08:00:00	AAPL	Stock	55.15	55.195	55.025	55.1122	163304.0
2019-09-27 09:00:00	AAPL	Stock	55.1	55.24	54.99	55.06	6801576.0
2019-09-27 10:00:00	AAPL	Stock	55.045	55.12	54.8675	55.0975	10810596.0
2019-09-27 11:00:00	AAPL	Stock	55.0975	55.13	54.445	54.9325	11589792.0
2019-09-27 12:00:00	AAPL	Stock	54.9325	54.9925	54.5575	54.5575	10938088.0
2019-09-27 13:00:00	AAPL	Stock	54.5575	54.7475	54.4925	54.645	8803340.0
2019-09-27 14:00:00	AAPL	Stock	54.6475	54.66	54.3202	54.375	10313184.0
2019-09-27 15:00:00	AAPL	Stock	54.375	54.7825	54.375	54.7125	14713808.0
2019-09-27 16:00:00	AAPL	Stock	54.7425	54.815	54.675	54.745	5195280.0
2019-09-27 17:00:00	AAPL	Stock	54.745	54.745	54.705	54.725	31272.0
2019-09-27 18:00:00	AAPL	Stock	54.6925	54.7	54.685	54.685	4636.0
2019-09-27 19:00:00	AAPL	Stock	54.7125	54.7125	54.6425	54.6875	23384.0
2019-09-27 04:00:00	MSFT	Stock	139.64	139.79	139.64	139.79	1628.0
2019-09-27 06:00:00	MSFT	Stock	139.9	140.03	139.9	140.03	1200.0
2019-09-27 07:00:00	MSFT	Stock	140.16	140.18	139.86	139.98	2930.0
2019-09-27 08:00:00	MSFT	Stock	139.9	139.98	139.67	139.8	9781.0
2019-09-27 09:00:00	MSFT	Stock	139.88	140.48	139.1	139.268	1522842.0
2019-09-27 10:00:00	MSFT	Stock	139.28	139.523	138.89	139.45	1728415.0
2019-09-27 11:00:00	MSFT	Stock	139.46	139.78	138.04	139.06	2229342.0
2019-09-27 12:00:00	MSFT	Stock	139.06	139.135	137.69	137.7	1634046.0
2019-09-27 13:00:00	MSFT	Stock	137.69	138.0	137.32	137.72	2246185.0
2019-09-27 14:00:00	MSFT	Stock	137.73	137.73	136.645	137.013	2080901.0
2019-09-27 15:00:00	MSFT	Stock	137.01	137.85	136.87	137.75	3844913.0
2019-09-27 16:00:00	MSFT	Stock	137.8	138.09	137.54	138.09	2970901.0
2019-09-27 17:00:00	MSFT	Stock	138.07	138.07	137.9	137.91	9045.0
2019-09-27 18:00:00	MSFT	Stock	137.9	137.9	137.84	137.84	3761.0
2019-09-27 19:00:00	MSFT	Stock	137.83	137.83	137.75	137.75	16158.0
2019-09-27 04:00:00	NVDA	Stock	4.37	4.37	4.37	4.37	8000.0
2019-09-27 05:00:00	NVDA	Stock	4.3738	4.3738	4.3738	4.3738	4000.0
2019-09-27 06:00:00	NVDA	Stock	4.38	4.3968	4.3742	4.3892	48680.0
2019-09-27 07:00:00	NVDA	Stock	4.3875	4.3905	4.3835	4.3862	88240.0
2019-09-27 08:00:00	NVDA	Stock	4.3868	4.392	4.375	4.3875	240160.0
2019-09-27 09:00:00	NVDA	Stock	4.384	4.4425	4.3566	4.3605	36265920.0
2019-09-27 10:00:00	NVDA	Stock	4.3592	4.4315	4.358	4.43	31163200.0
2019-09-27 11:00:00	NVDA	Stock	4.4305	4.442	4.352	4.3872	37808280.0
2019-09-27 12:00:00	NVDA	Stock	4.385	4.389	4.3098	4.3105	30381600.0
2019-09-27 13:00:00	NVDA	Stock	4.3085	4.3308	4.2878	4.3097	30866680.0
2019-09-27 14:00:00	NVDA	Stock	4.3108	4.312	4.238	4.2425	41312960.0
2019-09-27 15:00:00	NVDA	Stock	4.2427	4.2972	4.233	4.2947	69252120.0
2019-09-27 16:00:00	NVDA	Stock	4.2982	4.2998	4.2855	4.294	17854560.0
2019-09-27 17:00:00	NVDA	Stock	4.3	4.3025	4.294	4.3025	120040.0
2019-09-27 18:00:00	NVDA	Stock	4.302	4.3042	4.298	4.298	64480.0
2019-09-27 19:00:00	NVDA	Stock	4.295	4.3013	4.295	4.2972	290320.0
2019-09-27 05:00:00	AMZN	Stock	86.9935	87.05	86.9935	87.05	6000.0
2019-09-27 06:00:00	AMZN	Stock	87.125	87.247	87.125	87.247	6000.0
2019-09-27 07:00:00	AMZN	Stock	87.256	87.256	87.125	87.1675	16000.0

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

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