PREVIEW / stock_1hour / 2010-11-08

all stock 1-hour files

  file:    by_date/stock_1hour/2010/2010-11-08.parquet
  size:    935 KB
  rows:    44,406
  symbols: 3,514

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-08 04:00:00	AAPL	Stock	11.3364	11.3364	11.2839	11.2839	60228.0
2010-11-08 05:00:00	AAPL	Stock	11.2946	11.3132	11.2857	11.2929	28000.0
2010-11-08 06:00:00	AAPL	Stock	11.2868	11.2868	11.2868	11.2868	5600.0
2010-11-08 07:00:00	AAPL	Stock	11.29	11.3179	11.29	11.3179	129612.0
2010-11-08 08:00:00	AAPL	Stock	11.3121	11.355	11.3075	11.3504	1831732.0
2010-11-08 09:00:00	AAPL	Stock	11.35	11.4014	11.3129	11.3582	62040608.0
2010-11-08 10:00:00	AAPL	Stock	11.3575	11.415	11.3421	11.3932	62734672.0
2010-11-08 11:00:00	AAPL	Stock	11.3929	11.3992	11.3779	11.39	25306596.0
2010-11-08 12:00:00	AAPL	Stock	11.3907	11.4018	11.3821	11.3939	16717428.0
2010-11-08 13:00:00	AAPL	Stock	11.3916	11.4018	11.3821	11.3876	17145212.0
2010-11-08 14:00:00	AAPL	Stock	11.3868	11.3954	11.3768	11.3786	17291736.0
2010-11-08 15:00:00	AAPL	Stock	11.38	11.4089	11.3696	11.3857	53205040.0
2010-11-08 16:00:00	AAPL	Stock	11.3861	11.3936	11.3261	11.3761	16754192.0
2010-11-08 17:00:00	AAPL	Stock	11.3861	11.3861	11.3679	11.3696	619724.0
2010-11-08 18:00:00	AAPL	Stock	11.3682	11.3793	11.3629	11.3629	541240.0
2010-11-08 19:00:00	AAPL	Stock	11.3643	11.3643	11.3429	11.3571	1136856.0
2010-11-08 04:00:00	MSFT	Stock	26.65	26.65	26.65	26.65	300.0
2010-11-08 05:00:00	MSFT	Stock	26.9	26.9	26.89	26.89	400.0
2010-11-08 06:00:00	MSFT	Stock	26.69	26.69	26.65	26.69	10100.0
2010-11-08 07:00:00	MSFT	Stock	26.69	26.78	26.69	26.74	12277.0
2010-11-08 08:00:00	MSFT	Stock	26.75	26.75	26.67	26.73	88058.0
2010-11-08 09:00:00	MSFT	Stock	26.72	26.83	26.58	26.79	7127865.0
2010-11-08 10:00:00	MSFT	Stock	26.79	26.98	26.77	26.95	9454333.0
2010-11-08 11:00:00	MSFT	Stock	26.945	27.05	26.9	27.02	6152557.0
2010-11-08 12:00:00	MSFT	Stock	27.029	27.03	26.9	26.9	4861100.0
2010-11-08 13:00:00	MSFT	Stock	26.9	26.94	26.87	26.9	5234637.0
2010-11-08 14:00:00	MSFT	Stock	26.89	26.93	26.81	26.85	6888634.0
2010-11-08 15:00:00	MSFT	Stock	26.847	26.9	26.75	26.81	10782710.0
2010-11-08 16:00:00	MSFT	Stock	26.81	26.879	26.768	26.8	1614517.0
2010-11-08 17:00:00	MSFT	Stock	26.81	26.81	26.72	26.76	52243.0
2010-11-08 18:00:00	MSFT	Stock	26.76	26.81	26.73	26.78	14864.0
2010-11-08 19:00:00	MSFT	Stock	26.74	26.78	26.73	26.77	7028.0
2010-11-08 08:00:00	NVDA	Stock	0.3128	0.314	0.3128	0.3133	264000.0
2010-11-08 09:00:00	NVDA	Stock	0.3133	0.3173	0.3125	0.3148	96006520.0
2010-11-08 10:00:00	NVDA	Stock	0.3148	0.3183	0.3145	0.3158	113532840.0
2010-11-08 11:00:00	NVDA	Stock	0.3158	0.3168	0.315	0.3168	64289200.0
2010-11-08 12:00:00	NVDA	Stock	0.3166	0.3175	0.3163	0.317	50418440.0
2010-11-08 13:00:00	NVDA	Stock	0.3173	0.3185	0.3168	0.3183	63188760.0
2010-11-08 14:00:00	NVDA	Stock	0.3183	0.3193	0.3173	0.3175	63636640.0
2010-11-08 15:00:00	NVDA	Stock	0.3175	0.3183	0.3155	0.3165	130125040.0
2010-11-08 16:00:00	NVDA	Stock	0.316	0.3175	0.3155	0.3175	2581680.0
2010-11-08 17:00:00	NVDA	Stock	0.3163	0.3185	0.3163	0.3183	285320.0
2010-11-08 19:00:00	NVDA	Stock	0.3168	0.3168	0.3168	0.3168	12000.0
2010-11-08 05:00:00	AMZN	Stock	8.51	8.51	8.51	8.51	2000.0
2010-11-08 06:00:00	AMZN	Stock	8.51	8.51	8.51	8.51	2000.0
2010-11-08 07:00:00	AMZN	Stock	8.51	8.5665	8.51	8.56	14000.0
2010-11-08 08:00:00	AMZN	Stock	8.5385	8.555	8.526	8.552	208240.0
2010-11-08 09:00:00	AMZN	Stock	8.5505	8.555	8.4445	8.4545	13497820.0
2010-11-08 10:00:00	AMZN	Stock	8.4545	8.5995	8.439	8.58	19692440.0
2010-11-08 11:00:00	AMZN	Stock	8.581	8.635	8.5595	8.635	12449680.0

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

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