PREVIEW / stock_1hour / 2013-06-24

all stock 1-hour files

  file:    by_date/stock_1hour/2013/2013-06-24.parquet
  size:    1.0 MB
  rows:    48,244
  symbols: 3,521

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-06-24 04:00:00	AAPL	Stock	14.7143	14.7304	14.6536	14.6589	33712.0
2013-06-24 05:00:00	AAPL	Stock	14.6432	14.6432	14.6429	14.6429	21336.0
2013-06-24 06:00:00	AAPL	Stock	14.6429	14.6429	14.5896	14.6	58968.0
2013-06-24 07:00:00	AAPL	Stock	14.6107	14.6196	14.5271	14.5689	517356.0
2013-06-24 08:00:00	AAPL	Stock	14.5714	14.75	14.5357	14.6032	2426312.0
2013-06-24 09:00:00	AAPL	Stock	14.6	14.6014	14.3336	14.3696	78476916.0
2013-06-24 10:00:00	AAPL	Stock	14.3682	14.4167	14.3096	14.3571	83948760.0
2013-06-24 11:00:00	AAPL	Stock	14.36	14.3709	14.2161	14.2686	76796748.0
2013-06-24 12:00:00	AAPL	Stock	14.2687	14.3211	14.25	14.2789	34776252.0
2013-06-24 13:00:00	AAPL	Stock	14.2839	14.3561	14.2679	14.3464	36539580.0
2013-06-24 14:00:00	AAPL	Stock	14.3464	14.4546	14.3239	14.4325	49446572.0
2013-06-24 15:00:00	AAPL	Stock	14.4325	14.4911	14.3568	14.3621	75122124.0
2013-06-24 16:00:00	AAPL	Stock	14.3694	14.3857	14.2733	14.3714	11868416.0
2013-06-24 17:00:00	AAPL	Stock	14.3721	14.3964	14.3675	14.3675	353416.0
2013-06-24 18:00:00	AAPL	Stock	14.375	14.3946	14.3736	14.3925	134624.0
2013-06-24 19:00:00	AAPL	Stock	14.3839	14.3918	14.3721	14.3761	194040.0
2013-06-24 04:00:00	MSFT	Stock	33.06	33.06	33.06	33.06	200.0
2013-06-24 05:00:00	MSFT	Stock	32.97	32.97	32.97	32.97	100.0
2013-06-24 06:00:00	MSFT	Stock	32.99	32.99	32.99	32.99	100.0
2013-06-24 07:00:00	MSFT	Stock	32.96	33.04	32.91	32.93	7000.0
2013-06-24 08:00:00	MSFT	Stock	33.0	33.1	32.94	33.09	132522.0
2013-06-24 09:00:00	MSFT	Stock	33.04	33.11	32.57	33.01	7564363.0
2013-06-24 10:00:00	MSFT	Stock	33.0	33.45	32.83	33.365	9644786.0
2013-06-24 11:00:00	MSFT	Stock	33.365	33.45	33.27	33.39	6317035.0
2013-06-24 12:00:00	MSFT	Stock	33.395	33.72	33.32	33.7	5826459.0
2013-06-24 13:00:00	MSFT	Stock	33.7	34.05	33.63	34.02	6722674.0
2013-06-24 14:00:00	MSFT	Stock	34.025	34.2	33.95	34.065	6426138.0
2013-06-24 15:00:00	MSFT	Stock	34.06	34.11	33.71	33.71	10355322.0
2013-06-24 16:00:00	MSFT	Stock	33.71	33.98	33.281	33.72	2621947.0
2013-06-24 17:00:00	MSFT	Stock	33.72	33.78	33.71	33.78	5030.0
2013-06-24 18:00:00	MSFT	Stock	33.79	33.79	33.78	33.79	2852.0
2013-06-24 19:00:00	MSFT	Stock	33.79	33.79	33.72	33.79	1868.0
2013-06-24 07:00:00	NVDA	Stock	0.351	0.351	0.351	0.351	4000.0
2013-06-24 08:00:00	NVDA	Stock	0.3578	0.3578	0.3548	0.3548	12000.0
2013-06-24 09:00:00	NVDA	Stock	0.3553	0.3598	0.3495	0.3498	64284080.0
2013-06-24 10:00:00	NVDA	Stock	0.3498	0.3538	0.3478	0.3518	127432440.0
2013-06-24 11:00:00	NVDA	Stock	0.3518	0.3533	0.3485	0.3528	68545280.0
2013-06-24 12:00:00	NVDA	Stock	0.3528	0.3545	0.3515	0.3542	49998800.0
2013-06-24 13:00:00	NVDA	Stock	0.3542	0.355	0.3525	0.3545	45242480.0
2013-06-24 14:00:00	NVDA	Stock	0.3548	0.3572	0.354	0.3545	42924000.0
2013-06-24 15:00:00	NVDA	Stock	0.3544	0.3558	0.3528	0.3528	72986240.0
2013-06-24 16:00:00	NVDA	Stock	0.353	0.3535	0.353	0.3531	83438880.0
2013-06-24 17:00:00	NVDA	Stock	0.353	0.353	0.353	0.353	561120.0
2013-06-24 04:00:00	AMZN	Stock	13.6	13.6	13.55	13.55	4000.0
2013-06-24 06:00:00	AMZN	Stock	13.55	13.55	13.5125	13.5125	12000.0
2013-06-24 07:00:00	AMZN	Stock	13.525	13.525	13.51	13.51	70000.0
2013-06-24 08:00:00	AMZN	Stock	13.516	13.65	13.465	13.5725	340040.0
2013-06-24 09:00:00	AMZN	Stock	13.5725	13.5875	13.25	13.388	13635700.0
2013-06-24 10:00:00	AMZN	Stock	13.386	13.4845	13.3335	13.439	26924600.0
2013-06-24 11:00:00	AMZN	Stock	13.45	13.4615	13.303	13.3854	6368600.0

> showing 50 of 48,244 rows — these rows as CSV

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