PREVIEW / stock_1hour / 2023-02-09

all stock 1-hour files

  file:    by_date/stock_1hour/2023/2023-02-09.parquet
  size:    1.4 MB
  rows:    61,527
  symbols: 1,856

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-02-09 04:00:00	AAPL	Stock	152.98	153.69	152.93	153.69	52094.0
2023-02-09 05:00:00	AAPL	Stock	153.68	153.78	153.53	153.76	21221.0
2023-02-09 06:00:00	AAPL	Stock	153.76	153.79	153.5	153.6	29523.0
2023-02-09 07:00:00	AAPL	Stock	153.63	153.74	153.35	153.37	73754.0
2023-02-09 08:00:00	AAPL	Stock	153.5	153.9466	151.541	153.88	290519.0
2023-02-09 09:00:00	AAPL	Stock	153.87	154.33	152.8	153.27	6248173.0
2023-02-09 10:00:00	AAPL	Stock	153.27	153.76	152.6	153.315	6510467.0
2023-02-09 11:00:00	AAPL	Stock	153.31	153.49	152.62	153.2399	5492432.0
2023-02-09 12:00:00	AAPL	Stock	153.24	153.61	152.23	152.734	4708076.0
2023-02-09 13:00:00	AAPL	Stock	152.73	152.76	151.94	152.1	3636357.0
2023-02-09 14:00:00	AAPL	Stock	152.11	152.32	151.73	151.7699	3735122.0
2023-02-09 15:00:00	AAPL	Stock	151.77	151.79	150.42	150.88	8540754.0
2023-02-09 16:00:00	AAPL	Stock	150.88	151.55	150.7	151.29	7246134.0
2023-02-09 17:00:00	AAPL	Stock	151.3	151.3	151.0	151.03	33089.0
2023-02-09 18:00:00	AAPL	Stock	151.03	151.21	150.9	151.01	33488.0
2023-02-09 19:00:00	AAPL	Stock	151.0	151.0	150.55	150.75	40072.0
2023-02-09 04:00:00	MSFT	Stock	269.99	271.82	269.81	271.82	32667.0
2023-02-09 05:00:00	MSFT	Stock	271.69	272.14	271.28	272.1	10233.0
2023-02-09 06:00:00	MSFT	Stock	272.05	272.1	271.2	271.54	12314.0
2023-02-09 07:00:00	MSFT	Stock	271.79	271.8	271.0	271.11	79802.0
2023-02-09 08:00:00	MSFT	Stock	271.54	272.83	266.064	272.48	183604.0
2023-02-09 09:00:00	MSFT	Stock	272.44	274.26	269.66	271.5	5293862.0
2023-02-09 10:00:00	MSFT	Stock	271.495	272.7	269.51	270.86	4143652.0
2023-02-09 11:00:00	MSFT	Stock	270.855	270.855	268.47	268.83	2731098.0
2023-02-09 12:00:00	MSFT	Stock	268.81	269.88	266.99	267.73	2370727.0
2023-02-09 13:00:00	MSFT	Stock	267.72	267.74	265.54	265.69	2109036.0
2023-02-09 14:00:00	MSFT	Stock	265.69	266.19	265.05	265.48	1883196.0
2023-02-09 15:00:00	MSFT	Stock	265.47	265.6416	262.8	263.7	4721315.0
2023-02-09 16:00:00	MSFT	Stock	263.62	266.778	263.1651	264.05	4266871.0
2023-02-09 17:00:00	MSFT	Stock	264.29	264.29	263.22	263.22	44826.0
2023-02-09 18:00:00	MSFT	Stock	263.4	263.75	263.15	263.4	30072.0
2023-02-09 19:00:00	MSFT	Stock	263.23	263.6499	263.1	263.4	29118.0
2023-02-09 04:00:00	NVDA	Stock	22.525	22.656	22.4	22.616	333710.0
2023-02-09 05:00:00	NVDA	Stock	22.63	22.69	22.601	22.67	326830.0
2023-02-09 06:00:00	NVDA	Stock	22.678	22.68	22.572	22.609	252090.0
2023-02-09 07:00:00	NVDA	Stock	22.6	22.63	22.5	22.5	622130.0
2023-02-09 08:00:00	NVDA	Stock	22.58	22.645	22.1495	22.619	1551400.0
2023-02-09 09:00:00	NVDA	Stock	22.635	22.915	22.605	22.715	65459360.0
2023-02-09 10:00:00	NVDA	Stock	22.722	22.998	22.674	22.995	71149440.0
2023-02-09 11:00:00	NVDA	Stock	22.996	23.02	22.795	22.9274	71442480.0
2023-02-09 12:00:00	NVDA	Stock	22.923	22.9766	22.492	22.63	51784000.0
2023-02-09 13:00:00	NVDA	Stock	22.625	22.723	22.538	22.642	41479030.0
2023-02-09 14:00:00	NVDA	Stock	22.641	22.695	22.333	22.436	43707840.0
2023-02-09 15:00:00	NVDA	Stock	22.44	22.462	22.12	22.341	61983660.0
2023-02-09 16:00:00	NVDA	Stock	22.337	22.399	22.331	22.369	17780280.0
2023-02-09 17:00:00	NVDA	Stock	22.3702	22.374	22.325	22.34	392310.0
2023-02-09 18:00:00	NVDA	Stock	22.339	22.373	22.3	22.3	286410.0
2023-02-09 19:00:00	NVDA	Stock	22.29	22.308	22.152	22.165	444980.0
2023-02-09 04:00:00	AMZN	Stock	100.89	101.14	100.26	101.14	40890.0
2023-02-09 05:00:00	AMZN	Stock	101.08	101.38	100.91	101.34	36091.0

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

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