PREVIEW / stock_1hour / 2023-07-24

all stock 1-hour files

  file:    by_date/stock_1hour/2023/2023-07-24.parquet
  size:    1.4 MB
  rows:    60,487
  symbols: 1,561

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-07-24 04:00:00	AAPL	Stock	192.6	192.6	192.3	192.47	5047.0
2023-07-24 05:00:00	AAPL	Stock	192.59	192.75	192.5	192.5	3969.0
2023-07-24 06:00:00	AAPL	Stock	192.49	193.26	192.36	193.0	33807.0
2023-07-24 07:00:00	AAPL	Stock	193.02	193.14	192.77	192.93	96864.0
2023-07-24 08:00:00	AAPL	Stock	192.9	193.13	191.9	192.7	159771.0
2023-07-24 09:00:00	AAPL	Stock	192.77	194.91	192.53	193.51	7206118.0
2023-07-24 10:00:00	AAPL	Stock	193.51	193.83	192.96	193.38	4784295.0
2023-07-24 11:00:00	AAPL	Stock	193.38	193.74	192.83	193.12	3275653.0
2023-07-24 12:00:00	AAPL	Stock	193.12	193.4201	192.89	193.06	2444767.0
2023-07-24 13:00:00	AAPL	Stock	193.065	193.11	192.765	192.966	2343358.0
2023-07-24 14:00:00	AAPL	Stock	192.98	193.4599	192.595	192.76	3279481.0
2023-07-24 15:00:00	AAPL	Stock	192.7529	192.88	192.25	192.735	4383519.0
2023-07-24 16:00:00	AAPL	Stock	192.75	192.95	192.66	192.85	5444644.0
2023-07-24 17:00:00	AAPL	Stock	192.83	192.85	192.75	192.82	12645.0
2023-07-24 18:00:00	AAPL	Stock	192.81	192.82	192.76	192.82	11720.0
2023-07-24 19:00:00	AAPL	Stock	192.83	193.68	192.76	193.45	98379.0
2023-07-24 04:00:00	MSFT	Stock	345.7	346.83	345.7	345.81	7761.0
2023-07-24 05:00:00	MSFT	Stock	345.82	346.24	345.76	346.2	8251.0
2023-07-24 06:00:00	MSFT	Stock	345.92	346.25	345.5	345.5	6940.0
2023-07-24 07:00:00	MSFT	Stock	345.5	346.46	345.27	346.06	26743.0
2023-07-24 08:00:00	MSFT	Stock	345.45	346.4312	344.46	345.9999	63515.0
2023-07-24 09:00:00	MSFT	Stock	346.0101	346.92	342.31	343.58	3198385.0
2023-07-24 10:00:00	MSFT	Stock	343.575	346.49	343.33	344.32	2854452.0
2023-07-24 11:00:00	MSFT	Stock	344.33	346.24	343.29	344.15	2185040.0
2023-07-24 12:00:00	MSFT	Stock	344.17	345.03	343.6417	343.9105	1136702.0
2023-07-24 13:00:00	MSFT	Stock	343.905	346.01	343.685	345.8882	1309526.0
2023-07-24 14:00:00	MSFT	Stock	345.89	346.23	344.11	344.75	1498252.0
2023-07-24 15:00:00	MSFT	Stock	344.77	345.26	344.11	345.16	2162660.0
2023-07-24 16:00:00	MSFT	Stock	345.16	346.24	345.02	346.24	2631750.0
2023-07-24 17:00:00	MSFT	Stock	346.22	346.63	345.11	346.0	39660.0
2023-07-24 18:00:00	MSFT	Stock	346.02	346.15	345.7802	346.0	9375.0
2023-07-24 19:00:00	MSFT	Stock	346.12	346.35	345.8	346.3	19206.0
2023-07-24 04:00:00	NVDA	Stock	44.6	44.666	44.465	44.64	116550.0
2023-07-24 05:00:00	NVDA	Stock	44.65	44.874	44.65	44.725	152530.0
2023-07-24 06:00:00	NVDA	Stock	44.69	44.9	44.69	44.85	234870.0
2023-07-24 07:00:00	NVDA	Stock	44.851	44.908	44.68	44.735	513060.0
2023-07-24 08:00:00	NVDA	Stock	44.8801	44.92	44.37	44.65	1452440.0
2023-07-24 09:00:00	NVDA	Stock	44.658	44.885	44.04	44.33	53603860.0
2023-07-24 10:00:00	NVDA	Stock	44.317	44.777	44.22	44.635	55097710.0
2023-07-24 11:00:00	NVDA	Stock	44.63	45.109	44.512	44.92	44829440.0
2023-07-24 12:00:00	NVDA	Stock	44.908	45.024	44.52	44.5507	29549910.0
2023-07-24 13:00:00	NVDA	Stock	44.5447	44.86	44.46	44.841	24908430.0
2023-07-24 14:00:00	NVDA	Stock	44.8351	44.919	44.541	44.7295	21500440.0
2023-07-24 15:00:00	NVDA	Stock	44.7305	44.739	44.363	44.614	32725010.0
2023-07-24 16:00:00	NVDA	Stock	44.615	44.635	44.53	44.6	19273370.0
2023-07-24 17:00:00	NVDA	Stock	44.609	44.616	44.599	44.614	132030.0
2023-07-24 18:00:00	NVDA	Stock	44.609	44.639	44.603	44.622	133270.0
2023-07-24 19:00:00	NVDA	Stock	44.628	44.7	44.61	44.657	300630.0
2023-07-24 04:00:00	AMZN	Stock	130.37	130.47	130.25	130.37	12467.0
2023-07-24 05:00:00	AMZN	Stock	130.44	130.5	130.39	130.39	6277.0

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

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