PREVIEW / stock_1hour / 2013-07-24

all stock 1-hour files

  file:    by_date/stock_1hour/2013/2013-07-24.parquet
  size:    1003 KB
  rows:    46,315
  symbols: 3,502

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-07-24 04:00:00	AAPL	Stock	15.5	15.5632	15.5	15.5632	221424.0
2013-07-24 05:00:00	AAPL	Stock	15.5107	15.5625	15.5	15.5621	98588.0
2013-07-24 06:00:00	AAPL	Stock	15.5536	15.5836	15.5	15.5836	96740.0
2013-07-24 07:00:00	AAPL	Stock	15.575	15.7232	15.5714	15.6964	2404024.0
2013-07-24 08:00:00	AAPL	Stock	15.6786	15.7089	15.5714	15.6846	6094648.0
2013-07-24 09:00:00	AAPL	Stock	15.6843	15.7321	15.545	15.6107	132395564.0
2013-07-24 10:00:00	AAPL	Stock	15.6114	15.8654	15.5771	15.8339	151736480.0
2013-07-24 11:00:00	AAPL	Stock	15.8296	15.8739	15.8036	15.8107	66332028.0
2013-07-24 12:00:00	AAPL	Stock	15.8111	15.8329	15.7618	15.8279	48098428.0
2013-07-24 13:00:00	AAPL	Stock	15.83	15.8389	15.7446	15.7971	36219176.0
2013-07-24 14:00:00	AAPL	Stock	15.795	15.8782	15.79	15.8368	50581020.0
2013-07-24 15:00:00	AAPL	Stock	15.8375	15.8407	15.725	15.7375	71180256.0
2013-07-24 16:00:00	AAPL	Stock	15.7361	15.8248	15.7325	15.7707	12711748.0
2013-07-24 17:00:00	AAPL	Stock	15.7725	15.8218	15.75	15.7714	345520.0
2013-07-24 18:00:00	AAPL	Stock	15.7768	15.7857	15.7625	15.7643	28952.0
2013-07-24 19:00:00	AAPL	Stock	15.7661	15.7757	15.7575	15.7714	111188.0
2013-07-24 06:00:00	MSFT	Stock	31.93	31.93	31.93	31.93	100.0
2013-07-24 07:00:00	MSFT	Stock	31.94	31.95	31.93	31.95	2192.0
2013-07-24 08:00:00	MSFT	Stock	31.91	31.98	31.89	31.9	22207.0
2013-07-24 09:00:00	MSFT	Stock	31.94	32.19	31.91	32.0	9364209.0
2013-07-24 10:00:00	MSFT	Stock	31.99	32.1	31.89	32.044	8550910.0
2013-07-24 11:00:00	MSFT	Stock	32.045	32.08	31.95	32.01	7979463.0
2013-07-24 12:00:00	MSFT	Stock	32.01	32.02	31.95	31.98	4050430.0
2013-07-24 13:00:00	MSFT	Stock	31.99	32.0	31.93	31.965	3156538.0
2013-07-24 14:00:00	MSFT	Stock	31.97	32.03	31.93	31.973	4412611.0
2013-07-24 15:00:00	MSFT	Stock	31.98	32.03	31.92	31.97	7039247.0
2013-07-24 16:00:00	MSFT	Stock	31.96	32.003	31.93	31.99	7593502.0
2013-07-24 17:00:00	MSFT	Stock	32.011	32.03	31.99	32.03	20090.0
2013-07-24 18:00:00	MSFT	Stock	32.05	32.05	31.96	31.96	2403.0
2013-07-24 19:00:00	MSFT	Stock	31.95	31.95	31.93	31.95	7466.0
2013-07-24 08:00:00	NVDA	Stock	0.3582	0.3585	0.358	0.358	90320.0
2013-07-24 09:00:00	NVDA	Stock	0.3582	0.3595	0.357	0.3582	32690320.0
2013-07-24 10:00:00	NVDA	Stock	0.3581	0.3588	0.356	0.358	42204160.0
2013-07-24 11:00:00	NVDA	Stock	0.358	0.3592	0.3572	0.3572	19650280.0
2013-07-24 12:00:00	NVDA	Stock	0.3575	0.3576	0.356	0.3568	15068680.0
2013-07-24 13:00:00	NVDA	Stock	0.3568	0.357	0.355	0.3558	26219480.0
2013-07-24 14:00:00	NVDA	Stock	0.3558	0.3565	0.355	0.355	18387080.0
2013-07-24 15:00:00	NVDA	Stock	0.3551	0.357	0.3548	0.3553	116000080.0
2013-07-24 16:00:00	NVDA	Stock	0.3553	0.3564	0.3535	0.3553	3026840.0
2013-07-24 05:00:00	AMZN	Stock	15.092	15.092	15.08	15.08	6000.0
2013-07-24 07:00:00	AMZN	Stock	15.1375	15.185	15.1375	15.185	12000.0
2013-07-24 08:00:00	AMZN	Stock	15.15	15.1505	15.15	15.15	10000.0
2013-07-24 09:00:00	AMZN	Stock	15.129	15.192	15.0665	15.081	4128260.0
2013-07-24 10:00:00	AMZN	Stock	15.074	15.1285	15.0005	15.02	7859940.0
2013-07-24 11:00:00	AMZN	Stock	15.0125	15.069	15.012	15.0495	4415460.0
2013-07-24 12:00:00	AMZN	Stock	15.0565	15.0675	14.9605	14.9735	4754520.0
2013-07-24 13:00:00	AMZN	Stock	14.9686	14.9935	14.9125	14.9325	5738740.0
2013-07-24 14:00:00	AMZN	Stock	14.931	14.9895	14.926	14.9528	3581840.0
2013-07-24 15:00:00	AMZN	Stock	14.951	14.956	14.902	14.947	7601520.0
2013-07-24 16:00:00	AMZN	Stock	14.947	15.0415	14.9	14.947	1272420.0

> showing 50 of 46,315 rows — these rows as CSV

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