PREVIEW / stock_1hour / 2022-09-08

all stock 1-hour files

  file:    by_date/stock_1hour/2022/2022-09-08.parquet
  size:    1.3 MB
  rows:    61,118
  symbols: 2,207

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
2022-09-08 04:00:00	AAPL	Stock	156.4	156.4	155.4	156.08	41002.0
2022-09-08 05:00:00	AAPL	Stock	156.1	156.15	155.9	156.07	8748.0
2022-09-08 06:00:00	AAPL	Stock	156.07	156.39	156.0	156.33	7353.0
2022-09-08 07:00:00	AAPL	Stock	156.31	156.38	155.3	155.6	83809.0
2022-09-08 08:00:00	AAPL	Stock	156.33	159.0	154.52	154.71	404984.0
2022-09-08 09:00:00	AAPL	Stock	154.7	155.84	154.02	155.39	9349500.0
2022-09-08 10:00:00	AAPL	Stock	155.4	155.7961	154.37	155.76	10295720.0
2022-09-08 11:00:00	AAPL	Stock	155.77	156.36	155.38	155.52	6793252.0
2022-09-08 12:00:00	AAPL	Stock	155.53	155.675	152.68	153.182	12628835.0
2022-09-08 13:00:00	AAPL	Stock	153.19	154.14	152.695	153.55	8250233.0
2022-09-08 14:00:00	AAPL	Stock	153.55	154.41	153.37	153.8	5951471.0
2022-09-08 15:00:00	AAPL	Stock	153.81	154.47	153.48	154.47	11261712.0
2022-09-08 16:00:00	AAPL	Stock	154.41	154.6	154.04	154.45	6988603.0
2022-09-08 17:00:00	AAPL	Stock	154.45	154.52	154.36	154.49	103258.0
2022-09-08 18:00:00	AAPL	Stock	154.45	154.45	154.26	154.4	43407.0
2022-09-08 19:00:00	AAPL	Stock	154.38	154.69	154.3	154.6	58916.0
2022-09-08 04:00:00	MSFT	Stock	258.08	258.25	257.61	258.25	2080.0
2022-09-08 07:00:00	MSFT	Stock	258.6	258.7	258.0	258.0	9165.0
2022-09-08 08:00:00	MSFT	Stock	258.65	259.75	256.6	256.65	23269.0
2022-09-08 09:00:00	MSFT	Stock	257.1	258.46	255.5	257.84	2072344.0
2022-09-08 10:00:00	MSFT	Stock	257.87	259.72	256.3901	259.7	2020379.0
2022-09-08 11:00:00	MSFT	Stock	259.69	260.43	258.74	258.83	1427832.0
2022-09-08 12:00:00	MSFT	Stock	258.83	258.98	254.79	256.28	1795995.0
2022-09-08 13:00:00	MSFT	Stock	256.3	257.9	255.4564	256.84	1030863.0
2022-09-08 14:00:00	MSFT	Stock	256.85	257.82	256.3	256.69	857931.0
2022-09-08 15:00:00	MSFT	Stock	256.695	258.65	256.06	258.54	2053867.0
2022-09-08 16:00:00	MSFT	Stock	258.55	259.32	258.39	259.3	3456901.0
2022-09-08 17:00:00	MSFT	Stock	259.31	259.4	259.1424	259.25	9466.0
2022-09-08 18:00:00	MSFT	Stock	259.15	259.25	259.15	259.2	4293.0
2022-09-08 19:00:00	MSFT	Stock	259.29	259.77	259.2	259.72	4809.0
2022-09-08 04:00:00	NVDA	Stock	13.684	13.744	13.671	13.726	84560.0
2022-09-08 05:00:00	NVDA	Stock	13.724	13.732	13.72	13.72	7740.0
2022-09-08 06:00:00	NVDA	Stock	13.72	13.773	13.72	13.773	38720.0
2022-09-08 07:00:00	NVDA	Stock	13.755	13.78	13.731	13.755	253340.0
2022-09-08 08:00:00	NVDA	Stock	13.753	13.82	13.603	13.6462	1473060.0
2022-09-08 09:00:00	NVDA	Stock	13.63	13.7837	13.369	13.699	77163210.0
2022-09-08 10:00:00	NVDA	Stock	13.701	13.885	13.5738	13.869	92441500.0
2022-09-08 11:00:00	NVDA	Stock	13.8685	14.008	13.84	13.879	77300230.0
2022-09-08 12:00:00	NVDA	Stock	13.879	13.892	13.613	13.776	73114110.0
2022-09-08 13:00:00	NVDA	Stock	13.777	13.925	13.692	13.826	56175940.0
2022-09-08 14:00:00	NVDA	Stock	13.826	13.878	13.777	13.827	45694510.0
2022-09-08 15:00:00	NVDA	Stock	13.83	13.995	13.78	13.991	66365970.0
2022-09-08 16:00:00	NVDA	Stock	13.99	14.05	13.974	14.019	19016190.0
2022-09-08 17:00:00	NVDA	Stock	14.023	14.032	14.008	14.015	125250.0
2022-09-08 18:00:00	NVDA	Stock	14.021	14.028	14.008	14.018	87870.0
2022-09-08 19:00:00	NVDA	Stock	14.018	14.057	14.01	14.053	360900.0
2022-09-08 04:00:00	AMZN	Stock	128.61	129.51	128.61	129.18	10371.0
2022-09-08 05:00:00	AMZN	Stock	129.13	129.24	129.13	129.24	550.0
2022-09-08 06:00:00	AMZN	Stock	129.17	129.45	129.15	129.29	3089.0
2022-09-08 07:00:00	AMZN	Stock	129.28	129.64	129.24	129.49	29153.0

> showing 50 of 61,118 rows — these rows as CSV

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