PREVIEW / stock_1hour / 2021-09-09

all stock 1-hour files

  file:    by_date/stock_1hour/2021/2021-09-09.parquet
  size:    1.4 MB
  rows:    64,227
  symbols: 2,738

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-09 04:00:00	AAPL	Stock	154.98	155.0	154.41	154.45	12749.0
2021-09-09 05:00:00	AAPL	Stock	154.43	154.84	154.39	154.79	14443.0
2021-09-09 06:00:00	AAPL	Stock	154.8	154.95	154.7	154.95	7548.0
2021-09-09 07:00:00	AAPL	Stock	154.81	155.16	154.68	155.13	79833.0
2021-09-09 08:00:00	AAPL	Stock	154.9885	155.46	154.68	155.38	315816.0
2021-09-09 09:00:00	AAPL	Stock	155.36	156.11	154.72	155.2912	9971993.0
2021-09-09 10:00:00	AAPL	Stock	155.29	155.8	155.08	155.27	8296670.0
2021-09-09 11:00:00	AAPL	Stock	155.28	155.4	154.75	154.9391	5760256.0
2021-09-09 12:00:00	AAPL	Stock	154.935	155.23	154.78	154.91	3839995.0
2021-09-09 13:00:00	AAPL	Stock	154.9076	155.08	154.2501	154.4465	5393990.0
2021-09-09 14:00:00	AAPL	Stock	154.44	154.55	154.0825	154.4999	4584582.0
2021-09-09 15:00:00	AAPL	Stock	154.495	154.58	153.95	154.12	7452696.0
2021-09-09 16:00:00	AAPL	Stock	154.1	155.11	154.04	154.31	4035659.0
2021-09-09 17:00:00	AAPL	Stock	154.33	154.35	154.25	154.28	26336.0
2021-09-09 18:00:00	AAPL	Stock	154.31	154.32	154.2	154.2801	19632.0
2021-09-09 19:00:00	AAPL	Stock	154.3	154.32	154.16	154.27	34456.0
2021-09-09 04:00:00	MSFT	Stock	299.63	299.63	299.1	299.1	1192.0
2021-09-09 05:00:00	MSFT	Stock	299.3	299.85	299.28	299.85	3421.0
2021-09-09 06:00:00	MSFT	Stock	299.61	299.73	299.61	299.65	1106.0
2021-09-09 07:00:00	MSFT	Stock	299.59	300.2	299.25	300.19	9467.0
2021-09-09 08:00:00	MSFT	Stock	299.41	300.5	299.41	300.28	9685.0
2021-09-09 09:00:00	MSFT	Stock	300.4	302.14	299.74	301.4	1666915.0
2021-09-09 10:00:00	MSFT	Stock	301.39	301.92	300.0	300.1597	1532655.0
2021-09-09 11:00:00	MSFT	Stock	300.15	300.25	298.72	299.35	1665844.0
2021-09-09 12:00:00	MSFT	Stock	299.3499	299.42	298.81	298.84	1057311.0
2021-09-09 13:00:00	MSFT	Stock	298.84	299.18	297.4401	297.55	1682074.0
2021-09-09 14:00:00	MSFT	Stock	297.55	298.14	297.25	298.07	1742416.0
2021-09-09 15:00:00	MSFT	Stock	298.07	298.23	297.0	297.31	2342042.0
2021-09-09 16:00:00	MSFT	Stock	297.25	300.21	297.05	297.23	3022661.0
2021-09-09 17:00:00	MSFT	Stock	297.22	297.25	297.12	297.12	3382.0
2021-09-09 18:00:00	MSFT	Stock	297.25	297.25	297.12	297.16	1336.0
2021-09-09 19:00:00	MSFT	Stock	297.24	297.25	297.15	297.15	8465.0
2021-09-09 04:00:00	NVDA	Stock	22.148	22.173	22.126	22.126	64570.0
2021-09-09 05:00:00	NVDA	Stock	22.111	22.18	22.097	22.18	57170.0
2021-09-09 06:00:00	NVDA	Stock	22.165	22.165	22.156	22.161	5110.0
2021-09-09 07:00:00	NVDA	Stock	22.146	22.289	22.133	22.288	204900.0
2021-09-09 08:00:00	NVDA	Stock	22.1706	22.374	22.127	22.325	324690.0
2021-09-09 09:00:00	NVDA	Stock	22.325	22.538	22.2	22.34	26768880.0
2021-09-09 10:00:00	NVDA	Stock	22.342	22.478	22.325	22.377	22279340.0
2021-09-09 11:00:00	NVDA	Stock	22.3745	22.392	22.274	22.3384	18390750.0
2021-09-09 12:00:00	NVDA	Stock	22.339	22.368	22.288	22.2985	14483580.0
2021-09-09 13:00:00	NVDA	Stock	22.3	22.314	22.131	22.1925	16982610.0
2021-09-09 14:00:00	NVDA	Stock	22.19	22.2721	22.155	22.262	16664550.0
2021-09-09 15:00:00	NVDA	Stock	22.264	22.28	22.133	22.177	16574990.0
2021-09-09 16:00:00	NVDA	Stock	22.177	22.339	22.1	22.115	7120620.0
2021-09-09 17:00:00	NVDA	Stock	22.117	22.133	22.113	22.121	89340.0
2021-09-09 18:00:00	NVDA	Stock	22.131	22.147	22.122	22.123	41620.0
2021-09-09 19:00:00	NVDA	Stock	22.129	22.14	22.121	22.133	52870.0
2021-09-09 07:00:00	AMZN	Stock	175.8895	175.9	175.811	175.9	10300.0
2021-09-09 08:00:00	AMZN	Stock	175.7	176.55	175.601	176.405	109400.0

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

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