PREVIEW / stock_1hour / 2024-02-13

all stock 1-hour files

  file:    by_date/stock_1hour/2024/2024-02-13.parquet
  size:    1.4 MB
  rows:    60,114
  symbols: 1,149

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
2024-02-13 04:00:00	AAPL	Stock	186.52	186.61	186.0	186.11	13948.0
2024-02-13 05:00:00	AAPL	Stock	186.0	186.01	185.79	185.8	6698.0
2024-02-13 06:00:00	AAPL	Stock	185.8	186.06	185.73	185.82	10704.0
2024-02-13 07:00:00	AAPL	Stock	185.91	186.16	185.87	186.14	20184.0
2024-02-13 08:00:00	AAPL	Stock	185.97	187.03	185.05	185.25	301583.0
2024-02-13 09:00:00	AAPL	Stock	185.25	186.21	184.18	185.16	6197748.0
2024-02-13 10:00:00	AAPL	Stock	185.15	186.19	184.76	185.85	5724439.0
2024-02-13 11:00:00	AAPL	Stock	185.85	186.025	185.2701	185.41	3265268.0
2024-02-13 12:00:00	AAPL	Stock	185.41	185.77	185.11	185.16	2627139.0
2024-02-13 13:00:00	AAPL	Stock	185.15	185.44	184.96	185.0	2853125.0
2024-02-13 14:00:00	AAPL	Stock	184.99	184.995	183.7925	183.8597	4325804.0
2024-02-13 15:00:00	AAPL	Stock	183.855	185.2	183.5128	185.03	8417315.0
2024-02-13 16:00:00	AAPL	Stock	185.04	185.41	184.96	185.3197	7065189.0
2024-02-13 17:00:00	AAPL	Stock	185.31	185.34	185.11	185.34	30745.0
2024-02-13 18:00:00	AAPL	Stock	185.34	185.34	185.0	185.15	33688.0
2024-02-13 19:00:00	AAPL	Stock	185.17	185.35	185.11	185.3	10140.0
2024-02-13 04:00:00	MSFT	Stock	414.35	414.35	412.12	412.3	5863.0
2024-02-13 05:00:00	MSFT	Stock	412.33	412.33	411.92	412.1	5063.0
2024-02-13 06:00:00	MSFT	Stock	412.03	412.06	409.85	410.77	19750.0
2024-02-13 07:00:00	MSFT	Stock	410.63	411.47	408.84	410.1	51402.0
2024-02-13 08:00:00	MSFT	Stock	416.1	416.1	406.24	406.75	210956.0
2024-02-13 09:00:00	MSFT	Stock	406.7	407.7	403.39	407.57	3532336.0
2024-02-13 10:00:00	MSFT	Stock	407.51	410.071	406.06	408.26	2690513.0
2024-02-13 11:00:00	MSFT	Stock	408.3	409.78	407.8	407.89	1432350.0
2024-02-13 12:00:00	MSFT	Stock	407.88	408.32	406.87	406.89	1430362.0
2024-02-13 13:00:00	MSFT	Stock	406.87	407.84	406.26	406.36	1189633.0
2024-02-13 14:00:00	MSFT	Stock	406.375	406.47	404.56	405.14	1735105.0
2024-02-13 15:00:00	MSFT	Stock	405.1764	406.81	404.73	406.55	2884951.0
2024-02-13 16:00:00	MSFT	Stock	406.54	408.75	406.32	408.35	3496189.0
2024-02-13 17:00:00	MSFT	Stock	408.21	408.55	408.05	408.05	15904.0
2024-02-13 18:00:00	MSFT	Stock	407.71	408.18	407.0	407.7816	15934.0
2024-02-13 19:00:00	MSFT	Stock	407.75	408.54	407.72	408.54	7631.0
2024-02-13 04:00:00	NVDA	Stock	71.9	72.2	71.83	71.851	325320.0
2024-02-13 05:00:00	NVDA	Stock	71.855	72.0	71.253	71.54	377120.0
2024-02-13 06:00:00	NVDA	Stock	71.49	71.648	71.219	71.611	325830.0
2024-02-13 07:00:00	NVDA	Stock	71.605	72.275	71.433	72.275	962980.0
2024-02-13 08:00:00	NVDA	Stock	71.659	72.5	70.724	70.838	8088900.0
2024-02-13 09:00:00	NVDA	Stock	70.801	71.57	69.62	71.0215	81534670.0
2024-02-13 10:00:00	NVDA	Stock	71.028	73.3	70.81	72.664	104794980.0
2024-02-13 11:00:00	NVDA	Stock	72.674	73.45	72.568	72.585	53675940.0
2024-02-13 12:00:00	NVDA	Stock	72.59	72.809	71.894	72.024	42855530.0
2024-02-13 13:00:00	NVDA	Stock	72.031	72.449	71.825	72.367	31222230.0
2024-02-13 14:00:00	NVDA	Stock	72.3767	72.468	71.761	71.9286	38911290.0
2024-02-13 15:00:00	NVDA	Stock	71.9215	72.1959	71.35	72.19	63651360.0
2024-02-13 16:00:00	NVDA	Stock	72.186	72.64	72.079	72.6	16965460.0
2024-02-13 17:00:00	NVDA	Stock	72.6179	72.633	72.251	72.44	860490.0
2024-02-13 18:00:00	NVDA	Stock	72.4273	72.4273	72.255	72.36	394600.0
2024-02-13 19:00:00	NVDA	Stock	72.35	72.48	72.28	72.466	459070.0
2024-02-13 04:00:00	AMZN	Stock	171.68	171.85	171.61	171.62	9633.0
2024-02-13 05:00:00	AMZN	Stock	171.6	171.6	171.31	171.34	7963.0

> showing 50 of 60,114 rows — these rows as CSV

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