PREVIEW / stock_1hour / 2022-03-29

all stock 1-hour files

  file:    by_date/stock_1hour/2022/2022-03-29.parquet
  size:    1.5 MB
  rows:    66,278
  symbols: 2,546

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-03-29 04:00:00	AAPL	Stock	175.79	176.09	175.72	175.78	27243.0
2022-03-29 05:00:00	AAPL	Stock	175.8	176.4	175.62	175.97	49356.0
2022-03-29 06:00:00	AAPL	Stock	175.97	176.05	175.6	175.9	13034.0
2022-03-29 07:00:00	AAPL	Stock	175.9	176.56	175.63	176.36	173821.0
2022-03-29 08:00:00	AAPL	Stock	176.1501	176.95	174.49	176.87	591922.0
2022-03-29 09:00:00	AAPL	Stock	176.85	178.13	176.34	177.585	12850592.0
2022-03-29 10:00:00	AAPL	Stock	177.6	178.0	176.35	177.2	12946140.0
2022-03-29 11:00:00	AAPL	Stock	177.2	177.89	176.995	177.48	7528149.0
2022-03-29 12:00:00	AAPL	Stock	177.488	177.51	176.72	177.185	6277935.0
2022-03-29 13:00:00	AAPL	Stock	177.185	178.095	176.81	178.085	6846879.0
2022-03-29 14:00:00	AAPL	Stock	178.08	178.39	177.48	178.34	7972012.0
2022-03-29 15:00:00	AAPL	Stock	178.3401	179.01	178.28	179.0	16118091.0
2022-03-29 16:00:00	AAPL	Stock	178.97	178.99	178.53	178.68	12274900.0
2022-03-29 17:00:00	AAPL	Stock	178.68	178.78	178.65	178.75	36101.0
2022-03-29 18:00:00	AAPL	Stock	178.76	178.76	178.5	178.63	35162.0
2022-03-29 19:00:00	AAPL	Stock	178.63	178.75	178.56	178.75	48412.0
2022-03-29 04:00:00	MSFT	Stock	311.25	311.8	311.25	311.6	4179.0
2022-03-29 05:00:00	MSFT	Stock	311.81	312.54	311.76	312.05	4650.0
2022-03-29 06:00:00	MSFT	Stock	312.05	312.35	311.5	312.0	3062.0
2022-03-29 07:00:00	MSFT	Stock	312.19	312.7	311.1	311.95	26671.0
2022-03-29 08:00:00	MSFT	Stock	311.8808	314.5	309.42	313.57	104439.0
2022-03-29 09:00:00	MSFT	Stock	313.45	314.4	311.31	312.725	3108647.0
2022-03-29 10:00:00	MSFT	Stock	312.725	313.23	309.05	310.89	3227751.0
2022-03-29 11:00:00	MSFT	Stock	310.9	312.65	310.82	312.155	2336742.0
2022-03-29 12:00:00	MSFT	Stock	312.17	312.62	311.21	312.405	1468446.0
2022-03-29 13:00:00	MSFT	Stock	312.4298	313.47	311.77	313.4	1376688.0
2022-03-29 14:00:00	MSFT	Stock	313.39	314.8	313.02	314.415	1854918.0
2022-03-29 15:00:00	MSFT	Stock	314.42	315.82	314.1401	315.42	4208024.0
2022-03-29 16:00:00	MSFT	Stock	315.41	316.0	314.78	315.41	4977667.0
2022-03-29 17:00:00	MSFT	Stock	315.45	315.45	315.15	315.2	7242.0
2022-03-29 18:00:00	MSFT	Stock	315.33	315.33	314.63	315.0	6607.0
2022-03-29 19:00:00	MSFT	Stock	314.86	315.33	314.86	315.04	5372.0
2022-03-29 04:00:00	NVDA	Stock	28.24	28.505	28.24	28.316	469800.0
2022-03-29 05:00:00	NVDA	Stock	28.299	28.483	28.299	28.41	147710.0
2022-03-29 06:00:00	NVDA	Stock	28.405	28.424	28.3	28.34	66760.0
2022-03-29 07:00:00	NVDA	Stock	28.324	28.838	28.324	28.775	1786060.0
2022-03-29 08:00:00	NVDA	Stock	28.4	29.143	28.066	29.003	4628550.0
2022-03-29 09:00:00	NVDA	Stock	28.98	29.094	28.133	28.441	70845680.0
2022-03-29 10:00:00	NVDA	Stock	28.4425	28.597	27.98	28.5225	73713030.0
2022-03-29 11:00:00	NVDA	Stock	28.53	28.554	28.123	28.317	36727780.0
2022-03-29 12:00:00	NVDA	Stock	28.3169	28.395	28.11	28.293	29600030.0
2022-03-29 13:00:00	NVDA	Stock	28.299	28.515	28.157	28.493	29542160.0
2022-03-29 14:00:00	NVDA	Stock	28.5	28.583	28.33	28.569	34607570.0
2022-03-29 15:00:00	NVDA	Stock	28.573	28.758	28.486	28.659	55943340.0
2022-03-29 16:00:00	NVDA	Stock	28.658	28.723	28.552	28.58	22844500.0
2022-03-29 17:00:00	NVDA	Stock	28.58	28.607	28.55	28.577	308700.0
2022-03-29 18:00:00	NVDA	Stock	28.595	28.595	28.525	28.57	230690.0
2022-03-29 19:00:00	NVDA	Stock	28.57	28.58	28.5	28.51	337250.0
2022-03-29 06:00:00	AMZN	Stock	168.95	168.95	168.95	168.95	2360.0
2022-03-29 07:00:00	AMZN	Stock	168.9	169.9	168.9	169.9	119960.0

> showing 50 of 66,278 rows — these rows as CSV

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