PREVIEW / stock_1hour / 2016-03-14

all stock 1-hour files

  file:    by_date/stock_1hour/2016/2016-03-14.parquet
  size:    1.0 MB
  rows:    48,129
  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-14 04:00:00	AAPL	Stock	25.59	25.59	25.575	25.575	3344.0
2016-03-14 05:00:00	AAPL	Stock	25.565	25.565	25.545	25.545	1600.0
2016-03-14 06:00:00	AAPL	Stock	25.525	25.5425	25.5125	25.5125	12560.0
2016-03-14 07:00:00	AAPL	Stock	25.505	25.525	25.5	25.525	31068.0
2016-03-14 08:00:00	AAPL	Stock	25.5	25.525	25.4825	25.495	113608.0
2016-03-14 09:00:00	AAPL	Stock	25.48	25.6575	25.445	25.561	12982772.0
2016-03-14 10:00:00	AAPL	Stock	25.56	25.7275	25.525	25.6575	17526344.0
2016-03-14 11:00:00	AAPL	Stock	25.6575	25.6862	25.5325	25.5462	12366888.0
2016-03-14 12:00:00	AAPL	Stock	25.5425	25.67	25.535	25.6652	8233332.0
2016-03-14 13:00:00	AAPL	Stock	25.665	25.6825	25.61	25.615	6900776.0
2016-03-14 14:00:00	AAPL	Stock	25.6125	25.615	25.545	25.5712	8972588.0
2016-03-14 15:00:00	AAPL	Stock	25.572	25.685	25.555	25.63	14874912.0
2016-03-14 16:00:00	AAPL	Stock	25.63	25.6425	25.4935	25.6375	9358736.0
2016-03-14 17:00:00	AAPL	Stock	25.635	25.6475	25.625	25.625	28172.0
2016-03-14 18:00:00	AAPL	Stock	25.6375	25.6375	25.6375	25.6375	3960.0
2016-03-14 19:00:00	AAPL	Stock	25.64	25.65	25.625	25.65	9440.0
2016-03-14 08:00:00	MSFT	Stock	52.8	52.98	52.8	52.81	43913.0
2016-03-14 09:00:00	MSFT	Stock	52.8	53.03	52.63	52.86	2733948.0
2016-03-14 10:00:00	MSFT	Stock	52.86	53.13	52.75	52.97	2871731.0
2016-03-14 11:00:00	MSFT	Stock	52.97	53.41	52.96	53.31	2965120.0
2016-03-14 12:00:00	MSFT	Stock	53.309	53.59	53.27	53.375	2462505.0
2016-03-14 13:00:00	MSFT	Stock	53.38	53.395	53.19	53.22	1611251.0
2016-03-14 14:00:00	MSFT	Stock	53.21	53.35	53.08	53.255	1858974.0
2016-03-14 15:00:00	MSFT	Stock	53.25	53.44	53.16	53.17	3799574.0
2016-03-14 16:00:00	MSFT	Stock	53.17	53.21	53.17	53.17	3944421.0
2016-03-14 17:00:00	MSFT	Stock	53.16	53.2	53.16	53.2	200.0
2016-03-14 18:00:00	MSFT	Stock	53.2	53.2	53.14	53.14	3684.0
2016-03-14 07:00:00	NVDA	Stock	0.8055	0.8055	0.8055	0.8055	32000.0
2016-03-14 08:00:00	NVDA	Stock	0.8055	0.8055	0.8055	0.8055	20400.0
2016-03-14 09:00:00	NVDA	Stock	0.8078	0.8085	0.798	0.8002	27818920.0
2016-03-14 10:00:00	NVDA	Stock	0.8002	0.8095	0.7995	0.8088	26769640.0
2016-03-14 11:00:00	NVDA	Stock	0.8088	0.8104	0.806	0.8062	16821240.0
2016-03-14 12:00:00	NVDA	Stock	0.8065	0.808	0.8054	0.806	9783320.0
2016-03-14 13:00:00	NVDA	Stock	0.806	0.8062	0.8033	0.8038	11241640.0
2016-03-14 14:00:00	NVDA	Stock	0.804	0.8082	0.8018	0.8082	20079480.0
2016-03-14 15:00:00	NVDA	Stock	0.8082	0.8108	0.807	0.8074	49663840.0
2016-03-14 16:00:00	NVDA	Stock	0.8075	0.8075	0.8075	0.8075	1200480.0
2016-03-14 04:00:00	AMZN	Stock	28.5	28.5	28.5	28.5	5720.0
2016-03-14 07:00:00	AMZN	Stock	28.3765	28.3795	28.3765	28.3795	6000.0
2016-03-14 08:00:00	AMZN	Stock	28.3945	28.4495	28.355	28.3995	20000.0
2016-03-14 09:00:00	AMZN	Stock	28.37	28.415	28.1525	28.2848	8988860.0
2016-03-14 10:00:00	AMZN	Stock	28.2974	28.6	28.276	28.51	11226540.0
2016-03-14 11:00:00	AMZN	Stock	28.5085	28.6895	28.4565	28.6402	6783760.0
2016-03-14 12:00:00	AMZN	Stock	28.64	28.748	28.593	28.707	6761200.0
2016-03-14 13:00:00	AMZN	Stock	28.705	28.8445	28.6675	28.777	7100360.0
2016-03-14 14:00:00	AMZN	Stock	28.7775	28.7865	28.6165	28.7652	6777980.0
2016-03-14 15:00:00	AMZN	Stock	28.7605	28.7605	28.628	28.669	9467740.0
2016-03-14 16:00:00	AMZN	Stock	28.6685	28.6835	28.65	28.6655	3869120.0
2016-03-14 17:00:00	AMZN	Stock	28.6675	28.6675	28.6525	28.6525	17400.0
2016-03-14 19:00:00	AMZN	Stock	28.6785	28.6785	28.6785	28.6785	2000.0

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

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