PREVIEW / stock_1hour / 2015-04-16

all stock 1-hour files

  file:    by_date/stock_1hour/2015/2015-04-16.parquet
  size:    1.0 MB
  rows:    48,730
  symbols: 3,515

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
2015-04-16 04:00:00	AAPL	Stock	31.65	31.685	31.625	31.625	12020.0
2015-04-16 05:00:00	AAPL	Stock	31.67	31.6725	31.6375	31.6375	5028.0
2015-04-16 06:00:00	AAPL	Stock	31.6	31.625	31.575	31.605	26656.0
2015-04-16 07:00:00	AAPL	Stock	31.6	31.6125	31.5775	31.6125	99448.0
2015-04-16 08:00:00	AAPL	Stock	31.6125	31.67	31.5775	31.595	423632.0
2015-04-16 09:00:00	AAPL	Stock	31.6025	31.775	31.5425	31.6525	17186132.0
2015-04-16 10:00:00	AAPL	Stock	31.655	31.7	31.605	31.6215	16100232.0
2015-04-16 11:00:00	AAPL	Stock	31.6175	31.6625	31.5825	31.66	11017816.0
2015-04-16 12:00:00	AAPL	Stock	31.6612	31.67	31.5825	31.6125	7800788.0
2015-04-16 13:00:00	AAPL	Stock	31.6125	31.73	31.5875	31.7225	10626496.0
2015-04-16 14:00:00	AAPL	Stock	31.723	31.7325	31.5725	31.5775	11940244.0
2015-04-16 15:00:00	AAPL	Stock	31.58	31.64	31.5275	31.545	20715260.0
2015-04-16 16:00:00	AAPL	Stock	31.5425	31.6672	31.5325	31.5475	4165012.0
2015-04-16 17:00:00	AAPL	Stock	31.55	31.6775	31.55	31.6702	812996.0
2015-04-16 18:00:00	AAPL	Stock	31.67	31.675	31.6375	31.64	73764.0
2015-04-16 19:00:00	AAPL	Stock	31.6375	31.6625	31.625	31.66	145848.0
2015-04-16 06:00:00	MSFT	Stock	42.32	42.32	42.32	42.32	760.0
2015-04-16 07:00:00	MSFT	Stock	42.11	42.11	42.08	42.08	3562.0
2015-04-16 08:00:00	MSFT	Stock	42.09	42.11	42.06	42.08	12062.0
2015-04-16 09:00:00	MSFT	Stock	42.08	42.19	41.82	42.055	2797691.0
2015-04-16 10:00:00	MSFT	Stock	42.06	42.14	41.83	42.0	3593797.0
2015-04-16 11:00:00	MSFT	Stock	42.0	42.15	42.0	42.05	2379123.0
2015-04-16 12:00:00	MSFT	Stock	42.05	42.14	42.04	42.084	1202482.0
2015-04-16 13:00:00	MSFT	Stock	42.08	42.32	42.05	42.305	1468923.0
2015-04-16 14:00:00	MSFT	Stock	42.31	42.34	42.25	42.28	1789107.0
2015-04-16 15:00:00	MSFT	Stock	42.285	42.29	42.13	42.17	4604544.0
2015-04-16 16:00:00	MSFT	Stock	42.16	42.18	42.15	42.16	3663688.0
2015-04-16 17:00:00	MSFT	Stock	42.13	42.13	42.13	42.13	1027.0
2015-04-16 18:00:00	MSFT	Stock	42.16	42.16	42.16	42.16	423.0
2015-04-16 19:00:00	MSFT	Stock	42.18	42.18	42.18	42.18	200.0
2015-04-16 08:00:00	NVDA	Stock	0.563	0.563	0.563	0.563	40000.0
2015-04-16 09:00:00	NVDA	Stock	0.562	0.5672	0.562	0.5649	14089720.0
2015-04-16 10:00:00	NVDA	Stock	0.5648	0.566	0.5615	0.5632	18392760.0
2015-04-16 11:00:00	NVDA	Stock	0.563	0.5635	0.559	0.561	17845280.0
2015-04-16 12:00:00	NVDA	Stock	0.561	0.5622	0.5598	0.5598	13547880.0
2015-04-16 13:00:00	NVDA	Stock	0.56	0.5625	0.5582	0.5615	19688320.0
2015-04-16 14:00:00	NVDA	Stock	0.5616	0.5628	0.561	0.5611	13149240.0
2015-04-16 15:00:00	NVDA	Stock	0.5612	0.5638	0.5612	0.5625	45696000.0
2015-04-16 16:00:00	NVDA	Stock	0.5622	0.5622	0.5622	0.5622	1070160.0
2015-04-16 17:00:00	NVDA	Stock	0.5665	0.5665	0.5665	0.5665	8000.0
2015-04-16 08:00:00	AMZN	Stock	19.17	19.205	19.15	19.1805	86260.0
2015-04-16 09:00:00	AMZN	Stock	19.232	19.32	19.1455	19.2735	6001860.0
2015-04-16 10:00:00	AMZN	Stock	19.2658	19.3055	19.222	19.2808	6913620.0
2015-04-16 11:00:00	AMZN	Stock	19.2797	19.3725	19.2785	19.3088	5561260.0
2015-04-16 12:00:00	AMZN	Stock	19.3026	19.324	19.236	19.26	3796080.0
2015-04-16 13:00:00	AMZN	Stock	19.2556	19.2995	19.208	19.2975	2504700.0
2015-04-16 14:00:00	AMZN	Stock	19.299	19.328	19.28	19.29	2776720.0
2015-04-16 15:00:00	AMZN	Stock	19.2925	19.325	19.265	19.3015	8489020.0
2015-04-16 16:00:00	AMZN	Stock	19.302	19.33	19.2898	19.3125	273940.0
2015-04-16 17:00:00	AMZN	Stock	19.325	19.325	19.325	19.325	72400.0

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

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