PREVIEW / stock_1hour / 2024-05-07

all stock 1-hour files

  file:    by_date/stock_1hour/2024/2024-05-07.parquet
  size:    1.3 MB
  rows:    58,843
  symbols: 987

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
2024-05-07 04:00:00	AAPL	Stock	183.02	183.62	182.47	183.29	38190.0
2024-05-07 05:00:00	AAPL	Stock	183.13	183.4	183.0	183.34	19512.0
2024-05-07 06:00:00	AAPL	Stock	183.33	183.68	183.3	183.43	19125.0
2024-05-07 07:00:00	AAPL	Stock	183.32	183.53	182.75	183.28	38748.0
2024-05-07 08:00:00	AAPL	Stock	183.15	183.94	182.73	183.92	314122.0
2024-05-07 09:00:00	AAPL	Stock	183.92	184.9	182.92	183.92	11477978.0
2024-05-07 10:00:00	AAPL	Stock	183.93	184.47	182.3	182.6101	11742587.0
2024-05-07 11:00:00	AAPL	Stock	182.62	182.97	181.43	181.57	7417889.0
2024-05-07 12:00:00	AAPL	Stock	181.5699	182.02	181.32	181.865	5444395.0
2024-05-07 13:00:00	AAPL	Stock	181.87	182.8	181.87	182.6875	5052737.0
2024-05-07 14:00:00	AAPL	Stock	182.6801	182.92	182.3	182.4983	3661724.0
2024-05-07 15:00:00	AAPL	Stock	182.49	182.68	182.17	182.37	6294876.0
2024-05-07 16:00:00	AAPL	Stock	182.37	182.75	182.37	182.3948	6230035.0
2024-05-07 17:00:00	AAPL	Stock	182.37	182.5	182.26	182.35	34880.0
2024-05-07 18:00:00	AAPL	Stock	182.33	182.5	182.212	182.36	38845.0
2024-05-07 19:00:00	AAPL	Stock	182.35	182.4	182.23	182.23	19627.0
2024-05-07 04:00:00	MSFT	Stock	413.83	414.0	412.77	414.0	2006.0
2024-05-07 05:00:00	MSFT	Stock	413.8	413.9	413.42	413.45	1741.0
2024-05-07 06:00:00	MSFT	Stock	413.29	413.37	413.0	413.37	2997.0
2024-05-07 07:00:00	MSFT	Stock	413.3	413.3	411.99	412.33	11782.0
2024-05-07 08:00:00	MSFT	Stock	412.5	414.0	411.74	412.15	30409.0
2024-05-07 09:00:00	MSFT	Stock	412.2	414.94	411.51	412.29	1593750.0
2024-05-07 10:00:00	MSFT	Stock	412.37	413.7	411.7	412.72	1309136.0
2024-05-07 11:00:00	MSFT	Stock	412.71	413.1599	412.12	412.81	771495.0
2024-05-07 12:00:00	MSFT	Stock	412.82	412.92	411.422	411.8422	603385.0
2024-05-07 13:00:00	MSFT	Stock	411.8831	412.43	410.85	411.04	641105.0
2024-05-07 14:00:00	MSFT	Stock	411.0	411.8	410.26	410.4404	678457.0
2024-05-07 15:00:00	MSFT	Stock	410.49	410.64	409.09	409.17	2127848.0
2024-05-07 16:00:00	MSFT	Stock	409.34	409.69	408.89	409.1771	2917285.0
2024-05-07 17:00:00	MSFT	Stock	409.21	409.94	409.1101	409.59	14334.0
2024-05-07 18:00:00	MSFT	Stock	409.42	409.94	409.15	409.9	7375.0
2024-05-07 19:00:00	MSFT	Stock	409.5	410.15	409.5	409.98	1489.0
2024-05-07 04:00:00	NVDA	Stock	91.45	91.45	90.896	91.31	209670.0
2024-05-07 05:00:00	NVDA	Stock	91.305	91.33	90.62	90.734	275990.0
2024-05-07 06:00:00	NVDA	Stock	90.745	91.02	90.355	90.98	363880.0
2024-05-07 07:00:00	NVDA	Stock	90.9	91.424	90.9	91.08	1525090.0
2024-05-07 08:00:00	NVDA	Stock	91.28	91.514	90.9	91.249	2393890.0
2024-05-07 09:00:00	NVDA	Stock	91.22	91.781	89.2	89.693	64636190.0
2024-05-07 10:00:00	NVDA	Stock	89.662	90.567	89.011	90.567	60876250.0
2024-05-07 11:00:00	NVDA	Stock	90.568	91.072	90.252	91.0335	36955980.0
2024-05-07 12:00:00	NVDA	Stock	91.064	91.54	91.041	91.306	33927300.0
2024-05-07 13:00:00	NVDA	Stock	91.311	91.72	90.408	90.54	31536810.0
2024-05-07 14:00:00	NVDA	Stock	90.537	90.65	89.721	90.386	39965640.0
2024-05-07 15:00:00	NVDA	Stock	90.392	90.725	90.125	90.535	35861260.0
2024-05-07 16:00:00	NVDA	Stock	90.5075	90.6	90.265	90.4	16858410.0
2024-05-07 17:00:00	NVDA	Stock	90.4	90.554	90.22	90.26	375420.0
2024-05-07 18:00:00	NVDA	Stock	90.25	90.279	90.133	90.24	392440.0
2024-05-07 19:00:00	NVDA	Stock	90.24	90.443	90.195	90.422	345430.0
2024-05-07 04:00:00	AMZN	Stock	188.24	188.26	188.08	188.11	4553.0
2024-05-07 05:00:00	AMZN	Stock	188.3	188.31	188.14	188.14	1736.0

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

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