PREVIEW / stock_1hour / 2023-02-03

all stock 1-hour files

  file:    by_date/stock_1hour/2023/2023-02-03.parquet
  size:    1.4 MB
  rows:    62,784
  symbols: 1,903

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-03 04:00:00	AAPL	Stock	145.45	146.24	144.8	146.05	70211.0
2023-02-03 05:00:00	AAPL	Stock	146.01	146.2	145.65	145.78	27457.0
2023-02-03 06:00:00	AAPL	Stock	145.77	146.93	145.51	146.71	94094.0
2023-02-03 07:00:00	AAPL	Stock	146.71	149.0	146.63	148.4	781489.0
2023-02-03 08:00:00	AAPL	Stock	147.62	150.09	144.0	147.74	2317944.0
2023-02-03 09:00:00	AAPL	Stock	147.76	153.45	147.5	153.25	19612868.0
2023-02-03 10:00:00	AAPL	Stock	153.24	157.38	152.57	155.77	31686120.0
2023-02-03 11:00:00	AAPL	Stock	155.79	157.2	155.52	155.72	14244174.0
2023-02-03 12:00:00	AAPL	Stock	155.72	156.9899	154.44	154.5789	10729981.0
2023-02-03 13:00:00	AAPL	Stock	154.58	155.84	154.265	155.3464	11421232.0
2023-02-03 14:00:00	AAPL	Stock	155.35	155.69	154.4	154.68	8775212.0
2023-02-03 15:00:00	AAPL	Stock	154.68	155.325	154.09	154.5	13439828.0
2023-02-03 16:00:00	AAPL	Stock	154.495	154.77	154.11	154.435	13804581.0
2023-02-03 17:00:00	AAPL	Stock	154.43	154.5	154.03	154.2	124292.0
2023-02-03 18:00:00	AAPL	Stock	154.15	154.35	154.05	154.28	39433.0
2023-02-03 19:00:00	AAPL	Stock	154.29	154.39	154.25	154.39	28555.0
2023-02-03 04:00:00	MSFT	Stock	260.7	261.57	260.43	261.2	17171.0
2023-02-03 05:00:00	MSFT	Stock	261.2	261.35	261.0	261.23	4455.0
2023-02-03 06:00:00	MSFT	Stock	261.41	262.52	261.34	261.74	12629.0
2023-02-03 07:00:00	MSFT	Stock	262.0	262.55	261.47	262.49	34550.0
2023-02-03 08:00:00	MSFT	Stock	261.78	263.939	258.1	259.05	182985.0
2023-02-03 09:00:00	MSFT	Stock	259.2	264.6	258.0	261.82	2946608.0
2023-02-03 10:00:00	MSFT	Stock	261.72	264.2	260.6	261.805	3120073.0
2023-02-03 11:00:00	MSFT	Stock	261.8	263.79	261.21	261.41	1769800.0
2023-02-03 12:00:00	MSFT	Stock	261.42	262.8	260.16	260.43	1112459.0
2023-02-03 13:00:00	MSFT	Stock	260.41	260.4264	258.18	258.7	2275266.0
2023-02-03 14:00:00	MSFT	Stock	258.7	258.92	257.46	257.72	1888975.0
2023-02-03 15:00:00	MSFT	Stock	257.7	259.03	257.1	258.34	3811692.0
2023-02-03 16:00:00	MSFT	Stock	258.33	258.35	258.01	258.115	4631862.0
2023-02-03 17:00:00	MSFT	Stock	258.35	258.35	258.01	258.33	6718.0
2023-02-03 18:00:00	MSFT	Stock	258.24	258.3	258.11	258.22	4508.0
2023-02-03 19:00:00	MSFT	Stock	258.22	258.25	258.0	258.0001	5717.0
2023-02-03 04:00:00	NVDA	Stock	21.057	21.247	21.0	21.24	180760.0
2023-02-03 05:00:00	NVDA	Stock	21.249	21.25	21.178	21.2	30470.0
2023-02-03 06:00:00	NVDA	Stock	21.213	21.295	21.199	21.28	43660.0
2023-02-03 07:00:00	NVDA	Stock	21.278	21.47	21.278	21.47	309860.0
2023-02-03 08:00:00	NVDA	Stock	21.329	21.564	21.015	21.155	2983630.0
2023-02-03 09:00:00	NVDA	Stock	21.16	21.601	20.789	21.537	69648830.0
2023-02-03 10:00:00	NVDA	Stock	21.512	21.745	21.315	21.4931	72274160.0
2023-02-03 11:00:00	NVDA	Stock	21.495	21.692	21.4411	21.462	33465500.0
2023-02-03 12:00:00	NVDA	Stock	21.459	21.641	21.362	21.379	26589940.0
2023-02-03 13:00:00	NVDA	Stock	21.386	21.404	21.08	21.236	39910430.0
2023-02-03 14:00:00	NVDA	Stock	21.233	21.252	21.068	21.119	32285200.0
2023-02-03 15:00:00	NVDA	Stock	21.118	21.1595	20.9926	21.102	42750180.0
2023-02-03 16:00:00	NVDA	Stock	21.1	21.142	21.081	21.086	29021960.0
2023-02-03 17:00:00	NVDA	Stock	21.09	21.115	21.06	21.062	354530.0
2023-02-03 18:00:00	NVDA	Stock	21.064	21.115	21.062	21.091	219170.0
2023-02-03 19:00:00	NVDA	Stock	21.095	21.1	21.065	21.067	111090.0
2023-02-03 04:00:00	AMZN	Stock	106.09	106.88	105.58	106.74	128638.0
2023-02-03 05:00:00	AMZN	Stock	106.7	107.13	106.52	106.68	55356.0

> showing 50 of 62,784 rows — these rows as CSV

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