PREVIEW / stock_1hour / 2012-02-06

all stock 1-hour files

  file:    by_date/stock_1hour/2012/2012-02-06.parquet
  size:    948 KB
  rows:    44,915
  symbols: 3,553

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-06 06:00:00	AAPL	Stock	16.3607	16.3607	16.3571	16.3571	23520.0
2012-02-06 07:00:00	AAPL	Stock	16.3654	16.3829	16.3582	16.3589	59108.0
2012-02-06 08:00:00	AAPL	Stock	16.3711	16.3846	16.3443	16.3539	503160.0
2012-02-06 09:00:00	AAPL	Stock	16.3496	16.4743	16.3468	16.4639	37991436.0
2012-02-06 10:00:00	AAPL	Stock	16.4636	16.5179	16.4547	16.5082	46283216.0
2012-02-06 11:00:00	AAPL	Stock	16.5082	16.5954	16.5004	16.5821	51867844.0
2012-02-06 12:00:00	AAPL	Stock	16.5821	16.6064	16.5525	16.5961	32113788.0
2012-02-06 13:00:00	AAPL	Stock	16.5961	16.6018	16.5468	16.5529	20767432.0
2012-02-06 14:00:00	AAPL	Stock	16.5539	16.575	16.5464	16.5518	16164456.0
2012-02-06 15:00:00	AAPL	Stock	16.55	16.5696	16.5482	16.5664	32257064.0
2012-02-06 16:00:00	AAPL	Stock	16.5704	16.5782	16.5263	16.5725	6695108.0
2012-02-06 17:00:00	AAPL	Stock	16.5721	16.6018	16.5721	16.5857	492996.0
2012-02-06 18:00:00	AAPL	Stock	16.5889	16.5925	16.585	16.5914	208880.0
2012-02-06 19:00:00	AAPL	Stock	16.59	16.5911	16.5821	16.5911	155484.0
2012-02-06 07:00:00	MSFT	Stock	30.09	30.13	30.05	30.13	5343.0
2012-02-06 08:00:00	MSFT	Stock	30.16	30.17	30.04	30.06	13929.0
2012-02-06 09:00:00	MSFT	Stock	30.04	30.18	30.01	30.08	3270004.0
2012-02-06 10:00:00	MSFT	Stock	30.08	30.14	29.99	30.06	4330325.0
2012-02-06 11:00:00	MSFT	Stock	30.06	30.1	29.99	30.01	4397292.0
2012-02-06 12:00:00	MSFT	Stock	30.02	30.05	29.97	30.01	2423999.0
2012-02-06 13:00:00	MSFT	Stock	30.012	30.08	29.99	30.07	2332174.0
2012-02-06 14:00:00	MSFT	Stock	30.076	30.16	30.06	30.07	3134951.0
2012-02-06 15:00:00	MSFT	Stock	30.08	30.22	30.07	30.2	6193338.0
2012-02-06 16:00:00	MSFT	Stock	30.191	30.22	30.081	30.16	1586316.0
2012-02-06 17:00:00	MSFT	Stock	30.16	30.16	30.025	30.16	37072.0
2012-02-06 18:00:00	MSFT	Stock	30.15	30.15	30.14	30.15	3430.0
2012-02-06 19:00:00	MSFT	Stock	30.14	30.16	30.14	30.16	600.0
2012-02-06 08:00:00	NVDA	Stock	0.3948	0.3955	0.3938	0.3938	136400.0
2012-02-06 09:00:00	NVDA	Stock	0.3928	0.3938	0.389	0.393	46584720.0
2012-02-06 10:00:00	NVDA	Stock	0.393	0.394	0.3898	0.392	61529240.0
2012-02-06 11:00:00	NVDA	Stock	0.3918	0.3932	0.391	0.3918	28101320.0
2012-02-06 12:00:00	NVDA	Stock	0.3918	0.394	0.3902	0.3931	23213160.0
2012-02-06 13:00:00	NVDA	Stock	0.393	0.3935	0.3925	0.393	24115480.0
2012-02-06 14:00:00	NVDA	Stock	0.3928	0.393	0.392	0.392	25845640.0
2012-02-06 15:00:00	NVDA	Stock	0.392	0.3928	0.3913	0.3925	59437960.0
2012-02-06 16:00:00	NVDA	Stock	0.3922	0.3928	0.3906	0.3915	8797440.0
2012-02-06 17:00:00	NVDA	Stock	0.3913	0.3925	0.3913	0.3925	118720.0
2012-02-06 18:00:00	NVDA	Stock	0.3915	0.3915	0.3915	0.3915	48000.0
2012-02-06 19:00:00	NVDA	Stock	0.3925	0.3925	0.3925	0.3925	20000.0
2012-02-06 04:00:00	AMZN	Stock	9.35	9.35	9.33	9.33	4000.0
2012-02-06 06:00:00	AMZN	Stock	9.34	9.34	9.33	9.33	9000.0
2012-02-06 07:00:00	AMZN	Stock	9.3435	9.35	9.301	9.333	97960.0
2012-02-06 08:00:00	AMZN	Stock	9.309	9.335	9.2855	9.299	225840.0
2012-02-06 09:00:00	AMZN	Stock	9.2995	9.328	9.1975	9.23	19020220.0
2012-02-06 10:00:00	AMZN	Stock	9.226	9.2465	9.1724	9.2015	15589520.0
2012-02-06 11:00:00	AMZN	Stock	9.2015	9.2245	9.187	9.2197	12583780.0
2012-02-06 12:00:00	AMZN	Stock	9.22	9.2215	9.18	9.1985	9484420.0
2012-02-06 13:00:00	AMZN	Stock	9.1965	9.2325	9.194	9.225	11235320.0
2012-02-06 14:00:00	AMZN	Stock	9.225	9.226	9.187	9.187	9161940.0
2012-02-06 15:00:00	AMZN	Stock	9.189	9.201	9.146	9.1545	22443260.0

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

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