PREVIEW / stock_1hour / 2022-06-24

all stock 1-hour files

  file:    by_date/stock_1hour/2022/2022-06-24.parquet
  size:    1.4 MB
  rows:    63,151
  symbols: 2,271

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-06-24 04:00:00	AAPL	Stock	139.01	139.85	139.01	139.7	42705.0
2022-06-24 05:00:00	AAPL	Stock	139.69	140.0	139.57	139.88	18989.0
2022-06-24 06:00:00	AAPL	Stock	139.91	139.91	139.54	139.55	24349.0
2022-06-24 07:00:00	AAPL	Stock	139.51	139.8	139.05	139.5	94386.0
2022-06-24 08:00:00	AAPL	Stock	139.5	139.79	139.25	139.67	333022.0
2022-06-24 09:00:00	AAPL	Stock	139.64	141.07	139.64	139.9892	10450232.0
2022-06-24 10:00:00	AAPL	Stock	139.99	141.48	139.99	140.315	10148369.0
2022-06-24 11:00:00	AAPL	Stock	140.3	140.5	139.77	140.24	5691405.0
2022-06-24 12:00:00	AAPL	Stock	140.2418	140.4	139.83	140.12	4041096.0
2022-06-24 13:00:00	AAPL	Stock	140.13	140.27	139.81	139.92	4028010.0
2022-06-24 14:00:00	AAPL	Stock	139.915	140.48	139.85	140.445	4372216.0
2022-06-24 15:00:00	AAPL	Stock	140.445	141.91	140.04	141.81	13325114.0
2022-06-24 16:00:00	AAPL	Stock	141.82	141.89	141.36	141.66	23748540.0
2022-06-24 17:00:00	AAPL	Stock	141.58	141.65	141.45	141.52	74931.0
2022-06-24 18:00:00	AAPL	Stock	141.52	141.66	141.52	141.64	35329.0
2022-06-24 19:00:00	AAPL	Stock	141.65	141.75	141.61	141.75	30333.0
2022-06-24 04:00:00	MSFT	Stock	259.8	262.0	259.01	262.0	5584.0
2022-06-24 05:00:00	MSFT	Stock	262.2	262.2	261.55	262.0	3682.0
2022-06-24 06:00:00	MSFT	Stock	262.0	262.29	261.99	262.18	5011.0
2022-06-24 07:00:00	MSFT	Stock	261.7	262.01	261.2	261.61	15482.0
2022-06-24 08:00:00	MSFT	Stock	261.5	262.1785	260.0	261.3	39638.0
2022-06-24 09:00:00	MSFT	Stock	261.3	266.64	261.3	264.215	3254781.0
2022-06-24 10:00:00	MSFT	Stock	264.39	266.75	264.06	264.86	2857787.0
2022-06-24 11:00:00	MSFT	Stock	264.87	265.66	263.45	264.3384	1800686.0
2022-06-24 12:00:00	MSFT	Stock	264.34	264.7054	263.41	264.25	1023492.0
2022-06-24 13:00:00	MSFT	Stock	264.265	264.4306	263.64	263.95	1204420.0
2022-06-24 14:00:00	MSFT	Stock	263.97	265.17	263.6901	265.0418	1229697.0
2022-06-24 15:00:00	MSFT	Stock	265.044	267.98	264.661	267.98	4045723.0
2022-06-24 16:00:00	MSFT	Stock	267.93	267.93	267.1008	267.92	10539543.0
2022-06-24 17:00:00	MSFT	Stock	267.71	267.71	267.51	267.6	44819.0
2022-06-24 18:00:00	MSFT	Stock	267.6	267.87	267.55	267.75	5407.0
2022-06-24 19:00:00	MSFT	Stock	267.75	268.5	267.75	268.2	8786.0
2022-06-24 04:00:00	NVDA	Stock	16.301	16.502	16.301	16.478	180120.0
2022-06-24 05:00:00	NVDA	Stock	16.452	16.489	16.451	16.478	63130.0
2022-06-24 06:00:00	NVDA	Stock	16.486	16.51	16.474	16.474	112740.0
2022-06-24 07:00:00	NVDA	Stock	16.485	16.49	16.412	16.42	488780.0
2022-06-24 08:00:00	NVDA	Stock	16.487	16.587	16.1845	16.43	775640.0
2022-06-24 09:00:00	NVDA	Stock	16.435	16.704	16.31	16.597	69319140.0
2022-06-24 10:00:00	NVDA	Stock	16.595	17.066	16.595	16.967	90232510.0
2022-06-24 11:00:00	NVDA	Stock	16.963	17.0244	16.768	16.839	49344080.0
2022-06-24 12:00:00	NVDA	Stock	16.839	16.919	16.823	16.91	25639310.0
2022-06-24 13:00:00	NVDA	Stock	16.91	16.931	16.802	16.828	22712800.0
2022-06-24 14:00:00	NVDA	Stock	16.828	16.957	16.807	16.942	25278700.0
2022-06-24 15:00:00	NVDA	Stock	16.943	17.14	16.867	17.1375	60143770.0
2022-06-24 16:00:00	NVDA	Stock	17.139	17.15	17.068	17.126	38304340.0
2022-06-24 17:00:00	NVDA	Stock	17.135	17.135	17.091	17.111	202730.0
2022-06-24 18:00:00	NVDA	Stock	17.11	17.12	17.101	17.12	146290.0
2022-06-24 19:00:00	NVDA	Stock	17.12	17.15	17.12	17.15	232430.0
2022-06-24 04:00:00	AMZN	Stock	113.01	113.63	112.57	113.26	44145.0
2022-06-24 05:00:00	AMZN	Stock	113.14	113.4	113.1	113.37	19444.0

> showing 50 of 63,151 rows — these rows as CSV

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