PREVIEW / stock_1hour / 2021-11-12

all stock 1-hour files

  file:    by_date/stock_1hour/2021/2021-11-12.parquet
  size:    1.5 MB
  rows:    68,053
  symbols: 2,706

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-11-12 04:00:00	AAPL	Stock	148.26	148.32	147.95	148.01	6981.0
2021-11-12 05:00:00	AAPL	Stock	148.04	148.08	148.0	148.05	5137.0
2021-11-12 06:00:00	AAPL	Stock	148.09	148.18	148.05	148.17	6536.0
2021-11-12 07:00:00	AAPL	Stock	148.23	148.3	148.12	148.18	42726.0
2021-11-12 08:00:00	AAPL	Stock	148.16	148.39	147.501	148.35	172565.0
2021-11-12 09:00:00	AAPL	Stock	148.36	148.63	147.48	147.98	5774969.0
2021-11-12 10:00:00	AAPL	Stock	147.99	148.7779	147.77	148.57	6212226.0
2021-11-12 11:00:00	AAPL	Stock	148.57	150.09	148.52	149.8	10366887.0
2021-11-12 12:00:00	AAPL	Stock	149.805	149.88	149.55	149.575	3766671.0
2021-11-12 13:00:00	AAPL	Stock	149.575	149.96	149.292	149.94	4116543.0
2021-11-12 14:00:00	AAPL	Stock	149.935	150.03	149.74	149.9	3481793.0
2021-11-12 15:00:00	AAPL	Stock	149.9	150.4	149.75	149.99	7903261.0
2021-11-12 16:00:00	AAPL	Stock	149.99	150.06	149.95	149.99	6545703.0
2021-11-12 17:00:00	AAPL	Stock	150.0	150.0	149.97	149.98	74716.0
2021-11-12 18:00:00	AAPL	Stock	150.0	150.0	149.87	149.94	21148.0
2021-11-12 19:00:00	AAPL	Stock	149.96	149.98	149.73	149.73	55255.0
2021-11-12 04:00:00	MSFT	Stock	333.86	333.86	333.02	333.1	4364.0
2021-11-12 05:00:00	MSFT	Stock	333.57	333.57	333.57	333.57	250.0
2021-11-12 06:00:00	MSFT	Stock	333.5	333.96	333.5	333.73	1177.0
2021-11-12 07:00:00	MSFT	Stock	333.9	333.9	333.4	333.47	7804.0
2021-11-12 08:00:00	MSFT	Stock	333.5108	334.0	333.3	333.809	29266.0
2021-11-12 09:00:00	MSFT	Stock	333.9837	335.62	332.43	334.42	1562255.0
2021-11-12 10:00:00	MSFT	Stock	334.39	335.45	334.21	335.36	1345361.0
2021-11-12 11:00:00	MSFT	Stock	335.39	336.97	335.07	336.67	2300082.0
2021-11-12 12:00:00	MSFT	Stock	336.69	336.97	336.4	336.68	1060273.0
2021-11-12 13:00:00	MSFT	Stock	336.6816	336.86	336.24	336.74	842656.0
2021-11-12 14:00:00	MSFT	Stock	336.74	336.84	336.15	336.27	1035823.0
2021-11-12 15:00:00	MSFT	Stock	336.27	337.23	336.19	336.73	1920934.0
2021-11-12 16:00:00	MSFT	Stock	336.73	337.0216	336.39	336.79	3316494.0
2021-11-12 17:00:00	MSFT	Stock	336.99	337.0	336.6	336.6	27107.0
2021-11-12 18:00:00	MSFT	Stock	336.73	337.0	336.73	337.0	1495.0
2021-11-12 19:00:00	MSFT	Stock	336.9	337.15	336.85	337.15	4572.0
2021-11-12 04:00:00	NVDA	Stock	30.86	30.928	30.664	30.664	150020.0
2021-11-12 05:00:00	NVDA	Stock	30.687	30.784	30.687	30.733	55180.0
2021-11-12 06:00:00	NVDA	Stock	30.719	30.751	29.89	30.085	934780.0
2021-11-12 07:00:00	NVDA	Stock	30.086	30.245	29.933	29.99	1490790.0
2021-11-12 08:00:00	NVDA	Stock	30.185	30.2477	29.91	30.15	2098700.0
2021-11-12 09:00:00	NVDA	Stock	30.17	30.39	29.63	29.7455	48904970.0
2021-11-12 10:00:00	NVDA	Stock	29.7396	30.232	29.667	30.211	54668330.0
2021-11-12 11:00:00	NVDA	Stock	30.2135	30.68	30.176	30.621	52201910.0
2021-11-12 12:00:00	NVDA	Stock	30.6164	30.637	30.204	30.3295	40724500.0
2021-11-12 13:00:00	NVDA	Stock	30.328	30.4784	30.221	30.3401	22472800.0
2021-11-12 14:00:00	NVDA	Stock	30.341	30.475	30.264	30.364	20580710.0
2021-11-12 15:00:00	NVDA	Stock	30.368	30.481	30.347	30.3882	29911630.0
2021-11-12 16:00:00	NVDA	Stock	30.39	30.41	30.31	30.327	19523440.0
2021-11-12 17:00:00	NVDA	Stock	30.336	30.39	30.118	30.2	362770.0
2021-11-12 18:00:00	NVDA	Stock	30.28	30.28	30.1	30.12	328830.0
2021-11-12 19:00:00	NVDA	Stock	30.12	30.157	30.105	30.124	363400.0
2021-11-12 04:00:00	AMZN	Stock	174.25	174.25	174.25	174.25	3160.0
2021-11-12 05:00:00	AMZN	Stock	173.875	173.875	173.875	173.875	4840.0

> showing 50 of 68,053 rows — these rows as CSV

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