PREVIEW / stock_1hour / 2019-08-20

all stock 1-hour files

  file:    by_date/stock_1hour/2019/2019-08-20.parquet
  size:    1.1 MB
  rows:    49,471
  symbols: 2,566

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-20 04:00:00	AAPL	Stock	52.65	52.785	52.65	52.7525	14296.0
2019-08-20 05:00:00	AAPL	Stock	52.755	52.755	52.5925	52.65	7580.0
2019-08-20 06:00:00	AAPL	Stock	52.6825	52.75	52.65	52.65	14580.0
2019-08-20 07:00:00	AAPL	Stock	52.675	52.7625	52.5	52.7375	125772.0
2019-08-20 08:00:00	AAPL	Stock	52.6	52.9125	52.5375	52.775	322896.0
2019-08-20 09:00:00	AAPL	Stock	52.75	52.945	52.6275	52.7425	11930500.0
2019-08-20 10:00:00	AAPL	Stock	52.7425	53.1025	52.6925	53.095	11249568.0
2019-08-20 11:00:00	AAPL	Stock	53.095	53.3375	52.98	53.06	14821632.0
2019-08-20 12:00:00	AAPL	Stock	53.061	53.27	53.061	53.245	8693280.0
2019-08-20 13:00:00	AAPL	Stock	53.245	53.26	52.8175	52.9208	7658180.0
2019-08-20 14:00:00	AAPL	Stock	52.9175	52.9308	52.72	52.8625	7731388.0
2019-08-20 15:00:00	AAPL	Stock	52.86	52.8925	52.58	52.5875	12614872.0
2019-08-20 16:00:00	AAPL	Stock	52.59	52.6525	52.5175	52.5175	7163436.0
2019-08-20 17:00:00	AAPL	Stock	52.5575	52.5625	52.5175	52.55	36620.0
2019-08-20 18:00:00	AAPL	Stock	52.5375	52.625	52.505	52.5525	68264.0
2019-08-20 19:00:00	AAPL	Stock	52.61	52.69	52.5775	52.6725	95804.0
2019-08-20 04:00:00	MSFT	Stock	138.09	138.62	138.09	138.5	4131.0
2019-08-20 05:00:00	MSFT	Stock	138.4	138.62	138.4	138.61	4800.0
2019-08-20 06:00:00	MSFT	Stock	138.6	138.62	138.53	138.53	964.0
2019-08-20 07:00:00	MSFT	Stock	138.4	138.65	138.2	138.59	14451.0
2019-08-20 08:00:00	MSFT	Stock	138.29	138.8	138.06	138.41	76717.0
2019-08-20 09:00:00	MSFT	Stock	138.41	138.41	137.39	137.9	1941078.0
2019-08-20 10:00:00	MSFT	Stock	137.89	138.28	137.54	138.27	1925496.0
2019-08-20 11:00:00	MSFT	Stock	138.27	138.71	138.21	138.39	1633131.0
2019-08-20 12:00:00	MSFT	Stock	138.385	138.59	138.275	138.445	937191.0
2019-08-20 13:00:00	MSFT	Stock	138.44	138.49	137.83	137.96	1080395.0
2019-08-20 14:00:00	MSFT	Stock	137.96	137.995	137.39	137.675	1623312.0
2019-08-20 15:00:00	MSFT	Stock	137.67	137.9	137.24	137.24	3376283.0
2019-08-20 16:00:00	MSFT	Stock	137.24	137.44	137.16	137.25	4209990.0
2019-08-20 17:00:00	MSFT	Stock	137.25	137.3	137.15	137.15	4844.0
2019-08-20 18:00:00	MSFT	Stock	137.16	137.3	137.05	137.25	11353.0
2019-08-20 19:00:00	MSFT	Stock	137.27	137.3	137.25	137.3	9687.0
2019-08-20 04:00:00	NVDA	Stock	4.299	4.3125	4.2902	4.2925	88800.0
2019-08-20 05:00:00	NVDA	Stock	4.2695	4.2878	4.2695	4.2878	39600.0
2019-08-20 06:00:00	NVDA	Stock	4.2833	4.2833	4.2782	4.2825	26200.0
2019-08-20 07:00:00	NVDA	Stock	4.2875	4.2972	4.27	4.2925	912200.0
2019-08-20 08:00:00	NVDA	Stock	4.2722	4.3	4.2675	4.275	1976840.0
2019-08-20 09:00:00	NVDA	Stock	4.2725	4.2833	4.1884	4.1955	89004680.0
2019-08-20 10:00:00	NVDA	Stock	4.1938	4.2163	4.1755	4.2158	96842920.0
2019-08-20 11:00:00	NVDA	Stock	4.215	4.2195	4.1852	4.1968	53452040.0
2019-08-20 12:00:00	NVDA	Stock	4.197	4.2075	4.1878	4.2013	33857440.0
2019-08-20 13:00:00	NVDA	Stock	4.2013	4.2238	4.1908	4.2222	36689480.0
2019-08-20 14:00:00	NVDA	Stock	4.2222	4.2243	4.2028	4.217	36200520.0
2019-08-20 15:00:00	NVDA	Stock	4.2168	4.22	4.195	4.196	56321440.0
2019-08-20 16:00:00	NVDA	Stock	4.1968	4.198	4.1875	4.1888	23599280.0
2019-08-20 17:00:00	NVDA	Stock	4.189	4.195	4.1843	4.1862	181520.0
2019-08-20 18:00:00	NVDA	Stock	4.1848	4.195	4.184	4.1908	155680.0
2019-08-20 19:00:00	NVDA	Stock	4.1942	4.1958	4.1928	4.1932	248560.0
2019-08-20 04:00:00	AMZN	Stock	91.0685	91.0685	91.0685	91.0685	2000.0
2019-08-20 05:00:00	AMZN	Stock	91.0105	91.0105	91.0105	91.0105	2080.0

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

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