PREVIEW / stock_1hour / 2022-08-22

all stock 1-hour files

  file:    by_date/stock_1hour/2022/2022-08-22.parquet
  size:    1.4 MB
  rows:    63,435
  symbols: 2,207

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-08-22 04:00:00	AAPL	Stock	170.29	170.29	168.64	168.74	117516.0
2022-08-22 05:00:00	AAPL	Stock	168.8	168.9	168.53	168.68	43429.0
2022-08-22 06:00:00	AAPL	Stock	168.79	169.04	168.66	168.88	44040.0
2022-08-22 07:00:00	AAPL	Stock	168.9	169.3	168.86	169.15	201526.0
2022-08-22 08:00:00	AAPL	Stock	168.9499	171.092	168.5312	168.72	372275.0
2022-08-22 09:00:00	AAPL	Stock	168.74	169.86	168.4826	168.95	9106640.0
2022-08-22 10:00:00	AAPL	Stock	168.96	169.31	168.06	168.075	7182930.0
2022-08-22 11:00:00	AAPL	Stock	168.07	168.9	168.01	168.77	5664431.0
2022-08-22 12:00:00	AAPL	Stock	168.765	169.05	168.58	168.93	4157540.0
2022-08-22 13:00:00	AAPL	Stock	168.925	168.98	168.15	168.2	4289631.0
2022-08-22 14:00:00	AAPL	Stock	168.2	168.35	167.4	167.615	6022467.0
2022-08-22 15:00:00	AAPL	Stock	167.61	167.93	167.135	167.59	11394995.0
2022-08-22 16:00:00	AAPL	Stock	167.59	167.85	167.51	167.69	8100774.0
2022-08-22 17:00:00	AAPL	Stock	167.68	167.78	167.68	167.7692	38169.0
2022-08-22 18:00:00	AAPL	Stock	167.77	167.81	167.6	167.81	31610.0
2022-08-22 19:00:00	AAPL	Stock	167.75	167.99	167.75	167.98	31045.0
2022-08-22 04:00:00	MSFT	Stock	283.49	283.49	281.01	282.0	18071.0
2022-08-22 05:00:00	MSFT	Stock	281.77	282.0	281.36	281.74	2446.0
2022-08-22 06:00:00	MSFT	Stock	281.78	282.39	281.74	281.88	3455.0
2022-08-22 07:00:00	MSFT	Stock	282.0	282.19	281.5	281.7	12752.0
2022-08-22 08:00:00	MSFT	Stock	281.9822	285.435	280.729	281.22	52977.0
2022-08-22 09:00:00	MSFT	Stock	281.02	282.46	278.98	279.95	2215059.0
2022-08-22 10:00:00	MSFT	Stock	279.93	280.45	278.22	278.24	2106074.0
2022-08-22 11:00:00	MSFT	Stock	278.25	279.36	277.79	279.18	1440752.0
2022-08-22 12:00:00	MSFT	Stock	279.145	279.35	278.6034	278.9981	841051.0
2022-08-22 13:00:00	MSFT	Stock	279.02	279.05	278.08	278.23	842338.0
2022-08-22 14:00:00	MSFT	Stock	278.24	278.52	277.34	277.72	1064657.0
2022-08-22 15:00:00	MSFT	Stock	277.68	278.39	277.22	277.86	3626133.0
2022-08-22 16:00:00	MSFT	Stock	277.86	278.12	277.6	277.9999	4232875.0
2022-08-22 17:00:00	MSFT	Stock	278.0	278.0	277.91	277.9999	3969.0
2022-08-22 18:00:00	MSFT	Stock	278.0	278.39	277.7	278.2	7946.0
2022-08-22 19:00:00	MSFT	Stock	278.36	278.75	278.3	278.42	1684.0
2022-08-22 04:00:00	NVDA	Stock	17.6	17.6	17.33	17.37	186040.0
2022-08-22 05:00:00	NVDA	Stock	17.363	17.38	17.31	17.35	57950.0
2022-08-22 06:00:00	NVDA	Stock	17.359	17.399	17.315	17.36	178260.0
2022-08-22 07:00:00	NVDA	Stock	17.375	17.47	17.375	17.44	435270.0
2022-08-22 08:00:00	NVDA	Stock	17.386	17.8044	17.3759	17.42	790210.0
2022-08-22 09:00:00	NVDA	Stock	17.42	17.558	17.2515	17.423	53861600.0
2022-08-22 10:00:00	NVDA	Stock	17.4238	17.4238	17.178	17.185	58807460.0
2022-08-22 11:00:00	NVDA	Stock	17.185	17.313	17.151	17.3023	35619950.0
2022-08-22 12:00:00	NVDA	Stock	17.305	17.337	17.202	17.2281	26262370.0
2022-08-22 13:00:00	NVDA	Stock	17.228	17.237	17.071	17.106	34244760.0
2022-08-22 14:00:00	NVDA	Stock	17.105	17.12	17.0335	17.085	33217280.0
2022-08-22 15:00:00	NVDA	Stock	17.086	17.119	16.966	17.036	62088750.0
2022-08-22 16:00:00	NVDA	Stock	17.034	17.068	17.02	17.045	29797970.0
2022-08-22 17:00:00	NVDA	Stock	17.045	17.049	17.03	17.038	104610.0
2022-08-22 18:00:00	NVDA	Stock	17.039	17.06	17.012	17.057	151930.0
2022-08-22 19:00:00	NVDA	Stock	17.048	17.075	17.038	17.05	209850.0
2022-08-22 04:00:00	AMZN	Stock	136.95	136.95	135.01	135.25	31289.0
2022-08-22 05:00:00	AMZN	Stock	135.25	135.33	135.03	135.32	23077.0

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

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