PREVIEW / stock_1hour / 2023-07-05

all stock 1-hour files

  file:    by_date/stock_1hour/2023/2023-07-05.parquet
  size:    1.4 MB
  rows:    60,998
  symbols: 1,557

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-07-05 04:00:00	AAPL	Stock	192.71	192.71	191.5	191.5	10763.0
2023-07-05 05:00:00	AAPL	Stock	191.42	191.43	191.02	191.22	8864.0
2023-07-05 06:00:00	AAPL	Stock	191.2	191.64	190.99	191.54	16829.0
2023-07-05 07:00:00	AAPL	Stock	191.58	191.77	191.27	191.27	36186.0
2023-07-05 08:00:00	AAPL	Stock	191.6	192.88	191.08	191.48	140325.0
2023-07-05 09:00:00	AAPL	Stock	191.48	192.98	191.39	192.235	6423316.0
2023-07-05 10:00:00	AAPL	Stock	192.24	192.7399	192.03	192.3599	5477585.0
2023-07-05 11:00:00	AAPL	Stock	192.36	192.365	190.91	190.93	5283046.0
2023-07-05 12:00:00	AAPL	Stock	190.92	191.305	190.6779	191.135	3160582.0
2023-07-05 13:00:00	AAPL	Stock	191.13	191.29	190.865	190.9305	2382824.0
2023-07-05 14:00:00	AAPL	Stock	190.94	191.43	190.62	191.305	3613257.0
2023-07-05 15:00:00	AAPL	Stock	191.3	191.4899	191.22	191.33	4605558.0
2023-07-05 16:00:00	AAPL	Stock	191.33	191.34	191.17	191.3099	5053651.0
2023-07-05 17:00:00	AAPL	Stock	191.3	191.33	191.29	191.32	17128.0
2023-07-05 18:00:00	AAPL	Stock	191.31	191.37	191.25	191.35	25760.0
2023-07-05 19:00:00	AAPL	Stock	191.3	191.33	191.21	191.25	24420.0
2023-07-05 04:00:00	MSFT	Stock	336.67	336.67	335.9	335.9	2480.0
2023-07-05 05:00:00	MSFT	Stock	335.87	335.87	335.03	335.32	6030.0
2023-07-05 06:00:00	MSFT	Stock	335.65	336.0	335.65	335.89	1237.0
2023-07-05 07:00:00	MSFT	Stock	336.19	336.32	335.12	335.12	8908.0
2023-07-05 08:00:00	MSFT	Stock	336.29	338.67	334.8	334.89	54728.0
2023-07-05 09:00:00	MSFT	Stock	335.05	340.355	334.7276	338.68	2397638.0
2023-07-05 10:00:00	MSFT	Stock	338.71	341.65	338.5	340.94	1924064.0
2023-07-05 11:00:00	MSFT	Stock	340.955	340.98	338.63	338.86	1254459.0
2023-07-05 12:00:00	MSFT	Stock	338.86	339.355	338.17	338.7015	928417.0
2023-07-05 13:00:00	MSFT	Stock	338.745	339.085	338.14	338.36	629808.0
2023-07-05 14:00:00	MSFT	Stock	338.37	338.8	337.64	338.42	965795.0
2023-07-05 15:00:00	MSFT	Stock	338.4	338.75	337.8	338.18	1642724.0
2023-07-05 16:00:00	MSFT	Stock	338.18	338.21	337.68	337.9	2533778.0
2023-07-05 17:00:00	MSFT	Stock	337.85	338.02	337.7242	337.9	4481.0
2023-07-05 18:00:00	MSFT	Stock	338.0	338.2	337.91	338.2	3154.0
2023-07-05 19:00:00	MSFT	Stock	338.2	338.28	337.81	337.81	5423.0
2023-07-05 04:00:00	NVDA	Stock	42.4	42.4	42.002	42.01	130070.0
2023-07-05 05:00:00	NVDA	Stock	42.039	42.04	41.851	41.879	54990.0
2023-07-05 06:00:00	NVDA	Stock	41.877	42.12	41.87	42.085	86510.0
2023-07-05 07:00:00	NVDA	Stock	42.084	42.149	42.012	42.015	146360.0
2023-07-05 08:00:00	NVDA	Stock	42.093	42.65	41.97	42.09	720970.0
2023-07-05 09:00:00	NVDA	Stock	42.09	42.855	42.04	42.727	38952110.0
2023-07-05 10:00:00	NVDA	Stock	42.716	43.177	42.659	42.941	55520280.0
2023-07-05 11:00:00	NVDA	Stock	42.937	42.9396	42.489	42.571	37419000.0
2023-07-05 12:00:00	NVDA	Stock	42.577	42.799	42.488	42.672	26235490.0
2023-07-05 13:00:00	NVDA	Stock	42.674	42.81	42.6	42.728	17122930.0
2023-07-05 14:00:00	NVDA	Stock	42.73	42.804	42.458	42.62	25285680.0
2023-07-05 15:00:00	NVDA	Stock	42.624	42.672	42.304	42.3235	33483590.0
2023-07-05 16:00:00	NVDA	Stock	42.324	42.379	42.3	42.342	12644810.0
2023-07-05 17:00:00	NVDA	Stock	42.342	42.369	42.335	42.3581	108740.0
2023-07-05 18:00:00	NVDA	Stock	42.364	42.3937	42.342	42.3786	202790.0
2023-07-05 19:00:00	NVDA	Stock	42.376	42.444	42.375	42.44	277160.0
2023-07-05 04:00:00	AMZN	Stock	129.51	130.45	129.51	129.64	14249.0
2023-07-05 05:00:00	AMZN	Stock	129.63	129.64	129.25	129.33	9751.0

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

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