PREVIEW / stock_1hour / 2022-12-23

all stock 1-hour files

  file:    by_date/stock_1hour/2022/2022-12-23.parquet
  size:    1.3 MB
  rows:    59,375
  symbols: 1,938

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
2022-12-23 04:00:00	AAPL	Stock	131.42	132.17	131.3	131.84	20712.0
2022-12-23 05:00:00	AAPL	Stock	131.88	132.54	131.88	132.51	16156.0
2022-12-23 06:00:00	AAPL	Stock	132.5	132.79	132.19	132.19	10860.0
2022-12-23 07:00:00	AAPL	Stock	132.12	132.44	132.01	132.2	43609.0
2022-12-23 08:00:00	AAPL	Stock	132.2	133.4	131.04	132.09	402753.0
2022-12-23 09:00:00	AAPL	Stock	132.06	132.15	129.64	130.0179	9064268.0
2022-12-23 10:00:00	AAPL	Stock	130.02	132.415	129.6605	130.8701	12240166.0
2022-12-23 11:00:00	AAPL	Stock	130.88	131.69	130.2531	130.875	7356294.0
2022-12-23 12:00:00	AAPL	Stock	130.88	131.76	130.83	131.14	5071023.0
2022-12-23 13:00:00	AAPL	Stock	131.14	131.5	130.81	131.1799	4513698.0
2022-12-23 14:00:00	AAPL	Stock	131.17	131.76	130.93	131.7189	4462502.0
2022-12-23 15:00:00	AAPL	Stock	131.7189	131.999	131.2	131.86	8260735.0
2022-12-23 16:00:00	AAPL	Stock	131.85	131.99	131.59	131.75	4240930.0
2022-12-23 17:00:00	AAPL	Stock	131.75	131.79	131.71	131.78	30430.0
2022-12-23 18:00:00	AAPL	Stock	131.77	131.78	131.71	131.74	13072.0
2022-12-23 19:00:00	AAPL	Stock	131.75	131.75	131.65	131.65	21075.0
2022-12-23 04:00:00	MSFT	Stock	237.87	238.07	237.87	237.97	2410.0
2022-12-23 05:00:00	MSFT	Stock	237.97	238.99	237.97	238.99	3710.0
2022-12-23 06:00:00	MSFT	Stock	239.25	239.7	238.13	238.13	1637.0
2022-12-23 07:00:00	MSFT	Stock	238.17	239.3	238.17	239.3	5661.0
2022-12-23 08:00:00	MSFT	Stock	238.23	240.87	236.82	238.34	52784.0
2022-12-23 09:00:00	MSFT	Stock	237.95	237.95	234.209	234.51	2640540.0
2022-12-23 10:00:00	MSFT	Stock	234.48	238.701	233.9428	236.94	2699121.0
2022-12-23 11:00:00	MSFT	Stock	236.92	238.55	235.82	237.94	1842404.0
2022-12-23 12:00:00	MSFT	Stock	238.0	238.84	237.51	237.88	1387156.0
2022-12-23 13:00:00	MSFT	Stock	237.91	238.4	237.16	237.45	1141217.0
2022-12-23 14:00:00	MSFT	Stock	237.44	238.245	237.21	238.19	1139506.0
2022-12-23 15:00:00	MSFT	Stock	238.21	238.87	237.53	238.76	2264237.0
2022-12-23 16:00:00	MSFT	Stock	238.73	238.88	238.3	238.3518	2230748.0
2022-12-23 17:00:00	MSFT	Stock	238.32	238.53	238.15	238.35	2959.0
2022-12-23 18:00:00	MSFT	Stock	238.49	238.49	238.2	238.37	1399.0
2022-12-23 19:00:00	MSFT	Stock	238.3	238.45	238.23	238.23	845.0
2022-12-23 04:00:00	NVDA	Stock	15.222	15.289	15.201	15.23	69810.0
2022-12-23 05:00:00	NVDA	Stock	15.22	15.372	15.218	15.363	94100.0
2022-12-23 06:00:00	NVDA	Stock	15.362	15.399	15.301	15.301	124070.0
2022-12-23 07:00:00	NVDA	Stock	15.305	15.374	15.3	15.33	117570.0
2022-12-23 08:00:00	NVDA	Stock	15.275	15.445	15.098	15.263	2540140.0
2022-12-23 09:00:00	NVDA	Stock	15.265	15.292	14.883	14.987	48420450.0
2022-12-23 10:00:00	NVDA	Stock	14.993	15.339	14.908	15.0725	74843500.0
2022-12-23 11:00:00	NVDA	Stock	15.074	15.215	15.0017	15.152	43089790.0
2022-12-23 12:00:00	NVDA	Stock	15.1488	15.239	15.118	15.1635	28192180.0
2022-12-23 13:00:00	NVDA	Stock	15.1635	15.197	15.0855	15.1044	23277980.0
2022-12-23 14:00:00	NVDA	Stock	15.102	15.167	15.071	15.156	21645610.0
2022-12-23 15:00:00	NVDA	Stock	15.157	15.22	15.103	15.209	35419900.0
2022-12-23 16:00:00	NVDA	Stock	15.209	15.251	15.172	15.202	17480130.0
2022-12-23 17:00:00	NVDA	Stock	15.202	15.219	15.182	15.1989	107510.0
2022-12-23 18:00:00	NVDA	Stock	15.19	15.195	15.176	15.183	71140.0
2022-12-23 19:00:00	NVDA	Stock	15.183	15.185	15.158	15.184	97840.0
2022-12-23 04:00:00	AMZN	Stock	83.69	83.83	83.41	83.78	15338.0
2022-12-23 05:00:00	AMZN	Stock	83.74	84.24	83.74	84.17	13669.0

> showing 50 of 59,375 rows — these rows as CSV

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