PREVIEW / stock_1hour / 2014-09-29

all stock 1-hour files

  file:    by_date/stock_1hour/2014/2014-09-29.parquet
  size:    1.0 MB
  rows:    48,585
  symbols: 3,586

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-09-29 04:00:00	AAPL	Stock	25.135	25.135	24.7	24.775	232360.0
2014-09-29 05:00:00	AAPL	Stock	24.775	24.855	24.7575	24.84	75940.0
2014-09-29 06:00:00	AAPL	Stock	24.845	24.95	24.845	24.875	128096.0
2014-09-29 07:00:00	AAPL	Stock	24.895	24.9975	24.865	24.9	788644.0
2014-09-29 08:00:00	AAPL	Stock	24.9025	24.9825	24.7425	24.75	2105424.0
2014-09-29 09:00:00	AAPL	Stock	24.75	24.8625	24.63	24.8	32338936.0
2014-09-29 10:00:00	AAPL	Stock	24.8	25.0125	24.7775	24.9625	29053036.0
2014-09-29 11:00:00	AAPL	Stock	24.9578	25.1	24.9362	25.0335	23774416.0
2014-09-29 12:00:00	AAPL	Stock	25.0325	25.0725	24.92	25.0462	17086968.0
2014-09-29 13:00:00	AAPL	Stock	25.045	25.1	25.0125	25.065	14992776.0
2014-09-29 14:00:00	AAPL	Stock	25.0625	25.0775	24.885	25.02	21151740.0
2014-09-29 15:00:00	AAPL	Stock	25.0208	25.1088	24.975	25.0275	32721496.0
2014-09-29 16:00:00	AAPL	Stock	25.0275	25.1548	24.9658	25.05	6810116.0
2014-09-29 17:00:00	AAPL	Stock	25.0	25.0275	24.99	24.9925	1810336.0
2014-09-29 18:00:00	AAPL	Stock	24.9975	25.0275	24.99	24.99	660756.0
2014-09-29 19:00:00	AAPL	Stock	24.99	24.9975	24.9775	24.985	79024.0
2014-09-29 04:00:00	MSFT	Stock	46.39	46.39	46.22	46.22	600.0
2014-09-29 06:00:00	MSFT	Stock	46.22	46.22	46.22	46.22	500.0
2014-09-29 07:00:00	MSFT	Stock	46.1	46.1	46.1	46.1	2146.0
2014-09-29 08:00:00	MSFT	Stock	46.22	46.22	46.08	46.08	7776.0
2014-09-29 09:00:00	MSFT	Stock	46.05	46.16	45.76	46.07	3277006.0
2014-09-29 10:00:00	MSFT	Stock	46.07	46.33	45.96	46.305	3455108.0
2014-09-29 11:00:00	MSFT	Stock	46.3	46.45	46.26	46.4	3123723.0
2014-09-29 12:00:00	MSFT	Stock	46.4	46.4	46.16	46.3	2436505.0
2014-09-29 13:00:00	MSFT	Stock	46.3	46.34	46.195	46.295	1693371.0
2014-09-29 14:00:00	MSFT	Stock	46.3	46.381	46.21	46.38	2180854.0
2014-09-29 15:00:00	MSFT	Stock	46.38	46.56	46.37	46.44	6443216.0
2014-09-29 16:00:00	MSFT	Stock	46.44	46.49	46.27	46.27	2226802.0
2014-09-29 18:00:00	MSFT	Stock	46.43	46.44	46.43	46.44	32902.0
2014-09-29 08:00:00	NVDA	Stock	0.461	0.461	0.461	0.461	20000.0
2014-09-29 09:00:00	NVDA	Stock	0.46	0.4625	0.4556	0.459	33146520.0
2014-09-29 10:00:00	NVDA	Stock	0.4591	0.463	0.4585	0.4628	33411360.0
2014-09-29 11:00:00	NVDA	Stock	0.4628	0.4658	0.4621	0.4658	27546400.0
2014-09-29 12:00:00	NVDA	Stock	0.4658	0.4662	0.4638	0.4647	21883120.0
2014-09-29 13:00:00	NVDA	Stock	0.4646	0.4653	0.4638	0.4645	13471960.0
2014-09-29 14:00:00	NVDA	Stock	0.4645	0.4648	0.4618	0.463	23122320.0
2014-09-29 15:00:00	NVDA	Stock	0.463	0.465	0.4622	0.4629	44012440.0
2014-09-29 16:00:00	NVDA	Stock	0.4629	0.463	0.4618	0.4628	2026520.0
2014-09-29 06:00:00	AMZN	Stock	16.11	16.11	16.1	16.1	4000.0
2014-09-29 08:00:00	AMZN	Stock	16.0275	16.076	16.026	16.026	183120.0
2014-09-29 09:00:00	AMZN	Stock	16.026	16.0695	15.95	16.024	6012660.0
2014-09-29 10:00:00	AMZN	Stock	16.025	16.1685	15.9909	16.1285	7935240.0
2014-09-29 11:00:00	AMZN	Stock	16.1345	16.1875	16.091	16.1385	3891400.0
2014-09-29 12:00:00	AMZN	Stock	16.1398	16.1435	16.0285	16.1015	3268000.0
2014-09-29 13:00:00	AMZN	Stock	16.1	16.1095	16.038	16.0705	2333780.0
2014-09-29 14:00:00	AMZN	Stock	16.0713	16.1	16.019	16.0612	3622820.0
2014-09-29 15:00:00	AMZN	Stock	16.0675	16.13	16.06	16.0955	6142000.0
2014-09-29 16:00:00	AMZN	Stock	16.096	16.099	16.07	16.07	1294620.0
2014-09-29 17:00:00	AMZN	Stock	16.0625	16.0625	16.06	16.06	8320.0
2014-09-29 18:00:00	AMZN	Stock	16.091	16.091	16.0605	16.0605	96100.0

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

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