PREVIEW / stock_1hour / 2023-06-30

all stock 1-hour files

  file:    by_date/stock_1hour/2023/2023-06-30.parquet
  size:    1.4 MB
  rows:    60,402
  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-06-30 04:00:00	AAPL	Stock	190.37	190.95	190.37	190.95	22034.0
2023-06-30 05:00:00	AAPL	Stock	190.91	191.2	190.8	191.12	25685.0
2023-06-30 06:00:00	AAPL	Stock	191.04	191.2	190.83	190.88	27013.0
2023-06-30 07:00:00	AAPL	Stock	190.87	191.25	190.87	191.24	76761.0
2023-06-30 08:00:00	AAPL	Stock	190.98	192.21	190.32	192.11	733970.0
2023-06-30 09:00:00	AAPL	Stock	192.14	192.64	191.26	192.485	9792868.0
2023-06-30 10:00:00	AAPL	Stock	192.47	193.15	192.1591	192.54	9204986.0
2023-06-30 11:00:00	AAPL	Stock	192.54	192.82	191.98	192.3387	5468678.0
2023-06-30 12:00:00	AAPL	Stock	192.34	192.88	192.22	192.68	3830752.0
2023-06-30 13:00:00	AAPL	Stock	192.68	193.12	192.635	193.09	4563796.0
2023-06-30 14:00:00	AAPL	Stock	193.09	193.185	192.815	193.01	4256716.0
2023-06-30 15:00:00	AAPL	Stock	193.01	194.48	192.9	193.8	14737421.0
2023-06-30 16:00:00	AAPL	Stock	193.79	194.03	193.75	193.84	16900482.0
2023-06-30 17:00:00	AAPL	Stock	193.85	193.97	193.81	193.87	170465.0
2023-06-30 18:00:00	AAPL	Stock	193.89	193.9	193.81	193.85	50325.0
2023-06-30 19:00:00	AAPL	Stock	193.85	194.28	193.8494	194.28	82474.0
2023-06-30 04:00:00	MSFT	Stock	336.4	336.4	335.71	335.71	1741.0
2023-06-30 05:00:00	MSFT	Stock	336.39	336.39	336.39	336.39	229.0
2023-06-30 06:00:00	MSFT	Stock	336.2	336.39	336.2	336.39	1964.0
2023-06-30 07:00:00	MSFT	Stock	336.26	336.66	336.19	336.24	4802.0
2023-06-30 08:00:00	MSFT	Stock	336.27	339.0	335.1	338.43	53880.0
2023-06-30 09:00:00	MSFT	Stock	338.51	340.99	337.2	340.74	2436120.0
2023-06-30 10:00:00	MSFT	Stock	340.75	342.73	340.31	341.4112	2484560.0
2023-06-30 11:00:00	MSFT	Stock	341.4	341.95	339.66	340.2	1703757.0
2023-06-30 12:00:00	MSFT	Stock	340.23	341.3	339.8301	341.21	1217919.0
2023-06-30 13:00:00	MSFT	Stock	341.23	341.47	340.42	340.9175	1076995.0
2023-06-30 14:00:00	MSFT	Stock	340.91	341.03	340.27	340.6	1141612.0
2023-06-30 15:00:00	MSFT	Stock	340.65	341.5	340.18	340.39	3010716.0
2023-06-30 16:00:00	MSFT	Stock	340.34	340.76	340.21	340.5551	6631813.0
2023-06-30 17:00:00	MSFT	Stock	340.54	340.69	340.16	340.2495	8855.0
2023-06-30 18:00:00	MSFT	Stock	340.2319	340.47	340.23	340.44	1709.0
2023-06-30 19:00:00	MSFT	Stock	340.44	340.99	340.44	340.6	3854.0
2023-06-30 04:00:00	NVDA	Stock	41.11	41.25	41.0	41.198	113030.0
2023-06-30 05:00:00	NVDA	Stock	41.228	41.23	41.13	41.142	56750.0
2023-06-30 06:00:00	NVDA	Stock	41.12	41.227	41.111	41.227	78870.0
2023-06-30 07:00:00	NVDA	Stock	41.21	41.232	41.13	41.13	341840.0
2023-06-30 08:00:00	NVDA	Stock	41.2	41.438	40.926	41.32	2426790.0
2023-06-30 09:00:00	NVDA	Stock	41.32	42.193	41.3175	42.03	65982320.0
2023-06-30 10:00:00	NVDA	Stock	42.031	42.55	41.978	42.323	75513050.0
2023-06-30 11:00:00	NVDA	Stock	42.327	42.4019	42.008	42.242	52648820.0
2023-06-30 12:00:00	NVDA	Stock	42.24	42.38	42.086	42.3725	32913890.0
2023-06-30 13:00:00	NVDA	Stock	42.371	42.479	42.286	42.466	29826840.0
2023-06-30 14:00:00	NVDA	Stock	42.4645	42.477	42.291	42.3795	31978860.0
2023-06-30 15:00:00	NVDA	Stock	42.3825	42.518	42.229	42.281	53705490.0
2023-06-30 16:00:00	NVDA	Stock	42.302	42.3295	42.25	42.27	44573060.0
2023-06-30 17:00:00	NVDA	Stock	42.261	42.293	42.2161	42.228	331500.0
2023-06-30 18:00:00	NVDA	Stock	42.237	42.277	42.234	42.277	129280.0
2023-06-30 19:00:00	NVDA	Stock	42.278	42.325	42.263	42.284	364320.0
2023-06-30 04:00:00	AMZN	Stock	128.37	128.5	128.26	128.37	8561.0
2023-06-30 05:00:00	AMZN	Stock	128.4	128.85	128.35	128.7	9668.0

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

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