PREVIEW / stock_1hour / 2015-09-16

all stock 1-hour files

  file:    by_date/stock_1hour/2015/2015-09-16.parquet
  size:    1.0 MB
  rows:    48,343
  symbols: 3,472

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-09-16 04:00:00	AAPL	Stock	29.095	29.125	29.0425	29.1075	59940.0
2015-09-16 05:00:00	AAPL	Stock	29.1025	29.1175	29.0875	29.0875	34180.0
2015-09-16 06:00:00	AAPL	Stock	29.08	29.125	29.08	29.125	33796.0
2015-09-16 07:00:00	AAPL	Stock	29.115	29.125	29.0825	29.1125	40524.0
2015-09-16 08:00:00	AAPL	Stock	29.11	29.125	29.0075	29.035	349580.0
2015-09-16 09:00:00	AAPL	Stock	29.035	29.085	28.86	28.9568	23356704.0
2015-09-16 10:00:00	AAPL	Stock	28.9525	29.0725	28.905	28.9675	23568400.0
2015-09-16 11:00:00	AAPL	Stock	28.9675	29.135	28.9328	29.0762	18976436.0
2015-09-16 12:00:00	AAPL	Stock	29.0775	29.095	29.0275	29.0525	11118428.0
2015-09-16 13:00:00	AAPL	Stock	29.05	29.0525	28.955	29.0098	10904864.0
2015-09-16 14:00:00	AAPL	Stock	29.01	29.032	28.9262	28.9975	14087388.0
2015-09-16 15:00:00	AAPL	Stock	29.0	29.1188	28.9925	29.105	30188660.0
2015-09-16 16:00:00	AAPL	Stock	29.0838	29.11	29.0625	29.09	5596392.0
2015-09-16 17:00:00	AAPL	Stock	29.0975	29.105	29.0775	29.0975	151400.0
2015-09-16 18:00:00	AAPL	Stock	29.1	29.1	29.0775	29.0825	53248.0
2015-09-16 19:00:00	AAPL	Stock	29.0975	29.0975	29.075	29.095	90384.0
2015-09-16 07:00:00	MSFT	Stock	44.09	44.18	44.09	44.18	7684.0
2015-09-16 08:00:00	MSFT	Stock	44.16	44.26	44.08	44.09	14629.0
2015-09-16 09:00:00	MSFT	Stock	44.12	44.35	43.935	44.195	2491073.0
2015-09-16 10:00:00	MSFT	Stock	44.2	44.24	43.84	43.895	3188252.0
2015-09-16 11:00:00	MSFT	Stock	43.891	44.35	43.85	44.18	4293996.0
2015-09-16 12:00:00	MSFT	Stock	44.18	44.25	44.08	44.19	1626338.0
2015-09-16 13:00:00	MSFT	Stock	44.19	44.24	44.1	44.21	1562060.0
2015-09-16 14:00:00	MSFT	Stock	44.21	44.215	43.96	44.16	2579344.0
2015-09-16 15:00:00	MSFT	Stock	44.16	44.38	44.11	44.3	4734972.0
2015-09-16 16:00:00	MSFT	Stock	44.3	44.3	44.3	44.3	1528082.0
2015-09-16 17:00:00	MSFT	Stock	44.3	44.35	44.3	44.35	1800.0
2015-09-16 18:00:00	MSFT	Stock	44.34	44.34	44.31	44.33	510.0
2015-09-16 19:00:00	MSFT	Stock	44.34	44.34	44.34	44.34	500.0
2015-09-16 09:00:00	NVDA	Stock	0.572	0.5738	0.5687	0.5692	10206120.0
2015-09-16 10:00:00	NVDA	Stock	0.5692	0.5738	0.5681	0.5732	16667800.0
2015-09-16 11:00:00	NVDA	Stock	0.5732	0.5798	0.573	0.5794	35366760.0
2015-09-16 12:00:00	NVDA	Stock	0.5792	0.5808	0.5778	0.5802	27280760.0
2015-09-16 13:00:00	NVDA	Stock	0.58	0.5801	0.5762	0.5782	15772000.0
2015-09-16 14:00:00	NVDA	Stock	0.5782	0.5785	0.5745	0.5775	11891480.0
2015-09-16 15:00:00	NVDA	Stock	0.5772	0.5788	0.5768	0.5778	30694840.0
2015-09-16 16:00:00	NVDA	Stock	0.5775	0.5795	0.5775	0.5795	7887600.0
2015-09-16 17:00:00	NVDA	Stock	0.5762	0.5762	0.5762	0.5762	8000.0
2015-09-16 07:00:00	AMZN	Stock	26.143	26.143	26.125	26.125	37580.0
2015-09-16 08:00:00	AMZN	Stock	26.1	26.13	26.1	26.1015	69740.0
2015-09-16 09:00:00	AMZN	Stock	26.1135	26.1243	25.926	25.982	6610000.0
2015-09-16 10:00:00	AMZN	Stock	25.995	26.1935	25.969	26.1485	5555220.0
2015-09-16 11:00:00	AMZN	Stock	26.15	26.248	26.114	26.1835	3666140.0
2015-09-16 12:00:00	AMZN	Stock	26.184	26.2785	26.1605	26.241	4669520.0
2015-09-16 13:00:00	AMZN	Stock	26.2305	26.2535	26.1304	26.2528	3202780.0
2015-09-16 14:00:00	AMZN	Stock	26.2575	26.3403	26.1732	26.3125	4709100.0
2015-09-16 15:00:00	AMZN	Stock	26.316	26.415	26.295	26.362	6857400.0
2015-09-16 16:00:00	AMZN	Stock	26.362	26.3995	26.3505	26.351	1822680.0
2015-09-16 17:00:00	AMZN	Stock	26.3735	26.3735	26.3735	26.3735	2000.0
2015-09-16 18:00:00	AMZN	Stock	26.355	26.369	26.355	26.369	8000.0

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

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