PREVIEW / stock_1hour / 2023-07-18

all stock 1-hour files

  file:    by_date/stock_1hour/2023/2023-07-18.parquet
  size:    1.4 MB
  rows:    60,618
  symbols: 1,540

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-18 04:00:00	AAPL	Stock	193.82	193.94	193.71	193.73	9452.0
2023-07-18 05:00:00	AAPL	Stock	193.77	193.81	193.74	193.78	3859.0
2023-07-18 06:00:00	AAPL	Stock	193.81	193.81	193.67	193.81	4221.0
2023-07-18 07:00:00	AAPL	Stock	193.89	193.92	193.72	193.75	29179.0
2023-07-18 08:00:00	AAPL	Stock	193.82	194.35	193.42	193.68	208530.0
2023-07-18 09:00:00	AAPL	Stock	193.74	193.8	192.795	193.3201	5283185.0
2023-07-18 10:00:00	AAPL	Stock	193.325	193.57	192.8	193.365	5244920.0
2023-07-18 11:00:00	AAPL	Stock	193.37	193.655	192.76	193.2	4788071.0
2023-07-18 12:00:00	AAPL	Stock	193.2001	193.245	192.415	192.52	4569508.0
2023-07-18 13:00:00	AAPL	Stock	192.51	193.17	192.5	192.985	2591692.0
2023-07-18 14:00:00	AAPL	Stock	192.99	193.97	192.95	193.7899	4019004.0
2023-07-18 15:00:00	AAPL	Stock	193.7925	194.33	193.5314	193.73	8301922.0
2023-07-18 16:00:00	AAPL	Stock	193.73	193.73	193.3	193.33	5409906.0
2023-07-18 17:00:00	AAPL	Stock	193.35	193.4	193.32	193.38	24780.0
2023-07-18 18:00:00	AAPL	Stock	193.3512	193.73	193.3512	193.41	26965.0
2023-07-18 19:00:00	AAPL	Stock	193.47	193.47	193.34	193.41	31743.0
2023-07-18 04:00:00	MSFT	Stock	344.9	345.31	344.3	344.53	2512.0
2023-07-18 05:00:00	MSFT	Stock	344.55	344.55	344.16	344.23	1242.0
2023-07-18 06:00:00	MSFT	Stock	344.75	346.0	344.75	346.0	5574.0
2023-07-18 07:00:00	MSFT	Stock	345.72	346.16	345.43	345.91	10365.0
2023-07-18 08:00:00	MSFT	Stock	345.48	347.0	344.55	345.7	64599.0
2023-07-18 09:00:00	MSFT	Stock	346.0	346.79	342.17	343.37	2474524.0
2023-07-18 10:00:00	MSFT	Stock	343.39	344.53	342.62	344.3645	2015781.0
2023-07-18 11:00:00	MSFT	Stock	344.37	358.95	344.02	357.165	10853347.0
2023-07-18 12:00:00	MSFT	Stock	357.19	366.78	356.6	362.58	13931462.0
2023-07-18 13:00:00	MSFT	Stock	362.5974	365.0	362.5	363.94	5019609.0
2023-07-18 14:00:00	MSFT	Stock	363.97	365.5	363.85	364.08	3315421.0
2023-07-18 15:00:00	MSFT	Stock	364.07	364.56	359.46	359.525	7619542.0
2023-07-18 16:00:00	MSFT	Stock	359.54	359.89	358.5	358.63	4262848.0
2023-07-18 17:00:00	MSFT	Stock	358.67	358.9	358.2	358.59	24657.0
2023-07-18 18:00:00	MSFT	Stock	358.4617	360.15	358.4617	360.15	44278.0
2023-07-18 19:00:00	MSFT	Stock	360.15	360.98	360.0	360.7	55701.0
2023-07-18 04:00:00	NVDA	Stock	46.68	46.742	46.66	46.675	72240.0
2023-07-18 05:00:00	NVDA	Stock	46.7	46.7	46.631	46.694	29600.0
2023-07-18 06:00:00	NVDA	Stock	46.7	46.718	46.661	46.705	63680.0
2023-07-18 07:00:00	NVDA	Stock	46.709	46.953	46.709	46.884	803120.0
2023-07-18 08:00:00	NVDA	Stock	46.74	46.953	46.606	46.7	2276140.0
2023-07-18 09:00:00	NVDA	Stock	46.73	46.795	45.734	46.171	62783040.0
2023-07-18 10:00:00	NVDA	Stock	46.163	46.27	45.845	45.9788	56846740.0
2023-07-18 11:00:00	NVDA	Stock	45.9815	46.928	45.905	46.82	71123390.0
2023-07-18 12:00:00	NVDA	Stock	46.809	47.533	46.756	47.277	68203980.0
2023-07-18 13:00:00	NVDA	Stock	47.2849	47.634	47.2287	47.552	42354610.0
2023-07-18 14:00:00	NVDA	Stock	47.552	47.845	47.361	47.8423	44911200.0
2023-07-18 15:00:00	NVDA	Stock	47.839	47.896	47.472	47.5	65176950.0
2023-07-18 16:00:00	NVDA	Stock	47.494	47.512	47.2691	47.3001	18440780.0
2023-07-18 17:00:00	NVDA	Stock	47.3	47.494	47.275	47.345	362470.0
2023-07-18 18:00:00	NVDA	Stock	47.344	47.375	47.33	47.35	374040.0
2023-07-18 19:00:00	NVDA	Stock	47.348	47.37	47.3	47.355	443920.0
2023-07-18 04:00:00	AMZN	Stock	133.5	133.57	133.25	133.28	12933.0
2023-07-18 05:00:00	AMZN	Stock	133.44	133.5	133.3	133.5	3632.0

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

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