PREVIEW / stock_1hour / 2024-02-02

all stock 1-hour files

  file:    by_date/stock_1hour/2024/2024-02-02.parquet
  size:    1.3 MB
  rows:    58,674
  symbols: 1,160

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-02 04:00:00	AAPL	Stock	182.4	183.01	182.02	182.44	93283.0
2024-02-02 05:00:00	AAPL	Stock	182.4	182.4	181.26	181.4	68704.0
2024-02-02 06:00:00	AAPL	Stock	181.39	182.6	181.38	182.5	143398.0
2024-02-02 07:00:00	AAPL	Stock	182.31	182.5	180.75	180.8	307361.0
2024-02-02 08:00:00	AAPL	Stock	182.0	183.0	179.8	180.19	1204236.0
2024-02-02 09:00:00	AAPL	Stock	180.19	183.72	179.25	182.48	17884584.0
2024-02-02 10:00:00	AAPL	Stock	182.502	185.94	182.44	185.665	13286860.0
2024-02-02 11:00:00	AAPL	Stock	185.67	187.33	185.13	186.33	11081324.0
2024-02-02 12:00:00	AAPL	Stock	186.335	187.12	185.12	185.275	7053429.0
2024-02-02 13:00:00	AAPL	Stock	185.275	186.24	184.854	185.915	5335718.0
2024-02-02 14:00:00	AAPL	Stock	185.93	187.02	185.59	186.9803	4619767.0
2024-02-02 15:00:00	AAPL	Stock	186.99	187.07	185.83	185.84	10078946.0
2024-02-02 16:00:00	AAPL	Stock	185.84	185.88	185.2	185.33	9468680.0
2024-02-02 17:00:00	AAPL	Stock	185.2524	185.4	185.09	185.36	78335.0
2024-02-02 18:00:00	AAPL	Stock	185.37	185.5	185.21	185.25	28646.0
2024-02-02 19:00:00	AAPL	Stock	185.25	185.32	185.06	185.11	21086.0
2024-02-02 04:00:00	MSFT	Stock	407.7	408.1	407.01	407.43	13986.0
2024-02-02 05:00:00	MSFT	Stock	407.6	408.32	407.52	408.08	5569.0
2024-02-02 06:00:00	MSFT	Stock	408.01	408.2	407.95	408.0	5619.0
2024-02-02 07:00:00	MSFT	Stock	408.09	408.25	407.55	408.2	35219.0
2024-02-02 08:00:00	MSFT	Stock	408.0	410.92	405.0	405.36	173098.0
2024-02-02 09:00:00	MSFT	Stock	405.6	409.6	403.39	407.66	3418539.0
2024-02-02 10:00:00	MSFT	Stock	407.54	409.95	406.84	408.035	3006337.0
2024-02-02 11:00:00	MSFT	Stock	408.06	410.31	407.32	409.8215	2130975.0
2024-02-02 12:00:00	MSFT	Stock	409.83	411.745	409.64	411.645	2119461.0
2024-02-02 13:00:00	MSFT	Stock	411.7	412.27	410.7	411.935	1362235.0
2024-02-02 14:00:00	MSFT	Stock	411.97	412.42	411.3501	411.51	1060811.0
2024-02-02 15:00:00	MSFT	Stock	411.51	412.65	410.675	411.11	2610497.0
2024-02-02 16:00:00	MSFT	Stock	411.08	411.47	410.52	410.5884	3706151.0
2024-02-02 17:00:00	MSFT	Stock	410.58	411.63	410.58	411.63	13687.0
2024-02-02 18:00:00	MSFT	Stock	411.7	411.7	411.0327	411.0327	5599.0
2024-02-02 19:00:00	MSFT	Stock	411.09	411.37	410.88	411.06	6973.0
2024-02-02 04:00:00	NVDA	Stock	64.149	64.35	63.911	63.929	368360.0
2024-02-02 05:00:00	NVDA	Stock	63.959	64.09	63.855	64.0	86240.0
2024-02-02 06:00:00	NVDA	Stock	63.999	64.061	63.895	63.96	147910.0
2024-02-02 07:00:00	NVDA	Stock	63.995	64.355	63.98	64.25	1051970.0
2024-02-02 08:00:00	NVDA	Stock	64.039	64.355	63.802	63.861	3422360.0
2024-02-02 09:00:00	NVDA	Stock	63.85	65.436	63.69	65.1952	67955160.0
2024-02-02 10:00:00	NVDA	Stock	65.183	65.4	64.778	65.1685	58511560.0
2024-02-02 11:00:00	NVDA	Stock	65.179	66.095	65.072	65.969	48794650.0
2024-02-02 12:00:00	NVDA	Stock	65.972	66.6	65.871	66.284	54622890.0
2024-02-02 13:00:00	NVDA	Stock	66.2942	66.428	65.8169	66.1195	35284720.0
2024-02-02 14:00:00	NVDA	Stock	66.134	66.331	65.93	66.078	26934840.0
2024-02-02 15:00:00	NVDA	Stock	66.077	66.275	65.937	66.15	38400680.0
2024-02-02 16:00:00	NVDA	Stock	66.3	66.3	66.006	66.04	20632010.0
2024-02-02 17:00:00	NVDA	Stock	66.04	66.485	66.03	66.46	1073470.0
2024-02-02 18:00:00	NVDA	Stock	66.461	66.489	66.355	66.398	384240.0
2024-02-02 19:00:00	NVDA	Stock	66.397	66.398	66.167	66.2	475910.0
2024-02-02 04:00:00	AMZN	Stock	169.81	170.51	167.4	169.41	330480.0
2024-02-02 05:00:00	AMZN	Stock	169.4	169.77	168.7	169.59	90526.0

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

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