PREVIEW / stock_1hour / 2014-08-29

all stock 1-hour files

  file:    by_date/stock_1hour/2014/2014-08-29.parquet
  size:    1.0 MB
  rows:    47,920
  symbols: 3,585

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
2014-08-29 04:00:00	AAPL	Stock	25.655	25.6825	25.6525	25.675	16436.0
2014-08-29 05:00:00	AAPL	Stock	25.6825	25.6875	25.67	25.6725	38580.0
2014-08-29 06:00:00	AAPL	Stock	25.65	25.72	25.65	25.705	56060.0
2014-08-29 07:00:00	AAPL	Stock	25.705	25.725	25.675	25.6825	121000.0
2014-08-29 08:00:00	AAPL	Stock	25.6825	25.73	25.6275	25.6475	593144.0
2014-08-29 09:00:00	AAPL	Stock	25.645	25.7325	25.5875	25.63	26424468.0
2014-08-29 10:00:00	AAPL	Stock	25.63	25.6475	25.55	25.6178	23621476.0
2014-08-29 11:00:00	AAPL	Stock	25.62	25.6675	25.61	25.6198	19399264.0
2014-08-29 12:00:00	AAPL	Stock	25.62	25.6325	25.575	25.6112	13206424.0
2014-08-29 13:00:00	AAPL	Stock	25.6112	25.63	25.585	25.6075	9622672.0
2014-08-29 14:00:00	AAPL	Stock	25.6075	25.6525	25.605	25.6475	13119960.0
2014-08-29 15:00:00	AAPL	Stock	25.6475	25.65	25.585	25.625	27815996.0
2014-08-29 16:00:00	AAPL	Stock	25.625	25.6475	25.6	25.6375	32458092.0
2014-08-29 17:00:00	AAPL	Stock	25.6375	25.64	25.63	25.6375	47352.0
2014-08-29 18:00:00	AAPL	Stock	25.6275	25.635	25.6225	25.63	188272.0
2014-08-29 19:00:00	AAPL	Stock	25.63	25.6375	25.625	25.6375	87268.0
2014-08-29 08:00:00	MSFT	Stock	45.03	45.03	45.03	45.03	100.0
2014-08-29 09:00:00	MSFT	Stock	44.88	45.17	44.88	45.05	2782613.0
2014-08-29 10:00:00	MSFT	Stock	45.05	45.05	44.855	45.035	2027623.0
2014-08-29 11:00:00	MSFT	Stock	45.04	45.2	45.03	45.17	1520946.0
2014-08-29 12:00:00	MSFT	Stock	45.17	45.25	45.06	45.25	1554630.0
2014-08-29 13:00:00	MSFT	Stock	45.25	45.3	45.19	45.25	1440460.0
2014-08-29 14:00:00	MSFT	Stock	45.25	45.29	45.21	45.225	1798673.0
2014-08-29 15:00:00	MSFT	Stock	45.225	45.44	45.13	45.42	4823614.0
2014-08-29 16:00:00	MSFT	Stock	45.43	45.45	45.007	45.37	4394210.0
2014-08-29 18:00:00	MSFT	Stock	45.34	45.43	45.34	45.43	29586.0
2014-08-29 19:00:00	MSFT	Stock	45.4	45.44	45.4	45.44	1000.0
2014-08-29 09:00:00	NVDA	Stock	0.4865	0.4872	0.4838	0.4838	13938520.0
2014-08-29 10:00:00	NVDA	Stock	0.4838	0.4852	0.4812	0.4828	31324240.0
2014-08-29 11:00:00	NVDA	Stock	0.483	0.4843	0.4828	0.4832	12341200.0
2014-08-29 12:00:00	NVDA	Stock	0.4832	0.4855	0.4818	0.485	26161040.0
2014-08-29 13:00:00	NVDA	Stock	0.4852	0.4852	0.483	0.483	8956120.0
2014-08-29 14:00:00	NVDA	Stock	0.483	0.485	0.483	0.484	15780040.0
2014-08-29 15:00:00	NVDA	Stock	0.4841	0.4868	0.4835	0.486	48318280.0
2014-08-29 16:00:00	NVDA	Stock	0.4862	0.4866	0.486	0.4862	42464440.0
2014-08-29 19:00:00	NVDA	Stock	0.485	0.485	0.485	0.485	20000.0
2014-08-29 05:00:00	AMZN	Stock	17.076	17.076	17.076	17.076	14000.0
2014-08-29 07:00:00	AMZN	Stock	17.0805	17.0805	17.07	17.076	12000.0
2014-08-29 08:00:00	AMZN	Stock	17.001	17.105	17.001	17.087	28400.0
2014-08-29 09:00:00	AMZN	Stock	17.082	17.0995	16.919	16.966	4678320.0
2014-08-29 10:00:00	AMZN	Stock	16.969	17.0525	16.9227	17.0455	5724700.0
2014-08-29 11:00:00	AMZN	Stock	17.0485	17.0715	17.007	17.04	3639700.0
2014-08-29 12:00:00	AMZN	Stock	17.0365	17.0405	16.962	16.9775	3006860.0
2014-08-29 13:00:00	AMZN	Stock	16.9785	16.9815	16.9005	16.9295	3359940.0
2014-08-29 14:00:00	AMZN	Stock	16.9268	16.9475	16.884	16.918	2936120.0
2014-08-29 15:00:00	AMZN	Stock	16.9206	16.9525	16.9005	16.9515	6401240.0
2014-08-29 16:00:00	AMZN	Stock	16.9155	16.9718	16.9155	16.9405	2066420.0
2014-08-29 17:00:00	AMZN	Stock	16.952	16.9595	16.952	16.9595	10000.0
2014-08-29 18:00:00	AMZN	Stock	16.953	16.955	16.952	16.955	74680.0
2014-08-29 04:00:00	GOOGL	Stock	29.1005	29.1005	29.1005	29.1005	2000.0

> showing 50 of 47,920 rows — these rows as CSV

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