PREVIEW / stock_1hour / 2021-10-19

all stock 1-hour files

  file:    by_date/stock_1hour/2021/2021-10-19.parquet
  size:    1.4 MB
  rows:    64,369
  symbols: 2,676

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-10-19 04:00:00	AAPL	Stock	146.79	147.19	146.79	147.17	16065.0
2021-10-19 05:00:00	AAPL	Stock	147.19	147.22	147.09	147.2	8619.0
2021-10-19 06:00:00	AAPL	Stock	147.21	147.5	147.2	147.44	21772.0
2021-10-19 07:00:00	AAPL	Stock	147.33	147.63	147.29	147.4	149717.0
2021-10-19 08:00:00	AAPL	Stock	147.4	147.64	147.21	147.24	376388.0
2021-10-19 09:00:00	AAPL	Stock	147.22	147.89	146.55	147.78	12291547.0
2021-10-19 10:00:00	AAPL	Stock	147.789	149.04	147.6417	148.9264	14811095.0
2021-10-19 11:00:00	AAPL	Stock	148.9201	149.17	148.22	148.52	9616613.0
2021-10-19 12:00:00	AAPL	Stock	148.52	148.92	148.37	148.87	6170521.0
2021-10-19 13:00:00	AAPL	Stock	148.875	149.045	148.715	148.845	4756234.0
2021-10-19 14:00:00	AAPL	Stock	148.845	148.88	148.335	148.675	4933386.0
2021-10-19 15:00:00	AAPL	Stock	148.67	148.8373	148.26	148.78	8526405.0
2021-10-19 16:00:00	AAPL	Stock	148.79	148.86	148.64	148.81	5642219.0
2021-10-19 17:00:00	AAPL	Stock	148.79	148.83	148.62	148.71	61951.0
2021-10-19 18:00:00	AAPL	Stock	148.7	148.73	148.53	148.66	52566.0
2021-10-19 19:00:00	AAPL	Stock	148.62	148.66	148.55	148.6	77891.0
2021-10-19 04:00:00	MSFT	Stock	307.82	308.22	307.79	308.0	10909.0
2021-10-19 05:00:00	MSFT	Stock	308.28	308.4	308.28	308.4	1288.0
2021-10-19 06:00:00	MSFT	Stock	308.33	308.6	308.33	308.58	1620.0
2021-10-19 07:00:00	MSFT	Stock	308.3	308.61	308.25	308.5	17446.0
2021-10-19 08:00:00	MSFT	Stock	308.5927	308.69	307.7	307.8	33848.0
2021-10-19 09:00:00	MSFT	Stock	307.86	309.3	307.22	308.1	2547055.0
2021-10-19 10:00:00	MSFT	Stock	308.1	308.9799	307.8	308.94	2114966.0
2021-10-19 11:00:00	MSFT	Stock	308.95	309.0	307.87	307.93	1230824.0
2021-10-19 12:00:00	MSFT	Stock	307.93	308.42	307.69	308.2061	870323.0
2021-10-19 13:00:00	MSFT	Stock	308.21	308.71	308.05	308.49	970736.0
2021-10-19 14:00:00	MSFT	Stock	308.49	308.505	307.71	307.8	1020828.0
2021-10-19 15:00:00	MSFT	Stock	307.79	308.54	307.71	308.26	1876100.0
2021-10-19 16:00:00	MSFT	Stock	308.23	308.73	308.1	308.54	2959584.0
2021-10-19 17:00:00	MSFT	Stock	308.53	308.67	308.46	308.5	10101.0
2021-10-19 18:00:00	MSFT	Stock	308.52	308.62	308.3	308.62	6323.0
2021-10-19 19:00:00	MSFT	Stock	308.62	308.75	308.62	308.75	16582.0
2021-10-19 04:00:00	NVDA	Stock	22.299	22.359	22.297	22.31	47190.0
2021-10-19 05:00:00	NVDA	Stock	22.31	22.325	22.31	22.315	28370.0
2021-10-19 06:00:00	NVDA	Stock	22.315	22.35	22.304	22.336	39220.0
2021-10-19 07:00:00	NVDA	Stock	22.336	22.368	22.311	22.33	288450.0
2021-10-19 08:00:00	NVDA	Stock	22.341	22.369	22.1665	22.31	573720.0
2021-10-19 09:00:00	NVDA	Stock	22.293	22.349	22.1	22.1068	25082340.0
2021-10-19 10:00:00	NVDA	Stock	22.11	22.19	22.037	22.181	19265020.0
2021-10-19 11:00:00	NVDA	Stock	22.18	22.364	22.113	22.3103	20079920.0
2021-10-19 12:00:00	NVDA	Stock	22.312	22.328	22.271	22.319	9447970.0
2021-10-19 13:00:00	NVDA	Stock	22.3194	22.372	22.2896	22.355	10652590.0
2021-10-19 14:00:00	NVDA	Stock	22.356	22.379	22.213	22.228	13685680.0
2021-10-19 15:00:00	NVDA	Stock	22.227	22.317	22.225	22.294	16687220.0
2021-10-19 16:00:00	NVDA	Stock	22.29	22.33	22.268	22.268	9054660.0
2021-10-19 17:00:00	NVDA	Stock	22.279	22.287	22.252	22.268	107880.0
2021-10-19 18:00:00	NVDA	Stock	22.27	22.287	22.26	22.284	37410.0
2021-10-19 19:00:00	NVDA	Stock	22.275	22.309	22.261	22.295	70320.0
2021-10-19 06:00:00	AMZN	Stock	172.659	172.75	172.659	172.75	6000.0
2021-10-19 07:00:00	AMZN	Stock	172.7125	172.7655	172.25	172.25	72780.0

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

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