PREVIEW / stock_1hour / 2013-07-19

all stock 1-hour files

  file:    by_date/stock_1hour/2013/2013-07-19.parquet
  size:    989 KB
  rows:    46,036
  symbols: 3,476

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-19 05:00:00	AAPL	Stock	15.3514	15.3568	15.3514	15.3568	14000.0
2013-07-19 06:00:00	AAPL	Stock	15.3857	15.3961	15.3857	15.3961	5600.0
2013-07-19 07:00:00	AAPL	Stock	15.3839	15.4004	15.3839	15.4004	30100.0
2013-07-19 08:00:00	AAPL	Stock	15.4086	15.4732	15.3839	15.4643	785540.0
2013-07-19 09:00:00	AAPL	Stock	15.4536	15.5218	15.2839	15.3411	59776920.0
2013-07-19 10:00:00	AAPL	Stock	15.3414	15.3414	15.1979	15.2168	57935724.0
2013-07-19 11:00:00	AAPL	Stock	15.2171	15.2929	15.2143	15.2318	33910268.0
2013-07-19 12:00:00	AAPL	Stock	15.2336	15.2546	15.205	15.2321	20084988.0
2013-07-19 13:00:00	AAPL	Stock	15.2321	15.275	15.2289	15.2639	13772388.0
2013-07-19 14:00:00	AAPL	Stock	15.2639	15.2839	15.21	15.2196	17786524.0
2013-07-19 15:00:00	AAPL	Stock	15.2211	15.2279	15.1554	15.1771	50565816.0
2013-07-19 16:00:00	AAPL	Stock	15.1786	15.1818	15.1754	15.18	10306548.0
2013-07-19 17:00:00	AAPL	Stock	15.1786	15.2107	15.1768	15.1939	393764.0
2013-07-19 18:00:00	AAPL	Stock	15.1993	15.1993	15.1875	15.1893	58408.0
2013-07-19 19:00:00	AAPL	Stock	15.1946	15.1946	15.1821	15.1875	21140.0
2013-07-19 04:00:00	MSFT	Stock	33.3	33.3	33.21	33.21	1558.0
2013-07-19 05:00:00	MSFT	Stock	33.18	33.18	33.11	33.16	3254.0
2013-07-19 06:00:00	MSFT	Stock	33.08	33.18	32.86	33.0	136988.0
2013-07-19 07:00:00	MSFT	Stock	33.1	33.2	32.8	32.86	1352215.0
2013-07-19 08:00:00	MSFT	Stock	33.02	33.1	32.51	32.55	6435586.0
2013-07-19 09:00:00	MSFT	Stock	32.55	32.65	31.91	32.36	55361515.0
2013-07-19 10:00:00	MSFT	Stock	32.36	32.67	31.97	31.995	43553271.0
2013-07-19 11:00:00	MSFT	Stock	31.995	32.065	31.36	31.58	35927820.0
2013-07-19 12:00:00	MSFT	Stock	31.59	31.69	31.4	31.62	18685352.0
2013-07-19 13:00:00	MSFT	Stock	31.62	31.625	31.1	31.29	20266360.0
2013-07-19 14:00:00	MSFT	Stock	31.288	31.35	31.02	31.11	19543112.0
2013-07-19 15:00:00	MSFT	Stock	31.12	31.49	31.1	31.4	37929103.0
2013-07-19 16:00:00	MSFT	Stock	31.395	32.275	31.253	31.64	4777671.0
2013-07-19 17:00:00	MSFT	Stock	31.68	31.78	31.395	31.57	1278715.0
2013-07-19 18:00:00	MSFT	Stock	31.57	31.61	31.55	31.6	37082.0
2013-07-19 19:00:00	MSFT	Stock	31.6	31.64	31.54	31.6	37167.0
2013-07-19 08:00:00	NVDA	Stock	0.3602	0.3602	0.3602	0.3602	12000.0
2013-07-19 09:00:00	NVDA	Stock	0.3612	0.3632	0.3545	0.3548	72988520.0
2013-07-19 10:00:00	NVDA	Stock	0.3548	0.3558	0.3533	0.355	73911320.0
2013-07-19 11:00:00	NVDA	Stock	0.3553	0.3565	0.3533	0.3533	42212640.0
2013-07-19 12:00:00	NVDA	Stock	0.3533	0.3546	0.3522	0.3539	44933800.0
2013-07-19 13:00:00	NVDA	Stock	0.354	0.3561	0.3538	0.3555	61648880.0
2013-07-19 14:00:00	NVDA	Stock	0.3553	0.3555	0.3542	0.3549	71415640.0
2013-07-19 15:00:00	NVDA	Stock	0.3548	0.3562	0.3545	0.356	95250480.0
2013-07-19 16:00:00	NVDA	Stock	0.356	0.3572	0.3548	0.3548	2921200.0
2013-07-19 19:00:00	NVDA	Stock	0.3572	0.3572	0.3572	0.3572	12000.0
2013-07-19 07:00:00	AMZN	Stock	15.05	15.05	15.05	15.05	32000.0
2013-07-19 08:00:00	AMZN	Stock	15.2	15.2	15.051	15.075	72500.0
2013-07-19 09:00:00	AMZN	Stock	15.0875	15.284	15.08	15.2	19691960.0
2013-07-19 10:00:00	AMZN	Stock	15.207	15.2895	15.184	15.2352	11847540.0
2013-07-19 11:00:00	AMZN	Stock	15.238	15.268	15.18	15.182	6593260.0
2013-07-19 12:00:00	AMZN	Stock	15.186	15.233	15.1815	15.231	3727720.0
2013-07-19 13:00:00	AMZN	Stock	15.2315	15.2495	15.2105	15.2295	2537360.0
2013-07-19 14:00:00	AMZN	Stock	15.229	15.2645	15.2235	15.249	3154420.0
2013-07-19 15:00:00	AMZN	Stock	15.2485	15.266	15.23	15.2615	8374060.0

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

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