PREVIEW / stock_1hour / 2014-09-09

all stock 1-hour files

  file:    by_date/stock_1hour/2014/2014-09-09.parquet
  size:    1.0 MB
  rows:    48,798
  symbols: 3,565

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-09 04:00:00	AAPL	Stock	24.75	24.765	24.65	24.7175	75456.0
2014-09-09 05:00:00	AAPL	Stock	24.7425	24.7425	24.7025	24.7125	82840.0
2014-09-09 06:00:00	AAPL	Stock	24.735	24.8225	24.705	24.77	163936.0
2014-09-09 07:00:00	AAPL	Stock	24.7725	24.8175	24.765	24.7875	845316.0
2014-09-09 08:00:00	AAPL	Stock	24.7875	24.8175	24.71	24.76	2082420.0
2014-09-09 09:00:00	AAPL	Stock	24.76	24.9	24.7158	24.845	39323832.0
2014-09-09 10:00:00	AAPL	Stock	24.845	24.92	24.7055	24.7888	45061848.0
2014-09-09 11:00:00	AAPL	Stock	24.79	24.8925	24.7775	24.8762	24039276.0
2014-09-09 12:00:00	AAPL	Stock	24.874	25.08	24.8625	25.0625	58060924.0
2014-09-09 13:00:00	AAPL	Stock	25.0625	25.77	24.525	25.685	193214656.0
2014-09-09 14:00:00	AAPL	Stock	25.68	25.75	24.6	24.8175	184388356.0
2014-09-09 15:00:00	AAPL	Stock	24.8162	24.83	24.035	24.5	153405100.0
2014-09-09 16:00:00	AAPL	Stock	24.5	25.375	19.4375	24.5125	12394940.0
2014-09-09 17:00:00	AAPL	Stock	24.5125	24.515	24.465	24.47	1014172.0
2014-09-09 18:00:00	AAPL	Stock	24.48	24.6352	24.4425	24.465	618196.0
2014-09-09 19:00:00	AAPL	Stock	24.465	24.47	24.43	24.43	587124.0
2014-09-09 07:00:00	MSFT	Stock	46.5	46.5	46.5	46.5	1760.0
2014-09-09 08:00:00	MSFT	Stock	46.51	46.52	46.45	46.45	2383.0
2014-09-09 09:00:00	MSFT	Stock	46.35	46.72	46.3	46.54	3831083.0
2014-09-09 10:00:00	MSFT	Stock	46.53	46.735	46.52	46.69	5397752.0
2014-09-09 11:00:00	MSFT	Stock	46.69	46.885	46.67	46.86	4489110.0
2014-09-09 12:00:00	MSFT	Stock	46.85	46.86	46.75	46.83	2763512.0
2014-09-09 13:00:00	MSFT	Stock	46.83	46.97	46.77	46.906	3921631.0
2014-09-09 14:00:00	MSFT	Stock	46.9	46.95	46.62	46.67	5491767.0
2014-09-09 15:00:00	MSFT	Stock	46.67	46.79	46.62	46.76	10013716.0
2014-09-09 16:00:00	MSFT	Stock	46.76	46.79	46.71	46.786	1490682.0
2014-09-09 17:00:00	MSFT	Stock	46.79	46.79	46.724	46.76	4184.0
2014-09-09 18:00:00	MSFT	Stock	46.79	46.95	46.76	46.86	49167.0
2014-09-09 19:00:00	MSFT	Stock	46.86	46.86	46.8	46.8	1799.0
2014-09-09 09:00:00	NVDA	Stock	0.4925	0.4935	0.491	0.4915	19940120.0
2014-09-09 10:00:00	NVDA	Stock	0.4915	0.4935	0.4908	0.4928	24478200.0
2014-09-09 11:00:00	NVDA	Stock	0.4929	0.4945	0.4925	0.4944	21842360.0
2014-09-09 12:00:00	NVDA	Stock	0.4942	0.4945	0.4921	0.4928	14510400.0
2014-09-09 13:00:00	NVDA	Stock	0.4928	0.4958	0.4925	0.4944	22261080.0
2014-09-09 14:00:00	NVDA	Stock	0.4944	0.4945	0.4908	0.4915	16142800.0
2014-09-09 15:00:00	NVDA	Stock	0.4912	0.4914	0.488	0.4883	55209160.0
2014-09-09 16:00:00	NVDA	Stock	0.4885	0.4916	0.488	0.4885	11416920.0
2014-09-09 04:00:00	AMZN	Stock	17.05	17.05	17.05	17.05	5000.0
2014-09-09 06:00:00	AMZN	Stock	17.05	17.05	17.05	17.05	4000.0
2014-09-09 07:00:00	AMZN	Stock	17.0895	17.0895	17.0895	17.0895	8000.0
2014-09-09 08:00:00	AMZN	Stock	17.0945	17.117	17.0785	17.0785	119880.0
2014-09-09 09:00:00	AMZN	Stock	17.0805	17.106	16.829	16.839	12305800.0
2014-09-09 10:00:00	AMZN	Stock	16.8295	16.8665	16.688	16.7295	18271140.0
2014-09-09 11:00:00	AMZN	Stock	16.733	16.8015	16.716	16.7486	6909460.0
2014-09-09 12:00:00	AMZN	Stock	16.749	16.7745	16.6135	16.6575	9263940.0
2014-09-09 13:00:00	AMZN	Stock	16.655	16.7095	16.6145	16.667	9594740.0
2014-09-09 14:00:00	AMZN	Stock	16.6702	16.6945	16.5875	16.6125	7399520.0
2014-09-09 15:00:00	AMZN	Stock	16.616	16.625	16.459	16.4875	20849740.0
2014-09-09 16:00:00	AMZN	Stock	16.4875	16.6976	16.4875	16.5205	568060.0
2014-09-09 17:00:00	AMZN	Stock	16.524	16.524	16.5045	16.5075	64800.0

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

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