PREVIEW / stock_1hour / 2022-09-12

all stock 1-hour files

  file:    by_date/stock_1hour/2022/2022-09-12.parquet
  size:    1.4 MB
  rows:    62,558
  symbols: 2,222

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-09-12 04:00:00	AAPL	Stock	158.02	158.79	158.0	158.79	50579.0
2022-09-12 05:00:00	AAPL	Stock	158.75	159.09	158.7	158.81	78757.0
2022-09-12 06:00:00	AAPL	Stock	158.8	159.04	158.65	158.91	33405.0
2022-09-12 07:00:00	AAPL	Stock	158.89	159.54	158.78	159.48	121586.0
2022-09-12 08:00:00	AAPL	Stock	158.92	159.55	157.61	159.26	293271.0
2022-09-12 09:00:00	AAPL	Stock	159.2897	161.69	159.15	161.615	12947814.0
2022-09-12 10:00:00	AAPL	Stock	161.615	162.05	161.21	161.41	12733217.0
2022-09-12 11:00:00	AAPL	Stock	161.415	162.89	161.22	161.895	13112013.0
2022-09-12 12:00:00	AAPL	Stock	161.9	163.139	161.73	163.09	9411636.0
2022-09-12 13:00:00	AAPL	Stock	163.09	164.26	162.73	164.135	9797978.0
2022-09-12 14:00:00	AAPL	Stock	164.13	164.1777	163.28	163.57	8198850.0
2022-09-12 15:00:00	AAPL	Stock	163.579	163.9699	163.0701	163.45	12899958.0
2022-09-12 16:00:00	AAPL	Stock	163.45	163.85	163.27	163.83	9090277.0
2022-09-12 17:00:00	AAPL	Stock	163.8296	163.88	163.71	163.72	85956.0
2022-09-12 18:00:00	AAPL	Stock	163.72	163.85	163.65	163.85	37736.0
2022-09-12 19:00:00	AAPL	Stock	163.86	164.18	163.84	164.15	74143.0
2022-09-12 04:00:00	MSFT	Stock	264.45	266.6	264.45	266.47	4525.0
2022-09-12 05:00:00	MSFT	Stock	266.79	266.98	266.25	266.25	1436.0
2022-09-12 06:00:00	MSFT	Stock	265.82	265.82	265.32	265.63	761.0
2022-09-12 07:00:00	MSFT	Stock	265.45	265.82	265.11	265.77	22585.0
2022-09-12 08:00:00	MSFT	Stock	265.7439	265.8298	264.46	265.4	33541.0
2022-09-12 09:00:00	MSFT	Stock	265.303	267.35	264.86	266.94	1551918.0
2022-09-12 10:00:00	MSFT	Stock	266.95	267.45	266.3283	266.77	1488860.0
2022-09-12 11:00:00	MSFT	Stock	266.78	267.26	265.3637	265.64	1244073.0
2022-09-12 12:00:00	MSFT	Stock	265.63	266.43	265.19	266.19	955510.0
2022-09-12 13:00:00	MSFT	Stock	266.1892	267.01	265.63	266.88	813856.0
2022-09-12 14:00:00	MSFT	Stock	266.86	266.92	265.8348	266.49	857949.0
2022-09-12 15:00:00	MSFT	Stock	266.49	266.79	265.84	266.66	2112274.0
2022-09-12 16:00:00	MSFT	Stock	266.65	267.497	266.65	267.2411	4000698.0
2022-09-12 17:00:00	MSFT	Stock	267.4	267.4	267.1542	267.28	2604.0
2022-09-12 18:00:00	MSFT	Stock	267.28	267.28	267.03	267.19	4669.0
2022-09-12 19:00:00	MSFT	Stock	267.28	267.28	267.01	267.01	5499.0
2022-09-12 04:00:00	NVDA	Stock	14.42	14.5	14.42	14.495	84650.0
2022-09-12 05:00:00	NVDA	Stock	14.495	14.526	14.485	14.49	116400.0
2022-09-12 06:00:00	NVDA	Stock	14.487	14.498	14.461	14.483	61570.0
2022-09-12 07:00:00	NVDA	Stock	14.472	14.505	14.449	14.499	295880.0
2022-09-12 08:00:00	NVDA	Stock	14.488	14.51	14.428	14.455	1071220.0
2022-09-12 09:00:00	NVDA	Stock	14.455	14.486	14.284	14.457	56259270.0
2022-09-12 10:00:00	NVDA	Stock	14.456	14.547	14.331	14.345	81689750.0
2022-09-12 11:00:00	NVDA	Stock	14.346	14.383	14.2161	14.2445	58122740.0
2022-09-12 12:00:00	NVDA	Stock	14.245	14.337	14.198	14.3357	39913650.0
2022-09-12 13:00:00	NVDA	Stock	14.337	14.424	14.302	14.412	45050260.0
2022-09-12 14:00:00	NVDA	Stock	14.4115	14.43	14.276	14.37	42188840.0
2022-09-12 15:00:00	NVDA	Stock	14.371	14.506	14.356	14.505	60896970.0
2022-09-12 16:00:00	NVDA	Stock	14.505	14.535	14.483	14.53	19978130.0
2022-09-12 17:00:00	NVDA	Stock	14.521	14.54	14.52	14.531	223220.0
2022-09-12 18:00:00	NVDA	Stock	14.537	14.549	14.525	14.538	131530.0
2022-09-12 19:00:00	NVDA	Stock	14.53	14.585	14.526	14.585	323800.0
2022-09-12 04:00:00	AMZN	Stock	133.72	134.48	133.56	134.19	9899.0
2022-09-12 05:00:00	AMZN	Stock	134.17	134.3	133.99	134.09	9362.0

> showing 50 of 62,558 rows — these rows as CSV

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