PREVIEW / stock_1hour / 2014-09-22

all stock 1-hour files

  file:    by_date/stock_1hour/2014/2014-09-22.parquet
  size:    1.0 MB
  rows:    49,218
  symbols: 3,592

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-22 04:00:00	AAPL	Stock	25.27	25.27	25.1275	25.1775	22312.0
2014-09-22 05:00:00	AAPL	Stock	25.18	25.1825	25.14	25.14	13888.0
2014-09-22 06:00:00	AAPL	Stock	25.1575	25.2975	25.145	25.275	39280.0
2014-09-22 07:00:00	AAPL	Stock	25.27	25.3375	25.2475	25.3125	209964.0
2014-09-22 08:00:00	AAPL	Stock	25.3125	25.5625	25.125	25.4325	4982936.0
2014-09-22 09:00:00	AAPL	Stock	25.4275	25.535	25.33	25.404	35258276.0
2014-09-22 10:00:00	AAPL	Stock	25.4	25.41	25.1925	25.245	37407932.0
2014-09-22 11:00:00	AAPL	Stock	25.245	25.345	25.2125	25.2692	22139412.0
2014-09-22 12:00:00	AAPL	Stock	25.27	25.2975	25.2125	25.2575	15548164.0
2014-09-22 13:00:00	AAPL	Stock	25.255	25.2575	25.145	25.1828	18486704.0
2014-09-22 14:00:00	AAPL	Stock	25.185	25.2725	25.17	25.2575	18602464.0
2014-09-22 15:00:00	AAPL	Stock	25.2558	25.3325	25.205	25.2675	30070092.0
2014-09-22 16:00:00	AAPL	Stock	25.265	25.291	25.21	25.2225	10392548.0
2014-09-22 17:00:00	AAPL	Stock	25.22	25.265	25.18	25.19	1240852.0
2014-09-22 18:00:00	AAPL	Stock	25.1925	25.2025	25.1875	25.1925	100504.0
2014-09-22 19:00:00	AAPL	Stock	25.1875	25.265	25.165	25.1775	190816.0
2014-09-22 04:00:00	MSFT	Stock	47.31	47.31	47.25	47.25	500.0
2014-09-22 06:00:00	MSFT	Stock	47.31	47.31	47.3	47.3	500.0
2014-09-22 07:00:00	MSFT	Stock	47.25	47.27	47.12	47.25	21748.0
2014-09-22 08:00:00	MSFT	Stock	47.25	47.3	47.22	47.26	119565.0
2014-09-22 09:00:00	MSFT	Stock	47.26	47.36	47.05	47.32	6517674.0
2014-09-22 10:00:00	MSFT	Stock	47.32	47.38	47.01	47.09	7218327.0
2014-09-22 11:00:00	MSFT	Stock	47.085	47.18	47.05	47.095	3875001.0
2014-09-22 12:00:00	MSFT	Stock	47.09	47.21	47.06	47.185	2569424.0
2014-09-22 13:00:00	MSFT	Stock	47.19	47.21	47.045	47.05	2915228.0
2014-09-22 14:00:00	MSFT	Stock	47.05	47.12	46.98	47.05	3497834.0
2014-09-22 15:00:00	MSFT	Stock	47.051	47.15	47.0	47.06	7247089.0
2014-09-22 16:00:00	MSFT	Stock	47.06	47.133	47.05	47.05	3291572.0
2014-09-22 17:00:00	MSFT	Stock	47.05	47.05	47.0	47.0	451.0
2014-09-22 18:00:00	MSFT	Stock	47.05	47.06	47.05	47.06	30187.0
2014-09-22 08:00:00	NVDA	Stock	0.4768	0.4768	0.4768	0.4768	200000.0
2014-09-22 09:00:00	NVDA	Stock	0.4868	0.4868	0.4718	0.4753	20806280.0
2014-09-22 10:00:00	NVDA	Stock	0.4753	0.4771	0.4732	0.4742	39486040.0
2014-09-22 11:00:00	NVDA	Stock	0.4742	0.4753	0.4723	0.473	27716320.0
2014-09-22 12:00:00	NVDA	Stock	0.4729	0.474	0.472	0.4735	17753680.0
2014-09-22 13:00:00	NVDA	Stock	0.4732	0.4738	0.4721	0.4723	18591360.0
2014-09-22 14:00:00	NVDA	Stock	0.4723	0.4753	0.4723	0.474	24414960.0
2014-09-22 15:00:00	NVDA	Stock	0.4741	0.4748	0.472	0.4728	51687840.0
2014-09-22 16:00:00	NVDA	Stock	0.4723	0.4723	0.4722	0.4722	3486400.0
2014-09-22 07:00:00	AMZN	Stock	16.433	16.436	16.433	16.436	8000.0
2014-09-22 08:00:00	AMZN	Stock	16.4515	16.4735	16.4275	16.442	118660.0
2014-09-22 09:00:00	AMZN	Stock	16.464	16.4745	16.13	16.2095	12382160.0
2014-09-22 10:00:00	AMZN	Stock	16.192	16.2455	16.1005	16.1315	10528480.0
2014-09-22 11:00:00	AMZN	Stock	16.1285	16.1695	16.0575	16.096	7606000.0
2014-09-22 12:00:00	AMZN	Stock	16.096	16.169	16.053	16.1236	5158700.0
2014-09-22 13:00:00	AMZN	Stock	16.1295	16.139	16.076	16.076	3402340.0
2014-09-22 14:00:00	AMZN	Stock	16.076	16.18	16.067	16.16	5594220.0
2014-09-22 15:00:00	AMZN	Stock	16.163	16.249	16.15	16.2255	10137420.0
2014-09-22 16:00:00	AMZN	Stock	16.225	16.2345	16.1353	16.2	281700.0
2014-09-22 17:00:00	AMZN	Stock	16.1985	16.1985	16.1985	16.1985	2000.0

> showing 50 of 49,218 rows — these rows as CSV

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