PREVIEW / stock_1hour / 2010-11-10

all stock 1-hour files

  file:    by_date/stock_1hour/2010/2010-11-10.parquet
  size:    930 KB
  rows:    44,288
  symbols: 3,510

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
2010-11-10 05:00:00	AAPL	Stock	11.3018	11.3368	11.3018	11.3036	19600.0
2010-11-10 06:00:00	AAPL	Stock	11.3025	11.3189	11.3025	11.3114	86716.0
2010-11-10 07:00:00	AAPL	Stock	11.3054	11.3425	11.2793	11.2993	267540.0
2010-11-10 08:00:00	AAPL	Stock	11.2857	11.3304	11.2786	11.3057	2877308.0
2010-11-10 09:00:00	AAPL	Stock	11.3104	11.3389	11.2193	11.2586	73197936.0
2010-11-10 10:00:00	AAPL	Stock	11.2571	11.2826	11.1982	11.2821	74506852.0
2010-11-10 11:00:00	AAPL	Stock	11.2811	11.3561	11.2804	11.3493	53687256.0
2010-11-10 12:00:00	AAPL	Stock	11.3493	11.3568	11.3232	11.3404	26404084.0
2010-11-10 13:00:00	AAPL	Stock	11.3404	11.3579	11.3139	11.3436	41425412.0
2010-11-10 14:00:00	AAPL	Stock	11.3425	11.3846	11.3425	11.3668	45110800.0
2010-11-10 15:00:00	AAPL	Stock	11.3668	11.3732	11.3393	11.3604	48866300.0
2010-11-10 16:00:00	AAPL	Stock	11.3625	11.3625	11.2886	11.3232	7752612.0
2010-11-10 17:00:00	AAPL	Stock	11.3225	11.3225	11.2411	11.2679	3044832.0
2010-11-10 18:00:00	AAPL	Stock	11.2679	11.3582	11.2618	11.2946	825748.0
2010-11-10 19:00:00	AAPL	Stock	11.2996	11.3032	11.2543	11.2625	1300404.0
2010-11-10 06:00:00	MSFT	Stock	26.95	26.95	26.95	26.95	300.0
2010-11-10 07:00:00	MSFT	Stock	26.94	26.95	26.94	26.95	2800.0
2010-11-10 08:00:00	MSFT	Stock	26.99	27.03	26.95	27.02	16758.0
2010-11-10 09:00:00	MSFT	Stock	27.02	27.05	26.92	26.96	7592554.0
2010-11-10 10:00:00	MSFT	Stock	26.95	26.98	26.81	26.95	12078013.0
2010-11-10 11:00:00	MSFT	Stock	26.945	27.0	26.85	26.98	5328478.0
2010-11-10 12:00:00	MSFT	Stock	26.975	26.995	26.91	26.95	3606433.0
2010-11-10 13:00:00	MSFT	Stock	26.942	27.08	26.92	26.956	6709052.0
2010-11-10 14:00:00	MSFT	Stock	26.955	27.02	26.95	26.975	4976304.0
2010-11-10 15:00:00	MSFT	Stock	26.975	26.99	26.93	26.96	6780838.0
2010-11-10 16:00:00	MSFT	Stock	26.94	26.984	26.76	26.77	2134669.0
2010-11-10 17:00:00	MSFT	Stock	26.76	26.76	26.42	26.62	155828.0
2010-11-10 18:00:00	MSFT	Stock	26.61	26.94	26.54	26.62	36331.0
2010-11-10 19:00:00	MSFT	Stock	26.62	26.75	26.62	26.66	28530.0
2010-11-10 08:00:00	NVDA	Stock	0.3148	0.3165	0.3145	0.3165	36000.0
2010-11-10 09:00:00	NVDA	Stock	0.3168	0.3183	0.3138	0.3154	112061200.0
2010-11-10 10:00:00	NVDA	Stock	0.3153	0.3153	0.3125	0.313	98850320.0
2010-11-10 11:00:00	NVDA	Stock	0.313	0.317	0.3125	0.3163	82438360.0
2010-11-10 12:00:00	NVDA	Stock	0.3163	0.3173	0.3155	0.3158	42054320.0
2010-11-10 13:00:00	NVDA	Stock	0.316	0.317	0.3148	0.316	39520120.0
2010-11-10 14:00:00	NVDA	Stock	0.316	0.317	0.3158	0.317	31031000.0
2010-11-10 15:00:00	NVDA	Stock	0.317	0.3185	0.3168	0.3184	102102840.0
2010-11-10 16:00:00	NVDA	Stock	0.3185	0.3188	0.3158	0.3188	9973120.0
2010-11-10 17:00:00	NVDA	Stock	0.3163	0.3163	0.3125	0.313	620240.0
2010-11-10 18:00:00	NVDA	Stock	0.3125	0.3133	0.3125	0.3133	66000.0
2010-11-10 19:00:00	NVDA	Stock	0.315	0.315	0.3145	0.315	121000.0
2010-11-10 05:00:00	AMZN	Stock	8.516	8.516	8.516	8.516	2000.0
2010-11-10 07:00:00	AMZN	Stock	8.491	8.491	8.491	8.491	2000.0
2010-11-10 08:00:00	AMZN	Stock	8.477	8.5125	8.4705	8.5125	238240.0
2010-11-10 09:00:00	AMZN	Stock	8.5295	8.581	8.4705	8.554	14241060.0
2010-11-10 10:00:00	AMZN	Stock	8.5555	8.5865	8.491	8.5535	19716760.0
2010-11-10 11:00:00	AMZN	Stock	8.5505	8.578	8.5395	8.5625	12768960.0
2010-11-10 12:00:00	AMZN	Stock	8.565	8.6	8.5605	8.5905	10321120.0
2010-11-10 13:00:00	AMZN	Stock	8.5905	8.623	8.5735	8.606	10967960.0
2010-11-10 14:00:00	AMZN	Stock	8.6085	8.6655	8.6065	8.6622	14789660.0

> showing 50 of 44,288 rows — these rows as CSV

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