PREVIEW / stock_1hour / 2001-09-28

all stock 1-hour files

  file:    by_date/stock_1hour/2001/2001-09-28.parquet
  size:    374 KB
  rows:    18,307
  symbols: 1,344

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
2001-09-28 08:00:00	AAPL	Stock	0.2759	0.2775	0.2759	0.2775	11200.0
2001-09-28 09:00:00	AAPL	Stock	0.2786	0.2821	0.2759	0.2777	30665600.0
2001-09-28 10:00:00	AAPL	Stock	0.2775	0.282	0.2768	0.2805	46519200.0
2001-09-28 11:00:00	AAPL	Stock	0.2807	0.283	0.2796	0.2809	20949600.0
2001-09-28 12:00:00	AAPL	Stock	0.2807	0.2814	0.28	0.2805	8752800.0
2001-09-28 13:00:00	AAPL	Stock	0.2804	0.2839	0.2795	0.2821	26409600.0
2001-09-28 14:00:00	AAPL	Stock	0.2818	0.2821	0.2773	0.2777	34042400.0
2001-09-28 15:00:00	AAPL	Stock	0.278	0.2811	0.2748	0.2768	91599200.0
2001-09-28 16:00:00	AAPL	Stock	0.2768	0.2786	0.2757	0.277	74054400.0
2001-09-28 17:00:00	AAPL	Stock	0.277	0.277	0.277	0.277	2273600.0
2001-09-28 18:00:00	AAPL	Stock	0.2764	0.2764	0.2764	0.2764	16800.0
2001-09-28 08:00:00	MSFT	Stock	25.115	25.2	24.55	24.75	293200.0
2001-09-28 09:00:00	MSFT	Stock	24.7	24.875	24.49	24.6145	12556400.0
2001-09-28 10:00:00	MSFT	Stock	24.624	25.2985	24.57	24.935	29467200.0
2001-09-28 11:00:00	MSFT	Stock	24.92	25.2395	24.75	25.09	11289800.0
2001-09-28 12:00:00	MSFT	Stock	25.076	25.415	25.03	25.085	9163600.0
2001-09-28 13:00:00	MSFT	Stock	25.09	25.5	25.055	25.425	10403800.0
2001-09-28 14:00:00	MSFT	Stock	25.44	25.4505	25.11	25.225	8213800.0
2001-09-28 15:00:00	MSFT	Stock	25.22	25.6295	25.2	25.585	18154000.0
2001-09-28 16:00:00	MSFT	Stock	25.59	25.625	25.0952	25.585	8736000.0
2001-09-28 17:00:00	MSFT	Stock	25.51	25.585	25.105	25.505	1340800.0
2001-09-28 18:00:00	MSFT	Stock	25.51	25.51	25.47	25.49	6400.0
2001-09-28 08:00:00	NVDA	Stock	0.2217	0.225	0.2215	0.225	324000.0
2001-09-28 09:00:00	NVDA	Stock	0.2241	0.2271	0.2154	0.218	84600000.0
2001-09-28 10:00:00	NVDA	Stock	0.2179	0.229	0.2176	0.2256	191124000.0
2001-09-28 11:00:00	NVDA	Stock	0.2253	0.2337	0.2251	0.2301	151656000.0
2001-09-28 12:00:00	NVDA	Stock	0.2301	0.2333	0.2287	0.2313	78276000.0
2001-09-28 13:00:00	NVDA	Stock	0.2313	0.2398	0.2296	0.2389	111876000.0
2001-09-28 14:00:00	NVDA	Stock	0.2391	0.2401	0.2312	0.234	119940000.0
2001-09-28 15:00:00	NVDA	Stock	0.2331	0.2395	0.2281	0.2289	212676000.0
2001-09-28 16:00:00	NVDA	Stock	0.2288	0.2319	0.2283	0.2289	30432000.0
2001-09-28 17:00:00	NVDA	Stock	0.2289	0.2329	0.2289	0.2329	240000.0
2001-09-28 08:00:00	AMZN	Stock	0.3075	0.32	0.3075	0.3165	110000.0
2001-09-28 09:00:00	AMZN	Stock	0.316	0.316	0.3	0.3005	9948000.0
2001-09-28 10:00:00	AMZN	Stock	0.3005	0.3235	0.3	0.3115	25414000.0
2001-09-28 11:00:00	AMZN	Stock	0.3115	0.3115	0.2995	0.3075	18854000.0
2001-09-28 12:00:00	AMZN	Stock	0.3065	0.3075	0.3	0.3	12388000.0
2001-09-28 13:00:00	AMZN	Stock	0.3	0.307	0.2915	0.305	17600000.0
2001-09-28 14:00:00	AMZN	Stock	0.3045	0.305	0.2995	0.301	11596000.0
2001-09-28 15:00:00	AMZN	Stock	0.3	0.302	0.295	0.299	23644000.0
2001-09-28 16:00:00	AMZN	Stock	0.299	0.304	0.2975	0.2985	10900000.0
2001-09-28 17:00:00	AMZN	Stock	0.3	0.305	0.2985	0.2985	662000.0
2001-09-28 09:00:00	CL	Stock	28.985	29.06	28.65	28.8	493200.0
2001-09-28 10:00:00	CL	Stock	28.8	28.99	28.69	28.955	904600.0
2001-09-28 11:00:00	CL	Stock	28.955	29.025	28.805	28.82	544000.0
2001-09-28 12:00:00	CL	Stock	28.815	28.855	28.65	28.7	495200.0
2001-09-28 13:00:00	CL	Stock	28.69	28.89	28.675	28.85	430000.0
2001-09-28 14:00:00	CL	Stock	28.85	28.975	28.805	28.955	367200.0
2001-09-28 15:00:00	CL	Stock	28.95	29.045	28.875	29.035	741600.0
2001-09-28 16:00:00	CL	Stock	29.04	29.125	28.945	29.125	335200.0

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

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