PREVIEW / stock_1hour / 2019-07-11

all stock 1-hour files

  file:    by_date/stock_1hour/2019/2019-07-11.parquet
  size:    1.1 MB
  rows:    50,116
  symbols: 2,591

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-07-11 04:00:00	AAPL	Stock	50.9025	50.96	50.9025	50.925	6488.0
2019-07-11 05:00:00	AAPL	Stock	50.9375	51.0325	50.9375	51.0325	3864.0
2019-07-11 06:00:00	AAPL	Stock	51.0275	51.05	50.91	50.9975	17188.0
2019-07-11 07:00:00	AAPL	Stock	50.9925	51.0475	50.85	50.935	183668.0
2019-07-11 08:00:00	AAPL	Stock	50.9975	51.0425	50.9	50.9875	218052.0
2019-07-11 09:00:00	AAPL	Stock	50.965	51.0975	50.7752	50.995	9956248.0
2019-07-11 10:00:00	AAPL	Stock	50.9925	51.0325	50.8325	50.99	9739540.0
2019-07-11 11:00:00	AAPL	Stock	50.99	51.0875	50.9725	51.0325	6774880.0
2019-07-11 12:00:00	AAPL	Stock	51.035	51.0582	50.92	50.935	4998528.0
2019-07-11 13:00:00	AAPL	Stock	50.9375	50.9425	50.6275	50.6925	6847400.0
2019-07-11 14:00:00	AAPL	Stock	50.695	50.7075	50.54	50.6325	5368496.0
2019-07-11 15:00:00	AAPL	Stock	50.6325	50.705	50.4275	50.435	10877152.0
2019-07-11 16:00:00	AAPL	Stock	50.435	51.041	50.395	50.4125	7946812.0
2019-07-11 17:00:00	AAPL	Stock	50.4125	50.4375	50.38	50.4	47068.0
2019-07-11 18:00:00	AAPL	Stock	50.3875	50.4225	50.3875	50.39	11168.0
2019-07-11 19:00:00	AAPL	Stock	50.4125	50.4125	50.38	50.4125	38992.0
2019-07-11 04:00:00	MSFT	Stock	138.1	138.55	138.1	138.55	292.0
2019-07-11 05:00:00	MSFT	Stock	138.2	138.5	138.2	138.5	882.0
2019-07-11 06:00:00	MSFT	Stock	138.43	138.79	138.43	138.79	4420.0
2019-07-11 07:00:00	MSFT	Stock	138.5	138.6	138.25	138.43	13738.0
2019-07-11 08:00:00	MSFT	Stock	138.4	138.61	138.05	138.3	48004.0
2019-07-11 09:00:00	MSFT	Stock	138.27	138.78	138.06	138.65	2937976.0
2019-07-11 10:00:00	MSFT	Stock	138.655	138.75	138.29	138.72	2580314.0
2019-07-11 11:00:00	MSFT	Stock	138.72	139.22	138.69	139.085	2376809.0
2019-07-11 12:00:00	MSFT	Stock	139.083	139.13	138.83	138.97	1636499.0
2019-07-11 13:00:00	MSFT	Stock	138.97	139.0	138.16	138.247	1985995.0
2019-07-11 14:00:00	MSFT	Stock	138.25	138.3	138.01	138.215	1710601.0
2019-07-11 15:00:00	MSFT	Stock	138.215	138.48	137.87	138.4	4071116.0
2019-07-11 16:00:00	MSFT	Stock	138.4	138.52	138.36	138.36	2346757.0
2019-07-11 17:00:00	MSFT	Stock	138.36	138.404	138.35	138.39	13690.0
2019-07-11 18:00:00	MSFT	Stock	138.39	138.54	138.35	138.35	9752.0
2019-07-11 19:00:00	MSFT	Stock	138.45	138.47	138.4	138.45	7636.0
2019-07-11 05:00:00	NVDA	Stock	4.032	4.032	4.032	4.032	6680.0
2019-07-11 06:00:00	NVDA	Stock	4.0325	4.0325	4.0228	4.0298	59040.0
2019-07-11 07:00:00	NVDA	Stock	4.032	4.05	4.032	4.05	548720.0
2019-07-11 08:00:00	NVDA	Stock	4.0375	4.0732	4.0252	4.07	3739920.0
2019-07-11 09:00:00	NVDA	Stock	4.0698	4.113	4.0375	4.1042	111925720.0
2019-07-11 10:00:00	NVDA	Stock	4.1033	4.1595	4.0878	4.15	145987480.0
2019-07-11 11:00:00	NVDA	Stock	4.15	4.1898	4.1465	4.1818	99939360.0
2019-07-11 12:00:00	NVDA	Stock	4.181	4.198	4.1738	4.181	76982280.0
2019-07-11 13:00:00	NVDA	Stock	4.1816	4.1843	4.136	4.1508	81267200.0
2019-07-11 14:00:00	NVDA	Stock	4.1515	4.1562	4.1275	4.1296	43636480.0
2019-07-11 15:00:00	NVDA	Stock	4.1295	4.1572	4.1268	4.157	64283440.0
2019-07-11 16:00:00	NVDA	Stock	4.157	4.16	4.1381	4.1502	19296480.0
2019-07-11 17:00:00	NVDA	Stock	4.1573	4.1573	4.1515	4.1562	307800.0
2019-07-11 18:00:00	NVDA	Stock	4.1562	4.1618	4.1558	4.1558	573520.0
2019-07-11 19:00:00	NVDA	Stock	4.156	4.1658	4.1555	4.1625	737960.0
2019-07-11 06:00:00	AMZN	Stock	101.221	101.221	101.1175	101.1175	14600.0
2019-07-11 07:00:00	AMZN	Stock	101.22	101.45	101.22	101.3605	403460.0
2019-07-11 08:00:00	AMZN	Stock	101.3506	101.5	101.175	101.3385	685920.0

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

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