PREVIEW / stock_1hour / 2023-07-20

all stock 1-hour files

  file:    by_date/stock_1hour/2023/2023-07-20.parquet
  size:    1.3 MB
  rows:    59,928
  symbols: 1,537

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
2023-07-20 04:00:00	AAPL	Stock	193.78	193.81	193.25	193.29	28555.0
2023-07-20 05:00:00	AAPL	Stock	193.47	193.8	193.34	193.55	2654.0
2023-07-20 06:00:00	AAPL	Stock	193.76	194.0	193.74	193.9	13374.0
2023-07-20 07:00:00	AAPL	Stock	193.9	194.38	193.65	194.3	47501.0
2023-07-20 08:00:00	AAPL	Stock	193.95	194.7	193.74	194.01	153618.0
2023-07-20 09:00:00	AAPL	Stock	194.0	196.47	193.81	195.7303	7183692.0
2023-07-20 10:00:00	AAPL	Stock	195.74	195.77	193.9501	194.45	8856270.0
2023-07-20 11:00:00	AAPL	Stock	194.445	195.14	194.21	194.93	4545617.0
2023-07-20 12:00:00	AAPL	Stock	194.94	195.5899	194.26	194.48	6734739.0
2023-07-20 13:00:00	AAPL	Stock	194.475	194.55	193.88	194.3099	3566666.0
2023-07-20 14:00:00	AAPL	Stock	194.3	194.36	193.1061	193.27	4020083.0
2023-07-20 15:00:00	AAPL	Stock	193.275	193.45	192.495	193.14	8795860.0
2023-07-20 16:00:00	AAPL	Stock	193.14	193.58	192.91	192.96	7168023.0
2023-07-20 17:00:00	AAPL	Stock	192.96	193.0393	192.6	192.92	92555.0
2023-07-20 18:00:00	AAPL	Stock	192.9	193.15	192.8	193.0	69604.0
2023-07-20 19:00:00	AAPL	Stock	193.04	193.09	192.6	192.99	65513.0
2023-07-20 04:00:00	MSFT	Stock	354.84	354.84	352.01	352.05	12300.0
2023-07-20 05:00:00	MSFT	Stock	352.05	352.93	352.05	352.53	3356.0
2023-07-20 06:00:00	MSFT	Stock	352.75	353.83	352.75	353.55	3859.0
2023-07-20 07:00:00	MSFT	Stock	353.99	356.25	353.4	356.1	32809.0
2023-07-20 08:00:00	MSFT	Stock	353.55	356.25	352.4514	354.33	60474.0
2023-07-20 09:00:00	MSFT	Stock	354.33	357.97	353.2	355.8407	2769559.0
2023-07-20 10:00:00	MSFT	Stock	355.819	356.18	348.53	350.24	4186372.0
2023-07-20 11:00:00	MSFT	Stock	350.23	351.59	349.452	349.54	2482837.0
2023-07-20 12:00:00	MSFT	Stock	349.54	350.59	347.73	347.98	2208233.0
2023-07-20 13:00:00	MSFT	Stock	347.99	349.0	347.74	348.42	1363715.0
2023-07-20 14:00:00	MSFT	Stock	348.38	348.51	345.84	345.91	2285228.0
2023-07-20 15:00:00	MSFT	Stock	345.8945	347.35	345.37	346.88	4106307.0
2023-07-20 16:00:00	MSFT	Stock	346.89	347.42	346.65	347.17	4637236.0
2023-07-20 17:00:00	MSFT	Stock	347.15	347.44	346.7342	347.1204	21828.0
2023-07-20 18:00:00	MSFT	Stock	347.2	347.39	346.45	346.74	39176.0
2023-07-20 19:00:00	MSFT	Stock	346.7	347.2	346.05	346.41	26326.0
2023-07-20 04:00:00	NVDA	Stock	46.5	46.68	46.449	46.58	172320.0
2023-07-20 05:00:00	NVDA	Stock	46.513	46.625	46.469	46.6	73730.0
2023-07-20 06:00:00	NVDA	Stock	46.63	46.83	46.603	46.644	290060.0
2023-07-20 07:00:00	NVDA	Stock	46.669	46.712	46.477	46.7	1034090.0
2023-07-20 08:00:00	NVDA	Stock	46.79	46.79	46.481	46.603	1577590.0
2023-07-20 09:00:00	NVDA	Stock	46.581	47.087	46.252	46.758	48405290.0
2023-07-20 10:00:00	NVDA	Stock	46.7655	46.787	45.3	45.917	95538570.0
2023-07-20 11:00:00	NVDA	Stock	45.9249	46.385	45.918	46.226	52081650.0
2023-07-20 12:00:00	NVDA	Stock	46.225	46.45	45.837	45.99	38917750.0
2023-07-20 13:00:00	NVDA	Stock	45.987	46.121	45.888	45.956	25967380.0
2023-07-20 14:00:00	NVDA	Stock	45.948	45.948	45.423	45.463	39148640.0
2023-07-20 15:00:00	NVDA	Stock	45.464	45.785	45.062	45.5161	75422100.0
2023-07-20 16:00:00	NVDA	Stock	45.521	45.554	45.423	45.46	23660120.0
2023-07-20 17:00:00	NVDA	Stock	45.455	45.4926	45.3	45.3845	440380.0
2023-07-20 18:00:00	NVDA	Stock	45.376	45.418	44.9306	44.933	1792850.0
2023-07-20 19:00:00	NVDA	Stock	44.994	45.159	44.994	45.1	984920.0
2023-07-20 04:00:00	AMZN	Stock	134.47	134.56	133.78	133.95	19833.0
2023-07-20 05:00:00	AMZN	Stock	133.91	134.38	133.91	134.38	4121.0

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

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