PREVIEW / stock_1hour / 2013-08-12

all stock 1-hour files

  file:    by_date/stock_1hour/2013/2013-08-12.parquet
  size:    1014 KB
  rows:    47,282
  symbols: 3,521

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
2013-08-12 04:00:00	AAPL	Stock	16.2679	16.2743	16.2611	16.2611	8400.0
2013-08-12 05:00:00	AAPL	Stock	16.2625	16.2689	16.2379	16.2689	56000.0
2013-08-12 06:00:00	AAPL	Stock	16.25	16.3054	16.25	16.3029	67200.0
2013-08-12 07:00:00	AAPL	Stock	16.3321	16.3679	16.2857	16.3046	762748.0
2013-08-12 08:00:00	AAPL	Stock	16.3046	16.3629	16.2857	16.3275	2475256.0
2013-08-12 09:00:00	AAPL	Stock	16.3257	16.535	16.2996	16.4907	68153764.0
2013-08-12 10:00:00	AAPL	Stock	16.4904	16.6429	16.4764	16.6343	78398180.0
2013-08-12 11:00:00	AAPL	Stock	16.6371	16.6939	16.625	16.6521	44736216.0
2013-08-12 12:00:00	AAPL	Stock	16.6546	16.6739	16.5957	16.6418	28784084.0
2013-08-12 13:00:00	AAPL	Stock	16.6418	16.71	16.6268	16.6687	26667536.0
2013-08-12 14:00:00	AAPL	Stock	16.6671	16.7214	16.6557	16.7143	21641956.0
2013-08-12 15:00:00	AAPL	Stock	16.7164	16.7375	16.6379	16.6943	55928320.0
2013-08-12 16:00:00	AAPL	Stock	16.6914	16.7143	16.596	16.7086	13627516.0
2013-08-12 17:00:00	AAPL	Stock	16.7121	16.7211	16.6914	16.7207	477652.0
2013-08-12 18:00:00	AAPL	Stock	16.7179	16.725	16.7143	16.7175	152992.0
2013-08-12 19:00:00	AAPL	Stock	16.7175	16.73	16.7143	16.7293	246260.0
2013-08-12 07:00:00	MSFT	Stock	32.46	32.46	32.46	32.46	250.0
2013-08-12 08:00:00	MSFT	Stock	32.57	32.7	32.56	32.57	12680.0
2013-08-12 09:00:00	MSFT	Stock	32.57	32.83	32.46	32.68	4814525.0
2013-08-12 10:00:00	MSFT	Stock	32.69	32.94	32.67	32.938	3984203.0
2013-08-12 11:00:00	MSFT	Stock	32.93	32.97	32.82	32.88	3089118.0
2013-08-12 12:00:00	MSFT	Stock	32.875	32.88	32.76	32.85	2578011.0
2013-08-12 13:00:00	MSFT	Stock	32.86	32.86	32.763	32.8	2091381.0
2013-08-12 14:00:00	MSFT	Stock	32.795	32.85	32.76	32.835	1854140.0
2013-08-12 15:00:00	MSFT	Stock	32.85	32.91	32.82	32.88	4952748.0
2013-08-12 16:00:00	MSFT	Stock	32.87	32.98	32.7	32.86	1584609.0
2013-08-12 17:00:00	MSFT	Stock	32.87	32.9	32.87	32.9	91220.0
2013-08-12 18:00:00	MSFT	Stock	32.861	32.9	32.861	32.9	722.0
2013-08-12 19:00:00	MSFT	Stock	32.87	32.93	32.87	32.93	7145.0
2013-08-12 09:00:00	NVDA	Stock	0.3612	0.3645	0.3278	0.3612	51112960.0
2013-08-12 10:00:00	NVDA	Stock	0.3611	0.3635	0.3605	0.3628	47629880.0
2013-08-12 11:00:00	NVDA	Stock	0.3628	0.3632	0.362	0.3628	25373920.0
2013-08-12 12:00:00	NVDA	Stock	0.3628	0.3629	0.3608	0.3612	26792080.0
2013-08-12 13:00:00	NVDA	Stock	0.3612	0.3615	0.36	0.36	13385480.0
2013-08-12 14:00:00	NVDA	Stock	0.36	0.3605	0.358	0.3581	38136800.0
2013-08-12 15:00:00	NVDA	Stock	0.3582	0.3595	0.358	0.3592	46882480.0
2013-08-12 16:00:00	NVDA	Stock	0.3592	0.3622	0.3585	0.3585	6651120.0
2013-08-12 17:00:00	NVDA	Stock	0.3588	0.3592	0.3588	0.3592	259600.0
2013-08-12 09:00:00	AMZN	Stock	14.797	14.9295	14.763	14.913	7213220.0
2013-08-12 10:00:00	AMZN	Stock	14.912	14.954	14.824	14.8745	6278360.0
2013-08-12 11:00:00	AMZN	Stock	14.8725	14.8795	14.8055	14.818	5225540.0
2013-08-12 12:00:00	AMZN	Stock	14.815	14.8465	14.8	14.842	2840360.0
2013-08-12 13:00:00	AMZN	Stock	14.844	14.8499	14.7905	14.8035	1814720.0
2013-08-12 14:00:00	AMZN	Stock	14.8015	14.8297	14.7975	14.8235	1345400.0
2013-08-12 15:00:00	AMZN	Stock	14.8215	14.847	14.8	14.835	4208040.0
2013-08-12 16:00:00	AMZN	Stock	14.8345	14.863	14.8101	14.8375	139780.0
2013-08-12 17:00:00	AMZN	Stock	14.83	14.8345	14.83	14.8345	119200.0
2013-08-12 19:00:00	AMZN	Stock	14.8375	14.8375	14.8375	14.8375	2000.0
2013-08-12 04:00:00	META	Stock	38.5	38.5	38.24	38.24	890.0
2013-08-12 05:00:00	META	Stock	38.2	38.2	38.12	38.16	650.0

> showing 50 of 47,282 rows — these rows as CSV

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