PREVIEW / stock_1hour / 2021-09-14

all stock 1-hour files

  file:    by_date/stock_1hour/2021/2021-09-14.parquet
  size:    1.4 MB
  rows:    64,371
  symbols: 2,745

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-14 04:00:00	AAPL	Stock	149.45	150.04	149.45	150.04	25798.0
2021-09-14 05:00:00	AAPL	Stock	150.09	150.13	149.84	149.94	66268.0
2021-09-14 06:00:00	AAPL	Stock	149.9	150.12	149.9	150.0	20583.0
2021-09-14 07:00:00	AAPL	Stock	149.98	150.12	149.64	149.8	285600.0
2021-09-14 08:00:00	AAPL	Stock	149.8599	150.44	149.63	150.26	757685.0
2021-09-14 09:00:00	AAPL	Stock	150.27	151.07	149.63	149.875	11670545.0
2021-09-14 10:00:00	AAPL	Stock	149.875	150.02	149.185	149.665	10903920.0
2021-09-14 11:00:00	AAPL	Stock	149.669	150.44	149.575	150.251	8761966.0
2021-09-14 12:00:00	AAPL	Stock	150.26	150.38	148.8	149.0	8856323.0
2021-09-14 13:00:00	AAPL	Stock	148.99	149.17	148.28	148.59	12896742.0
2021-09-14 14:00:00	AAPL	Stock	148.5701	148.61	146.91	147.745	17259558.0
2021-09-14 15:00:00	AAPL	Stock	147.75	148.33	147.21	148.19	14870757.0
2021-09-14 16:00:00	AAPL	Stock	148.12	148.45	148.12	148.16	9023675.0
2021-09-14 17:00:00	AAPL	Stock	148.15	148.23	148.12	148.16	66723.0
2021-09-14 18:00:00	AAPL	Stock	148.16	148.22	148.01	148.19	45717.0
2021-09-14 19:00:00	AAPL	Stock	148.19	148.2	148.15	148.19	69987.0
2021-09-14 04:00:00	MSFT	Stock	297.59	298.04	297.2	298.04	3433.0
2021-09-14 05:00:00	MSFT	Stock	297.9	297.9	297.54	297.63	888.0
2021-09-14 06:00:00	MSFT	Stock	297.73	297.84	297.51	297.6	2994.0
2021-09-14 07:00:00	MSFT	Stock	297.5	297.56	296.7	296.7	7602.0
2021-09-14 08:00:00	MSFT	Stock	297.4501	298.9999	296.83	298.6799	51156.0
2021-09-14 09:00:00	MSFT	Stock	298.55	300.08	298.0876	299.05	2112327.0
2021-09-14 10:00:00	MSFT	Stock	299.06	299.93	298.5	299.5235	2092752.0
2021-09-14 11:00:00	MSFT	Stock	299.53	300.92	299.53	300.9	1764505.0
2021-09-14 12:00:00	MSFT	Stock	300.9186	301.39	300.14	300.53	1500425.0
2021-09-14 13:00:00	MSFT	Stock	300.52	300.825	300.07	300.63	951605.0
2021-09-14 14:00:00	MSFT	Stock	300.63	300.72	299.29	300.26	1309153.0
2021-09-14 15:00:00	MSFT	Stock	300.28	300.58	299.49	299.94	2880931.0
2021-09-14 16:00:00	MSFT	Stock	299.79	300.18	299.73	299.8081	3376514.0
2021-09-14 17:00:00	MSFT	Stock	299.9	299.9	299.28	299.47	2398.0
2021-09-14 18:00:00	MSFT	Stock	299.84	302.99	299.79	302.7	185217.0
2021-09-14 19:00:00	MSFT	Stock	302.7499	303.12	302.39	302.39	66950.0
2021-09-14 04:00:00	NVDA	Stock	22.09	22.125	22.08	22.118	12500.0
2021-09-14 05:00:00	NVDA	Stock	22.146	22.17	22.146	22.152	8150.0
2021-09-14 06:00:00	NVDA	Stock	22.098	22.098	22.098	22.098	1000.0
2021-09-14 07:00:00	NVDA	Stock	22.1	22.125	22.042	22.072	119780.0
2021-09-14 08:00:00	NVDA	Stock	22.035	22.272	22.035	22.225	939850.0
2021-09-14 09:00:00	NVDA	Stock	22.225	22.371	22.086	22.2129	26958000.0
2021-09-14 10:00:00	NVDA	Stock	22.21	22.339	22.098	22.2329	34285820.0
2021-09-14 11:00:00	NVDA	Stock	22.233	22.3919	22.21	22.345	18692790.0
2021-09-14 12:00:00	NVDA	Stock	22.351	22.403	22.29	22.366	17011860.0
2021-09-14 13:00:00	NVDA	Stock	22.366	22.41	22.263	22.365	13085130.0
2021-09-14 14:00:00	NVDA	Stock	22.364	22.376	22.175	22.265	12926310.0
2021-09-14 15:00:00	NVDA	Stock	22.266	22.268	22.177	22.252	17310930.0
2021-09-14 16:00:00	NVDA	Stock	22.242	22.265	22.237	22.25	15918620.0
2021-09-14 17:00:00	NVDA	Stock	22.25	22.26	22.242	22.245	25220.0
2021-09-14 18:00:00	NVDA	Stock	22.245	22.255	22.242	22.255	1009380.0
2021-09-14 19:00:00	NVDA	Stock	22.26	22.27	22.245	22.27	34920.0
2021-09-14 07:00:00	AMZN	Stock	173.068	173.1525	172.75	172.75	26880.0
2021-09-14 08:00:00	AMZN	Stock	173.1	173.94	172.75	173.5325	88720.0

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

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