PREVIEW / stock_1hour / 2022-05-25

all stock 1-hour files

  file:    by_date/stock_1hour/2022/2022-05-25.parquet
  size:    1.4 MB
  rows:    61,422
  symbols: 2,342

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-05-25 04:00:00	AAPL	Stock	141.19	141.19	140.01	140.4	30403.0
2022-05-25 05:00:00	AAPL	Stock	140.36	140.5	139.7	140.45	31153.0
2022-05-25 06:00:00	AAPL	Stock	140.4	140.55	139.61	139.65	65423.0
2022-05-25 07:00:00	AAPL	Stock	139.65	139.85	138.67	138.89	272998.0
2022-05-25 08:00:00	AAPL	Stock	139.7945	142.13	138.08	138.68	1060983.0
2022-05-25 09:00:00	AAPL	Stock	138.7	140.34	138.11	139.33	9727130.0
2022-05-25 10:00:00	AAPL	Stock	139.33	141.38	138.95	140.19	12560332.0
2022-05-25 11:00:00	AAPL	Stock	140.19	140.63	139.45	139.9184	7431491.0
2022-05-25 12:00:00	AAPL	Stock	139.92	140.185	138.8414	139.44	6561967.0
2022-05-25 13:00:00	AAPL	Stock	139.435	139.76	138.5008	139.45	6943880.0
2022-05-25 14:00:00	AAPL	Stock	139.4699	141.19	138.5534	141.09	12961161.0
2022-05-25 15:00:00	AAPL	Stock	141.1	141.785	139.93	140.7011	14405507.0
2022-05-25 16:00:00	AAPL	Stock	140.71	140.71	138.68	139.7741	7597646.0
2022-05-25 17:00:00	AAPL	Stock	139.84	140.52	139.6094	139.78	42573.0
2022-05-25 18:00:00	AAPL	Stock	139.78	140.4	139.78	140.02	60763.0
2022-05-25 19:00:00	AAPL	Stock	140.06	140.25	139.85	139.93	44354.0
2022-05-25 04:00:00	MSFT	Stock	260.4	260.4	259.4	259.85	2484.0
2022-05-25 05:00:00	MSFT	Stock	259.1	259.65	258.8	259.65	4052.0
2022-05-25 06:00:00	MSFT	Stock	259.71	259.87	259.39	259.39	1962.0
2022-05-25 07:00:00	MSFT	Stock	259.44	259.91	257.8	258.4	25842.0
2022-05-25 08:00:00	MSFT	Stock	259.1173	259.99	257.8	258.66	74591.0
2022-05-25 09:00:00	MSFT	Stock	258.66	261.3498	257.54	259.26	2315087.0
2022-05-25 10:00:00	MSFT	Stock	259.25	260.88	257.125	259.6483	2831353.0
2022-05-25 11:00:00	MSFT	Stock	259.66	260.1	258.11	259.48	1980071.0
2022-05-25 12:00:00	MSFT	Stock	259.485	260.19	258.555	259.8	1904510.0
2022-05-25 13:00:00	MSFT	Stock	259.75	260.62	258.68	260.29	1285403.0
2022-05-25 14:00:00	MSFT	Stock	260.33	264.18	258.76	263.73	3597123.0
2022-05-25 15:00:00	MSFT	Stock	263.72	264.58	261.39	262.66	3354538.0
2022-05-25 16:00:00	MSFT	Stock	262.52	262.6938	259.86	261.5	3490787.0
2022-05-25 17:00:00	MSFT	Stock	261.62	261.9344	260.8801	261.7162	9357.0
2022-05-25 18:00:00	MSFT	Stock	261.69	262.75	261.69	262.39	18012.0
2022-05-25 19:00:00	MSFT	Stock	262.39	262.5	261.77	262.05	5863.0
2022-05-25 04:00:00	NVDA	Stock	16.287	16.324	16.123	16.18	169810.0
2022-05-25 05:00:00	NVDA	Stock	16.18	16.197	16.075	16.189	93540.0
2022-05-25 06:00:00	NVDA	Stock	16.149	16.2	16.09	16.11	65130.0
2022-05-25 07:00:00	NVDA	Stock	16.123	16.188	15.911	15.96	975640.0
2022-05-25 08:00:00	NVDA	Stock	16.365	16.365	15.905	15.99	1821330.0
2022-05-25 09:00:00	NVDA	Stock	15.98	16.7	15.96	16.429	88902740.0
2022-05-25 10:00:00	NVDA	Stock	16.4245	16.755	16.325	16.533	91686230.0
2022-05-25 11:00:00	NVDA	Stock	16.53	16.7	16.421	16.652	67727060.0
2022-05-25 12:00:00	NVDA	Stock	16.655	16.788	16.57	16.6907	64311640.0
2022-05-25 13:00:00	NVDA	Stock	16.6893	16.78	16.585	16.723	42754820.0
2022-05-25 14:00:00	NVDA	Stock	16.7265	16.964	16.522	16.93	86345530.0
2022-05-25 15:00:00	NVDA	Stock	16.93	17.111	16.771	16.9835	103246240.0
2022-05-25 16:00:00	NVDA	Stock	16.975	17.12	15.22	15.829	66364760.0
2022-05-25 17:00:00	NVDA	Stock	15.84	16.0	15.3	15.85	18237960.0
2022-05-25 18:00:00	NVDA	Stock	15.883	15.948	15.833	15.948	3414750.0
2022-05-25 19:00:00	NVDA	Stock	15.946	15.954	15.77	15.812	3153910.0
2022-05-25 05:00:00	AMZN	Stock	104.025	104.025	104.025	104.025	2000.0
2022-05-25 06:00:00	AMZN	Stock	103.843	103.95	103.843	103.95	4000.0

> showing 50 of 61,422 rows — these rows as CSV

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