PREVIEW / stock_1hour / 2015-04-23

all stock 1-hour files

  file:    by_date/stock_1hour/2015/2015-04-23.parquet
  size:    1.0 MB
  rows:    48,978
  symbols: 3,507

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-04-23 04:00:00	AAPL	Stock	32.0025	32.0025	31.93	31.955	24724.0
2015-04-23 05:00:00	AAPL	Stock	31.975	32.0225	31.975	31.9825	4240.0
2015-04-23 06:00:00	AAPL	Stock	32.08	32.0875	32.01	32.05	69228.0
2015-04-23 07:00:00	AAPL	Stock	32.0475	32.0925	32.0475	32.0675	104904.0
2015-04-23 08:00:00	AAPL	Stock	32.075	32.135	32.055	32.1347	539976.0
2015-04-23 09:00:00	AAPL	Stock	32.125	32.34	32.035	32.3242	28640176.0
2015-04-23 10:00:00	AAPL	Stock	32.325	32.445	32.215	32.2192	31218116.0
2015-04-23 11:00:00	AAPL	Stock	32.22	32.3975	32.2175	32.3752	17601080.0
2015-04-23 12:00:00	AAPL	Stock	32.3745	32.47	32.3375	32.47	13347876.0
2015-04-23 13:00:00	AAPL	Stock	32.4675	32.4825	32.385	32.4612	12112712.0
2015-04-23 14:00:00	AAPL	Stock	32.46	32.525	32.445	32.5225	23623044.0
2015-04-23 15:00:00	AAPL	Stock	32.52	32.605	32.4125	32.42	33766572.0
2015-04-23 16:00:00	AAPL	Stock	32.4175	32.5375	32.4125	32.5375	9592728.0
2015-04-23 17:00:00	AAPL	Stock	32.535	32.5625	32.5025	32.5175	276092.0
2015-04-23 18:00:00	AAPL	Stock	32.5125	32.535	32.5	32.5025	264736.0
2015-04-23 19:00:00	AAPL	Stock	32.505	32.5675	32.5025	32.52	319800.0
2015-04-23 05:00:00	MSFT	Stock	42.63	42.63	42.63	42.63	100.0
2015-04-23 06:00:00	MSFT	Stock	42.64	42.64	42.64	42.64	247.0
2015-04-23 07:00:00	MSFT	Stock	42.79	42.79	42.76	42.78	2462.0
2015-04-23 08:00:00	MSFT	Stock	42.9	42.9	42.73	42.73	16646.0
2015-04-23 09:00:00	MSFT	Stock	42.75	43.19	42.71	43.05	5623356.0
2015-04-23 10:00:00	MSFT	Stock	43.045	43.15	42.875	42.96	6090432.0
2015-04-23 11:00:00	MSFT	Stock	42.965	43.53	42.95	43.39	4718067.0
2015-04-23 12:00:00	MSFT	Stock	43.4	43.53	43.32	43.415	3391399.0
2015-04-23 13:00:00	MSFT	Stock	43.42	43.47	43.26	43.315	3875183.0
2015-04-23 14:00:00	MSFT	Stock	43.319	43.6	43.29	43.445	4133856.0
2015-04-23 15:00:00	MSFT	Stock	43.45	43.61	43.275	43.35	8961988.0
2015-04-23 16:00:00	MSFT	Stock	43.34	45.05	43.34	44.65	4882255.0
2015-04-23 17:00:00	MSFT	Stock	44.64	44.79	44.35	44.4	199684.0
2015-04-23 18:00:00	MSFT	Stock	44.39	45.34	43.75	45.03	626973.0
2015-04-23 19:00:00	MSFT	Stock	45.08	45.08	44.75	44.79	76194.0
2015-04-23 08:00:00	NVDA	Stock	0.5495	0.5538	0.549	0.549	259400.0
2015-04-23 09:00:00	NVDA	Stock	0.5502	0.5514	0.5335	0.5514	58096560.0
2015-04-23 10:00:00	NVDA	Stock	0.5515	0.5518	0.5475	0.548	30580240.0
2015-04-23 11:00:00	NVDA	Stock	0.548	0.5536	0.548	0.553	26022600.0
2015-04-23 12:00:00	NVDA	Stock	0.5532	0.5572	0.5525	0.557	29837680.0
2015-04-23 13:00:00	NVDA	Stock	0.557	0.5582	0.556	0.5582	20850360.0
2015-04-23 14:00:00	NVDA	Stock	0.5585	0.5608	0.5582	0.5589	27997080.0
2015-04-23 15:00:00	NVDA	Stock	0.559	0.559	0.5555	0.5558	34654440.0
2015-04-23 16:00:00	NVDA	Stock	0.5555	0.5555	0.555	0.5555	5920280.0
2015-04-23 17:00:00	NVDA	Stock	0.5555	0.5555	0.5555	0.5555	4000.0
2015-04-23 08:00:00	AMZN	Stock	19.5	19.55	19.5	19.5285	97560.0
2015-04-23 09:00:00	AMZN	Stock	19.5715	19.5715	19.437	19.4785	10095280.0
2015-04-23 10:00:00	AMZN	Stock	19.4965	19.5322	19.3075	19.3075	14922780.0
2015-04-23 11:00:00	AMZN	Stock	19.3075	19.413	19.3075	19.3455	10154540.0
2015-04-23 12:00:00	AMZN	Stock	19.3485	19.4435	19.3125	19.4415	10544740.0
2015-04-23 13:00:00	AMZN	Stock	19.4375	19.4595	19.393	19.405	7782540.0
2015-04-23 14:00:00	AMZN	Stock	19.403	19.465	19.383	19.4435	8068580.0
2015-04-23 15:00:00	AMZN	Stock	19.4425	19.594	19.441	19.5	22714840.0
2015-04-23 16:00:00	AMZN	Stock	19.4995	21.0	18.5775	20.5325	49754520.0

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

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