PREVIEW / stock_1hour / 2014-11-06

all stock 1-hour files

  file:    by_date/stock_1hour/2014/2014-11-06.parquet
  size:    1.0 MB
  rows:    48,552
  symbols: 3,541

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-11-06 04:00:00	AAPL	Stock	27.125	27.125	27.0825	27.0975	45292.0
2014-11-06 05:00:00	AAPL	Stock	27.105	27.125	27.105	27.125	6760.0
2014-11-06 06:00:00	AAPL	Stock	27.16	27.1625	27.125	27.135	16936.0
2014-11-06 07:00:00	AAPL	Stock	27.145	27.1625	27.09	27.09	191904.0
2014-11-06 08:00:00	AAPL	Stock	27.0925	27.16	27.0875	27.115	941168.0
2014-11-06 09:00:00	AAPL	Stock	27.12	27.1625	27.015	27.0675	22826364.0
2014-11-06 10:00:00	AAPL	Stock	27.065	27.1225	26.95	27.1185	21832884.0
2014-11-06 11:00:00	AAPL	Stock	27.1178	27.1625	27.09	27.1225	15450752.0
2014-11-06 12:00:00	AAPL	Stock	27.12	27.1425	27.0525	27.055	10246464.0
2014-11-06 13:00:00	AAPL	Stock	27.0575	27.13	27.05	27.115	10852920.0
2014-11-06 14:00:00	AAPL	Stock	27.1175	27.1175	27.08	27.085	8653236.0
2014-11-06 15:00:00	AAPL	Stock	27.0858	27.1975	27.055	27.1725	26817564.0
2014-11-06 16:00:00	AAPL	Stock	27.1725	27.18	27.1095	27.159	8377924.0
2014-11-06 17:00:00	AAPL	Stock	27.1575	27.175	27.1525	27.165	431716.0
2014-11-06 18:00:00	AAPL	Stock	27.1575	27.175	27.1575	27.1625	767644.0
2014-11-06 19:00:00	AAPL	Stock	27.1675	27.19	27.155	27.19	110456.0
2014-11-06 07:00:00	MSFT	Stock	47.77	47.84	47.76	47.84	2378.0
2014-11-06 08:00:00	MSFT	Stock	47.82	48.11	47.81	48.09	16219.0
2014-11-06 09:00:00	MSFT	Stock	48.02	48.275	47.79	48.26	4147731.0
2014-11-06 10:00:00	MSFT	Stock	48.26	48.5	48.26	48.39	5824259.0
2014-11-06 11:00:00	MSFT	Stock	48.38	48.54	48.28	48.316	3874251.0
2014-11-06 12:00:00	MSFT	Stock	48.315	48.38	48.17	48.38	3108990.0
2014-11-06 13:00:00	MSFT	Stock	48.37	48.59	48.37	48.503	2728948.0
2014-11-06 14:00:00	MSFT	Stock	48.51	48.74	48.45	48.73	2796581.0
2014-11-06 15:00:00	MSFT	Stock	48.72	48.86	48.63	48.69	6912554.0
2014-11-06 16:00:00	MSFT	Stock	48.7	48.726	47.96	48.7	1750027.0
2014-11-06 17:00:00	MSFT	Stock	48.7	48.8	48.69	48.8	10071.0
2014-11-06 18:00:00	MSFT	Stock	48.8	48.8	48.8	48.8	420.0
2014-11-06 19:00:00	MSFT	Stock	48.76	48.76	48.7	48.74	2284.0
2014-11-06 09:00:00	NVDA	Stock	0.5043	0.5055	0.4993	0.4995	24506120.0
2014-11-06 10:00:00	NVDA	Stock	0.4998	0.5005	0.4965	0.4981	46879280.0
2014-11-06 11:00:00	NVDA	Stock	0.4984	0.5005	0.498	0.4992	39341120.0
2014-11-06 12:00:00	NVDA	Stock	0.4992	0.501	0.499	0.5004	30746200.0
2014-11-06 13:00:00	NVDA	Stock	0.5005	0.5055	0.5003	0.5031	53826520.0
2014-11-06 14:00:00	NVDA	Stock	0.5032	0.5045	0.5009	0.5043	41599120.0
2014-11-06 15:00:00	NVDA	Stock	0.5043	0.5062	0.503	0.5053	132268080.0
2014-11-06 16:00:00	NVDA	Stock	0.5055	0.5275	0.4978	0.5188	7577920.0
2014-11-06 17:00:00	NVDA	Stock	0.5175	0.5175	0.5112	0.515	1300200.0
2014-11-06 18:00:00	NVDA	Stock	0.5155	0.5155	0.5112	0.512	306600.0
2014-11-06 19:00:00	NVDA	Stock	0.512	0.5162	0.512	0.5162	66800.0
2014-11-06 05:00:00	AMZN	Stock	14.725	14.725	14.6815	14.6815	83000.0
2014-11-06 06:00:00	AMZN	Stock	14.69	14.69	14.661	14.675	79000.0
2014-11-06 07:00:00	AMZN	Stock	14.68	14.74	14.68	14.74	116600.0
2014-11-06 08:00:00	AMZN	Stock	14.695	14.844	14.695	14.844	259740.0
2014-11-06 09:00:00	AMZN	Stock	14.845	14.845	14.6145	14.692	12937080.0
2014-11-06 10:00:00	AMZN	Stock	14.6945	14.8105	14.6732	14.7085	14010840.0
2014-11-06 11:00:00	AMZN	Stock	14.711	14.818	14.6845	14.707	8087240.0
2014-11-06 12:00:00	AMZN	Stock	14.7075	14.7075	14.636	14.678	5279880.0
2014-11-06 13:00:00	AMZN	Stock	14.68	14.7032	14.64	14.7016	6796420.0
2014-11-06 14:00:00	AMZN	Stock	14.704	14.756	14.689	14.7445	5442660.0

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

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