PREVIEW / stock_1hour / 2019-08-30

all stock 1-hour files

  file:    by_date/stock_1hour/2019/2019-08-30.parquet
  size:    1.1 MB
  rows:    50,171
  symbols: 2,571

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-08-30 04:00:00	AAPL	Stock	52.4175	52.575	52.4	52.5025	35764.0
2019-08-30 05:00:00	AAPL	Stock	52.625	52.755	52.625	52.7	26920.0
2019-08-30 06:00:00	AAPL	Stock	52.7025	52.725	52.6125	52.6975	21444.0
2019-08-30 07:00:00	AAPL	Stock	52.6975	52.6975	52.4875	52.6375	177236.0
2019-08-30 08:00:00	AAPL	Stock	52.595	52.6572	52.4875	52.6125	224656.0
2019-08-30 09:00:00	AAPL	Stock	52.6075	52.6375	52.3025	52.3402	10152628.0
2019-08-30 10:00:00	AAPL	Stock	52.335	52.4425	52.095	52.1725	9620992.0
2019-08-30 11:00:00	AAPL	Stock	52.17	52.2125	51.8	51.9875	8625096.0
2019-08-30 12:00:00	AAPL	Stock	51.9908	52.0142	51.825	51.9538	5614416.0
2019-08-30 13:00:00	AAPL	Stock	51.9535	51.9825	51.8462	51.9225	3638976.0
2019-08-30 14:00:00	AAPL	Stock	51.9212	52.0125	51.8575	51.91	4570948.0
2019-08-30 15:00:00	AAPL	Stock	51.9125	52.1875	51.8025	52.185	14319708.0
2019-08-30 16:00:00	AAPL	Stock	52.185	52.2	51.945	52.0375	12081680.0
2019-08-30 17:00:00	AAPL	Stock	52.185	52.185	52.04	52.0875	235852.0
2019-08-30 18:00:00	AAPL	Stock	52.0675	52.0725	52.0375	52.0375	25772.0
2019-08-30 19:00:00	AAPL	Stock	52.0375	52.1125	52.0	52.0375	49224.0
2019-08-30 04:00:00	MSFT	Stock	138.4	139.0	138.4	139.0	2748.0
2019-08-30 05:00:00	MSFT	Stock	139.03	139.1	138.92	139.1	786.0
2019-08-30 06:00:00	MSFT	Stock	139.1	139.38	139.1	139.37	2863.0
2019-08-30 07:00:00	MSFT	Stock	139.2	139.25	138.8	139.0	21384.0
2019-08-30 08:00:00	MSFT	Stock	139.0	139.24	138.8	139.001	52321.0
2019-08-30 09:00:00	MSFT	Stock	139.001	139.18	138.28	138.42	1773352.0
2019-08-30 10:00:00	MSFT	Stock	138.41	138.59	137.54	137.69	2036003.0
2019-08-30 11:00:00	MSFT	Stock	137.68	137.78	136.27	137.078	2269254.0
2019-08-30 12:00:00	MSFT	Stock	137.1	137.27	136.81	137.156	1127582.0
2019-08-30 13:00:00	MSFT	Stock	137.16	137.26	136.94	137.11	857121.0
2019-08-30 14:00:00	MSFT	Stock	137.11	137.37	136.71	136.895	1745436.0
2019-08-30 15:00:00	MSFT	Stock	136.9	137.98	136.66	137.92	5073332.0
2019-08-30 16:00:00	MSFT	Stock	137.92	138.55	137.47	137.55	5255566.0
2019-08-30 17:00:00	MSFT	Stock	137.64	137.86	137.55	137.71	93297.0
2019-08-30 18:00:00	MSFT	Stock	137.63	137.75	137.6	137.71	6546.0
2019-08-30 19:00:00	MSFT	Stock	137.71	137.74	137.71	137.72	1266.0
2019-08-30 04:00:00	NVDA	Stock	4.2035	4.2038	4.2	4.2025	57880.0
2019-08-30 05:00:00	NVDA	Stock	4.21	4.2182	4.21	4.2182	82680.0
2019-08-30 06:00:00	NVDA	Stock	4.217	4.225	4.2165	4.2198	71800.0
2019-08-30 07:00:00	NVDA	Stock	4.2225	4.226	4.2	4.2092	590680.0
2019-08-30 08:00:00	NVDA	Stock	4.2026	4.222	4.2002	4.2185	857640.0
2019-08-30 09:00:00	NVDA	Stock	4.2148	4.2625	4.1915	4.2551	54239280.0
2019-08-30 10:00:00	NVDA	Stock	4.2542	4.2715	4.2175	4.218	47773560.0
2019-08-30 11:00:00	NVDA	Stock	4.2182	4.2213	4.1702	4.1899	36374960.0
2019-08-30 12:00:00	NVDA	Stock	4.1908	4.2058	4.1873	4.2022	15353160.0
2019-08-30 13:00:00	NVDA	Stock	4.2038	4.2045	4.1818	4.1888	12322840.0
2019-08-30 14:00:00	NVDA	Stock	4.189	4.2	4.1732	4.1805	17424560.0
2019-08-30 15:00:00	NVDA	Stock	4.1812	4.1888	4.1695	4.1878	44302040.0
2019-08-30 16:00:00	NVDA	Stock	4.1878	4.1888	4.1812	4.185	19518080.0
2019-08-30 17:00:00	NVDA	Stock	4.1812	4.1878	4.179	4.1862	539720.0
2019-08-30 18:00:00	NVDA	Stock	4.1818	4.1828	4.1778	4.1778	96320.0
2019-08-30 19:00:00	NVDA	Stock	4.1875	4.1875	4.179	4.1862	171880.0
2019-08-30 04:00:00	AMZN	Stock	89.571	89.571	89.571	89.571	4040.0
2019-08-30 06:00:00	AMZN	Stock	90.005	90.005	90.002	90.005	13340.0

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

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