PREVIEW / stock_1hour / 2022-04-20

all stock 1-hour files

  file:    by_date/stock_1hour/2022/2022-04-20.parquet
  size:    1.4 MB
  rows:    63,307
  symbols: 2,494

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-04-20 04:00:00	AAPL	Stock	166.8	167.0	166.31	166.99	17917.0
2022-04-20 05:00:00	AAPL	Stock	167.02	168.0	167.0	167.85	22706.0
2022-04-20 06:00:00	AAPL	Stock	167.71	168.12	167.51	167.74	39479.0
2022-04-20 07:00:00	AAPL	Stock	167.75	169.15	167.56	169.0	128853.0
2022-04-20 08:00:00	AAPL	Stock	167.847	169.15	166.8	169.1	446509.0
2022-04-20 09:00:00	AAPL	Stock	169.11	169.12	166.51	166.7144	8571764.0
2022-04-20 10:00:00	AAPL	Stock	166.67	168.4	166.55	167.79	8843315.0
2022-04-20 11:00:00	AAPL	Stock	167.78	167.82	166.46	166.7761	6331156.0
2022-04-20 12:00:00	AAPL	Stock	166.765	167.285	166.1	167.0814	5291307.0
2022-04-20 13:00:00	AAPL	Stock	167.08	168.08	166.95	167.765	5632309.0
2022-04-20 14:00:00	AAPL	Stock	167.76	167.82	166.45	166.88	5117302.0
2022-04-20 15:00:00	AAPL	Stock	166.88	167.94	166.8267	167.23	12289318.0
2022-04-20 16:00:00	AAPL	Stock	167.23	167.8799	167.18	167.59	6289733.0
2022-04-20 17:00:00	AAPL	Stock	167.53	167.7	167.5	167.68	39992.0
2022-04-20 18:00:00	AAPL	Stock	167.54	167.85	167.53	167.66	32533.0
2022-04-20 19:00:00	AAPL	Stock	167.66	167.99	167.65	167.93	55740.0
2022-04-20 04:00:00	MSFT	Stock	283.44	284.77	283.3	284.77	10334.0
2022-04-20 05:00:00	MSFT	Stock	284.78	286.47	284.66	286.34	10363.0
2022-04-20 06:00:00	MSFT	Stock	286.2	286.3	285.42	286.3	10270.0
2022-04-20 07:00:00	MSFT	Stock	286.03	288.88	285.85	288.55	40777.0
2022-04-20 08:00:00	MSFT	Stock	286.0	288.88	284.15	288.27	67985.0
2022-04-20 09:00:00	MSFT	Stock	288.2	289.98	285.98	286.4	2585633.0
2022-04-20 10:00:00	MSFT	Stock	286.38	288.89	285.8	288.085	2117051.0
2022-04-20 11:00:00	MSFT	Stock	288.08	288.13	286.22	287.17	1666756.0
2022-04-20 12:00:00	MSFT	Stock	287.21	287.38	285.3702	286.48	1323501.0
2022-04-20 13:00:00	MSFT	Stock	286.46	288.01	286.11	287.57	1084292.0
2022-04-20 14:00:00	MSFT	Stock	287.55	287.98	285.52	286.09	1301428.0
2022-04-20 15:00:00	MSFT	Stock	286.1	288.1199	286.03	286.36	3204062.0
2022-04-20 16:00:00	MSFT	Stock	286.33	287.98	286.2	287.19	2931754.0
2022-04-20 17:00:00	MSFT	Stock	287.18	287.26	286.7	286.8	33363.0
2022-04-20 18:00:00	MSFT	Stock	286.51	287.34	286.5	287.01	28185.0
2022-04-20 19:00:00	MSFT	Stock	286.76	287.34	286.75	287.25	10728.0
2022-04-20 04:00:00	NVDA	Stock	21.988	22.258	21.9	22.233	276710.0
2022-04-20 05:00:00	NVDA	Stock	22.259	22.39	22.226	22.373	219230.0
2022-04-20 06:00:00	NVDA	Stock	22.375	22.4	22.303	22.375	177640.0
2022-04-20 07:00:00	NVDA	Stock	22.344	22.497	22.28	22.496	542940.0
2022-04-20 08:00:00	NVDA	Stock	22.278	22.55	21.87	22.548	1741730.0
2022-04-20 09:00:00	NVDA	Stock	22.55	22.6704	21.789	21.796	58101030.0
2022-04-20 10:00:00	NVDA	Stock	21.797	21.8961	21.4741	21.803	63723470.0
2022-04-20 11:00:00	NVDA	Stock	21.808	21.81	21.321	21.3545	41073940.0
2022-04-20 12:00:00	NVDA	Stock	21.356	21.514	21.2	21.431	45078450.0
2022-04-20 13:00:00	NVDA	Stock	21.429	21.649	21.423	21.558	38979490.0
2022-04-20 14:00:00	NVDA	Stock	21.5525	21.6088	21.283	21.348	31939670.0
2022-04-20 15:00:00	NVDA	Stock	21.342	21.657	21.334	21.482	54462570.0
2022-04-20 16:00:00	NVDA	Stock	21.481	21.65	21.481	21.5539	14549620.0
2022-04-20 17:00:00	NVDA	Stock	21.553	21.6288	21.55	21.62	318740.0
2022-04-20 18:00:00	NVDA	Stock	21.605	21.645	21.605	21.624	249410.0
2022-04-20 19:00:00	NVDA	Stock	21.63	21.655	21.61	21.622	278700.0
2022-04-20 04:00:00	AMZN	Stock	156.8	156.8625	156.8	156.8625	4000.0
2022-04-20 05:00:00	AMZN	Stock	157.15	157.15	157.0	157.1	12620.0

> showing 50 of 63,307 rows — these rows as CSV

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