PREVIEW / stock_1hour / 2013-02-28

all stock 1-hour files

  file:    by_date/stock_1hour/2013/2013-02-28.parquet
  size:    982 KB
  rows:    45,785
  symbols: 3,462

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
2013-02-28 05:00:00	AAPL	Stock	15.8964	15.8964	15.8964	15.8964	58800.0
2013-02-28 07:00:00	AAPL	Stock	15.8929	15.9107	15.8571	15.8746	385224.0
2013-02-28 08:00:00	AAPL	Stock	15.9018	15.9211	15.8307	15.865	862624.0
2013-02-28 09:00:00	AAPL	Stock	15.8657	15.9779	15.8214	15.8896	53114796.0
2013-02-28 10:00:00	AAPL	Stock	15.8843	15.9954	15.8404	15.8779	54322184.0
2013-02-28 11:00:00	AAPL	Stock	15.8775	15.9286	15.8504	15.8915	27506640.0
2013-02-28 12:00:00	AAPL	Stock	15.8929	15.9518	15.8904	15.9097	20818924.0
2013-02-28 13:00:00	AAPL	Stock	15.9079	15.9471	15.8857	15.9275	22332968.0
2013-02-28 14:00:00	AAPL	Stock	15.9275	15.9568	15.8571	15.8696	30495388.0
2013-02-28 15:00:00	AAPL	Stock	15.8754	15.9	15.7646	15.765	59124968.0
2013-02-28 16:00:00	AAPL	Stock	15.7643	15.9125	15.7406	15.7682	37964808.0
2013-02-28 17:00:00	AAPL	Stock	15.7696	15.7768	15.7643	15.7732	3272612.0
2013-02-28 18:00:00	AAPL	Stock	15.7732	15.7864	15.7643	15.775	264180.0
2013-02-28 19:00:00	AAPL	Stock	15.7689	15.7725	15.7646	15.7657	121240.0
2013-02-28 08:00:00	MSFT	Stock	27.94	27.94	27.58	27.85	16899.0
2013-02-28 09:00:00	MSFT	Stock	27.85	27.97	27.74	27.89	2963567.0
2013-02-28 10:00:00	MSFT	Stock	27.89	27.94	27.75	27.76	4205241.0
2013-02-28 11:00:00	MSFT	Stock	27.765	27.87	27.75	27.84	2619547.0
2013-02-28 12:00:00	MSFT	Stock	27.84	27.88	27.83	27.855	1704438.0
2013-02-28 13:00:00	MSFT	Stock	27.85	27.94	27.83	27.94	2808285.0
2013-02-28 14:00:00	MSFT	Stock	27.935	27.96	27.9	27.915	3056073.0
2013-02-28 15:00:00	MSFT	Stock	27.915	27.92	27.77	27.775	9482247.0
2013-02-28 16:00:00	MSFT	Stock	27.77	27.929	27.77	27.8	8386634.0
2013-02-28 17:00:00	MSFT	Stock	27.8	27.81	27.78	27.8	18645.0
2013-02-28 18:00:00	MSFT	Stock	27.8	27.81	27.8	27.81	1400.0
2013-02-28 19:00:00	MSFT	Stock	27.8	27.8	27.78	27.78	700.0
2013-02-28 08:00:00	NVDA	Stock	0.315	0.315	0.315	0.315	12000.0
2013-02-28 09:00:00	NVDA	Stock	0.314	0.3185	0.3128	0.3185	48855800.0
2013-02-28 10:00:00	NVDA	Stock	0.3185	0.32	0.3145	0.3154	118348920.0
2013-02-28 11:00:00	NVDA	Stock	0.3153	0.3183	0.3151	0.3171	53514600.0
2013-02-28 12:00:00	NVDA	Stock	0.3173	0.3186	0.316	0.3185	53055040.0
2013-02-28 13:00:00	NVDA	Stock	0.3184	0.321	0.3184	0.3198	78790600.0
2013-02-28 14:00:00	NVDA	Stock	0.3198	0.3213	0.3193	0.32	62269400.0
2013-02-28 15:00:00	NVDA	Stock	0.32	0.32	0.3165	0.3165	128109320.0
2013-02-28 16:00:00	NVDA	Stock	0.3165	0.3188	0.3146	0.3165	44277440.0
2013-02-28 17:00:00	NVDA	Stock	0.3165	0.3165	0.3165	0.3165	54680.0
2013-02-28 19:00:00	NVDA	Stock	0.3165	0.3165	0.3165	0.3165	4000.0
2013-02-28 04:00:00	AMZN	Stock	13.1625	13.1625	13.1625	13.1625	2000.0
2013-02-28 08:00:00	AMZN	Stock	13.25	13.25	13.1075	13.1075	137400.0
2013-02-28 09:00:00	AMZN	Stock	13.111	13.2365	13.0315	13.168	8855740.0
2013-02-28 10:00:00	AMZN	Stock	13.1595	13.229	13.1045	13.199	11215480.0
2013-02-28 11:00:00	AMZN	Stock	13.1975	13.248	13.18	13.2345	3593120.0
2013-02-28 12:00:00	AMZN	Stock	13.2315	13.275	13.221	13.267	5169840.0
2013-02-28 13:00:00	AMZN	Stock	13.2605	13.35	13.2435	13.3305	5291560.0
2013-02-28 14:00:00	AMZN	Stock	13.3305	13.3355	13.2385	13.2525	4948800.0
2013-02-28 15:00:00	AMZN	Stock	13.255	13.2585	13.2045	13.2085	6914800.0
2013-02-28 16:00:00	AMZN	Stock	13.2135	13.24	13.2055	13.2135	2474320.0
2013-02-28 17:00:00	AMZN	Stock	13.239	13.239	13.2	13.2325	27520.0
2013-02-28 18:00:00	AMZN	Stock	13.1825	13.1825	13.1825	13.1825	3000.0
2013-02-28 19:00:00	AMZN	Stock	13.178	13.1875	13.1655	13.1655	16100.0

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

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