PREVIEW / stock_1hour / 2023-05-30

all stock 1-hour files

  file:    by_date/stock_1hour/2023/2023-05-30.parquet
  size:    1.4 MB
  rows:    61,638
  symbols: 1,661

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-05-30 04:00:00	AAPL	Stock	176.1	176.23	175.88	175.96	46477.0
2023-05-30 05:00:00	AAPL	Stock	175.96	176.6	175.96	176.46	27716.0
2023-05-30 06:00:00	AAPL	Stock	176.46	177.0	176.31	176.73	52018.0
2023-05-30 07:00:00	AAPL	Stock	176.73	177.5	176.73	177.39	150421.0
2023-05-30 08:00:00	AAPL	Stock	176.7311	178.18	175.81	177.651	604187.0
2023-05-30 09:00:00	AAPL	Stock	177.66	178.99	176.57	177.7399	9930567.0
2023-05-30 10:00:00	AAPL	Stock	177.72	178.0982	176.975	177.44	6284792.0
2023-05-30 11:00:00	AAPL	Stock	177.435	177.79	176.7504	177.3215	4301168.0
2023-05-30 12:00:00	AAPL	Stock	177.33	177.975	177.09	177.83	3410529.0
2023-05-30 13:00:00	AAPL	Stock	177.85	177.86	176.82	176.97	3477770.0
2023-05-30 14:00:00	AAPL	Stock	176.965	177.85	176.59	177.47	3850988.0
2023-05-30 15:00:00	AAPL	Stock	177.47	177.685	176.81	177.33	6689726.0
2023-05-30 16:00:00	AAPL	Stock	177.34	177.4	177.1	177.3	7395236.0
2023-05-30 17:00:00	AAPL	Stock	177.29	177.32	177.13	177.13	31152.0
2023-05-30 18:00:00	AAPL	Stock	177.17	177.39	177.17	177.35	12304.0
2023-05-30 19:00:00	AAPL	Stock	177.37	177.7	177.36	177.66	52022.0
2023-05-30 04:00:00	MSFT	Stock	335.65	337.19	334.95	336.76	29868.0
2023-05-30 05:00:00	MSFT	Stock	336.16	336.66	336.0	336.4	23771.0
2023-05-30 06:00:00	MSFT	Stock	336.5	336.8	336.0	336.53	18977.0
2023-05-30 07:00:00	MSFT	Stock	336.54	337.62	336.53	337.37	73040.0
2023-05-30 08:00:00	MSFT	Stock	336.62	338.11	334.68	336.7	148574.0
2023-05-30 09:00:00	MSFT	Stock	336.7	336.8	330.58	331.85	4783163.0
2023-05-30 10:00:00	MSFT	Stock	331.8	334.21	330.59	333.03	3070599.0
2023-05-30 11:00:00	MSFT	Stock	333.04	333.49	331.65	332.455	1671577.0
2023-05-30 12:00:00	MSFT	Stock	332.5063	332.5063	331.3101	332.1859	2076751.0
2023-05-30 13:00:00	MSFT	Stock	332.185	332.59	330.71	330.83	1583263.0
2023-05-30 14:00:00	MSFT	Stock	330.84	333.02	330.53	332.43	1548067.0
2023-05-30 15:00:00	MSFT	Stock	332.43	333.092	330.52	331.22	2681829.0
2023-05-30 16:00:00	MSFT	Stock	331.23	331.58	331.13	331.37	3993554.0
2023-05-30 17:00:00	MSFT	Stock	331.3099	331.41	331.0	331.0006	11926.0
2023-05-30 18:00:00	MSFT	Stock	331.21	331.7525	331.1055	331.61	7232.0
2023-05-30 19:00:00	MSFT	Stock	331.77	333.0	331.77	333.0	13045.0
2023-05-30 04:00:00	NVDA	Stock	39.358	40.395	39.258	40.185	1926590.0
2023-05-30 05:00:00	NVDA	Stock	40.195	40.491	40.195	40.25	775190.0
2023-05-30 06:00:00	NVDA	Stock	40.234	40.383	40.184	40.229	686920.0
2023-05-30 07:00:00	NVDA	Stock	40.237	40.737	40.14	40.702	3842450.0
2023-05-30 08:00:00	NVDA	Stock	40.206	40.937	39.145	40.65	8675210.0
2023-05-30 09:00:00	NVDA	Stock	40.65	41.938	40.267	40.943	155547880.0
2023-05-30 10:00:00	NVDA	Stock	40.93	41.485	40.648	40.856	118136250.0
2023-05-30 11:00:00	NVDA	Stock	40.852	41.415	40.84	41.204	76020120.0
2023-05-30 12:00:00	NVDA	Stock	41.202	41.2213	40.11	40.472	102279500.0
2023-05-30 13:00:00	NVDA	Stock	40.48	40.5751	39.97	40.0095	71813870.0
2023-05-30 14:00:00	NVDA	Stock	40.005	40.348	39.949	40.273	56331250.0
2023-05-30 15:00:00	NVDA	Stock	40.269	40.314	39.95	40.113	68571260.0
2023-05-30 16:00:00	NVDA	Stock	40.113	40.274	40.111	40.1317	28567840.0
2023-05-30 17:00:00	NVDA	Stock	40.132	40.17	39.726	39.757	1365210.0
2023-05-30 18:00:00	NVDA	Stock	39.765	39.995	39.742	39.87	1181670.0
2023-05-30 19:00:00	NVDA	Stock	39.897	39.947	39.795	39.8	554510.0
2023-05-30 04:00:00	AMZN	Stock	121.59	122.15	120.3	121.86	55604.0
2023-05-30 05:00:00	AMZN	Stock	121.99	122.49	121.99	122.27	34858.0

> showing 50 of 61,638 rows — these rows as CSV

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