PREVIEW / stock_1hour / 2023-10-03

all stock 1-hour files

  file:    by_date/stock_1hour/2023/2023-10-03.parquet
  size:    1.3 MB
  rows:    58,645
  symbols: 1,400

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-03 04:00:00	AAPL	Stock	173.23	173.87	173.23	173.8	20209.0
2023-10-03 05:00:00	AAPL	Stock	173.67	173.67	173.23	173.34	5585.0
2023-10-03 06:00:00	AAPL	Stock	173.42	173.69	173.3	173.3	4591.0
2023-10-03 07:00:00	AAPL	Stock	173.33	173.37	172.36	172.75	55540.0
2023-10-03 08:00:00	AAPL	Stock	173.34	173.76	172.03	172.15	132770.0
2023-10-03 09:00:00	AAPL	Stock	172.15	173.63	170.6365	173.27	4870900.0
2023-10-03 10:00:00	AAPL	Stock	173.27	173.3	170.82	171.51	7938819.0
2023-10-03 11:00:00	AAPL	Stock	171.5	171.985	171.36	171.75	4583512.0
2023-10-03 12:00:00	AAPL	Stock	171.7482	172.69	171.69	172.56	4302131.0
2023-10-03 13:00:00	AAPL	Stock	172.55	172.805	171.75	171.97	3479083.0
2023-10-03 14:00:00	AAPL	Stock	171.97	172.4	171.551	172.27	3665810.0
2023-10-03 15:00:00	AAPL	Stock	172.26	172.52	171.78	172.46	7950548.0
2023-10-03 16:00:00	AAPL	Stock	172.47	172.55	172.09	172.13	5519566.0
2023-10-03 17:00:00	AAPL	Stock	172.13	172.2078	172.0	172.05	38370.0
2023-10-03 18:00:00	AAPL	Stock	172.05	172.19	171.94	172.08	30782.0
2023-10-03 19:00:00	AAPL	Stock	172.01	172.01	170.85	170.88	156456.0
2023-10-03 04:00:00	MSFT	Stock	321.5	322.4	321.5	322.1	1000.0
2023-10-03 05:00:00	MSFT	Stock	321.1	321.6	321.1	321.6	557.0
2023-10-03 06:00:00	MSFT	Stock	321.6	321.8	321.44	321.55	2114.0
2023-10-03 07:00:00	MSFT	Stock	321.25	321.25	319.07	319.6	13871.0
2023-10-03 08:00:00	MSFT	Stock	321.15	321.44	318.3026	319.09	36885.0
2023-10-03 09:00:00	MSFT	Stock	319.07	321.39	318.77	320.66	1294590.0
2023-10-03 10:00:00	MSFT	Stock	320.645	320.73	314.21	314.36	2352768.0
2023-10-03 11:00:00	MSFT	Stock	314.34	314.74	313.08	314.3	2222313.0
2023-10-03 12:00:00	MSFT	Stock	314.32	314.5563	313.18	313.7	1275492.0
2023-10-03 13:00:00	MSFT	Stock	313.71	314.21	312.395	312.48	1157673.0
2023-10-03 14:00:00	MSFT	Stock	312.47	313.1299	311.99	312.75	1229078.0
2023-10-03 15:00:00	MSFT	Stock	312.71	313.52	311.215	313.39	2840233.0
2023-10-03 16:00:00	MSFT	Stock	313.39	313.51	313.04	313.15	2971881.0
2023-10-03 17:00:00	MSFT	Stock	313.088	313.1	312.66	312.83	6350.0
2023-10-03 18:00:00	MSFT	Stock	312.79	313.0	312.58	312.95	7568.0
2023-10-03 19:00:00	MSFT	Stock	312.85	313.66	312.7	313.66	10890.0
2023-10-03 04:00:00	NVDA	Stock	44.77	45.128	44.7	45.058	173990.0
2023-10-03 05:00:00	NVDA	Stock	45.033	45.033	44.912	44.95	85840.0
2023-10-03 06:00:00	NVDA	Stock	44.931	45.1	44.931	45.007	127780.0
2023-10-03 07:00:00	NVDA	Stock	45.024	45.024	44.782	44.921	775290.0
2023-10-03 08:00:00	NVDA	Stock	45.001	45.023	44.6	44.62	2719010.0
2023-10-03 09:00:00	NVDA	Stock	44.621	45.13	44.57	44.9948	56186880.0
2023-10-03 10:00:00	NVDA	Stock	45.0025	45.015	43.681	43.724	77466710.0
2023-10-03 11:00:00	NVDA	Stock	43.731	43.936	43.597	43.679	52834870.0
2023-10-03 12:00:00	NVDA	Stock	43.673	44.102	43.638	43.908	41411040.0
2023-10-03 13:00:00	NVDA	Stock	43.908	44.028	43.5048	43.5656	37211200.0
2023-10-03 14:00:00	NVDA	Stock	43.5603	43.672	43.391	43.5889	36668160.0
2023-10-03 15:00:00	NVDA	Stock	43.579	43.71	43.246	43.534	51029250.0
2023-10-03 16:00:00	NVDA	Stock	43.517	43.583	43.4812	43.51	15513020.0
2023-10-03 17:00:00	NVDA	Stock	43.503	43.517	43.32	43.33	498080.0
2023-10-03 18:00:00	NVDA	Stock	43.345	43.425	43.323	43.425	296290.0
2023-10-03 19:00:00	NVDA	Stock	43.38	43.419	43.28	43.39	455870.0
2023-10-03 04:00:00	AMZN	Stock	129.41	129.88	129.41	129.6	6611.0
2023-10-03 05:00:00	AMZN	Stock	129.49	129.49	129.15	129.33	10144.0

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

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