PREVIEW / stock_1hour / 2023-04-05

all stock 1-hour files

  file:    by_date/stock_1hour/2023/2023-04-05.parquet
  size:    1.3 MB
  rows:    58,969
  symbols: 1,703

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-04-05 04:00:00	AAPL	Stock	165.68	165.68	165.1	165.34	13017.0
2023-04-05 05:00:00	AAPL	Stock	165.29	165.35	165.17	165.2	16833.0
2023-04-05 06:00:00	AAPL	Stock	165.25	165.39	165.22	165.38	15904.0
2023-04-05 07:00:00	AAPL	Stock	165.32	165.79	165.3	165.6	59646.0
2023-04-05 08:00:00	AAPL	Stock	165.46	165.8	165.06	165.18	175711.0
2023-04-05 09:00:00	AAPL	Stock	165.18	165.2999	164.21	164.6201	5720674.0
2023-04-05 10:00:00	AAPL	Stock	164.65	164.92	163.2699	163.29	6566443.0
2023-04-05 11:00:00	AAPL	Stock	163.28	163.77	162.68	162.9601	5224331.0
2023-04-05 12:00:00	AAPL	Stock	162.98	163.0	161.8	162.33	5816892.0
2023-04-05 13:00:00	AAPL	Stock	162.33	163.095	162.26	162.945	4311605.0
2023-04-05 14:00:00	AAPL	Stock	162.95	163.305	162.65	163.2388	3631008.0
2023-04-05 15:00:00	AAPL	Stock	163.24	163.95	162.93	163.76	7389063.0
2023-04-05 16:00:00	AAPL	Stock	163.76	163.86	163.2983	163.65	5684746.0
2023-04-05 17:00:00	AAPL	Stock	163.63	163.76	163.32	163.6	61636.0
2023-04-05 18:00:00	AAPL	Stock	163.5	163.5899	163.35	163.47	20818.0
2023-04-05 19:00:00	AAPL	Stock	163.46	163.61	163.03	163.55	26934.0
2023-04-05 04:00:00	MSFT	Stock	287.55	287.87	286.65	286.65	4010.0
2023-04-05 05:00:00	MSFT	Stock	286.5	286.99	286.49	286.88	1776.0
2023-04-05 06:00:00	MSFT	Stock	286.98	287.18	286.72	287.18	3820.0
2023-04-05 07:00:00	MSFT	Stock	287.16	287.2	286.4	286.85	15329.0
2023-04-05 08:00:00	MSFT	Stock	286.36	287.35	286.2	286.54	30020.0
2023-04-05 09:00:00	MSFT	Stock	286.68	287.15	284.82	285.7	2481953.0
2023-04-05 10:00:00	MSFT	Stock	285.7	286.3	283.31	283.58	2671733.0
2023-04-05 11:00:00	MSFT	Stock	283.55	284.33	283.33	284.18	2188607.0
2023-04-05 12:00:00	MSFT	Stock	284.18	284.28	282.95	283.47	1615914.0
2023-04-05 13:00:00	MSFT	Stock	283.45	283.96	282.92	283.9	1369735.0
2023-04-05 14:00:00	MSFT	Stock	283.9	284.58	283.76	284.19	1326511.0
2023-04-05 15:00:00	MSFT	Stock	284.19	284.77	283.67	284.34	2643286.0
2023-04-05 16:00:00	MSFT	Stock	284.34	284.39	284.03	284.13	2856195.0
2023-04-05 17:00:00	MSFT	Stock	284.1876	284.2	283.93	283.93	4036.0
2023-04-05 18:00:00	MSFT	Stock	284.0	284.19	284.0	284.19	15761.0
2023-04-05 19:00:00	MSFT	Stock	284.16	284.3	284.13	284.25	20842.0
2023-04-05 04:00:00	NVDA	Stock	27.342	27.35	27.083	27.135	408380.0
2023-04-05 05:00:00	NVDA	Stock	27.129	27.155	27.108	27.11	207750.0
2023-04-05 06:00:00	NVDA	Stock	27.11	27.11	27.02	27.06	328130.0
2023-04-05 07:00:00	NVDA	Stock	27.05	27.083	26.85	26.886	2474780.0
2023-04-05 08:00:00	NVDA	Stock	26.965	27.4	26.86	26.942	3172040.0
2023-04-05 09:00:00	NVDA	Stock	26.945	26.998	26.628	26.769	64871860.0
2023-04-05 10:00:00	NVDA	Stock	26.773	26.855	26.434	26.461	85197830.0
2023-04-05 11:00:00	NVDA	Stock	26.4645	26.716	26.395	26.668	52250960.0
2023-04-05 12:00:00	NVDA	Stock	26.671	26.683	26.4516	26.516	36706190.0
2023-04-05 13:00:00	NVDA	Stock	26.519	26.67	26.457	26.628	31847190.0
2023-04-05 14:00:00	NVDA	Stock	26.63	26.81	26.612	26.7505	39000880.0
2023-04-05 15:00:00	NVDA	Stock	26.749	26.9114	26.59	26.881	56761250.0
2023-04-05 16:00:00	NVDA	Stock	26.881	26.888	26.847	26.874	20871560.0
2023-04-05 17:00:00	NVDA	Stock	26.874	26.874	26.801	26.81	330280.0
2023-04-05 18:00:00	NVDA	Stock	26.805	26.881	26.77	26.8	157760.0
2023-04-05 19:00:00	NVDA	Stock	26.801	26.81	26.645	26.72	598770.0
2023-04-05 04:00:00	AMZN	Stock	104.18	104.18	103.53	103.8	3517.0
2023-04-05 05:00:00	AMZN	Stock	103.74	103.82	103.65	103.78	6637.0

> showing 50 of 58,969 rows — these rows as CSV

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