PREVIEW / stock_1hour / 2024-04-02

all stock 1-hour files

  file:    by_date/stock_1hour/2024/2024-04-02.parquet
  size:    1.4 MB
  rows:    60,352
  symbols: 1,053

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-04-02 04:00:00	AAPL	Stock	169.71	170.08	169.71	169.9	9099.0
2024-04-02 05:00:00	AAPL	Stock	170.0	170.04	169.85	169.89	5983.0
2024-04-02 06:00:00	AAPL	Stock	169.8	169.88	169.6	169.65	6693.0
2024-04-02 07:00:00	AAPL	Stock	169.63	169.64	169.35	169.41	44995.0
2024-04-02 08:00:00	AAPL	Stock	169.6	169.93	169.0	169.06	163009.0
2024-04-02 09:00:00	AAPL	Stock	169.05	169.33	168.2302	169.08	6237778.0
2024-04-02 10:00:00	AAPL	Stock	169.09	169.34	168.53	168.675	4733273.0
2024-04-02 11:00:00	AAPL	Stock	168.675	169.15	168.615	168.65	3346980.0
2024-04-02 12:00:00	AAPL	Stock	168.65	168.87	168.37	168.8	2849584.0
2024-04-02 13:00:00	AAPL	Stock	168.8	169.105	168.8	169.0101	3037411.0
2024-04-02 14:00:00	AAPL	Stock	169.02	169.06	168.75	168.825	2504469.0
2024-04-02 15:00:00	AAPL	Stock	168.825	169.2201	168.73	168.94	7289753.0
2024-04-02 16:00:00	AAPL	Stock	168.94	169.03	168.71	168.9318	9621982.0
2024-04-02 17:00:00	AAPL	Stock	168.97	168.99	168.84	168.95	23414.0
2024-04-02 18:00:00	AAPL	Stock	168.96	169.2519	168.9	169.25	23503.0
2024-04-02 19:00:00	AAPL	Stock	169.25	169.48	169.2	169.4	32148.0
2024-04-02 04:00:00	MSFT	Stock	424.49	424.49	423.88	423.88	3523.0
2024-04-02 05:00:00	MSFT	Stock	423.99	424.95	423.95	424.49	2898.0
2024-04-02 06:00:00	MSFT	Stock	424.12	424.19	423.32	424.01	2560.0
2024-04-02 07:00:00	MSFT	Stock	424.11	424.11	423.11	423.11	7986.0
2024-04-02 08:00:00	MSFT	Stock	423.95	425.98	420.0	420.74	42444.0
2024-04-02 09:00:00	MSFT	Stock	420.68	421.64	419.11	419.4325	1590059.0
2024-04-02 10:00:00	MSFT	Stock	419.54	420.19	417.84	419.99	1449253.0
2024-04-02 11:00:00	MSFT	Stock	420.0	421.63	419.55	420.94	1079958.0
2024-04-02 12:00:00	MSFT	Stock	420.87	421.44	420.28	421.44	574132.0
2024-04-02 13:00:00	MSFT	Stock	421.48	422.38	421.42	421.785	774503.0
2024-04-02 14:00:00	MSFT	Stock	421.82	422.14	421.0	421.24	629465.0
2024-04-02 15:00:00	MSFT	Stock	421.235	422.21	421.07	421.46	1642580.0
2024-04-02 16:00:00	MSFT	Stock	421.44	421.86	420.35	421.66	3692086.0
2024-04-02 17:00:00	MSFT	Stock	421.72	421.75	421.44	421.75	5269.0
2024-04-02 18:00:00	MSFT	Stock	421.5	421.61	421.2	421.4	2847.0
2024-04-02 19:00:00	MSFT	Stock	421.39	421.76	421.35	421.5984	2853.0
2024-04-02 04:00:00	NVDA	Stock	89.81	90.318	89.81	90.004	95800.0
2024-04-02 05:00:00	NVDA	Stock	90.087	90.087	89.78	89.78	22430.0
2024-04-02 06:00:00	NVDA	Stock	89.733	89.819	89.524	89.727	98980.0
2024-04-02 07:00:00	NVDA	Stock	89.7	89.88	89.4	89.5	429080.0
2024-04-02 08:00:00	NVDA	Stock	89.8	90.02	88.841	88.947	2720380.0
2024-04-02 09:00:00	NVDA	Stock	88.9969	88.9969	87.725	88.4	53975380.0
2024-04-02 10:00:00	NVDA	Stock	88.426	88.559	87.62	88.3265	54330400.0
2024-04-02 11:00:00	NVDA	Stock	88.3265	89.612	88.25	89.0766	54019480.0
2024-04-02 12:00:00	NVDA	Stock	89.047	89.789	88.911	89.697	31958840.0
2024-04-02 13:00:00	NVDA	Stock	89.696	90.094	89.311	89.3804	38349210.0
2024-04-02 14:00:00	NVDA	Stock	89.3822	89.755	89.212	89.4	24872060.0
2024-04-02 15:00:00	NVDA	Stock	89.378	89.67	89.227	89.447	35538310.0
2024-04-02 16:00:00	NVDA	Stock	89.472	89.525	89.228	89.34	20081370.0
2024-04-02 17:00:00	NVDA	Stock	89.349	89.452	89.25	89.288	170080.0
2024-04-02 18:00:00	NVDA	Stock	89.305	89.305	89.15	89.225	201730.0
2024-04-02 19:00:00	NVDA	Stock	89.225	89.279	89.21	89.236	251380.0
2024-04-02 04:00:00	AMZN	Stock	180.76	181.14	180.7	180.9	8759.0
2024-04-02 05:00:00	AMZN	Stock	181.1	181.28	180.96	180.96	5477.0

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

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