PREVIEW / stock_1hour / 2023-04-21

all stock 1-hour files

  file:    by_date/stock_1hour/2023/2023-04-21.parquet
  size:    1.3 MB
  rows:    58,726
  symbols: 1,667

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-04-21 04:00:00	AAPL	Stock	166.68	166.68	166.32	166.58	8269.0
2023-04-21 05:00:00	AAPL	Stock	166.6	166.66	166.5	166.61	2711.0
2023-04-21 06:00:00	AAPL	Stock	166.57	166.57	162.99	163.77	215195.0
2023-04-21 07:00:00	AAPL	Stock	163.97	164.49	163.89	164.0	260471.0
2023-04-21 08:00:00	AAPL	Stock	164.35	166.44	163.8	164.62	390277.0
2023-04-21 09:00:00	AAPL	Stock	164.62	166.4521	164.41	164.9	10443296.0
2023-04-21 10:00:00	AAPL	Stock	164.895	165.68	164.49	165.01	7661123.0
2023-04-21 11:00:00	AAPL	Stock	165.02	165.42	164.71	165.22	4790040.0
2023-04-21 12:00:00	AAPL	Stock	165.22	165.24	164.745	164.9	3253460.0
2023-04-21 13:00:00	AAPL	Stock	164.895	165.21	164.68	165.075	3852138.0
2023-04-21 14:00:00	AAPL	Stock	165.075	165.365	164.88	165.035	4071148.0
2023-04-21 15:00:00	AAPL	Stock	165.0328	165.065	164.69	165.02	6571841.0
2023-04-21 16:00:00	AAPL	Stock	165.02	165.07	164.97	164.98	5763949.0
2023-04-21 17:00:00	AAPL	Stock	164.98	165.02	164.95	164.95	292814.0
2023-04-21 18:00:00	AAPL	Stock	164.9501	165.0	164.91	164.91	13983.0
2023-04-21 19:00:00	AAPL	Stock	164.9	165.0	164.9	164.9201	7949.0
2023-04-21 04:00:00	MSFT	Stock	286.48	286.48	286.08	286.35	2930.0
2023-04-21 05:00:00	MSFT	Stock	286.45	286.7	286.3	286.7	3062.0
2023-04-21 06:00:00	MSFT	Stock	285.86	286.0	285.41	285.41	4892.0
2023-04-21 07:00:00	MSFT	Stock	285.5	285.62	283.35	283.58	29368.0
2023-04-21 08:00:00	MSFT	Stock	285.66	286.45	283.3	285.15	58304.0
2023-04-21 09:00:00	MSFT	Stock	285.39	285.53	283.0608	283.19	2851476.0
2023-04-21 10:00:00	MSFT	Stock	283.18	285.24	283.08	284.15	2499381.0
2023-04-21 11:00:00	MSFT	Stock	284.18	285.89	284.18	285.62	1787583.0
2023-04-21 12:00:00	MSFT	Stock	285.62	285.94	284.79	285.09	1038023.0
2023-04-21 13:00:00	MSFT	Stock	285.07	285.88	284.81	285.76	1116452.0
2023-04-21 14:00:00	MSFT	Stock	285.77	286.27	285.45	285.61	1149136.0
2023-04-21 15:00:00	MSFT	Stock	285.6	285.92	285.01	285.79	2049024.0
2023-04-21 16:00:00	MSFT	Stock	285.8	285.84	285.51	285.59	2979413.0
2023-04-21 17:00:00	MSFT	Stock	285.75	285.78	285.61	285.78	104678.0
2023-04-21 18:00:00	MSFT	Stock	285.78	285.8499	285.35	285.35	2511.0
2023-04-21 19:00:00	MSFT	Stock	285.35	285.38	285.0	285.34	5681.0
2023-04-21 04:00:00	NVDA	Stock	27.105	27.137	27.06	27.07	162170.0
2023-04-21 05:00:00	NVDA	Stock	27.075	27.077	26.89	26.98	218910.0
2023-04-21 06:00:00	NVDA	Stock	26.979	26.979	26.877	26.878	75750.0
2023-04-21 07:00:00	NVDA	Stock	26.925	27.0	26.9	26.962	520180.0
2023-04-21 08:00:00	NVDA	Stock	27.16	27.171	26.8752	27.05	1180970.0
2023-04-21 09:00:00	NVDA	Stock	27.048	27.122	26.7552	26.76	43361800.0
2023-04-21 10:00:00	NVDA	Stock	26.76	27.093	26.722	26.946	51254740.0
2023-04-21 11:00:00	NVDA	Stock	26.948	27.142	26.923	27.062	36454480.0
2023-04-21 12:00:00	NVDA	Stock	27.068	27.1184	26.986	27.049	24517550.0
2023-04-21 13:00:00	NVDA	Stock	27.049	27.144	26.861	27.0485	42377600.0
2023-04-21 14:00:00	NVDA	Stock	27.051	27.091	26.951	26.995	17643900.0
2023-04-21 15:00:00	NVDA	Stock	26.994	27.183	26.923	27.125	35472810.0
2023-04-21 16:00:00	NVDA	Stock	27.109	27.125	27.084	27.11	14601180.0
2023-04-21 17:00:00	NVDA	Stock	27.11	27.1444	27.106	27.134	133950.0
2023-04-21 18:00:00	NVDA	Stock	27.134	27.135	27.12	27.131	77390.0
2023-04-21 19:00:00	NVDA	Stock	27.135	27.15	27.1	27.144	173070.0
2023-04-21 04:00:00	AMZN	Stock	103.88	103.97	103.5	103.79	12456.0
2023-04-21 05:00:00	AMZN	Stock	103.85	104.01	103.72	103.99	15082.0

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

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