PREVIEW / stock_1hour / 2024-09-12

all stock 1-hour files

  file:    by_date/stock_1hour/2024/2024-09-12.parquet
  size:    1.3 MB
  rows:    58,242
  symbols: 868

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-09-12 04:00:00	AAPL	Stock	222.5	223.45	221.92	222.65	11052.0
2024-09-12 05:00:00	AAPL	Stock	222.61	222.99	222.6	222.62	5355.0
2024-09-12 06:00:00	AAPL	Stock	222.6	222.67	222.5	222.66	12109.0
2024-09-12 07:00:00	AAPL	Stock	222.6	223.0	222.6	222.6	17145.0
2024-09-12 08:00:00	AAPL	Stock	222.69	223.16	222.104	222.76	74281.0
2024-09-12 09:00:00	AAPL	Stock	222.6014	223.0	219.82	221.04	4059568.0
2024-09-12 10:00:00	AAPL	Stock	221.04	222.3794	220.94	221.8	3665060.0
2024-09-12 11:00:00	AAPL	Stock	221.81	223.0675	221.67	221.975	2721209.0
2024-09-12 12:00:00	AAPL	Stock	221.98	222.5399	221.62	222.5	1573599.0
2024-09-12 13:00:00	AAPL	Stock	222.49	223.23	222.43	223.08	2206327.0
2024-09-12 14:00:00	AAPL	Stock	223.09	223.55	222.16	223.19	2684529.0
2024-09-12 15:00:00	AAPL	Stock	223.18	223.5	222.25	222.87	5212542.0
2024-09-12 16:00:00	AAPL	Stock	222.87	222.87	222.15	222.29	6865410.0
2024-09-12 17:00:00	AAPL	Stock	222.282	222.4	222.0	222.2	44229.0
2024-09-12 18:00:00	AAPL	Stock	222.41	222.75	222.2383	222.64	31611.0
2024-09-12 19:00:00	AAPL	Stock	222.6	222.95	222.6	222.757	12046.0
2024-09-12 04:00:00	MSFT	Stock	423.7	424.05	422.52	423.06	6621.0
2024-09-12 05:00:00	MSFT	Stock	423.15	423.15	423.15	423.15	554.0
2024-09-12 06:00:00	MSFT	Stock	423.13	423.81	422.87	423.81	1352.0
2024-09-12 07:00:00	MSFT	Stock	423.15	423.69	423.15	423.51	4501.0
2024-09-12 08:00:00	MSFT	Stock	423.3	425.0	422.004	422.65	31607.0
2024-09-12 09:00:00	MSFT	Stock	422.55	424.01	420.14	421.07	1332289.0
2024-09-12 10:00:00	MSFT	Stock	421.06	423.0	420.0	420.24	1317716.0
2024-09-12 11:00:00	MSFT	Stock	420.21	421.8658	419.75	420.02	901302.0
2024-09-12 12:00:00	MSFT	Stock	420.0	422.965	419.8	422.75	661542.0
2024-09-12 13:00:00	MSFT	Stock	422.755	425.98	422.5	425.98	1140911.0
2024-09-12 14:00:00	MSFT	Stock	425.96	427.3692	424.26	426.38	1069321.0
2024-09-12 15:00:00	MSFT	Stock	426.38	427.16	425.4	427.09	1645734.0
2024-09-12 16:00:00	MSFT	Stock	427.085	427.76	426.5	426.68	3360331.0
2024-09-12 17:00:00	MSFT	Stock	426.68	427.181	426.3719	426.7	8358.0
2024-09-12 18:00:00	MSFT	Stock	426.8	427.6	426.63	427.58	8808.0
2024-09-12 19:00:00	MSFT	Stock	427.69	428.0	427.4379	427.9	5482.0
2024-09-12 04:00:00	NVDA	Stock	117.0	118.07	116.6	117.83	1225542.0
2024-09-12 05:00:00	NVDA	Stock	117.8	118.4	117.72	117.89	682064.0
2024-09-12 06:00:00	NVDA	Stock	117.88	118.09	117.52	117.59	372253.0
2024-09-12 07:00:00	NVDA	Stock	117.6	118.289	117.04	118.08	1670064.0
2024-09-12 08:00:00	NVDA	Stock	118.08	118.84	116.78	116.78	5746142.0
2024-09-12 09:00:00	NVDA	Stock	116.8	118.27	115.38	118.2601	52894736.0
2024-09-12 10:00:00	NVDA	Stock	118.26	120.24	117.79	118.625	69738026.0
2024-09-12 11:00:00	NVDA	Stock	118.64	119.7899	117.77	118.148	41249676.0
2024-09-12 12:00:00	NVDA	Stock	118.14	119.4399	118.1	119.436	28240613.0
2024-09-12 13:00:00	NVDA	Stock	119.43	120.79	119.11	120.645	32741392.0
2024-09-12 14:00:00	NVDA	Stock	120.646	120.74	119.1	120.3201	33122828.0
2024-09-12 15:00:00	NVDA	Stock	120.325	120.49	119.02	119.18	36010415.0
2024-09-12 16:00:00	NVDA	Stock	119.23	119.26	118.1	118.71	17421410.0
2024-09-12 17:00:00	NVDA	Stock	118.71	118.83	118.38	118.79	738645.0
2024-09-12 18:00:00	NVDA	Stock	118.791	118.9	118.47	118.8	574718.0
2024-09-12 19:00:00	NVDA	Stock	118.8	119.15	118.77	119.119	640894.0
2024-09-12 04:00:00	AMZN	Stock	184.64	184.81	183.67	184.6	29709.0
2024-09-12 05:00:00	AMZN	Stock	184.72	184.9	184.29	184.49	18174.0

> showing 50 of 58,242 rows — these rows as CSV

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