PREVIEW / stock_1hour / 2021-09-02

all stock 1-hour files

  file:    by_date/stock_1hour/2021/2021-09-02.parquet
  size:    1.4 MB
  rows:    64,403
  symbols: 2,734

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
2021-09-02 04:00:00	AAPL	Stock	152.86	153.44	152.86	153.15	32333.0
2021-09-02 05:00:00	AAPL	Stock	153.04	153.32	153.04	153.1	6057.0
2021-09-02 06:00:00	AAPL	Stock	153.15	153.29	153.13	153.2	7482.0
2021-09-02 07:00:00	AAPL	Stock	153.2	153.49	153.19	153.49	123413.0
2021-09-02 08:00:00	AAPL	Stock	153.49	153.96	152.129	153.78	452340.0
2021-09-02 09:00:00	AAPL	Stock	153.76	154.72	153.59	154.16	11019867.0
2021-09-02 10:00:00	AAPL	Stock	154.16	154.33	153.3609	154.053	9695936.0
2021-09-02 11:00:00	AAPL	Stock	154.06	154.14	153.525	153.585	6367542.0
2021-09-02 12:00:00	AAPL	Stock	153.58	153.74	153.02	153.305	5309204.0
2021-09-02 13:00:00	AAPL	Stock	153.3007	153.4688	152.53	152.6	5966156.0
2021-09-02 14:00:00	AAPL	Stock	152.605	153.54	152.4	153.47	8249952.0
2021-09-02 15:00:00	AAPL	Stock	153.4694	153.825	153.315	153.71	10768824.0
2021-09-02 16:00:00	AAPL	Stock	153.65	153.77	153.5	153.6937	5436121.0
2021-09-02 17:00:00	AAPL	Stock	153.69	153.73	153.51	153.572	44733.0
2021-09-02 18:00:00	AAPL	Stock	153.6	153.73	153.6	153.7	27087.0
2021-09-02 19:00:00	AAPL	Stock	153.7	153.7	153.55	153.59	25825.0
2021-09-02 04:00:00	MSFT	Stock	302.25	302.7	302.25	302.7	2949.0
2021-09-02 05:00:00	MSFT	Stock	302.5	302.6	302.4	302.51	1914.0
2021-09-02 06:00:00	MSFT	Stock	302.48	302.5	302.4	302.5	2015.0
2021-09-02 07:00:00	MSFT	Stock	302.16	302.69	302.16	302.69	1874.0
2021-09-02 08:00:00	MSFT	Stock	302.4998	302.74	302.16	302.56	12843.0
2021-09-02 09:00:00	MSFT	Stock	302.64	303.3602	301.83	302.855	1688234.0
2021-09-02 10:00:00	MSFT	Stock	302.81	302.98	301.7354	301.7401	1416551.0
2021-09-02 11:00:00	MSFT	Stock	301.75	301.85	301.08	301.115	1119558.0
2021-09-02 12:00:00	MSFT	Stock	301.1	301.125	300.56	300.8	966497.0
2021-09-02 13:00:00	MSFT	Stock	300.805	301.04	300.41	300.56	967597.0
2021-09-02 14:00:00	MSFT	Stock	300.56	301.145	300.18	301.08	1005967.0
2021-09-02 15:00:00	MSFT	Stock	301.08	301.26	300.47	301.16	2003762.0
2021-09-02 16:00:00	MSFT	Stock	301.15	301.65	301.14	301.51	3166803.0
2021-09-02 17:00:00	MSFT	Stock	301.61	301.77	301.6	301.75	11086.0
2021-09-02 18:00:00	MSFT	Stock	301.65	301.6899	301.5	301.5	3713.0
2021-09-02 19:00:00	MSFT	Stock	301.5	301.5	301.39	301.4	1419.0
2021-09-02 04:00:00	NVDA	Stock	22.462	22.463	22.45	22.46	10170.0
2021-09-02 05:00:00	NVDA	Stock	22.499	22.499	22.45	22.45	20530.0
2021-09-02 06:00:00	NVDA	Stock	22.46	22.471	22.459	22.471	13190.0
2021-09-02 07:00:00	NVDA	Stock	22.475	22.524	22.45	22.5	145280.0
2021-09-02 08:00:00	NVDA	Stock	22.47	22.54	22.3849	22.513	355620.0
2021-09-02 09:00:00	NVDA	Stock	22.524	22.537	22.333	22.537	30996970.0
2021-09-02 10:00:00	NVDA	Stock	22.538	22.569	22.38	22.468	28716590.0
2021-09-02 11:00:00	NVDA	Stock	22.471	22.593	22.455	22.4754	17903710.0
2021-09-02 12:00:00	NVDA	Stock	22.475	22.487	22.3956	22.462	15507060.0
2021-09-02 13:00:00	NVDA	Stock	22.4638	22.489	22.366	22.387	11625700.0
2021-09-02 14:00:00	NVDA	Stock	22.385	22.425	22.2945	22.41	12164610.0
2021-09-02 15:00:00	NVDA	Stock	22.411	22.42	22.319	22.401	16677990.0
2021-09-02 16:00:00	NVDA	Stock	22.401	22.401	22.37	22.399	13796740.0
2021-09-02 17:00:00	NVDA	Stock	22.387	22.39	22.37	22.372	95420.0
2021-09-02 18:00:00	NVDA	Stock	22.379	22.38	22.364	22.378	39830.0
2021-09-02 19:00:00	NVDA	Stock	22.377	22.378	22.351	22.365	132380.0
2021-09-02 04:00:00	AMZN	Stock	174.5	174.5	174.4965	174.4965	13860.0
2021-09-02 07:00:00	AMZN	Stock	174.7	174.71	174.7	174.71	11120.0

> showing 50 of 64,403 rows — these rows as CSV

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