PREVIEW / stock_1hour / 2023-03-10

all stock 1-hour files

  file:    by_date/stock_1hour/2023/2023-03-10.parquet
  size:    1.4 MB
  rows:    62,328
  symbols: 1,792

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-03-10 04:00:00	AAPL	Stock	150.29	150.91	149.77	150.64	18436.0
2023-03-10 05:00:00	AAPL	Stock	150.58	150.95	150.51	150.51	10826.0
2023-03-10 06:00:00	AAPL	Stock	150.48	150.5	149.01	150.06	66583.0
2023-03-10 07:00:00	AAPL	Stock	150.02	150.81	150.01	150.64	51432.0
2023-03-10 08:00:00	AAPL	Stock	150.3	152.0	149.6	151.04	434367.0
2023-03-10 09:00:00	AAPL	Stock	151.04	151.5	148.89	149.775	7394956.0
2023-03-10 10:00:00	AAPL	Stock	149.79	150.5199	149.17	150.46	8486884.0
2023-03-10 11:00:00	AAPL	Stock	150.44	150.94	149.75	149.85	6624557.0
2023-03-10 12:00:00	AAPL	Stock	149.86	150.05	149.0301	149.1697	4687205.0
2023-03-10 13:00:00	AAPL	Stock	149.17	149.4	147.85	148.2	6403636.0
2023-03-10 14:00:00	AAPL	Stock	148.2	149.0	147.84	148.65	6860645.0
2023-03-10 15:00:00	AAPL	Stock	148.66	148.77	147.6096	148.48	10525699.0
2023-03-10 16:00:00	AAPL	Stock	148.48	149.16	148.34	149.08	8365405.0
2023-03-10 17:00:00	AAPL	Stock	149.04	149.04	148.5	148.76	68331.0
2023-03-10 18:00:00	AAPL	Stock	148.76	148.81	148.5	148.51	16036.0
2023-03-10 19:00:00	AAPL	Stock	148.45	148.6	148.25	148.6	20664.0
2023-03-10 04:00:00	MSFT	Stock	251.6	252.65	251.4	251.89	10379.0
2023-03-10 05:00:00	MSFT	Stock	252.23	252.75	251.2	251.2	6224.0
2023-03-10 06:00:00	MSFT	Stock	251.55	252.83	250.71	252.7	22641.0
2023-03-10 07:00:00	MSFT	Stock	252.26	252.3	251.22	251.76	4790.0
2023-03-10 08:00:00	MSFT	Stock	252.29	254.9726	250.0	253.1	106341.0
2023-03-10 09:00:00	MSFT	Stock	253.11	253.5	247.77	248.67	2304162.0
2023-03-10 10:00:00	MSFT	Stock	248.76	252.39	248.73	252.24	3370998.0
2023-03-10 11:00:00	MSFT	Stock	252.21	252.79	250.52	250.8	2620160.0
2023-03-10 12:00:00	MSFT	Stock	250.805	251.44	249.78	249.82	1699936.0
2023-03-10 13:00:00	MSFT	Stock	249.83	250.44	247.78	247.82	1613463.0
2023-03-10 14:00:00	MSFT	Stock	247.805	250.1	247.77	249.6	2191827.0
2023-03-10 15:00:00	MSFT	Stock	249.6	249.85	247.6	248.6	3259176.0
2023-03-10 16:00:00	MSFT	Stock	248.6	250.89	248.3	249.98	4266557.0
2023-03-10 17:00:00	MSFT	Stock	250.09	250.1	248.59	249.16	5675.0
2023-03-10 18:00:00	MSFT	Stock	249.2	249.2	248.98	248.98	1963.0
2023-03-10 19:00:00	MSFT	Stock	248.84	249.2	248.72	249.15	4031.0
2023-03-10 04:00:00	NVDA	Stock	23.301	23.515	23.301	23.466	295130.0
2023-03-10 05:00:00	NVDA	Stock	23.465	23.48	23.363	23.378	295760.0
2023-03-10 06:00:00	NVDA	Stock	23.383	23.5	23.344	23.488	155640.0
2023-03-10 07:00:00	NVDA	Stock	23.463	23.485	23.4	23.448	288290.0
2023-03-10 08:00:00	NVDA	Stock	23.225	23.722	23.212	23.58	4415730.0
2023-03-10 09:00:00	NVDA	Stock	23.589	23.65	22.726	23.0064	64412780.0
2023-03-10 10:00:00	NVDA	Stock	23.011	23.36	22.876	23.342	67879600.0
2023-03-10 11:00:00	NVDA	Stock	23.341	23.627	23.236	23.2638	54359520.0
2023-03-10 12:00:00	NVDA	Stock	23.2612	23.381	23.0714	23.075	36712650.0
2023-03-10 13:00:00	NVDA	Stock	23.082	23.163	22.805	22.873	35442910.0
2023-03-10 14:00:00	NVDA	Stock	22.871	23.105	22.869	23.004	41254540.0
2023-03-10 15:00:00	NVDA	Stock	23.01	23.111	22.87	22.969	48832530.0
2023-03-10 16:00:00	NVDA	Stock	22.965	23.045	22.92	23.025	25272400.0
2023-03-10 17:00:00	NVDA	Stock	23.016	23.02	22.975	22.99	262640.0
2023-03-10 18:00:00	NVDA	Stock	22.993	23.0	22.975	22.975	57320.0
2023-03-10 19:00:00	NVDA	Stock	22.98	23.0	22.975	22.995	157880.0
2023-03-10 04:00:00	AMZN	Stock	92.06	92.49	91.8	92.22	13873.0
2023-03-10 05:00:00	AMZN	Stock	92.22	92.5	92.16	92.16	8667.0

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

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