PREVIEW / stock_1hour / 2017-05-10

all stock 1-hour files

  file:    by_date/stock_1hour/2017/2017-05-10.parquet
  size:    1.0 MB
  rows:    48,222
  symbols: 3,025

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
2017-05-10 04:00:00	AAPL	Stock	38.395	38.395	38.395	38.395	400.0
2017-05-10 05:00:00	AAPL	Stock	38.3175	38.3175	38.275	38.3175	22452.0
2017-05-10 06:00:00	AAPL	Stock	38.33	38.3575	38.305	38.3175	30488.0
2017-05-10 07:00:00	AAPL	Stock	38.325	38.3375	38.2625	38.305	222384.0
2017-05-10 08:00:00	AAPL	Stock	38.3175	38.4975	38.1875	38.2625	904016.0
2017-05-10 09:00:00	AAPL	Stock	38.2625	38.485	38.225	38.255	14705156.0
2017-05-10 10:00:00	AAPL	Stock	38.2525	38.2862	38.0275	38.222	22751016.0
2017-05-10 11:00:00	AAPL	Stock	38.22	38.36	38.2125	38.256	9883936.0
2017-05-10 12:00:00	AAPL	Stock	38.257	38.3562	38.2302	38.345	7376952.0
2017-05-10 13:00:00	AAPL	Stock	38.3438	38.37	38.2925	38.355	7372976.0
2017-05-10 14:00:00	AAPL	Stock	38.3545	38.41	38.32	38.3375	7222700.0
2017-05-10 15:00:00	AAPL	Stock	38.3352	38.3575	38.21	38.315	15503280.0
2017-05-10 16:00:00	AAPL	Stock	38.3075	38.3375	38.3	38.3275	6031752.0
2017-05-10 17:00:00	AAPL	Stock	38.32	38.3375	38.3125	38.325	63876.0
2017-05-10 18:00:00	AAPL	Stock	38.325	38.3425	38.3225	38.3325	37092.0
2017-05-10 19:00:00	AAPL	Stock	38.3425	38.35	38.3325	38.35	35192.0
2017-05-10 05:00:00	MSFT	Stock	69.05	69.05	69.05	69.05	100.0
2017-05-10 08:00:00	MSFT	Stock	69.02	69.02	69.02	69.02	175.0
2017-05-10 09:00:00	MSFT	Stock	68.96	69.15	68.93	69.09	1229941.0
2017-05-10 10:00:00	MSFT	Stock	69.08	69.15	68.92	68.98	2391987.0
2017-05-10 11:00:00	MSFT	Stock	68.99	69.125	68.96	69.07	1273222.0
2017-05-10 12:00:00	MSFT	Stock	69.08	69.14	69.03	69.12	1340484.0
2017-05-10 13:00:00	MSFT	Stock	69.112	69.337	69.08	69.29	2083718.0
2017-05-10 14:00:00	MSFT	Stock	69.29	69.41	69.22	69.41	2038452.0
2017-05-10 15:00:00	MSFT	Stock	69.405	69.56	69.26	69.31	4897448.0
2017-05-10 16:00:00	MSFT	Stock	69.32	69.34	69.25	69.28	1287017.0
2017-05-10 17:00:00	MSFT	Stock	69.26	69.28	69.26	69.28	3600.0
2017-05-10 18:00:00	MSFT	Stock	69.25	69.25	69.02	69.2	38160.0
2017-05-10 19:00:00	MSFT	Stock	69.2	69.2	69.17	69.17	1926.0
2017-05-10 04:00:00	NVDA	Stock	2.8238	2.8498	2.8125	2.8438	614400.0
2017-05-10 05:00:00	NVDA	Stock	2.8498	2.855	2.8425	2.8525	267760.0
2017-05-10 06:00:00	NVDA	Stock	2.856	2.8858	2.8538	2.875	2028480.0
2017-05-10 07:00:00	NVDA	Stock	2.8725	2.907	2.8535	2.8748	16195080.0
2017-05-10 08:00:00	NVDA	Stock	2.875	2.9043	2.8482	2.9025	26884360.0
2017-05-10 09:00:00	NVDA	Stock	2.9003	2.955	2.8505	2.9168	515092160.0
2017-05-10 10:00:00	NVDA	Stock	2.916	2.9563	2.9068	2.9445	320364000.0
2017-05-10 11:00:00	NVDA	Stock	2.9447	2.961	2.9305	2.9523	146204360.0
2017-05-10 12:00:00	NVDA	Stock	2.9525	2.9875	2.9518	2.9865	171783000.0
2017-05-10 13:00:00	NVDA	Stock	2.9868	3.022	2.9848	3.0133	219500560.0
2017-05-10 14:00:00	NVDA	Stock	3.0135	3.0178	2.98	3.004	158708160.0
2017-05-10 15:00:00	NVDA	Stock	3.0038	3.0455	3.0022	3.0325	273925400.0
2017-05-10 16:00:00	NVDA	Stock	3.0325	3.038	3.0262	3.0323	117650480.0
2017-05-10 17:00:00	NVDA	Stock	3.03	3.0323	3.0278	3.0318	301320.0
2017-05-10 18:00:00	NVDA	Stock	3.0315	3.0323	3.0295	3.0312	1164440.0
2017-05-10 19:00:00	NVDA	Stock	3.0312	3.0325	3.0298	3.0312	809560.0
2017-05-10 06:00:00	AMZN	Stock	47.621	47.6225	47.621	47.6225	24000.0
2017-05-10 07:00:00	AMZN	Stock	47.653	47.653	47.62	47.62	20000.0
2017-05-10 08:00:00	AMZN	Stock	47.64	47.64	47.575	47.6005	63680.0
2017-05-10 09:00:00	AMZN	Stock	47.604	47.7	47.25	47.4138	8211660.0
2017-05-10 10:00:00	AMZN	Stock	47.3945	47.475	47.3	47.38	5772560.0

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

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