PREVIEW / stock_1hour / 2023-06-01

all stock 1-hour files

  file:    by_date/stock_1hour/2023/2023-06-01.parquet
  size:    1.3 MB
  rows:    60,111
  symbols: 1,643

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-01 04:00:00	AAPL	Stock	177.8	177.95	177.35	177.95	15877.0
2023-06-01 05:00:00	AAPL	Stock	177.94	177.94	177.56	177.73	17984.0
2023-06-01 06:00:00	AAPL	Stock	177.72	177.93	177.72	177.75	15632.0
2023-06-01 07:00:00	AAPL	Stock	177.76	178.18	177.67	177.83	41876.0
2023-06-01 08:00:00	AAPL	Stock	177.8403	178.18	177.06	177.63	180824.0
2023-06-01 09:00:00	AAPL	Stock	177.6	177.96	176.9306	177.31	5696771.0
2023-06-01 10:00:00	AAPL	Stock	177.32	179.285	177.28	178.95	7954254.0
2023-06-01 11:00:00	AAPL	Stock	178.96	179.645	178.77	179.58	6235677.0
2023-06-01 12:00:00	AAPL	Stock	179.58	180.0	179.58	179.9001	4779110.0
2023-06-01 13:00:00	AAPL	Stock	179.91	180.0	179.465	179.89	5390257.0
2023-06-01 14:00:00	AAPL	Stock	179.885	180.12	179.56	179.8192	6448898.0
2023-06-01 15:00:00	AAPL	Stock	179.8191	180.12	179.22	180.1	9633050.0
2023-06-01 16:00:00	AAPL	Stock	180.1	180.49	180.01	180.4	8877091.0
2023-06-01 17:00:00	AAPL	Stock	180.3812	180.59	180.38	180.49	93106.0
2023-06-01 18:00:00	AAPL	Stock	180.49	180.59	180.44	180.54	22176.0
2023-06-01 19:00:00	AAPL	Stock	180.54	180.68	180.46	180.49	49424.0
2023-06-01 04:00:00	MSFT	Stock	328.96	329.2	327.46	327.8	8447.0
2023-06-01 05:00:00	MSFT	Stock	327.96	327.97	327.2	327.7	2736.0
2023-06-01 06:00:00	MSFT	Stock	327.7	328.0	327.58	327.88	2839.0
2023-06-01 07:00:00	MSFT	Stock	328.01	329.1	327.88	327.88	7984.0
2023-06-01 08:00:00	MSFT	Stock	329.09	329.2599	326.08	327.75	40283.0
2023-06-01 09:00:00	MSFT	Stock	327.55	328.47	324.72	327.895	2562167.0
2023-06-01 10:00:00	MSFT	Stock	327.94	329.0	326.42	328.38	1980069.0
2023-06-01 11:00:00	MSFT	Stock	328.42	330.2	328.01	330.15	1750086.0
2023-06-01 12:00:00	MSFT	Stock	330.17	331.34	330.17	330.92	1334634.0
2023-06-01 13:00:00	MSFT	Stock	330.97	331.72	330.4299	331.7	1426370.0
2023-06-01 14:00:00	MSFT	Stock	331.71	333.35	331.42	333.03	1877728.0
2023-06-01 15:00:00	MSFT	Stock	333.03	333.53	331.23	332.63	2956080.0
2023-06-01 16:00:00	MSFT	Stock	332.64	333.29	332.5588	333.005	3749226.0
2023-06-01 17:00:00	MSFT	Stock	333.01	333.24	333.0	333.0	7979.0
2023-06-01 18:00:00	MSFT	Stock	333.1	333.3898	333.015	333.05	5451.0
2023-06-01 19:00:00	MSFT	Stock	333.05	333.33	332.9	333.21	3791.0
2023-06-01 04:00:00	NVDA	Stock	38.002	38.389	38.002	38.366	364640.0
2023-06-01 05:00:00	NVDA	Stock	38.342	38.4	38.292	38.39	167540.0
2023-06-01 06:00:00	NVDA	Stock	38.395	38.54	38.271	38.282	566790.0
2023-06-01 07:00:00	NVDA	Stock	38.3	38.345	38.108	38.15	705860.0
2023-06-01 08:00:00	NVDA	Stock	38.281	38.345	37.9	38.227	2196300.0
2023-06-01 09:00:00	NVDA	Stock	38.21	39.2	38.182	39.1412	83590500.0
2023-06-01 10:00:00	NVDA	Stock	39.158	39.289	38.527	39.0725	79553240.0
2023-06-01 11:00:00	NVDA	Stock	39.072	39.5	39.042	39.42	56516550.0
2023-06-01 12:00:00	NVDA	Stock	39.423	39.635	39.364	39.6275	47360260.0
2023-06-01 13:00:00	NVDA	Stock	39.63	39.938	39.5806	39.8645	54501350.0
2023-06-01 14:00:00	NVDA	Stock	39.8696	40.05	39.743	39.8945	46995250.0
2023-06-01 15:00:00	NVDA	Stock	39.897	39.99	39.473	39.774	61948940.0
2023-06-01 16:00:00	NVDA	Stock	39.767	39.929	39.723	39.92	25459960.0
2023-06-01 17:00:00	NVDA	Stock	39.92	40.0399	39.873	39.92	1219310.0
2023-06-01 18:00:00	NVDA	Stock	39.91	39.94	39.846	39.895	363680.0
2023-06-01 19:00:00	NVDA	Stock	39.8952	39.99	39.895	39.96	526380.0
2023-06-01 04:00:00	AMZN	Stock	120.58	120.81	120.24	120.7	8239.0
2023-06-01 05:00:00	AMZN	Stock	120.66	120.7	120.55	120.55	4098.0

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

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