PREVIEW / stock_1hour / 2015-11-09

all stock 1-hour files

  file:    by_date/stock_1hour/2015/2015-11-09.parquet
  size:    1.0 MB
  rows:    48,660
  symbols: 3,418

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-11-09 04:00:00	AAPL	Stock	30.255	30.255	30.225	30.225	5952.0
2015-11-09 05:00:00	AAPL	Stock	30.2125	30.2125	30.175	30.175	3200.0
2015-11-09 06:00:00	AAPL	Stock	30.175	30.1875	30.1375	30.1475	13184.0
2015-11-09 07:00:00	AAPL	Stock	30.1625	30.1725	30.145	30.1625	37156.0
2015-11-09 08:00:00	AAPL	Stock	30.1625	30.325	30.1475	30.27	561388.0
2015-11-09 09:00:00	AAPL	Stock	30.27	30.4525	30.1225	30.3225	20878636.0
2015-11-09 10:00:00	AAPL	Stock	30.3225	30.38	30.1875	30.3	21156660.0
2015-11-09 11:00:00	AAPL	Stock	30.3	30.3175	30.0125	30.0895	18564084.0
2015-11-09 12:00:00	AAPL	Stock	30.0895	30.1825	30.0775	30.155	9284364.0
2015-11-09 13:00:00	AAPL	Stock	30.1575	30.2238	30.0925	30.12	9220192.0
2015-11-09 14:00:00	AAPL	Stock	30.12	30.125	30.025	30.0638	9825524.0
2015-11-09 15:00:00	AAPL	Stock	30.0625	30.2325	30.0335	30.145	18478404.0
2015-11-09 16:00:00	AAPL	Stock	30.1425	30.19	29.925	30.0225	18040628.0
2015-11-09 17:00:00	AAPL	Stock	30.0	30.095	30.0	30.075	180360.0
2015-11-09 18:00:00	AAPL	Stock	30.0775	30.095	30.0525	30.095	39188.0
2015-11-09 19:00:00	AAPL	Stock	30.07	30.1175	30.07	30.1025	67952.0
2015-11-09 04:00:00	MSFT	Stock	54.88	54.91	54.74	54.74	1300.0
2015-11-09 05:00:00	MSFT	Stock	54.73	54.74	54.73	54.74	331.0
2015-11-09 06:00:00	MSFT	Stock	54.73	54.74	54.73	54.73	1500.0
2015-11-09 07:00:00	MSFT	Stock	54.74	54.78	54.7	54.78	6260.0
2015-11-09 08:00:00	MSFT	Stock	54.74	54.81	54.73	54.8	12718.0
2015-11-09 09:00:00	MSFT	Stock	54.73	54.87	54.55	54.59	3445883.0
2015-11-09 10:00:00	MSFT	Stock	54.59	54.6	54.17	54.195	3663627.0
2015-11-09 11:00:00	MSFT	Stock	54.19	54.215	53.56	53.597	3806998.0
2015-11-09 12:00:00	MSFT	Stock	53.6	54.05	53.57	53.94	2873696.0
2015-11-09 13:00:00	MSFT	Stock	53.935	54.02	53.765	53.91	2218166.0
2015-11-09 14:00:00	MSFT	Stock	53.92	53.97	53.72	53.85	2602147.0
2015-11-09 15:00:00	MSFT	Stock	53.85	54.24	53.8	54.16	7069665.0
2015-11-09 16:00:00	MSFT	Stock	54.16	54.17	54.13	54.16	4036705.0
2015-11-09 17:00:00	MSFT	Stock	54.14	54.15	54.14	54.15	4202.0
2015-11-09 18:00:00	MSFT	Stock	54.104	54.104	54.1	54.1	5900.0
2015-11-09 19:00:00	MSFT	Stock	54.15	54.15	54.1	54.1	5100.0
2015-11-09 08:00:00	NVDA	Stock	0.7888	0.7888	0.7875	0.7875	107320.0
2015-11-09 09:00:00	NVDA	Stock	0.7875	0.7875	0.7759	0.7803	66178640.0
2015-11-09 10:00:00	NVDA	Stock	0.7803	0.7828	0.7742	0.7798	78415200.0
2015-11-09 11:00:00	NVDA	Stock	0.7798	0.7822	0.7759	0.7775	66419360.0
2015-11-09 12:00:00	NVDA	Stock	0.7776	0.7821	0.7765	0.7818	51754000.0
2015-11-09 13:00:00	NVDA	Stock	0.7818	0.7825	0.7793	0.7818	48467480.0
2015-11-09 14:00:00	NVDA	Stock	0.782	0.7828	0.7793	0.7822	47119720.0
2015-11-09 15:00:00	NVDA	Stock	0.782	0.7875	0.7803	0.7852	100375480.0
2015-11-09 16:00:00	NVDA	Stock	0.7852	0.7862	0.785	0.7852	18646440.0
2015-11-09 04:00:00	AMZN	Stock	32.91	32.955	32.91	32.955	17620.0
2015-11-09 05:00:00	AMZN	Stock	33.0265	33.0265	32.9625	32.9625	8000.0
2015-11-09 06:00:00	AMZN	Stock	32.9945	33.0065	32.975	32.9925	24600.0
2015-11-09 07:00:00	AMZN	Stock	32.9555	32.9555	32.943	32.945	22000.0
2015-11-09 08:00:00	AMZN	Stock	32.9265	33.015	32.925	32.9995	206540.0
2015-11-09 09:00:00	AMZN	Stock	32.9775	33.0978	32.804	32.9112	10524680.0
2015-11-09 10:00:00	AMZN	Stock	32.93	32.9685	32.577	32.7392	14150080.0
2015-11-09 11:00:00	AMZN	Stock	32.725	32.725	32.425	32.4505	12324120.0
2015-11-09 12:00:00	AMZN	Stock	32.4505	32.5865	32.3924	32.545	7555740.0

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

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