PREVIEW / stock_1hour / 2016-03-09

all stock 1-hour files

  file:    by_date/stock_1hour/2016/2016-03-09.parquet
  size:    1.0 MB
  rows:    48,099
  symbols: 3,335

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-03-09 04:00:00	AAPL	Stock	25.37	25.4275	25.37	25.385	3156.0
2016-03-09 05:00:00	AAPL	Stock	25.3875	25.43	25.1325	25.4	11324.0
2016-03-09 06:00:00	AAPL	Stock	25.3975	25.4125	25.375	25.3975	33144.0
2016-03-09 07:00:00	AAPL	Stock	25.4	25.4825	25.3825	25.3825	85336.0
2016-03-09 08:00:00	AAPL	Stock	25.385	25.475	25.35	25.375	199628.0
2016-03-09 09:00:00	AAPL	Stock	25.375	25.42	25.0675	25.1625	18335388.0
2016-03-09 10:00:00	AAPL	Stock	25.1625	25.3375	25.1575	25.2032	17527372.0
2016-03-09 11:00:00	AAPL	Stock	25.205	25.3575	25.1975	25.3175	12717740.0
2016-03-09 12:00:00	AAPL	Stock	25.315	25.325	25.2175	25.28	8870964.0
2016-03-09 13:00:00	AAPL	Stock	25.275	25.325	25.196	25.3075	7840296.0
2016-03-09 14:00:00	AAPL	Stock	25.31	25.3275	25.205	25.2462	9250208.0
2016-03-09 15:00:00	AAPL	Stock	25.2475	25.2875	25.2025	25.2775	16147420.0
2016-03-09 16:00:00	AAPL	Stock	25.28	25.2875	25.233	25.2875	7829700.0
2016-03-09 17:00:00	AAPL	Stock	25.28	25.29	25.2775	25.2825	10632.0
2016-03-09 18:00:00	AAPL	Stock	25.2825	25.29	25.28	25.2825	17708.0
2016-03-09 19:00:00	AAPL	Stock	25.295	25.295	25.28	25.295	50044.0
2016-03-09 04:00:00	MSFT	Stock	50.49	52.01	50.49	52.01	440.0
2016-03-09 06:00:00	MSFT	Stock	51.99	51.99	51.99	51.99	100.0
2016-03-09 07:00:00	MSFT	Stock	51.99	52.0	51.99	52.0	1100.0
2016-03-09 08:00:00	MSFT	Stock	52.15	52.15	51.92	51.98	1815.0
2016-03-09 09:00:00	MSFT	Stock	51.98	52.22	51.855	52.155	2139405.0
2016-03-09 10:00:00	MSFT	Stock	52.14	52.64	52.04	52.295	4315553.0
2016-03-09 11:00:00	MSFT	Stock	52.29	52.77	52.29	52.684	3243975.0
2016-03-09 12:00:00	MSFT	Stock	52.68	52.72	52.5	52.54	2278719.0
2016-03-09 13:00:00	MSFT	Stock	52.54	52.674	52.39	52.63	2451579.0
2016-03-09 14:00:00	MSFT	Stock	52.62	52.84	52.61	52.79	3260555.0
2016-03-09 15:00:00	MSFT	Stock	52.79	52.85	52.56	52.83	5660408.0
2016-03-09 16:00:00	MSFT	Stock	52.84	52.85	52.8	52.85	2786547.0
2016-03-09 17:00:00	MSFT	Stock	52.83	52.85	52.83	52.85	3238.0
2016-03-09 18:00:00	MSFT	Stock	52.85	52.85	52.8	52.8	2200.0
2016-03-09 19:00:00	MSFT	Stock	52.83	52.83	52.83	52.83	800.0
2016-03-09 09:00:00	NVDA	Stock	0.8	0.8019	0.783	0.7839	22677280.0
2016-03-09 10:00:00	NVDA	Stock	0.7838	0.7942	0.7832	0.7841	31609360.0
2016-03-09 11:00:00	NVDA	Stock	0.7843	0.7925	0.7841	0.792	25911680.0
2016-03-09 12:00:00	NVDA	Stock	0.7919	0.7919	0.7868	0.788	12636880.0
2016-03-09 13:00:00	NVDA	Stock	0.7881	0.7932	0.7878	0.7931	21959960.0
2016-03-09 14:00:00	NVDA	Stock	0.7931	0.7954	0.79	0.7901	31754040.0
2016-03-09 15:00:00	NVDA	Stock	0.7902	0.7932	0.7878	0.7932	59539040.0
2016-03-09 16:00:00	NVDA	Stock	0.7932	0.7932	0.7932	0.7932	320840.0
2016-03-09 19:00:00	NVDA	Stock	0.7935	0.7935	0.7935	0.7935	5360.0
2016-03-09 07:00:00	AMZN	Stock	28.2895	28.2895	28.2	28.209	43600.0
2016-03-09 08:00:00	AMZN	Stock	28.209	28.2625	28.1	28.135	255440.0
2016-03-09 09:00:00	AMZN	Stock	28.1505	28.1995	27.5062	27.617	15536680.0
2016-03-09 10:00:00	AMZN	Stock	27.614	27.799	27.568	27.6445	16523180.0
2016-03-09 11:00:00	AMZN	Stock	27.6212	27.774	27.615	27.774	8536400.0
2016-03-09 12:00:00	AMZN	Stock	27.766	27.7945	27.661	27.7035	5633760.0
2016-03-09 13:00:00	AMZN	Stock	27.724	27.989	27.693	27.9575	7656840.0
2016-03-09 14:00:00	AMZN	Stock	27.959	27.9709	27.778	27.885	7708920.0
2016-03-09 15:00:00	AMZN	Stock	27.874	27.974	27.795	27.974	13432440.0
2016-03-09 16:00:00	AMZN	Stock	27.9735	27.9735	27.7095	27.95	2155160.0

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

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