PREVIEW / stock_1hour / 2015-10-29

all stock 1-hour files

  file:    by_date/stock_1hour/2015/2015-10-29.parquet
  size:    1.0 MB
  rows:    47,995
  symbols: 3,408

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-10-29 04:00:00	AAPL	Stock	29.8	29.8	29.5425	29.6075	22216.0
2015-10-29 05:00:00	AAPL	Stock	29.5625	29.6	29.545	29.6	36344.0
2015-10-29 06:00:00	AAPL	Stock	29.5975	29.6125	29.555	29.5875	30988.0
2015-10-29 07:00:00	AAPL	Stock	29.6	29.625	29.55	29.55	217936.0
2015-10-29 08:00:00	AAPL	Stock	29.565	29.65	29.5525	29.65	813480.0
2015-10-29 09:00:00	AAPL	Stock	29.65	29.8	29.575	29.6175	27479176.0
2015-10-29 10:00:00	AAPL	Stock	29.6225	29.7975	29.5675	29.66	28451164.0
2015-10-29 11:00:00	AAPL	Stock	29.6625	29.7325	29.6175	29.72	15706864.0
2015-10-29 12:00:00	AAPL	Stock	29.7175	29.955	29.68	29.945	20286812.0
2015-10-29 13:00:00	AAPL	Stock	29.945	29.9675	29.8275	29.945	25476092.0
2015-10-29 14:00:00	AAPL	Stock	29.945	30.1375	29.925	30.12	28723224.0
2015-10-29 15:00:00	AAPL	Stock	30.12	30.1725	30.0325	30.1325	38797788.0
2015-10-29 16:00:00	AAPL	Stock	30.1325	30.1875	29.9542	30.17	4790088.0
2015-10-29 17:00:00	AAPL	Stock	30.1675	30.1925	30.125	30.1475	151648.0
2015-10-29 18:00:00	AAPL	Stock	30.145	30.1875	30.1425	30.1625	128292.0
2015-10-29 19:00:00	AAPL	Stock	30.1625	30.17	30.1325	30.16	127044.0
2015-10-29 04:00:00	MSFT	Stock	53.74	53.74	53.74	53.74	500.0
2015-10-29 05:00:00	MSFT	Stock	53.74	53.74	53.59	53.59	1834.0
2015-10-29 06:00:00	MSFT	Stock	53.6	53.62	53.6	53.62	700.0
2015-10-29 07:00:00	MSFT	Stock	53.62	53.67	53.6	53.64	6510.0
2015-10-29 08:00:00	MSFT	Stock	53.69	53.74	53.63	53.7	13355.0
2015-10-29 09:00:00	MSFT	Stock	53.7	53.77	53.22	53.69	2871063.0
2015-10-29 10:00:00	MSFT	Stock	53.69	53.83	53.255	53.28	3958811.0
2015-10-29 11:00:00	MSFT	Stock	53.29	53.505	53.225	53.475	3646639.0
2015-10-29 12:00:00	MSFT	Stock	53.48	53.65	53.36	53.49	2959634.0
2015-10-29 13:00:00	MSFT	Stock	53.49	53.55	53.31	53.395	3102457.0
2015-10-29 14:00:00	MSFT	Stock	53.4	53.6	53.39	53.526	2650988.0
2015-10-29 15:00:00	MSFT	Stock	53.52	53.7	53.32	53.35	6655933.0
2015-10-29 16:00:00	MSFT	Stock	53.36	53.57	53.28	53.4	3140432.0
2015-10-29 17:00:00	MSFT	Stock	53.36	53.4	53.36	53.4	1500.0
2015-10-29 18:00:00	MSFT	Stock	53.42	53.42	53.36	53.36	2465.0
2015-10-29 19:00:00	MSFT	Stock	53.36	53.42	53.33	53.42	2400.0
2015-10-29 04:00:00	NVDA	Stock	0.7175	0.7175	0.7175	0.7175	21000.0
2015-10-29 09:00:00	NVDA	Stock	0.708	0.7125	0.7012	0.7018	24284920.0
2015-10-29 10:00:00	NVDA	Stock	0.7018	0.7048	0.6962	0.6968	51351440.0
2015-10-29 11:00:00	NVDA	Stock	0.697	0.7002	0.6952	0.7	33423000.0
2015-10-29 12:00:00	NVDA	Stock	0.7001	0.702	0.6992	0.702	16335440.0
2015-10-29 13:00:00	NVDA	Stock	0.7018	0.7032	0.6988	0.6989	24563720.0
2015-10-29 14:00:00	NVDA	Stock	0.6989	0.7	0.6942	0.6945	32985600.0
2015-10-29 15:00:00	NVDA	Stock	0.6945	0.6954	0.6908	0.692	117003400.0
2015-10-29 16:00:00	NVDA	Stock	0.692	0.692	0.6915	0.6915	1142440.0
2015-10-29 17:00:00	NVDA	Stock	0.6925	0.6925	0.6925	0.6925	10000.0
2015-10-29 04:00:00	AMZN	Stock	30.775	30.775	30.775	30.775	2080.0
2015-10-29 05:00:00	AMZN	Stock	30.75	30.75	30.75	30.75	6000.0
2015-10-29 07:00:00	AMZN	Stock	30.775	30.775	30.7495	30.7495	44360.0
2015-10-29 08:00:00	AMZN	Stock	30.7485	30.79	30.6785	30.75	41640.0
2015-10-29 09:00:00	AMZN	Stock	30.775	31.0	30.7555	30.8504	10239080.0
2015-10-29 10:00:00	AMZN	Stock	30.87	31.215	30.83	31.165	17329940.0
2015-10-29 11:00:00	AMZN	Stock	31.15	31.358	31.15	31.21	14461740.0
2015-10-29 12:00:00	AMZN	Stock	31.217	31.3	31.147	31.247	6270640.0

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

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