PREVIEW / stock_1hour / 2014-08-14

all stock 1-hour files

  file:    by_date/stock_1hour/2014/2014-08-14.parquet
  size:    1.0 MB
  rows:    48,222
  symbols: 3,580

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-14 04:00:00	AAPL	Stock	24.3125	24.3375	24.3125	24.3375	12060.0
2014-08-14 05:00:00	AAPL	Stock	24.33	24.3425	24.33	24.3425	12088.0
2014-08-14 06:00:00	AAPL	Stock	24.3375	24.3725	24.32	24.355	12476.0
2014-08-14 07:00:00	AAPL	Stock	24.3575	24.37	24.32	24.3275	50496.0
2014-08-14 08:00:00	AAPL	Stock	24.3325	24.37	24.295	24.3	689740.0
2014-08-14 09:00:00	AAPL	Stock	24.2975	24.3625	24.2	24.2775	21811076.0
2014-08-14 10:00:00	AAPL	Stock	24.28	24.385	24.2438	24.3625	22629016.0
2014-08-14 11:00:00	AAPL	Stock	24.3625	24.385	24.2812	24.3275	12915924.0
2014-08-14 12:00:00	AAPL	Stock	24.33	24.3475	24.305	24.3275	7710184.0
2014-08-14 13:00:00	AAPL	Stock	24.3268	24.3925	24.3125	24.39	9768428.0
2014-08-14 14:00:00	AAPL	Stock	24.39	24.39	24.3325	24.3712	9018840.0
2014-08-14 15:00:00	AAPL	Stock	24.3722	24.3925	24.345	24.375	16271696.0
2014-08-14 16:00:00	AAPL	Stock	24.3728	24.3925	24.3332	24.38	3069324.0
2014-08-14 17:00:00	AAPL	Stock	24.3825	24.39	24.3625	24.3625	133096.0
2014-08-14 18:00:00	AAPL	Stock	24.37	24.39	24.37	24.375	49824.0
2014-08-14 19:00:00	AAPL	Stock	24.375	24.395	24.375	24.395	80924.0
2014-08-14 06:00:00	MSFT	Stock	43.95	43.95	43.95	43.95	100.0
2014-08-14 07:00:00	MSFT	Stock	44.12	44.12	44.12	44.12	100.0
2014-08-14 08:00:00	MSFT	Stock	44.11	44.11	43.99	44.04	1273.0
2014-08-14 09:00:00	MSFT	Stock	44.07	44.33	44.03	44.27	2060420.0
2014-08-14 10:00:00	MSFT	Stock	44.27	44.28	44.01	44.07	2947026.0
2014-08-14 11:00:00	MSFT	Stock	44.06	44.26	44.04	44.22	2936898.0
2014-08-14 12:00:00	MSFT	Stock	44.22	44.24	44.08	44.187	1578284.0
2014-08-14 13:00:00	MSFT	Stock	44.19	44.325	44.15	44.31	1687926.0
2014-08-14 14:00:00	MSFT	Stock	44.3	44.417	44.25	44.36	2120789.0
2014-08-14 15:00:00	MSFT	Stock	44.355	44.37	44.24	44.28	3757983.0
2014-08-14 16:00:00	MSFT	Stock	44.27	44.355	44.106	44.218	1257686.0
2014-08-14 17:00:00	MSFT	Stock	44.29	44.29	44.29	44.29	7400.0
2014-08-14 18:00:00	MSFT	Stock	44.3	44.33	44.3	44.33	975.0
2014-08-14 19:00:00	MSFT	Stock	44.36	44.36	44.33	44.33	500.0
2014-08-14 08:00:00	NVDA	Stock	0.4772	0.4772	0.4772	0.4772	8000.0
2014-08-14 09:00:00	NVDA	Stock	0.477	0.477	0.469	0.4713	36104040.0
2014-08-14 10:00:00	NVDA	Stock	0.4713	0.4715	0.4683	0.4688	32199160.0
2014-08-14 11:00:00	NVDA	Stock	0.4688	0.471	0.468	0.4694	29046200.0
2014-08-14 12:00:00	NVDA	Stock	0.4695	0.471	0.4694	0.4706	15058600.0
2014-08-14 13:00:00	NVDA	Stock	0.4708	0.472	0.47	0.4702	20043800.0
2014-08-14 14:00:00	NVDA	Stock	0.4702	0.4705	0.4688	0.469	24758040.0
2014-08-14 15:00:00	NVDA	Stock	0.469	0.4702	0.468	0.4699	64145200.0
2014-08-14 16:00:00	NVDA	Stock	0.4699	0.4705	0.469	0.4705	7458360.0
2014-08-14 06:00:00	AMZN	Stock	16.3435	16.3435	16.3435	16.3435	2000.0
2014-08-14 07:00:00	AMZN	Stock	16.3605	16.3605	16.3605	16.3605	4000.0
2014-08-14 08:00:00	AMZN	Stock	16.375	16.39	16.3335	16.35	191180.0
2014-08-14 09:00:00	AMZN	Stock	16.35	16.4875	16.325	16.4735	10538720.0
2014-08-14 10:00:00	AMZN	Stock	16.4695	16.5385	16.4255	16.5322	10934540.0
2014-08-14 11:00:00	AMZN	Stock	16.528	16.574	16.527	16.574	7999780.0
2014-08-14 12:00:00	AMZN	Stock	16.571	16.575	16.54	16.5485	4724640.0
2014-08-14 13:00:00	AMZN	Stock	16.553	16.644	16.551	16.6427	6995040.0
2014-08-14 14:00:00	AMZN	Stock	16.6425	16.7045	16.609	16.694	8289120.0
2014-08-14 15:00:00	AMZN	Stock	16.6935	16.6985	16.6505	16.66	12600060.0
2014-08-14 16:00:00	AMZN	Stock	16.6575	16.675	16.4022	16.675	519100.0

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

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