PREVIEW / stock_1hour / 2012-02-16

all stock 1-hour files

  file:    by_date/stock_1hour/2012/2012-02-16.parquet
  size:    958 KB
  rows:    45,350
  symbols: 3,526

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
2012-02-16 04:00:00	AAPL	Stock	17.6079	17.7071	17.6079	17.7071	75040.0
2012-02-16 05:00:00	AAPL	Stock	17.6843	17.7232	17.6786	17.7061	54152.0
2012-02-16 06:00:00	AAPL	Stock	17.7264	17.7314	17.7132	17.7146	47600.0
2012-02-16 07:00:00	AAPL	Stock	17.7121	17.7121	17.6157	17.6457	1462300.0
2012-02-16 08:00:00	AAPL	Stock	17.6361	17.7857	17.5861	17.685	10743040.0
2012-02-16 09:00:00	AAPL	Stock	17.6786	17.715	17.3796	17.525	200192272.0
2012-02-16 10:00:00	AAPL	Stock	17.52	17.6693	17.5039	17.5365	145828312.0
2012-02-16 11:00:00	AAPL	Stock	17.5393	17.5932	17.4643	17.5671	101390212.0
2012-02-16 12:00:00	AAPL	Stock	17.5679	17.7482	17.5575	17.7068	116285344.0
2012-02-16 13:00:00	AAPL	Stock	17.7043	18.0318	17.6964	18.01	162918756.0
2012-02-16 14:00:00	AAPL	Stock	18.0096	18.0257	17.8761	17.9205	83125336.0
2012-02-16 15:00:00	AAPL	Stock	17.9232	18.0	17.9039	17.9464	91237972.0
2012-02-16 16:00:00	AAPL	Stock	17.9482	17.9676	17.5099	17.7143	20408304.0
2012-02-16 17:00:00	AAPL	Stock	17.9332	17.9482	17.9286	17.9482	367052.0
2012-02-16 18:00:00	AAPL	Stock	17.955	17.9814	17.9511	17.9732	622244.0
2012-02-16 19:00:00	AAPL	Stock	17.9732	18.0107	17.9689	18.0	476392.0
2012-02-16 07:00:00	MSFT	Stock	30.01	30.08	29.99	30.0	19000.0
2012-02-16 08:00:00	MSFT	Stock	30.04	30.2	30.0	30.16	59493.0
2012-02-16 09:00:00	MSFT	Stock	30.17	30.71	30.17	30.665	7279435.0
2012-02-16 10:00:00	MSFT	Stock	30.67	30.74	30.57	30.595	8343572.0
2012-02-16 11:00:00	MSFT	Stock	30.595	30.95	30.59	30.945	7926618.0
2012-02-16 12:00:00	MSFT	Stock	30.94	31.22	30.88	31.192	14634906.0
2012-02-16 13:00:00	MSFT	Stock	31.2	31.55	31.15	31.445	17091347.0
2012-02-16 14:00:00	MSFT	Stock	31.44	31.55	31.34	31.345	13834129.0
2012-02-16 15:00:00	MSFT	Stock	31.35	31.39	31.22	31.29	18083825.0
2012-02-16 16:00:00	MSFT	Stock	31.3	31.475	30.05	31.36	2951823.0
2012-02-16 17:00:00	MSFT	Stock	31.34	31.34	31.21	31.21	38788.0
2012-02-16 18:00:00	MSFT	Stock	31.2	31.25	31.15	31.24	13400.0
2012-02-16 19:00:00	MSFT	Stock	31.24	31.28	31.24	31.28	7680.0
2012-02-16 06:00:00	NVDA	Stock	0.3783	0.3783	0.3735	0.3773	256000.0
2012-02-16 07:00:00	NVDA	Stock	0.3735	0.3813	0.3735	0.3813	3390120.0
2012-02-16 08:00:00	NVDA	Stock	0.3813	0.3818	0.374	0.3795	14687000.0
2012-02-16 09:00:00	NVDA	Stock	0.3795	0.3898	0.375	0.388	329240240.0
2012-02-16 10:00:00	NVDA	Stock	0.3882	0.3995	0.3882	0.395	418946680.0
2012-02-16 11:00:00	NVDA	Stock	0.3953	0.411	0.3948	0.41	370706280.0
2012-02-16 12:00:00	NVDA	Stock	0.4098	0.411	0.4043	0.4093	156333280.0
2012-02-16 13:00:00	NVDA	Stock	0.4093	0.4125	0.4088	0.4105	145088000.0
2012-02-16 14:00:00	NVDA	Stock	0.4108	0.4133	0.41	0.4128	142751600.0
2012-02-16 15:00:00	NVDA	Stock	0.4128	0.4145	0.4108	0.4115	275683760.0
2012-02-16 16:00:00	NVDA	Stock	0.412	0.4138	0.4005	0.4112	2372880.0
2012-02-16 17:00:00	NVDA	Stock	0.4112	0.413	0.4112	0.4118	195600.0
2012-02-16 18:00:00	NVDA	Stock	0.4125	0.4125	0.4115	0.4122	218400.0
2012-02-16 19:00:00	NVDA	Stock	0.4128	0.4135	0.4115	0.4135	238200.0
2012-02-16 04:00:00	AMZN	Stock	9.125	9.125	9.0905	9.1045	8000.0
2012-02-16 05:00:00	AMZN	Stock	9.093	9.094	9.002	9.025	114820.0
2012-02-16 06:00:00	AMZN	Stock	9.008	9.017	8.9505	8.9875	180400.0
2012-02-16 07:00:00	AMZN	Stock	9.0	9.0	8.856	8.8875	1129800.0
2012-02-16 08:00:00	AMZN	Stock	8.8875	8.99	8.865	8.9195	2554040.0
2012-02-16 09:00:00	AMZN	Stock	8.9195	8.93	8.757	8.837	63934020.0
2012-02-16 10:00:00	AMZN	Stock	8.837	8.878	8.811	8.815	36414700.0

> showing 50 of 45,350 rows — these rows as CSV

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