PREVIEW / stock_1hour / 2009-02-09

all stock 1-hour files

  file:    by_date/stock_1hour/2009/2009-02-09.parquet
  size:    801 KB
  rows:    39,426
  symbols: 3,328

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
2009-02-09 06:00:00	AAPL	Stock	3.5446	3.5571	3.5446	3.5571	15120.0
2009-02-09 07:00:00	AAPL	Stock	3.5536	3.5607	3.5536	3.5571	84000.0
2009-02-09 08:00:00	AAPL	Stock	3.5536	3.5707	3.5536	3.5704	662872.0
2009-02-09 09:00:00	AAPL	Stock	3.5679	3.6368	3.5536	3.6336	115590524.0
2009-02-09 10:00:00	AAPL	Stock	3.6339	3.6725	3.6014	3.6689	165775512.0
2009-02-09 11:00:00	AAPL	Stock	3.6696	3.67	3.6454	3.6654	83021736.0
2009-02-09 12:00:00	AAPL	Stock	3.6654	3.6786	3.6518	3.6693	62915944.0
2009-02-09 13:00:00	AAPL	Stock	3.6696	3.6779	3.6414	3.675	73031280.0
2009-02-09 14:00:00	AAPL	Stock	3.6746	3.675	3.6371	3.6496	78256136.0
2009-02-09 15:00:00	AAPL	Stock	3.6493	3.6775	3.6429	3.6643	107755452.0
2009-02-09 16:00:00	AAPL	Stock	3.6639	3.6654	3.6347	3.6564	11689300.0
2009-02-09 17:00:00	AAPL	Stock	3.6554	3.6604	3.6546	3.6554	528556.0
2009-02-09 18:00:00	AAPL	Stock	3.6611	3.6611	3.6443	3.6482	4563188.0
2009-02-09 19:00:00	AAPL	Stock	3.65	3.6518	3.6179	3.625	460572.0
2009-02-09 20:00:00	AAPL	Stock	3.6611	3.6611	3.6611	3.6611	45724.0
2009-02-09 04:00:00	MSFT	Stock	19.51	19.51	19.2	19.2	500.0
2009-02-09 06:00:00	MSFT	Stock	19.33	19.33	19.33	19.33	1000.0
2009-02-09 07:00:00	MSFT	Stock	19.5	19.5	19.5	19.5	1000.0
2009-02-09 08:00:00	MSFT	Stock	19.55	19.7	19.5	19.56	29630.0
2009-02-09 09:00:00	MSFT	Stock	19.56	19.77	19.38	19.49	4966313.0
2009-02-09 10:00:00	MSFT	Stock	19.481	19.51	19.34	19.51	7667545.0
2009-02-09 11:00:00	MSFT	Stock	19.51	19.52	19.31	19.31	5551612.0
2009-02-09 12:00:00	MSFT	Stock	19.32	19.4	19.3	19.392	3566465.0
2009-02-09 13:00:00	MSFT	Stock	19.395	19.46	19.3	19.39	3201490.0
2009-02-09 14:00:00	MSFT	Stock	19.39	19.4	19.26	19.35	6554188.0
2009-02-09 15:00:00	MSFT	Stock	19.34	19.46	19.34	19.44	13145491.0
2009-02-09 16:00:00	MSFT	Stock	19.45	19.48	19.34	19.36	5770004.0
2009-02-09 17:00:00	MSFT	Stock	19.4	19.41	19.36	19.41	4017.0
2009-02-09 18:00:00	MSFT	Stock	19.4	19.44	19.4	19.4	14614.0
2009-02-09 19:00:00	MSFT	Stock	19.41	19.41	19.35	19.35	11277.0
2009-02-09 08:00:00	NVDA	Stock	0.2458	0.2458	0.2405	0.2445	244000.0
2009-02-09 09:00:00	NVDA	Stock	0.2442	0.2493	0.2405	0.2455	78264080.0
2009-02-09 10:00:00	NVDA	Stock	0.2455	0.2465	0.2398	0.2462	154592160.0
2009-02-09 11:00:00	NVDA	Stock	0.246	0.2462	0.242	0.2438	78771920.0
2009-02-09 12:00:00	NVDA	Stock	0.2438	0.245	0.2422	0.2426	76131600.0
2009-02-09 13:00:00	NVDA	Stock	0.2425	0.245	0.241	0.2429	57046320.0
2009-02-09 14:00:00	NVDA	Stock	0.243	0.2432	0.2368	0.24	100831240.0
2009-02-09 15:00:00	NVDA	Stock	0.24	0.244	0.239	0.2432	148725640.0
2009-02-09 16:00:00	NVDA	Stock	0.2425	0.2435	0.2375	0.2435	13049760.0
2009-02-09 17:00:00	NVDA	Stock	0.243	0.243	0.2425	0.2428	72000.0
2009-02-09 18:00:00	NVDA	Stock	0.2438	0.2438	0.2438	0.2438	12000.0
2009-02-09 19:00:00	NVDA	Stock	0.2412	0.2425	0.2412	0.2425	34640.0
2009-02-09 05:00:00	AMZN	Stock	3.3	3.3	3.285	3.285	14000.0
2009-02-09 07:00:00	AMZN	Stock	3.3	3.33	3.3	3.33	16000.0
2009-02-09 08:00:00	AMZN	Stock	3.33	3.335	3.305	3.3075	121120.0
2009-02-09 09:00:00	AMZN	Stock	3.313	3.365	3.2875	3.363	24272120.0
2009-02-09 10:00:00	AMZN	Stock	3.3635	3.368	3.269	3.325	46110000.0
2009-02-09 11:00:00	AMZN	Stock	3.325	3.325	3.278	3.287	25464440.0
2009-02-09 12:00:00	AMZN	Stock	3.287	3.3425	3.2855	3.3415	20573960.0
2009-02-09 13:00:00	AMZN	Stock	3.3405	3.3495	3.3145	3.334	16230920.0

> showing 50 of 39,426 rows — these rows as CSV

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