PREVIEW / stock_1hour / 2016-05-11

all stock 1-hour files

  file:    by_date/stock_1hour/2016/2016-05-11.parquet
  size:    1.0 MB
  rows:    48,031
  symbols: 3,288

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
2016-05-11 04:00:00	AAPL	Stock	23.2775	23.28	23.2775	23.28	1600.0
2016-05-11 05:00:00	AAPL	Stock	23.2125	23.2375	23.2125	23.2225	3600.0
2016-05-11 06:00:00	AAPL	Stock	23.2375	23.275	23.2375	23.2525	1344.0
2016-05-11 07:00:00	AAPL	Stock	23.285	23.295	23.2775	23.29	15452.0
2016-05-11 08:00:00	AAPL	Stock	23.3	23.3475	23.25	23.3125	109736.0
2016-05-11 09:00:00	AAPL	Stock	23.305	23.375	23.165	23.2575	16211224.0
2016-05-11 10:00:00	AAPL	Stock	23.2575	23.3925	23.2	23.305	18362116.0
2016-05-11 11:00:00	AAPL	Stock	23.3025	23.3275	23.2025	23.2725	16783632.0
2016-05-11 12:00:00	AAPL	Stock	23.2725	23.33	23.235	23.2525	7603812.0
2016-05-11 13:00:00	AAPL	Stock	23.2525	23.255	23.1925	23.1925	8331240.0
2016-05-11 14:00:00	AAPL	Stock	23.1925	23.2228	23.15	23.16	9832136.0
2016-05-11 15:00:00	AAPL	Stock	23.1625	23.2025	23.115	23.1275	20058100.0
2016-05-11 16:00:00	AAPL	Stock	23.1275	23.1375	23.095	23.1125	8610144.0
2016-05-11 17:00:00	AAPL	Stock	23.1075	23.115	23.0575	23.0775	181344.0
2016-05-11 18:00:00	AAPL	Stock	23.08	23.095	23.07	23.095	44284.0
2016-05-11 19:00:00	AAPL	Stock	23.095	23.095	23.08	23.09	44636.0
2016-05-11 08:00:00	MSFT	Stock	50.84	51.02	50.84	51.02	4692.0
2016-05-11 09:00:00	MSFT	Stock	50.86	51.56	50.86	51.52	3321169.0
2016-05-11 10:00:00	MSFT	Stock	51.514	51.78	51.25	51.74	3946633.0
2016-05-11 11:00:00	MSFT	Stock	51.745	51.745	51.34	51.37	2932353.0
2016-05-11 12:00:00	MSFT	Stock	51.36	51.495	51.26	51.27	1521750.0
2016-05-11 13:00:00	MSFT	Stock	51.27	51.343	51.07	51.08	1602380.0
2016-05-11 14:00:00	MSFT	Stock	51.08	51.16	51.0	51.03	1960701.0
2016-05-11 15:00:00	MSFT	Stock	51.04	51.13	51.0	51.05	3745845.0
2016-05-11 16:00:00	MSFT	Stock	51.05	51.06	50.95	51.06	2883756.0
2016-05-11 17:00:00	MSFT	Stock	51.06	51.1	51.06	51.1	1900.0
2016-05-11 07:00:00	NVDA	Stock	0.9	0.9	0.9	0.9	4000.0
2016-05-11 08:00:00	NVDA	Stock	0.899	0.899	0.899	0.899	159880.0
2016-05-11 09:00:00	NVDA	Stock	0.9	0.9068	0.8968	0.9045	26522680.0
2016-05-11 10:00:00	NVDA	Stock	0.9043	0.9115	0.9038	0.9054	45359960.0
2016-05-11 11:00:00	NVDA	Stock	0.9053	0.9055	0.9012	0.9043	31111000.0
2016-05-11 12:00:00	NVDA	Stock	0.904	0.905	0.9008	0.9016	26720320.0
2016-05-11 13:00:00	NVDA	Stock	0.9016	0.9055	0.9016	0.9036	26761640.0
2016-05-11 14:00:00	NVDA	Stock	0.9036	0.9053	0.9015	0.9025	40086440.0
2016-05-11 15:00:00	NVDA	Stock	0.9025	0.904	0.8998	0.9015	55785760.0
2016-05-11 16:00:00	NVDA	Stock	0.9015	0.9018	0.901	0.9018	54786680.0
2016-05-11 17:00:00	NVDA	Stock	0.9025	0.9038	0.9015	0.9038	752000.0
2016-05-11 18:00:00	NVDA	Stock	0.9015	0.909	0.9015	0.9082	187000.0
2016-05-11 19:00:00	NVDA	Stock	0.906	0.9062	0.906	0.9062	86000.0
2016-05-11 04:00:00	AMZN	Stock	35.025	35.238	35.025	35.238	45880.0
2016-05-11 06:00:00	AMZN	Stock	35.1	35.1	35.1	35.1	10000.0
2016-05-11 07:00:00	AMZN	Stock	35.144	35.168	35.142	35.15	86780.0
2016-05-11 08:00:00	AMZN	Stock	35.18	35.1985	35.08	35.1875	246760.0
2016-05-11 09:00:00	AMZN	Stock	35.1885	35.367	35.0825	35.235	20889040.0
2016-05-11 10:00:00	AMZN	Stock	35.2314	35.625	35.2145	35.4725	24733960.0
2016-05-11 11:00:00	AMZN	Stock	35.4635	35.75	35.4135	35.737	13304100.0
2016-05-11 12:00:00	AMZN	Stock	35.7228	35.894	35.7095	35.8405	12850500.0
2016-05-11 13:00:00	AMZN	Stock	35.85	35.85	35.6375	35.7895	9469760.0
2016-05-11 14:00:00	AMZN	Stock	35.7935	35.95	35.6785	35.7715	16164040.0
2016-05-11 15:00:00	AMZN	Stock	35.776	35.862	35.565	35.6665	26347940.0

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

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