PREVIEW / stock_1hour / 2021-12-22

all stock 1-hour files

  file:    by_date/stock_1hour/2021/2021-12-22.parquet
  size:    1.4 MB
  rows:    64,478
  symbols: 2,654

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-12-22 04:00:00	AAPL	Stock	172.29	172.48	171.91	172.09	14392.0
2021-12-22 05:00:00	AAPL	Stock	172.09	172.79	172.0	172.79	12576.0
2021-12-22 06:00:00	AAPL	Stock	172.79	173.1	172.52	172.94	19828.0
2021-12-22 07:00:00	AAPL	Stock	172.9	173.07	172.5	172.56	110658.0
2021-12-22 08:00:00	AAPL	Stock	172.56	173.0	172.22	172.8	321429.0
2021-12-22 09:00:00	AAPL	Stock	172.8	174.04	172.15	173.72	10724438.0
2021-12-22 10:00:00	AAPL	Stock	173.73	174.525	172.89	174.48	13445680.0
2021-12-22 11:00:00	AAPL	Stock	174.47	174.4967	173.56	174.12	8160387.0
2021-12-22 12:00:00	AAPL	Stock	174.13	174.61	174.0	174.5268	6968192.0
2021-12-22 13:00:00	AAPL	Stock	174.51	174.75	173.77	174.1099	6082131.0
2021-12-22 14:00:00	AAPL	Stock	174.11	174.59	173.48	174.52	7383177.0
2021-12-22 15:00:00	AAPL	Stock	174.52	175.86	174.36	175.63	13229242.0
2021-12-22 16:00:00	AAPL	Stock	175.63	175.95	175.58	175.81	7666242.0
2021-12-22 17:00:00	AAPL	Stock	175.78	175.84	175.65	175.81	41712.0
2021-12-22 18:00:00	AAPL	Stock	175.84	175.85	175.71	175.82	42349.0
2021-12-22 19:00:00	AAPL	Stock	175.84	176.0	175.75	175.98	77553.0
2021-12-22 04:00:00	MSFT	Stock	326.75	326.75	326.2	326.2	2565.0
2021-12-22 05:00:00	MSFT	Stock	326.32	326.7	326.11	326.7	675.0
2021-12-22 06:00:00	MSFT	Stock	327.13	328.23	327.13	328.22	6837.0
2021-12-22 07:00:00	MSFT	Stock	328.25	328.25	326.82	326.82	14138.0
2021-12-22 08:00:00	MSFT	Stock	328.0	328.2499	326.22	326.97	26710.0
2021-12-22 09:00:00	MSFT	Stock	326.98	329.46	325.75	328.17	2207385.0
2021-12-22 10:00:00	MSFT	Stock	328.16	331.14	327.14	330.9037	3098790.0
2021-12-22 11:00:00	MSFT	Stock	330.93	331.48	327.72	331.24	2015332.0
2021-12-22 12:00:00	MSFT	Stock	331.28	331.56	330.44	331.2	1449631.0
2021-12-22 13:00:00	MSFT	Stock	331.185	331.21	330.02	330.71	1131128.0
2021-12-22 14:00:00	MSFT	Stock	330.7	331.54	330.23	331.44	1368631.0
2021-12-22 15:00:00	MSFT	Stock	331.43	333.605	331.285	333.27	3301635.0
2021-12-22 16:00:00	MSFT	Stock	333.2	333.8	333.2	333.62	3719934.0
2021-12-22 17:00:00	MSFT	Stock	333.8	333.8	333.3	333.75	8140.0
2021-12-22 18:00:00	MSFT	Stock	333.75	333.96	333.45	333.9	5078.0
2021-12-22 19:00:00	MSFT	Stock	333.85	333.85	333.46	333.75	5518.0
2021-12-22 04:00:00	NVDA	Stock	28.9	28.945	28.738	28.76	188380.0
2021-12-22 05:00:00	NVDA	Stock	28.801	28.97	28.8	28.967	78010.0
2021-12-22 06:00:00	NVDA	Stock	28.953	29.024	28.928	29.015	114670.0
2021-12-22 07:00:00	NVDA	Stock	29.001	29.199	28.99	29.05	851320.0
2021-12-22 08:00:00	NVDA	Stock	29.1331	29.199	28.731	28.844	1906690.0
2021-12-22 09:00:00	NVDA	Stock	28.837	29.225	28.449	28.934	48570270.0
2021-12-22 10:00:00	NVDA	Stock	28.928	29.15	28.647	29.0865	46462460.0
2021-12-22 11:00:00	NVDA	Stock	29.091	29.555	28.904	29.456	56260420.0
2021-12-22 12:00:00	NVDA	Stock	29.456	29.5149	29.138	29.3012	31979420.0
2021-12-22 13:00:00	NVDA	Stock	29.303	29.352	28.928	29.0695	24655990.0
2021-12-22 14:00:00	NVDA	Stock	29.068	29.333	28.922	29.285	24389020.0
2021-12-22 15:00:00	NVDA	Stock	29.29	29.425	29.136	29.388	40919660.0
2021-12-22 16:00:00	NVDA	Stock	29.4	29.47	29.375	29.41	14420290.0
2021-12-22 17:00:00	NVDA	Stock	29.412	29.45	29.38	29.415	160910.0
2021-12-22 18:00:00	NVDA	Stock	29.419	29.429	29.381	29.4	240300.0
2021-12-22 19:00:00	NVDA	Stock	29.415	29.435	29.368	29.419	368740.0
2021-12-22 06:00:00	AMZN	Stock	170.05	170.1875	170.05	170.1875	4000.0
2021-12-22 07:00:00	AMZN	Stock	170.3065	170.417	170.25	170.2505	13900.0

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

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