PREVIEW / stock_1hour / 2015-05-15

all stock 1-hour files

  file:    by_date/stock_1hour/2015/2015-05-15.parquet
  size:    1.0 MB
  rows:    48,702
  symbols: 3,500

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
2015-05-15 04:00:00	AAPL	Stock	32.22	32.37	32.22	32.31	8488.0
2015-05-15 05:00:00	AAPL	Stock	32.325	32.3475	32.325	32.3475	12208.0
2015-05-15 06:00:00	AAPL	Stock	32.35	32.4	32.3325	32.39	178756.0
2015-05-15 07:00:00	AAPL	Stock	32.365	32.3825	32.2825	32.3125	221832.0
2015-05-15 08:00:00	AAPL	Stock	32.3125	32.3825	32.1375	32.2175	1156000.0
2015-05-15 09:00:00	AAPL	Stock	32.2125	32.3725	32.095	32.1525	35831728.0
2015-05-15 10:00:00	AAPL	Stock	32.1525	32.1925	32.0525	32.1875	27326532.0
2015-05-15 11:00:00	AAPL	Stock	32.1862	32.2175	32.065	32.135	14704400.0
2015-05-15 12:00:00	AAPL	Stock	32.1375	32.188	32.115	32.1385	10109168.0
2015-05-15 13:00:00	AAPL	Stock	32.1395	32.17	32.105	32.11	8858484.0
2015-05-15 14:00:00	AAPL	Stock	32.11	32.2275	32.075	32.215	15052572.0
2015-05-15 15:00:00	AAPL	Stock	32.2162	32.22	32.1275	32.19	20861928.0
2015-05-15 16:00:00	AAPL	Stock	32.1925	32.2075	32.15	32.1975	5496668.0
2015-05-15 17:00:00	AAPL	Stock	32.1925	32.205	32.1775	32.1875	126396.0
2015-05-15 18:00:00	AAPL	Stock	32.1875	32.195	32.1825	32.185	20420.0
2015-05-15 19:00:00	AAPL	Stock	32.1825	32.2	32.1825	32.2	64716.0
2015-05-15 06:00:00	MSFT	Stock	48.99	48.99	48.99	48.99	103.0
2015-05-15 07:00:00	MSFT	Stock	48.95	48.95	48.83	48.83	1000.0
2015-05-15 08:00:00	MSFT	Stock	48.85	48.9	48.79	48.84	8489.0
2015-05-15 09:00:00	MSFT	Stock	48.84	48.95	48.456	48.59	4906591.0
2015-05-15 10:00:00	MSFT	Stock	48.59	48.62	48.365	48.465	3223594.0
2015-05-15 11:00:00	MSFT	Stock	48.47	48.49	48.26	48.28	2358213.0
2015-05-15 12:00:00	MSFT	Stock	48.29	48.3	48.17	48.18	1881792.0
2015-05-15 13:00:00	MSFT	Stock	48.18	48.25	48.05	48.09	2372502.0
2015-05-15 14:00:00	MSFT	Stock	48.09	48.27	48.05	48.24	2035775.0
2015-05-15 15:00:00	MSFT	Stock	48.25	48.3	48.07	48.3	6784976.0
2015-05-15 16:00:00	MSFT	Stock	48.295	48.295	48.2	48.28	3035819.0
2015-05-15 17:00:00	MSFT	Stock	48.29	48.29	48.29	48.29	100.0
2015-05-15 18:00:00	MSFT	Stock	48.27	48.29	48.26	48.29	1400.0
2015-05-15 09:00:00	NVDA	Stock	0.5345	0.537	0.5322	0.5329	45229200.0
2015-05-15 10:00:00	NVDA	Stock	0.5327	0.5336	0.5293	0.5335	38029440.0
2015-05-15 11:00:00	NVDA	Stock	0.5335	0.5349	0.5331	0.5342	24774920.0
2015-05-15 12:00:00	NVDA	Stock	0.534	0.5345	0.5332	0.5335	12150280.0
2015-05-15 13:00:00	NVDA	Stock	0.5335	0.5338	0.5325	0.533	13577240.0
2015-05-15 14:00:00	NVDA	Stock	0.533	0.5341	0.5327	0.533	18814200.0
2015-05-15 15:00:00	NVDA	Stock	0.533	0.5335	0.532	0.5324	42127640.0
2015-05-15 16:00:00	NVDA	Stock	0.5325	0.5325	0.5325	0.5325	11798000.0
2015-05-15 07:00:00	AMZN	Stock	21.625	21.628	21.6235	21.6235	43300.0
2015-05-15 08:00:00	AMZN	Stock	21.6995	21.6995	21.625	21.6275	21680.0
2015-05-15 09:00:00	AMZN	Stock	21.6035	21.615	21.325	21.4635	27329200.0
2015-05-15 10:00:00	AMZN	Stock	21.453	21.5	21.327	21.3765	10653140.0
2015-05-15 11:00:00	AMZN	Stock	21.3765	21.379	21.215	21.2665	9706340.0
2015-05-15 12:00:00	AMZN	Stock	21.2698	21.3435	21.2465	21.3225	6111600.0
2015-05-15 13:00:00	AMZN	Stock	21.3285	21.3335	21.26	21.286	6046900.0
2015-05-15 14:00:00	AMZN	Stock	21.28	21.297	21.24	21.2798	5473280.0
2015-05-15 15:00:00	AMZN	Stock	21.2795	21.333	21.2675	21.296	12585540.0
2015-05-15 16:00:00	AMZN	Stock	21.3	21.3	21.2535	21.263	2394480.0
2015-05-15 17:00:00	AMZN	Stock	21.2785	21.2785	21.2785	21.2785	2000.0
2015-05-15 18:00:00	AMZN	Stock	21.3	21.3095	21.295	21.3095	22760.0
2015-05-15 19:00:00	AMZN	Stock	21.308	21.308	21.308	21.308	5000.0

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

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