PREVIEW / stock_1hour / 2023-02-10

all stock 1-hour files

  file:    by_date/stock_1hour/2023/2023-02-10.parquet
  size:    1.4 MB
  rows:    61,040
  symbols: 1,858

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-02-10 04:00:00	AAPL	Stock	150.4	150.75	149.34	149.34	32411.0
2023-02-10 05:00:00	AAPL	Stock	149.39	149.48	149.0	149.37	25123.0
2023-02-10 06:00:00	AAPL	Stock	149.25	149.25	148.7	148.73	32565.0
2023-02-10 07:00:00	AAPL	Stock	148.86	149.09	148.75	148.93	89355.0
2023-02-10 08:00:00	AAPL	Stock	148.8588	150.3	148.73	149.46	239210.0
2023-02-10 09:00:00	AAPL	Stock	149.44	150.56	149.1	149.93	6145839.0
2023-02-10 10:00:00	AAPL	Stock	149.935	151.3401	149.35	150.37	8119622.0
2023-02-10 11:00:00	AAPL	Stock	150.35	150.91	149.7	149.82	4223765.0
2023-02-10 12:00:00	AAPL	Stock	149.81	150.19	149.43	150.155	3855930.0
2023-02-10 13:00:00	AAPL	Stock	150.155	151.115	150.0699	150.46	4387204.0
2023-02-10 14:00:00	AAPL	Stock	150.465	150.6501	150.0101	150.65	3913888.0
2023-02-10 15:00:00	AAPL	Stock	150.66	151.155	150.29	151.02	7127897.0
2023-02-10 16:00:00	AAPL	Stock	151.01	151.05	150.91	150.92	6584991.0
2023-02-10 17:00:00	AAPL	Stock	150.93	151.01	150.91	150.99	42239.0
2023-02-10 18:00:00	AAPL	Stock	150.96	151.02	150.96	151.02	13629.0
2023-02-10 19:00:00	AAPL	Stock	151.0	151.26	150.97	151.26	20811.0
2023-02-10 04:00:00	MSFT	Stock	265.08	265.08	260.53	260.54	24211.0
2023-02-10 05:00:00	MSFT	Stock	260.62	261.07	259.86	260.37	54361.0
2023-02-10 06:00:00	MSFT	Stock	260.28	260.28	258.8	259.3	17915.0
2023-02-10 07:00:00	MSFT	Stock	259.68	260.54	259.55	260.36	29006.0
2023-02-10 08:00:00	MSFT	Stock	260.01	263.63	259.56	260.85	63867.0
2023-02-10 09:00:00	MSFT	Stock	260.85	263.3	260.55	262.2351	2580540.0
2023-02-10 10:00:00	MSFT	Stock	262.17	264.09	261.18	262.42	3175324.0
2023-02-10 11:00:00	MSFT	Stock	262.42	263.28	261.15	261.35	1706869.0
2023-02-10 12:00:00	MSFT	Stock	261.36	261.674	260.662	261.6699	1626478.0
2023-02-10 13:00:00	MSFT	Stock	261.68	262.779	261.22	261.73	1302583.0
2023-02-10 14:00:00	MSFT	Stock	261.74	262.22	261.06	261.875	1283527.0
2023-02-10 15:00:00	MSFT	Stock	261.89	263.53	261.352	263.1	2903755.0
2023-02-10 16:00:00	MSFT	Stock	263.1	263.44	262.95	263.3	3557844.0
2023-02-10 17:00:00	MSFT	Stock	263.3008	263.595	263.1	263.5	12548.0
2023-02-10 18:00:00	MSFT	Stock	263.45	264.36	263.4	264.12	16184.0
2023-02-10 19:00:00	MSFT	Stock	264.04	265.95	263.9	265.76	27994.0
2023-02-10 04:00:00	NVDA	Stock	22.226	22.285	21.766	21.766	406410.0
2023-02-10 05:00:00	NVDA	Stock	21.781	21.822	21.71	21.76	325830.0
2023-02-10 06:00:00	NVDA	Stock	21.768	21.77	21.621	21.7	302260.0
2023-02-10 07:00:00	NVDA	Stock	21.714	21.88	21.68	21.75	1232570.0
2023-02-10 08:00:00	NVDA	Stock	21.78	22.2	21.68	21.881	1792940.0
2023-02-10 09:00:00	NVDA	Stock	21.881	22.0776	21.519	21.637	71939760.0
2023-02-10 10:00:00	NVDA	Stock	21.65	21.731	21.279	21.329	81896720.0
2023-02-10 11:00:00	NVDA	Stock	21.328	21.409	21.008	21.02	59926050.0
2023-02-10 12:00:00	NVDA	Stock	21.019	21.135	20.811	21.131	60636310.0
2023-02-10 13:00:00	NVDA	Stock	21.133	21.363	21.027	21.037	57393400.0
2023-02-10 14:00:00	NVDA	Stock	21.0365	21.15	20.957	21.136	40768190.0
2023-02-10 15:00:00	NVDA	Stock	21.136	21.382	21.102	21.26	55753470.0
2023-02-10 16:00:00	NVDA	Stock	21.26	21.272	21.23	21.252	18010550.0
2023-02-10 17:00:00	NVDA	Stock	21.245	21.265	21.244	21.246	205520.0
2023-02-10 18:00:00	NVDA	Stock	21.254	21.287	21.254	21.27	202440.0
2023-02-10 19:00:00	NVDA	Stock	21.276	21.285	21.26	21.27	153920.0
2023-02-10 04:00:00	AMZN	Stock	98.53	98.53	97.45	97.47	28439.0
2023-02-10 05:00:00	AMZN	Stock	97.52	97.64	97.32	97.64	31004.0

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

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