PREVIEW / stock_1hour / 2006-11-28

all stock 1-hour files

  file:    by_date/stock_1hour/2006/2006-11-28.parquet
  size:    648 KB
  rows:    30,632
  symbols: 2,471

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
2006-11-28 06:00:00	AAPL	Stock	3.2089	3.2093	3.2089	3.2093	56000.0
2006-11-28 07:00:00	AAPL	Stock	3.2186	3.2321	3.2061	3.2286	846832.0
2006-11-28 08:00:00	AAPL	Stock	3.2257	3.2336	3.2054	3.2104	9998520.0
2006-11-28 09:00:00	AAPL	Stock	3.21	3.2471	3.2068	3.2289	185752056.0
2006-11-28 10:00:00	AAPL	Stock	3.2293	3.2768	3.2254	3.2596	234721648.0
2006-11-28 11:00:00	AAPL	Stock	3.2593	3.275	3.2521	3.2679	113724408.0
2006-11-28 12:00:00	AAPL	Stock	3.2679	3.2839	3.22	3.2496	115253516.0
2006-11-28 13:00:00	AAPL	Stock	3.2496	3.2646	3.2375	3.2386	91721868.0
2006-11-28 14:00:00	AAPL	Stock	3.2386	3.2625	3.2271	3.2557	113696744.0
2006-11-28 15:00:00	AAPL	Stock	3.2564	3.2846	3.2518	3.2768	161411684.0
2006-11-28 16:00:00	AAPL	Stock	3.2768	3.2804	3.2732	3.2804	2432976.0
2006-11-28 17:00:00	AAPL	Stock	3.2807	3.2821	3.2754	3.2754	653576.0
2006-11-28 18:00:00	AAPL	Stock	3.2821	3.2821	3.2763	3.2804	350084.0
2006-11-28 19:00:00	AAPL	Stock	3.2821	3.2846	3.2814	3.2825	84056.0
2006-11-28 07:00:00	MSFT	Stock	29.37	29.41	29.37	29.37	1300.0
2006-11-28 08:00:00	MSFT	Stock	29.38	29.4	29.32	29.32	21717.0
2006-11-28 09:00:00	MSFT	Stock	29.32	29.35	29.13	29.27	9536711.0
2006-11-28 10:00:00	MSFT	Stock	29.272	29.41	29.18	29.32	11450790.0
2006-11-28 11:00:00	MSFT	Stock	29.319	29.37	29.2	29.29	6302259.0
2006-11-28 12:00:00	MSFT	Stock	29.29	29.36	29.24	29.29	5025859.0
2006-11-28 13:00:00	MSFT	Stock	29.28	29.39	29.27	29.3	6181190.0
2006-11-28 14:00:00	MSFT	Stock	29.3	29.35	29.29	29.31	4278612.0
2006-11-28 15:00:00	MSFT	Stock	29.31	29.42	29.29	29.39	7942596.0
2006-11-28 16:00:00	MSFT	Stock	29.39	29.45	29.31	29.31	326966.0
2006-11-28 17:00:00	MSFT	Stock	29.32	29.33	29.31	29.32	20300.0
2006-11-28 18:00:00	MSFT	Stock	29.389	29.4	29.38	29.39	3449.0
2006-11-28 19:00:00	MSFT	Stock	29.39	29.4	29.39	29.4	1250.0
2006-11-28 08:00:00	NVDA	Stock	0.59	0.59	0.5892	0.5892	30000.0
2006-11-28 09:00:00	NVDA	Stock	0.5867	0.5938	0.5773	0.5825	66903600.0
2006-11-28 10:00:00	NVDA	Stock	0.582	0.589	0.5778	0.587	81934020.0
2006-11-28 11:00:00	NVDA	Stock	0.587	0.5928	0.5783	0.5897	52691100.0
2006-11-28 12:00:00	NVDA	Stock	0.5895	0.5942	0.5812	0.5902	53037900.0
2006-11-28 13:00:00	NVDA	Stock	0.5902	0.5927	0.5887	0.5918	35083020.0
2006-11-28 14:00:00	NVDA	Stock	0.5918	0.5987	0.5888	0.5972	69807600.0
2006-11-28 15:00:00	NVDA	Stock	0.5972	0.6048	0.5963	0.5995	107620440.0
2006-11-28 16:00:00	NVDA	Stock	0.5995	0.6	0.5988	0.5995	1104540.0
2006-11-28 17:00:00	NVDA	Stock	0.5993	0.5993	0.5992	0.5993	114000.0
2006-11-28 19:00:00	NVDA	Stock	0.6	0.6	0.6	0.6	12000.0
2006-11-28 08:00:00	AMZN	Stock	2.0375	2.05	2.0275	2.0275	102720.0
2006-11-28 09:00:00	AMZN	Stock	2.0255	2.0375	2.0185	2.022	21675880.0
2006-11-28 10:00:00	AMZN	Stock	2.022	2.038	2.0165	2.0175	32273280.0
2006-11-28 11:00:00	AMZN	Stock	2.0175	2.033	2.016	2.025	12674120.0
2006-11-28 12:00:00	AMZN	Stock	2.0255	2.039	2.0185	2.0275	15003720.0
2006-11-28 13:00:00	AMZN	Stock	2.028	2.0335	2.015	2.0195	12790100.0
2006-11-28 14:00:00	AMZN	Stock	2.0195	2.0335	2.0185	2.033	14781480.0
2006-11-28 15:00:00	AMZN	Stock	2.033	2.0535	2.0305	2.049	27648060.0
2006-11-28 16:00:00	AMZN	Stock	2.043	2.0478	2.043	2.046	211180.0
2006-11-28 17:00:00	AMZN	Stock	2.0455	2.0455	2.0455	2.0455	2000.0
2006-11-28 08:00:00	CL	Stock	32.505	32.505	32.505	32.505	8000.0
2006-11-28 09:00:00	CL	Stock	32.79	32.79	32.35	32.375	344000.0

> showing 50 of 30,632 rows — these rows as CSV

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