PREVIEW / stock_1hour / 2015-02-12

all stock 1-hour files

  file:    by_date/stock_1hour/2015/2015-02-12.parquet
  size:    1.0 MB
  rows:    48,803
  symbols: 3,526

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-02-12 04:00:00	AAPL	Stock	31.375	31.6225	31.375	31.57	192052.0
2015-02-12 05:00:00	AAPL	Stock	31.57	31.595	31.5125	31.575	164468.0
2015-02-12 06:00:00	AAPL	Stock	31.5725	31.5975	31.4975	31.5075	279736.0
2015-02-12 07:00:00	AAPL	Stock	31.5	31.52	31.4125	31.52	482832.0
2015-02-12 08:00:00	AAPL	Stock	31.51	31.575	31.2	31.46	2389116.0
2015-02-12 09:00:00	AAPL	Stock	31.46	31.7975	31.425	31.785	64477884.0
2015-02-12 10:00:00	AAPL	Stock	31.7895	31.87	31.675	31.7375	57145872.0
2015-02-12 11:00:00	AAPL	Stock	31.7375	31.7775	31.3925	31.5408	47811256.0
2015-02-12 12:00:00	AAPL	Stock	31.542	31.6842	31.5362	31.6025	24600120.0
2015-02-12 13:00:00	AAPL	Stock	31.6025	31.645	31.48	31.6325	24093196.0
2015-02-12 14:00:00	AAPL	Stock	31.6325	31.655	31.5425	31.6082	19602772.0
2015-02-12 15:00:00	AAPL	Stock	31.6125	31.64	31.54	31.6075	26868964.0
2015-02-12 16:00:00	AAPL	Stock	31.615	31.6538	31.1325	31.5925	8478460.0
2015-02-12 17:00:00	AAPL	Stock	31.5925	31.626	31.5675	31.595	3746304.0
2015-02-12 18:00:00	AAPL	Stock	31.595	31.615	31.22	31.58	129568.0
2015-02-12 19:00:00	AAPL	Stock	31.5775	31.5875	31.55	31.555	128368.0
2015-02-12 07:00:00	MSFT	Stock	42.51	42.6	42.51	42.59	8185.0
2015-02-12 08:00:00	MSFT	Stock	42.58	42.59	42.49	42.49	218834.0
2015-02-12 09:00:00	MSFT	Stock	42.53	42.83	42.5	42.75	3738299.0
2015-02-12 10:00:00	MSFT	Stock	42.76	42.82	42.66	42.735	3505705.0
2015-02-12 11:00:00	MSFT	Stock	42.74	42.75	42.62	42.655	3221838.0
2015-02-12 12:00:00	MSFT	Stock	42.656	42.78	42.63	42.76	2679638.0
2015-02-12 13:00:00	MSFT	Stock	42.755	42.96	42.75	42.94	3026883.0
2015-02-12 14:00:00	MSFT	Stock	42.935	43.05	42.86	43.05	3050535.0
2015-02-12 15:00:00	MSFT	Stock	43.04	43.09	42.935	43.08	6187209.0
2015-02-12 16:00:00	MSFT	Stock	43.09	43.094	42.776	43.01	4442751.0
2015-02-12 17:00:00	MSFT	Stock	43.01	43.09	42.92	42.96	32550.0
2015-02-12 18:00:00	MSFT	Stock	42.96	42.98	42.38	42.98	5511.0
2015-02-12 19:00:00	MSFT	Stock	42.98	43.0	42.98	43.0	3460.0
2015-02-12 07:00:00	NVDA	Stock	0.5388	0.54	0.5388	0.54	48000.0
2015-02-12 08:00:00	NVDA	Stock	0.5388	0.551	0.5388	0.549	1099840.0
2015-02-12 09:00:00	NVDA	Stock	0.5462	0.5625	0.545	0.56	171000520.0
2015-02-12 10:00:00	NVDA	Stock	0.56	0.5622	0.5545	0.5548	135719680.0
2015-02-12 11:00:00	NVDA	Stock	0.5549	0.56	0.5548	0.5578	64712600.0
2015-02-12 12:00:00	NVDA	Stock	0.5576	0.5592	0.555	0.556	49095680.0
2015-02-12 13:00:00	NVDA	Stock	0.5558	0.558	0.5555	0.5559	46488920.0
2015-02-12 14:00:00	NVDA	Stock	0.5559	0.5572	0.5538	0.5568	44045280.0
2015-02-12 15:00:00	NVDA	Stock	0.5565	0.5575	0.5532	0.5575	109883120.0
2015-02-12 16:00:00	NVDA	Stock	0.5572	0.5596	0.5562	0.5575	2134520.0
2015-02-12 17:00:00	NVDA	Stock	0.5562	0.5562	0.5532	0.5562	1474160.0
2015-02-12 18:00:00	NVDA	Stock	0.5575	0.5575	0.5575	0.5575	13760.0
2015-02-12 19:00:00	NVDA	Stock	0.5562	0.5562	0.555	0.555	8000.0
2015-02-12 04:00:00	AMZN	Stock	18.734	18.734	18.734	18.734	4000.0
2015-02-12 08:00:00	AMZN	Stock	18.75	18.825	18.75	18.8	80720.0
2015-02-12 09:00:00	AMZN	Stock	18.7995	18.9255	18.706	18.8575	8149960.0
2015-02-12 10:00:00	AMZN	Stock	18.8645	18.8745	18.6575	18.687	10859260.0
2015-02-12 11:00:00	AMZN	Stock	18.691	18.8315	18.6775	18.8111	6015620.0
2015-02-12 12:00:00	AMZN	Stock	18.8145	18.864	18.7955	18.8345	5168600.0
2015-02-12 13:00:00	AMZN	Stock	18.8325	18.904	18.8175	18.904	5267860.0
2015-02-12 14:00:00	AMZN	Stock	18.9045	18.923	18.8705	18.891	4627360.0

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

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