PREVIEW / stock_1hour / 2002-07-17

all stock 1-hour files

  file:    by_date/stock_1hour/2002/2002-07-17.parquet
  size:    396 KB
  rows:    18,861
  symbols: 1,440

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
2002-07-17 08:00:00	AAPL	Stock	0.2964	0.2991	0.288	0.2902	21106400.0
2002-07-17 09:00:00	AAPL	Stock	0.29	0.3171	0.2777	0.2786	273638400.0
2002-07-17 10:00:00	AAPL	Stock	0.2786	0.2832	0.2714	0.2768	305676000.0
2002-07-17 11:00:00	AAPL	Stock	0.2768	0.2804	0.2732	0.2768	136494400.0
2002-07-17 12:00:00	AAPL	Stock	0.2768	0.2779	0.2713	0.2746	100872800.0
2002-07-17 13:00:00	AAPL	Stock	0.2746	0.2768	0.2729	0.2763	57859200.0
2002-07-17 14:00:00	AAPL	Stock	0.2757	0.2782	0.2741	0.275	79116800.0
2002-07-17 15:00:00	AAPL	Stock	0.275	0.2804	0.2741	0.2793	162215200.0
2002-07-17 16:00:00	AAPL	Stock	0.2786	0.2818	0.2766	0.2818	18888800.0
2002-07-17 17:00:00	AAPL	Stock	0.2795	0.2795	0.2773	0.2786	1321600.0
2002-07-17 18:00:00	AAPL	Stock	0.2768	0.2768	0.2768	0.2768	84000.0
2002-07-17 08:00:00	MSFT	Stock	25.97	26.2	25.46	26.19	303400.0
2002-07-17 09:00:00	MSFT	Stock	26.175	26.65	26.15	26.415	14696400.0
2002-07-17 10:00:00	MSFT	Stock	26.42	26.565	26.12	26.235	12198000.0
2002-07-17 11:00:00	MSFT	Stock	26.235	26.365	25.945	26.105	15248400.0
2002-07-17 12:00:00	MSFT	Stock	26.11	26.31	25.585	25.75	12639200.0
2002-07-17 13:00:00	MSFT	Stock	25.75	25.995	25.65	25.87	11876000.0
2002-07-17 14:00:00	MSFT	Stock	25.87	25.995	25.605	25.725	10342600.0
2002-07-17 15:00:00	MSFT	Stock	25.725	26.145	25.59	25.993	15622800.0
2002-07-17 16:00:00	MSFT	Stock	26.005	26.35	25.955	26.14	2565600.0
2002-07-17 17:00:00	MSFT	Stock	26.15	26.175	25.975	25.98	327000.0
2002-07-17 18:00:00	MSFT	Stock	26.0	26.0	25.79	25.895	25800.0
2002-07-17 08:00:00	NVDA	Stock	0.17	0.1767	0.16	0.1742	30168000.0
2002-07-17 09:00:00	NVDA	Stock	0.1742	0.1771	0.1692	0.1702	371424000.0
2002-07-17 10:00:00	NVDA	Stock	0.1702	0.1725	0.1637	0.1654	357792000.0
2002-07-17 11:00:00	NVDA	Stock	0.1654	0.1674	0.1642	0.1653	149388000.0
2002-07-17 12:00:00	NVDA	Stock	0.165	0.1679	0.1555	0.1569	286956000.0
2002-07-17 13:00:00	NVDA	Stock	0.1569	0.16	0.1559	0.1589	241440000.0
2002-07-17 14:00:00	NVDA	Stock	0.1587	0.16	0.1567	0.1598	171420000.0
2002-07-17 15:00:00	NVDA	Stock	0.1595	0.1657	0.1592	0.1625	235308000.0
2002-07-17 16:00:00	NVDA	Stock	0.1628	0.1641	0.162	0.1624	18744000.0
2002-07-17 17:00:00	NVDA	Stock	0.163	0.1633	0.1596	0.16	2628000.0
2002-07-17 18:00:00	NVDA	Stock	0.16	0.16	0.1585	0.1592	648000.0
2002-07-17 08:00:00	AMZN	Stock	0.82	0.8376	0.816	0.8376	268000.0
2002-07-17 09:00:00	AMZN	Stock	0.8381	0.858	0.8276	0.8405	16640000.0
2002-07-17 10:00:00	AMZN	Stock	0.84	0.844	0.821	0.829	16826000.0
2002-07-17 11:00:00	AMZN	Stock	0.8275	0.8345	0.8185	0.825	11892000.0
2002-07-17 12:00:00	AMZN	Stock	0.825	0.828	0.7675	0.768	35676000.0
2002-07-17 13:00:00	AMZN	Stock	0.7675	0.7975	0.766	0.7865	22926000.0
2002-07-17 14:00:00	AMZN	Stock	0.786	0.8005	0.785	0.7967	15426000.0
2002-07-17 15:00:00	AMZN	Stock	0.7965	0.8118	0.7925	0.807	19688000.0
2002-07-17 16:00:00	AMZN	Stock	0.809	0.8125	0.8	0.805	4110000.0
2002-07-17 17:00:00	AMZN	Stock	0.808	0.808	0.808	0.808	238000.0
2002-07-17 18:00:00	AMZN	Stock	0.8025	0.8025	0.8025	0.8025	30000.0
2002-07-17 09:00:00	CL	Stock	24.25	24.3	24.0	24.05	606400.0
2002-07-17 10:00:00	CL	Stock	24.05	24.125	24.0	24.115	671400.0
2002-07-17 11:00:00	CL	Stock	24.075	24.27	24.04	24.175	443800.0
2002-07-17 12:00:00	CL	Stock	24.15	24.155	23.5	23.5	1008200.0
2002-07-17 13:00:00	CL	Stock	23.495	23.76	23.45	23.76	787800.0
2002-07-17 14:00:00	CL	Stock	23.76	23.9	23.485	23.55	675200.0

> showing 50 of 18,861 rows — these rows as CSV

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