PREVIEW / stock_1hour / 2005-07-28

all stock 1-hour files

  file:    by_date/stock_1hour/2005/2005-07-28.parquet
  size:    575 KB
  rows:    27,442
  symbols: 2,052

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
2005-07-28 08:00:00	AAPL	Stock	1.5714	1.5804	1.5714	1.5736	371504.0
2005-07-28 09:00:00	AAPL	Stock	1.5739	1.5739	1.5496	1.5568	46467820.0
2005-07-28 10:00:00	AAPL	Stock	1.5568	1.5589	1.5464	1.5536	56921536.0
2005-07-28 11:00:00	AAPL	Stock	1.5536	1.5679	1.5521	1.5643	35397012.0
2005-07-28 12:00:00	AAPL	Stock	1.5643	1.5664	1.5571	1.5625	19332936.0
2005-07-28 13:00:00	AAPL	Stock	1.5625	1.5629	1.5582	1.56	19523336.0
2005-07-28 14:00:00	AAPL	Stock	1.5596	1.5654	1.5571	1.5596	19183948.0
2005-07-28 15:00:00	AAPL	Stock	1.5593	1.5671	1.5568	1.5621	43744680.0
2005-07-28 16:00:00	AAPL	Stock	1.5636	1.5671	1.55	1.5571	4620056.0
2005-07-28 17:00:00	AAPL	Stock	1.5571	1.5589	1.5571	1.5571	93128.0
2005-07-28 18:00:00	AAPL	Stock	1.5571	1.5571	1.5571	1.5571	48020.0
2005-07-28 08:00:00	MSFT	Stock	25.71	25.77	25.71	25.75	422845.0
2005-07-28 09:00:00	MSFT	Stock	25.75	25.79	25.69	25.77	4632262.0
2005-07-28 10:00:00	MSFT	Stock	25.76	25.78	25.66	25.769	6840508.0
2005-07-28 11:00:00	MSFT	Stock	25.77	25.85	25.75	25.81	9062508.0
2005-07-28 12:00:00	MSFT	Stock	25.8	25.82	25.7	25.76	5244087.0
2005-07-28 13:00:00	MSFT	Stock	25.76	25.82	25.75	25.78	4218676.0
2005-07-28 14:00:00	MSFT	Stock	25.78	25.79	25.75	25.76	3668503.0
2005-07-28 15:00:00	MSFT	Stock	25.77	25.77	25.71	25.76	8747155.0
2005-07-28 16:00:00	MSFT	Stock	25.76	25.8	25.745	25.78	323848.0
2005-07-28 17:00:00	MSFT	Stock	25.77	25.8	25.76	25.79	48950.0
2005-07-28 18:00:00	MSFT	Stock	25.79	25.8	25.79	25.79	8725.0
2005-07-28 08:00:00	NVDA	Stock	0.2275	0.2283	0.2242	0.2255	583200.0
2005-07-28 09:00:00	NVDA	Stock	0.2265	0.227	0.225	0.2263	53591160.0
2005-07-28 10:00:00	NVDA	Stock	0.2262	0.2263	0.222	0.2235	63606960.0
2005-07-28 11:00:00	NVDA	Stock	0.2234	0.2267	0.2232	0.2261	49110600.0
2005-07-28 12:00:00	NVDA	Stock	0.2261	0.2266	0.2256	0.2262	21016440.0
2005-07-28 13:00:00	NVDA	Stock	0.2261	0.2283	0.2259	0.2271	74550720.0
2005-07-28 14:00:00	NVDA	Stock	0.2271	0.2277	0.2267	0.2267	45525360.0
2005-07-28 15:00:00	NVDA	Stock	0.2267	0.2275	0.2263	0.2272	76794960.0
2005-07-28 16:00:00	NVDA	Stock	0.2272	0.2272	0.2271	0.2272	10724160.0
2005-07-28 17:00:00	NVDA	Stock	0.2272	0.2272	0.2272	0.2272	60000.0
2005-07-28 18:00:00	NVDA	Stock	0.2272	0.2272	0.2272	0.2272	211440.0
2005-07-28 08:00:00	AMZN	Stock	2.1755	2.1755	2.1685	2.171	420100.0
2005-07-28 09:00:00	AMZN	Stock	2.1715	2.224	2.1685	2.2165	70086500.0
2005-07-28 10:00:00	AMZN	Stock	2.2165	2.254	2.214	2.2245	124661480.0
2005-07-28 11:00:00	AMZN	Stock	2.225	2.237	2.212	2.2325	31864640.0
2005-07-28 12:00:00	AMZN	Stock	2.2325	2.261	2.232	2.2585	55470980.0
2005-07-28 13:00:00	AMZN	Stock	2.2585	2.2875	2.2475	2.2645	79333560.0
2005-07-28 14:00:00	AMZN	Stock	2.2645	2.2775	2.2595	2.276	49232940.0
2005-07-28 15:00:00	AMZN	Stock	2.276	2.2905	2.268	2.284	86690940.0
2005-07-28 16:00:00	AMZN	Stock	2.2835	2.285	2.278	2.2815	1844080.0
2005-07-28 17:00:00	AMZN	Stock	2.28	2.2845	2.28	2.281	273760.0
2005-07-28 18:00:00	AMZN	Stock	2.2815	2.284	2.2815	2.2825	50000.0
2005-07-28 09:00:00	CL	Stock	26.125	26.325	26.08	26.325	674800.0
2005-07-28 10:00:00	CL	Stock	26.325	26.425	26.275	26.39	838000.0
2005-07-28 11:00:00	CL	Stock	26.395	26.71	26.34	26.685	1768200.0
2005-07-28 12:00:00	CL	Stock	26.685	26.73	26.61	26.635	948400.0
2005-07-28 13:00:00	CL	Stock	26.635	26.65	26.505	26.64	598200.0
2005-07-28 14:00:00	CL	Stock	26.63	26.665	26.525	26.605	939400.0

> showing 50 of 27,442 rows — these rows as CSV

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