PREVIEW / stock_1hour / 2012-07-02

all stock 1-hour files

  file:    by_date/stock_1hour/2012/2012-07-02.parquet
  size:    943 KB
  rows:    45,351
  symbols: 3,490

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-07-02 04:00:00	AAPL	Stock	20.875	20.9532	20.875	20.9464	126000.0
2012-07-02 05:00:00	AAPL	Stock	20.9532	20.9536	20.9286	20.9286	54320.0
2012-07-02 06:00:00	AAPL	Stock	20.9214	20.9214	20.8982	20.9018	56280.0
2012-07-02 07:00:00	AAPL	Stock	20.9	20.9561	20.8929	20.8929	271516.0
2012-07-02 08:00:00	AAPL	Stock	20.8929	20.8982	20.8196	20.8661	1253532.0
2012-07-02 09:00:00	AAPL	Stock	20.8607	21.1389	20.8411	21.0791	84401240.0
2012-07-02 10:00:00	AAPL	Stock	21.0825	21.1954	20.9679	21.1143	99987776.0
2012-07-02 11:00:00	AAPL	Stock	21.1129	21.1607	21.08	21.08	51005192.0
2012-07-02 12:00:00	AAPL	Stock	21.0832	21.1189	21.0139	21.0954	47415200.0
2012-07-02 13:00:00	AAPL	Stock	21.0954	21.1446	21.0714	21.1107	23299164.0
2012-07-02 14:00:00	AAPL	Stock	21.1107	21.1371	21.0871	21.1248	25807516.0
2012-07-02 15:00:00	AAPL	Stock	21.1236	21.17	21.08	21.1682	52439464.0
2012-07-02 16:00:00	AAPL	Stock	21.1616	21.175	21.1034	21.1664	7142464.0
2012-07-02 17:00:00	AAPL	Stock	21.1661	21.1764	21.1614	21.1761	323904.0
2012-07-02 18:00:00	AAPL	Stock	21.1768	21.1889	21.175	21.1861	330456.0
2012-07-02 19:00:00	AAPL	Stock	21.18	21.1857	21.1679	21.1786	264264.0
2012-07-02 08:00:00	MSFT	Stock	30.55	30.59	30.48	30.5	10193.0
2012-07-02 09:00:00	MSFT	Stock	30.52	30.64	30.39	30.51	3050034.0
2012-07-02 10:00:00	MSFT	Stock	30.51	30.515	30.282	30.36	5142926.0
2012-07-02 11:00:00	MSFT	Stock	30.363	30.43	30.21	30.39	3277448.0
2012-07-02 12:00:00	MSFT	Stock	30.395	30.49	30.29	30.455	3359828.0
2012-07-02 13:00:00	MSFT	Stock	30.45	30.5	30.41	30.45	1746316.0
2012-07-02 14:00:00	MSFT	Stock	30.442	30.52	30.43	30.485	3244571.0
2012-07-02 15:00:00	MSFT	Stock	30.49	30.57	30.41	30.54	5554554.0
2012-07-02 16:00:00	MSFT	Stock	30.55	30.57	30.35	30.42	4234892.0
2012-07-02 17:00:00	MSFT	Stock	30.47	30.56	30.35	30.35	12796.0
2012-07-02 18:00:00	MSFT	Stock	30.44	30.45	30.35	30.37	5666.0
2012-07-02 19:00:00	MSFT	Stock	30.37	30.38	30.03	30.28	16545.0
2012-07-02 08:00:00	NVDA	Stock	0.3462	0.3465	0.3455	0.3465	194000.0
2012-07-02 09:00:00	NVDA	Stock	0.3462	0.3475	0.3395	0.3405	56501760.0
2012-07-02 10:00:00	NVDA	Stock	0.3402	0.3405	0.337	0.3375	102458720.0
2012-07-02 11:00:00	NVDA	Stock	0.3374	0.338	0.3355	0.3368	68915400.0
2012-07-02 12:00:00	NVDA	Stock	0.3368	0.3375	0.3355	0.3368	66401320.0
2012-07-02 13:00:00	NVDA	Stock	0.3368	0.3378	0.3353	0.3358	79678400.0
2012-07-02 14:00:00	NVDA	Stock	0.3358	0.336	0.3338	0.3353	70393440.0
2012-07-02 15:00:00	NVDA	Stock	0.335	0.3366	0.3335	0.3362	123327120.0
2012-07-02 16:00:00	NVDA	Stock	0.3362	0.337	0.3355	0.336	10137680.0
2012-07-02 17:00:00	NVDA	Stock	0.336	0.3361	0.336	0.336	1043400.0
2012-07-02 18:00:00	NVDA	Stock	0.337	0.3373	0.337	0.3373	60000.0
2012-07-02 19:00:00	NVDA	Stock	0.3385	0.3385	0.3385	0.3385	16000.0
2012-07-02 05:00:00	AMZN	Stock	11.4985	11.4985	11.4985	11.4985	2000.0
2012-07-02 07:00:00	AMZN	Stock	11.4755	11.4755	11.4755	11.4755	2000.0
2012-07-02 08:00:00	AMZN	Stock	11.38	11.45	11.38	11.4215	269160.0
2012-07-02 09:00:00	AMZN	Stock	11.425	11.4895	11.3545	11.3546	7808680.0
2012-07-02 10:00:00	AMZN	Stock	11.3605	11.4135	11.317	11.343	8900460.0
2012-07-02 11:00:00	AMZN	Stock	11.3425	11.3935	11.3175	11.3725	5736280.0
2012-07-02 12:00:00	AMZN	Stock	11.3725	11.456	11.3725	11.445	5651080.0
2012-07-02 13:00:00	AMZN	Stock	11.4445	11.4445	11.4095	11.4193	2711040.0
2012-07-02 14:00:00	AMZN	Stock	11.4195	11.437	11.4	11.435	3714980.0
2012-07-02 15:00:00	AMZN	Stock	11.4336	11.467	11.4166	11.4655	9411440.0

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

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