PREVIEW / stock_1hour / 2022-10-25

all stock 1-hour files

  file:    by_date/stock_1hour/2022/2022-10-25.parquet
  size:    1.4 MB
  rows:    61,468
  symbols: 2,164

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-10-25 04:00:00	AAPL	Stock	149.5	150.17	149.5	149.8	24044.0
2022-10-25 05:00:00	AAPL	Stock	149.81	149.81	149.31	149.61	12496.0
2022-10-25 06:00:00	AAPL	Stock	149.53	149.53	148.9	149.2	69026.0
2022-10-25 07:00:00	AAPL	Stock	149.31	149.34	148.76	148.82	150506.0
2022-10-25 08:00:00	AAPL	Stock	148.8501	149.84	148.5	149.25	172349.0
2022-10-25 09:00:00	AAPL	Stock	149.21	151.43	149.21	151.3163	10921009.0
2022-10-25 10:00:00	AAPL	Stock	151.35	151.49	150.64	150.925	10366634.0
2022-10-25 11:00:00	AAPL	Stock	150.9201	151.88	150.8	151.675	7385855.0
2022-10-25 12:00:00	AAPL	Stock	151.685	151.875	151.47	151.555	5063037.0
2022-10-25 13:00:00	AAPL	Stock	151.555	151.75	151.15	151.44	5301673.0
2022-10-25 14:00:00	AAPL	Stock	151.43	152.22	151.41	151.78	5685480.0
2022-10-25 15:00:00	AAPL	Stock	151.79	152.49	151.78	152.39	10553677.0
2022-10-25 16:00:00	AAPL	Stock	152.38	152.5	150.2	151.17	9296581.0
2022-10-25 17:00:00	AAPL	Stock	151.17	152.34	150.35	150.5	254591.0
2022-10-25 18:00:00	AAPL	Stock	150.5	151.45	150.42	150.85	364638.0
2022-10-25 19:00:00	AAPL	Stock	150.82	150.95	150.4	150.9	130689.0
2022-10-25 04:00:00	MSFT	Stock	247.36	247.87	247.0	247.5	5587.0
2022-10-25 05:00:00	MSFT	Stock	247.49	247.49	246.7	246.7	3899.0
2022-10-25 06:00:00	MSFT	Stock	246.79	247.5	246.79	247.5	1622.0
2022-10-25 07:00:00	MSFT	Stock	247.7	248.09	247.3	247.51	31971.0
2022-10-25 08:00:00	MSFT	Stock	247.4467	248.1975	247.02	247.77	52059.0
2022-10-25 09:00:00	MSFT	Stock	247.8	249.79	245.83	249.465	3664813.0
2022-10-25 10:00:00	MSFT	Stock	249.49	249.7	247.74	248.59	2657602.0
2022-10-25 11:00:00	MSFT	Stock	248.63	250.0	248.32	249.75	2296384.0
2022-10-25 12:00:00	MSFT	Stock	249.78	249.9523	248.7814	248.88	1717288.0
2022-10-25 13:00:00	MSFT	Stock	248.87	249.41	248.16	249.12	1746258.0
2022-10-25 14:00:00	MSFT	Stock	249.12	250.11	249.045	249.532	2013161.0
2022-10-25 15:00:00	MSFT	Stock	249.53	251.04	249.35	250.76	4243650.0
2022-10-25 16:00:00	MSFT	Stock	251.0	252.7	242.0	246.08	5654123.0
2022-10-25 17:00:00	MSFT	Stock	246.13	246.48	237.06	238.08	1043865.0
2022-10-25 18:00:00	MSFT	Stock	238.11	238.86	230.39	234.11	1452696.0
2022-10-25 19:00:00	MSFT	Stock	234.05	234.32	233.22	234.0	255163.0
2022-10-25 04:00:00	NVDA	Stock	12.628	12.66	12.6	12.6	36130.0
2022-10-25 05:00:00	NVDA	Stock	12.568	12.58	12.563	12.58	9030.0
2022-10-25 06:00:00	NVDA	Stock	12.599	12.605	12.566	12.605	16050.0
2022-10-25 07:00:00	NVDA	Stock	12.596	12.62	12.58	12.583	43470.0
2022-10-25 08:00:00	NVDA	Stock	12.6006	12.6279	12.5518	12.587	571830.0
2022-10-25 09:00:00	NVDA	Stock	12.594	13.065	12.587	13.061	76614040.0
2022-10-25 10:00:00	NVDA	Stock	13.06	13.165	12.97	13.067	86258450.0
2022-10-25 11:00:00	NVDA	Stock	13.067	13.274	13.047	13.189	58649850.0
2022-10-25 12:00:00	NVDA	Stock	13.19	13.278	13.155	13.206	45330260.0
2022-10-25 13:00:00	NVDA	Stock	13.206	13.243	13.1345	13.154	40095010.0
2022-10-25 14:00:00	NVDA	Stock	13.1544	13.283	13.1474	13.232	39141350.0
2022-10-25 15:00:00	NVDA	Stock	13.232	13.3	13.219	13.261	55149250.0
2022-10-25 16:00:00	NVDA	Stock	13.261	13.275	12.927	13.009	24766860.0
2022-10-25 17:00:00	NVDA	Stock	13.011	13.02	12.94	12.949	567490.0
2022-10-25 18:00:00	NVDA	Stock	12.942	13.005	12.8	12.88	1836520.0
2022-10-25 19:00:00	NVDA	Stock	12.875	12.875	12.8151	12.85	1121180.0
2022-10-25 04:00:00	AMZN	Stock	119.53	119.66	118.49	119.0	19423.0
2022-10-25 05:00:00	AMZN	Stock	119.05	119.05	118.57	118.95	2231.0

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

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