PREVIEW / stock_1hour / 2023-08-11

all stock 1-hour files

  file:    by_date/stock_1hour/2023/2023-08-11.parquet
  size:    1.3 MB
  rows:    58,532
  symbols: 1,487

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-08-11 04:00:00	AAPL	Stock	178.43	178.48	177.4	177.69	26406.0
2023-08-11 05:00:00	AAPL	Stock	177.74	177.8	177.37	177.58	9209.0
2023-08-11 06:00:00	AAPL	Stock	177.62	177.7	177.52	177.67	9370.0
2023-08-11 07:00:00	AAPL	Stock	177.74	178.1	177.69	177.93	44068.0
2023-08-11 08:00:00	AAPL	Stock	177.79	178.75	177.13	177.35	291142.0
2023-08-11 09:00:00	AAPL	Stock	177.27	177.62	176.55	176.86	5402237.0
2023-08-11 10:00:00	AAPL	Stock	176.86	178.62	176.86	178.01	8201197.0
2023-08-11 11:00:00	AAPL	Stock	178.015	178.185	177.281	177.71	4244037.0
2023-08-11 12:00:00	AAPL	Stock	177.72	178.095	177.3	177.395	2959063.0
2023-08-11 13:00:00	AAPL	Stock	177.4	177.99	177.2001	177.755	3279238.0
2023-08-11 14:00:00	AAPL	Stock	177.76	178.55	177.74	178.3389	4781773.0
2023-08-11 15:00:00	AAPL	Stock	178.33	178.35	177.6699	177.89	5880587.0
2023-08-11 16:00:00	AAPL	Stock	177.79	177.87	177.58	177.79	5511642.0
2023-08-11 17:00:00	AAPL	Stock	177.77	177.79	177.64	177.72	25303.0
2023-08-11 18:00:00	AAPL	Stock	177.72	177.75	177.6601	177.7	15627.0
2023-08-11 19:00:00	AAPL	Stock	177.74	177.75	177.64	177.75	28102.0
2023-08-11 04:00:00	MSFT	Stock	323.05	323.06	321.69	322.16	2864.0
2023-08-11 05:00:00	MSFT	Stock	322.18	322.3	321.01	321.01	1345.0
2023-08-11 06:00:00	MSFT	Stock	321.22	322.12	321.22	321.8	2177.0
2023-08-11 07:00:00	MSFT	Stock	321.99	322.38	321.6	321.6	7621.0
2023-08-11 08:00:00	MSFT	Stock	322.0	322.38	320.2402	320.27	44022.0
2023-08-11 09:00:00	MSFT	Stock	320.28	321.12	319.42	319.74	1856619.0
2023-08-11 10:00:00	MSFT	Stock	319.78	322.32	319.56	320.89	2379548.0
2023-08-11 11:00:00	MSFT	Stock	320.93	321.49	319.21	320.23	1538114.0
2023-08-11 12:00:00	MSFT	Stock	320.21	321.54	319.77	320.29	1181421.0
2023-08-11 13:00:00	MSFT	Stock	320.3	321.34	320.14	321.06	981253.0
2023-08-11 14:00:00	MSFT	Stock	321.06	322.41	320.95	322.17	1200935.0
2023-08-11 15:00:00	MSFT	Stock	322.16	322.23	320.59	321.09	2473352.0
2023-08-11 16:00:00	MSFT	Stock	321.19	321.37	320.52	321.1	3122809.0
2023-08-11 17:00:00	MSFT	Stock	321.09	321.09	321.0	321.0	6701.0
2023-08-11 18:00:00	MSFT	Stock	321.05	321.16	321.0	321.08	3429.0
2023-08-11 19:00:00	MSFT	Stock	321.05	321.13	320.4	320.75	4196.0
2023-08-11 04:00:00	NVDA	Stock	42.406	42.406	41.898	41.98	180550.0
2023-08-11 05:00:00	NVDA	Stock	42.02	42.04	41.94	41.992	105710.0
2023-08-11 06:00:00	NVDA	Stock	41.951	42.048	41.9	42.02	167960.0
2023-08-11 07:00:00	NVDA	Stock	42.048	42.2	42.045	42.052	405900.0
2023-08-11 08:00:00	NVDA	Stock	42.084	42.493	41.675	41.762	3519890.0
2023-08-11 09:00:00	NVDA	Stock	41.75	42.018	41.43	41.5437	52464220.0
2023-08-11 10:00:00	NVDA	Stock	41.553	41.847	41.34	41.4048	66290990.0
2023-08-11 11:00:00	NVDA	Stock	41.419	41.487	40.639	40.93	87977010.0
2023-08-11 12:00:00	NVDA	Stock	40.935	41.189	40.77	40.896	55225510.0
2023-08-11 13:00:00	NVDA	Stock	40.905	41.12	40.874	41.032	37447480.0
2023-08-11 14:00:00	NVDA	Stock	41.038	41.188	40.94	41.005	43085420.0
2023-08-11 15:00:00	NVDA	Stock	41.011	41.084	40.806	40.855	51285870.0
2023-08-11 16:00:00	NVDA	Stock	40.872	40.88	40.751	40.833	16998510.0
2023-08-11 17:00:00	NVDA	Stock	40.822	40.849	40.775	40.79	314450.0
2023-08-11 18:00:00	NVDA	Stock	40.79	40.82	40.755	40.785	351720.0
2023-08-11 19:00:00	NVDA	Stock	40.779	40.805	40.755	40.76	448360.0
2023-08-11 04:00:00	AMZN	Stock	138.7	138.7	138.01	138.14	9839.0
2023-08-11 05:00:00	AMZN	Stock	138.12	138.22	137.67	137.81	5933.0

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

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