PREVIEW / stock_1hour / 2019-10-28

all stock 1-hour files

  file:    by_date/stock_1hour/2019/2019-10-28.parquet
  size:    1.1 MB
  rows:    49,872
  symbols: 2,517

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-10-28 04:00:00	AAPL	Stock	61.825	61.9825	61.825	61.9575	25732.0
2019-10-28 05:00:00	AAPL	Stock	61.915	61.9175	61.855	61.8575	16176.0
2019-10-28 06:00:00	AAPL	Stock	61.86	61.8625	61.8	61.8625	32156.0
2019-10-28 07:00:00	AAPL	Stock	61.8375	61.9375	61.785	61.85	168904.0
2019-10-28 08:00:00	AAPL	Stock	61.9125	61.98	61.4925	61.9625	609952.0
2019-10-28 09:00:00	AAPL	Stock	61.965	62.09	61.68	62.0062	15947604.0
2019-10-28 10:00:00	AAPL	Stock	62.005	62.1625	61.9375	62.02	14661828.0
2019-10-28 11:00:00	AAPL	Stock	62.015	62.1825	61.9925	62.1388	9546236.0
2019-10-28 12:00:00	AAPL	Stock	62.1425	62.18	62.0575	62.1212	6781412.0
2019-10-28 13:00:00	AAPL	Stock	62.12	62.17	62.0875	62.1025	5409532.0
2019-10-28 14:00:00	AAPL	Stock	62.1018	62.145	62.075	62.1238	5145252.0
2019-10-28 15:00:00	AAPL	Stock	62.1238	62.3125	62.1225	62.26	14052968.0
2019-10-28 16:00:00	AAPL	Stock	62.2625	62.29	62.0082	62.2625	6592616.0
2019-10-28 17:00:00	AAPL	Stock	62.2675	62.3375	62.25	62.285	131552.0
2019-10-28 18:00:00	AAPL	Stock	62.2775	62.3	62.2625	62.2875	45932.0
2019-10-28 19:00:00	AAPL	Stock	62.2875	62.325	62.2825	62.2875	64880.0
2019-10-28 04:00:00	MSFT	Stock	145.0	146.44	145.0	145.4	30427.0
2019-10-28 05:00:00	MSFT	Stock	145.23	145.23	144.75	145.06	22586.0
2019-10-28 06:00:00	MSFT	Stock	145.05	145.74	144.82	144.99	71999.0
2019-10-28 07:00:00	MSFT	Stock	144.95	145.5	144.32	144.4	221870.0
2019-10-28 08:00:00	MSFT	Stock	144.45	145.5	144.1	144.39	400400.0
2019-10-28 09:00:00	MSFT	Stock	144.39	145.67	143.8	144.405	9502346.0
2019-10-28 10:00:00	MSFT	Stock	144.405	144.51	143.7	143.9	4942417.0
2019-10-28 11:00:00	MSFT	Stock	143.89	144.26	143.55	143.994	3188780.0
2019-10-28 12:00:00	MSFT	Stock	144.0	144.015	143.52	143.6	1972330.0
2019-10-28 13:00:00	MSFT	Stock	143.6	144.34	143.51	144.115	2133915.0
2019-10-28 14:00:00	MSFT	Stock	144.11	144.4	144.03	144.355	1869174.0
2019-10-28 15:00:00	MSFT	Stock	144.35	144.4	143.96	144.2	3476116.0
2019-10-28 16:00:00	MSFT	Stock	144.19	144.22	143.595	144.17	2958173.0
2019-10-28 17:00:00	MSFT	Stock	144.19	144.2	144.01	144.17	14157.0
2019-10-28 18:00:00	MSFT	Stock	144.17	144.2	144.04	144.1	22788.0
2019-10-28 19:00:00	MSFT	Stock	144.12	144.2	144.01	144.09	10039.0
2019-10-28 04:00:00	NVDA	Stock	5.12	5.15	5.12	5.15	25720.0
2019-10-28 05:00:00	NVDA	Stock	5.15	5.15	5.15	5.15	13600.0
2019-10-28 06:00:00	NVDA	Stock	5.1462	5.1462	5.1418	5.1418	41240.0
2019-10-28 07:00:00	NVDA	Stock	5.146	5.1675	5.1378	5.1675	506040.0
2019-10-28 08:00:00	NVDA	Stock	5.1425	5.1873	5.1008	5.185	2455680.0
2019-10-28 09:00:00	NVDA	Stock	5.186	5.1948	5.1279	5.15	65718960.0
2019-10-28 10:00:00	NVDA	Stock	5.1525	5.1985	5.1468	5.1768	55633480.0
2019-10-28 11:00:00	NVDA	Stock	5.1771	5.2225	5.1725	5.2148	43720160.0
2019-10-28 12:00:00	NVDA	Stock	5.2151	5.216	5.1678	5.1758	27995720.0
2019-10-28 13:00:00	NVDA	Stock	5.1774	5.187	5.1592	5.1671	17614960.0
2019-10-28 14:00:00	NVDA	Stock	5.1665	5.1885	5.1665	5.1763	24189800.0
2019-10-28 15:00:00	NVDA	Stock	5.1765	5.19	5.1612	5.1693	32054880.0
2019-10-28 16:00:00	NVDA	Stock	5.1698	5.17	5.1553	5.1672	26665800.0
2019-10-28 17:00:00	NVDA	Stock	5.1698	5.185	5.1698	5.18	399360.0
2019-10-28 18:00:00	NVDA	Stock	5.1795	5.1795	5.1725	5.1725	89280.0
2019-10-28 19:00:00	NVDA	Stock	5.1713	5.1713	5.1622	5.1622	266400.0
2019-10-28 04:00:00	AMZN	Stock	87.6535	87.6535	87.5975	87.5975	6000.0
2019-10-28 05:00:00	AMZN	Stock	87.5975	87.7	87.5975	87.7	4000.0

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

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