PREVIEW / stock_1hour / 2023-10-06

all stock 1-hour files

  file:    by_date/stock_1hour/2023/2023-10-06.parquet
  size:    1.3 MB
  rows:    57,449
  symbols: 1,381

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-10-06 04:00:00	AAPL	Stock	175.08	175.22	174.87	174.88	11298.0
2023-10-06 05:00:00	AAPL	Stock	174.82	175.1	174.82	175.08	6662.0
2023-10-06 06:00:00	AAPL	Stock	175.08	175.5	175.08	175.35	11762.0
2023-10-06 07:00:00	AAPL	Stock	175.36	175.56	175.1	175.15	32470.0
2023-10-06 08:00:00	AAPL	Stock	175.4105	175.59	172.75	173.29	470719.0
2023-10-06 09:00:00	AAPL	Stock	173.29	175.06	173.04	174.03	5237626.0
2023-10-06 10:00:00	AAPL	Stock	174.04	175.28	173.35	175.13	7025855.0
2023-10-06 11:00:00	AAPL	Stock	175.1324	176.84	175.09	176.7987	6605541.0
2023-10-06 12:00:00	AAPL	Stock	176.795	177.05	176.31	176.82	4872804.0
2023-10-06 13:00:00	AAPL	Stock	176.83	177.39	176.69	177.2799	4316992.0
2023-10-06 14:00:00	AAPL	Stock	177.275	177.7059	177.13	177.54	3615049.0
2023-10-06 15:00:00	AAPL	Stock	177.535	177.99	177.4	177.49	8724928.0
2023-10-06 16:00:00	AAPL	Stock	177.47	177.7	177.45	177.57	8376813.0
2023-10-06 17:00:00	AAPL	Stock	177.53	177.56	177.5	177.53	17310.0
2023-10-06 18:00:00	AAPL	Stock	177.54	177.59	177.51	177.53	14339.0
2023-10-06 19:00:00	AAPL	Stock	177.52	177.77	177.51	177.72	21611.0
2023-10-06 04:00:00	MSFT	Stock	320.15	320.27	319.99	319.99	858.0
2023-10-06 05:00:00	MSFT	Stock	319.95	319.95	319.74	319.74	300.0
2023-10-06 06:00:00	MSFT	Stock	319.97	321.52	319.97	321.39	1983.0
2023-10-06 07:00:00	MSFT	Stock	321.25	321.31	319.99	320.2	7730.0
2023-10-06 08:00:00	MSFT	Stock	321.2464	321.45	314.14	315.35	113503.0
2023-10-06 09:00:00	MSFT	Stock	315.2	320.17	315.0	319.17	1754809.0
2023-10-06 10:00:00	MSFT	Stock	319.12	322.5	317.8	322.05	2333551.0
2023-10-06 11:00:00	MSFT	Stock	322.1	325.5	321.965	325.31	2603537.0
2023-10-06 12:00:00	MSFT	Stock	325.3	325.76	324.17	325.32	1258448.0
2023-10-06 13:00:00	MSFT	Stock	325.37	327.09	325.22	326.94	1267879.0
2023-10-06 14:00:00	MSFT	Stock	326.945	328.13	326.51	327.96	1432280.0
2023-10-06 15:00:00	MSFT	Stock	327.98	329.19	327.09	327.26	3340286.0
2023-10-06 16:00:00	MSFT	Stock	327.27	329.7855	327.18	329.24	4773926.0
2023-10-06 17:00:00	MSFT	Stock	329.24	329.2684	328.6	328.62	19176.0
2023-10-06 18:00:00	MSFT	Stock	328.7	329.0	328.62	329.0	11358.0
2023-10-06 19:00:00	MSFT	Stock	328.96	329.18	328.88	329.18	10807.0
2023-10-06 04:00:00	NVDA	Stock	44.7	44.828	44.7	44.796	78840.0
2023-10-06 05:00:00	NVDA	Stock	44.765	44.873	44.765	44.843	58190.0
2023-10-06 06:00:00	NVDA	Stock	44.847	44.91	44.827	44.845	81410.0
2023-10-06 07:00:00	NVDA	Stock	44.841	44.884	44.688	44.7	610040.0
2023-10-06 08:00:00	NVDA	Stock	44.806	44.884	43.94	44.08	6432720.0
2023-10-06 09:00:00	NVDA	Stock	44.069	44.512	44.0	44.237	41587780.0
2023-10-06 10:00:00	NVDA	Stock	44.232	45.045	44.075	44.884	68855650.0
2023-10-06 11:00:00	NVDA	Stock	44.89	45.48	44.832	45.4753	52269840.0
2023-10-06 12:00:00	NVDA	Stock	45.4745	45.62	45.401	45.533	43609350.0
2023-10-06 13:00:00	NVDA	Stock	45.533	45.641	45.426	45.5208	28351070.0
2023-10-06 14:00:00	NVDA	Stock	45.517	45.65	45.45	45.592	27628900.0
2023-10-06 15:00:00	NVDA	Stock	45.596	45.789	45.532	45.7616	45092390.0
2023-10-06 16:00:00	NVDA	Stock	45.762	45.762	45.128	45.492	25105910.0
2023-10-06 17:00:00	NVDA	Stock	45.492	45.5	45.401	45.48	684150.0
2023-10-06 18:00:00	NVDA	Stock	45.485	45.58	45.48	45.58	443550.0
2023-10-06 19:00:00	NVDA	Stock	45.58	45.595	45.514	45.515	430330.0
2023-10-06 04:00:00	AMZN	Stock	126.49	126.5	125.95	126.04	4663.0
2023-10-06 05:00:00	AMZN	Stock	126.0	126.2	126.0	126.18	3861.0

> showing 50 of 57,449 rows — these rows as CSV

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