PREVIEW / stock_1hour / 2023-02-21

all stock 1-hour files

  file:    by_date/stock_1hour/2023/2023-02-21.parquet
  size:    1.4 MB
  rows:    62,361
  symbols: 1,851

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-02-21 04:00:00	AAPL	Stock	150.86	151.22	150.22	151.1	57589.0
2023-02-21 05:00:00	AAPL	Stock	150.97	150.97	150.41	150.51	27526.0
2023-02-21 06:00:00	AAPL	Stock	150.5	150.9	150.45	150.75	15501.0
2023-02-21 07:00:00	AAPL	Stock	150.8	151.02	150.53	150.66	51173.0
2023-02-21 08:00:00	AAPL	Stock	150.5499	151.77	150.2912	150.45	209970.0
2023-02-21 09:00:00	AAPL	Stock	150.44	151.3	150.08	150.36	6757287.0
2023-02-21 10:00:00	AAPL	Stock	150.36	150.61	149.6	149.9115	7376553.0
2023-02-21 11:00:00	AAPL	Stock	149.93	150.06	149.36	149.8001	4421167.0
2023-02-21 12:00:00	AAPL	Stock	149.8	150.15	149.62	150.02	3550903.0
2023-02-21 13:00:00	AAPL	Stock	150.01	150.0334	149.29	149.4039	3442543.0
2023-02-21 14:00:00	AAPL	Stock	149.41	149.41	148.565	148.67	4432834.0
2023-02-21 15:00:00	AAPL	Stock	148.675	148.94	148.405	148.48	7831798.0
2023-02-21 16:00:00	AAPL	Stock	148.48	148.69	148.43	148.51	11462671.0
2023-02-21 17:00:00	AAPL	Stock	148.5	148.59	148.48	148.55	128205.0
2023-02-21 18:00:00	AAPL	Stock	148.56	148.88	148.53	148.8	68942.0
2023-02-21 19:00:00	AAPL	Stock	148.82	148.88	148.65	148.72	35120.0
2023-02-21 04:00:00	MSFT	Stock	255.5	256.98	254.7	256.55	20050.0
2023-02-21 05:00:00	MSFT	Stock	256.2	256.2	255.72	256.0	2385.0
2023-02-21 06:00:00	MSFT	Stock	255.81	256.6	255.81	255.99	1948.0
2023-02-21 07:00:00	MSFT	Stock	256.09	256.47	255.17	256.02	13475.0
2023-02-21 08:00:00	MSFT	Stock	255.683	257.93	255.17	255.36	41149.0
2023-02-21 09:00:00	MSFT	Stock	255.42	255.69	253.85	254.2	2771039.0
2023-02-21 10:00:00	MSFT	Stock	254.16	254.5	252.84	253.29	2650794.0
2023-02-21 11:00:00	MSFT	Stock	253.3	253.64	251.81	251.86	1958014.0
2023-02-21 12:00:00	MSFT	Stock	251.86	252.47	251.59	252.42	1713688.0
2023-02-21 13:00:00	MSFT	Stock	252.41	252.89	252.19	252.7836	1430016.0
2023-02-21 14:00:00	MSFT	Stock	252.82	252.98	252.21	252.54	1658872.0
2023-02-21 15:00:00	MSFT	Stock	252.57	252.92	251.81	252.68	3445570.0
2023-02-21 16:00:00	MSFT	Stock	252.67	253.35	252.3	252.99	6278017.0
2023-02-21 17:00:00	MSFT	Stock	252.97	252.97	252.6	252.6	43399.0
2023-02-21 18:00:00	MSFT	Stock	252.7	253.0	252.31	253.0	10539.0
2023-02-21 19:00:00	MSFT	Stock	252.86	253.22	252.67	252.9	5768.0
2023-02-21 04:00:00	NVDA	Stock	21.383	21.383	21.041	21.055	853530.0
2023-02-21 05:00:00	NVDA	Stock	21.07	21.122	21.039	21.072	153630.0
2023-02-21 06:00:00	NVDA	Stock	21.061	21.15	21.061	21.14	91090.0
2023-02-21 07:00:00	NVDA	Stock	21.11	21.165	21.06	21.105	296910.0
2023-02-21 08:00:00	NVDA	Stock	21.118	21.388	21.0	21.0	1242060.0
2023-02-21 09:00:00	NVDA	Stock	20.991	21.4938	20.941	21.186	55243620.0
2023-02-21 10:00:00	NVDA	Stock	21.186	21.233	20.941	21.073	61442360.0
2023-02-21 11:00:00	NVDA	Stock	21.071	21.128	20.8791	20.891	41356510.0
2023-02-21 12:00:00	NVDA	Stock	20.891	21.058	20.8467	21.0409	30043370.0
2023-02-21 13:00:00	NVDA	Stock	21.0405	21.059	20.87	20.893	19700120.0
2023-02-21 14:00:00	NVDA	Stock	20.894	20.924	20.727	20.75	29728770.0
2023-02-21 15:00:00	NVDA	Stock	20.751	20.8349	20.618	20.657	51516730.0
2023-02-21 16:00:00	NVDA	Stock	20.655	20.706	20.654	20.682	42286660.0
2023-02-21 17:00:00	NVDA	Stock	20.682	20.682	20.6	20.6061	377730.0
2023-02-21 18:00:00	NVDA	Stock	20.621	20.64	20.53	20.59	472340.0
2023-02-21 19:00:00	NVDA	Stock	20.598	20.655	20.598	20.62	312980.0
2023-02-21 04:00:00	AMZN	Stock	96.0	97.03	95.77	96.2	54204.0
2023-02-21 05:00:00	AMZN	Stock	96.12	96.18	95.92	95.98	16231.0

> showing 50 of 62,361 rows — these rows as CSV

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