PREVIEW / stock_1hour / 2015-01-14

all stock 1-hour files

  file:    by_date/stock_1hour/2015/2015-01-14.parquet
  size:    1.0 MB
  rows:    49,518
  symbols: 3,535

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-01-14 04:00:00	AAPL	Stock	27.5425	27.545	27.42	27.545	23408.0
2015-01-14 05:00:00	AAPL	Stock	27.5675	27.675	27.55	27.55	32472.0
2015-01-14 06:00:00	AAPL	Stock	27.5625	27.6175	27.5475	27.5875	12880.0
2015-01-14 07:00:00	AAPL	Stock	27.5525	27.5525	27.435	27.4625	145080.0
2015-01-14 08:00:00	AAPL	Stock	27.4725	27.5225	27.155	27.225	2249868.0
2015-01-14 09:00:00	AAPL	Stock	27.225	27.6225	27.1775	27.4375	27726412.0
2015-01-14 10:00:00	AAPL	Stock	27.4372	27.5872	27.315	27.3975	27387248.0
2015-01-14 11:00:00	AAPL	Stock	27.4	27.415	27.23	27.2825	22345468.0
2015-01-14 12:00:00	AAPL	Stock	27.2872	27.325	27.1825	27.2725	17295076.0
2015-01-14 13:00:00	AAPL	Stock	27.275	27.3	27.125	27.23	17896240.0
2015-01-14 14:00:00	AAPL	Stock	27.2322	27.495	27.205	27.2728	25352524.0
2015-01-14 15:00:00	AAPL	Stock	27.275	27.475	27.268	27.4475	29270596.0
2015-01-14 16:00:00	AAPL	Stock	27.45	27.5	27.25	27.495	12953864.0
2015-01-14 17:00:00	AAPL	Stock	27.495	27.4975	27.3342	27.495	766528.0
2015-01-14 18:00:00	AAPL	Stock	27.495	27.5475	27.45	27.5325	517520.0
2015-01-14 19:00:00	AAPL	Stock	27.535	27.5375	27.495	27.495	255812.0
2015-01-14 04:00:00	MSFT	Stock	46.25	46.32	46.25	46.32	1200.0
2015-01-14 05:00:00	MSFT	Stock	46.35	46.35	46.35	46.35	600.0
2015-01-14 06:00:00	MSFT	Stock	46.33	46.34	46.28	46.34	463.0
2015-01-14 07:00:00	MSFT	Stock	46.21	46.21	46.11	46.11	997.0
2015-01-14 08:00:00	MSFT	Stock	46.13	46.14	45.78	45.79	30196.0
2015-01-14 09:00:00	MSFT	Stock	45.83	46.24	45.79	45.99	3348740.0
2015-01-14 10:00:00	MSFT	Stock	45.99	46.195	45.93	46.0	4519519.0
2015-01-14 11:00:00	MSFT	Stock	46.0	46.1	45.86	45.95	3064343.0
2015-01-14 12:00:00	MSFT	Stock	45.95	46.035	45.83	45.925	2108783.0
2015-01-14 13:00:00	MSFT	Stock	45.925	45.97	45.62	45.775	2264461.0
2015-01-14 14:00:00	MSFT	Stock	45.78	46.065	45.68	45.8	2821596.0
2015-01-14 15:00:00	MSFT	Stock	45.795	46.14	45.79	45.95	6606268.0
2015-01-14 16:00:00	MSFT	Stock	45.955	46.17	45.881	46.17	3693047.0
2015-01-14 17:00:00	MSFT	Stock	45.943	46.14	45.943	46.12	6095.0
2015-01-14 18:00:00	MSFT	Stock	46.14	46.14	46.14	46.14	3000.0
2015-01-14 19:00:00	MSFT	Stock	46.1	46.1	46.09	46.09	3000.0
2015-01-14 08:00:00	NVDA	Stock	0.485	0.485	0.485	0.485	4000.0
2015-01-14 09:00:00	NVDA	Stock	0.4878	0.492	0.485	0.4908	20371640.0
2015-01-14 10:00:00	NVDA	Stock	0.4908	0.495	0.4908	0.4928	15348880.0
2015-01-14 11:00:00	NVDA	Stock	0.4928	0.4932	0.4891	0.4905	13511760.0
2015-01-14 12:00:00	NVDA	Stock	0.4908	0.492	0.4895	0.492	12508080.0
2015-01-14 13:00:00	NVDA	Stock	0.492	0.4925	0.4878	0.4883	14657600.0
2015-01-14 14:00:00	NVDA	Stock	0.488	0.4928	0.488	0.4905	18338120.0
2015-01-14 15:00:00	NVDA	Stock	0.4905	0.4948	0.4905	0.4935	47756240.0
2015-01-14 16:00:00	NVDA	Stock	0.4935	0.4935	0.4933	0.4935	9518320.0
2015-01-14 04:00:00	AMZN	Stock	14.7145	14.7145	14.7145	14.7145	2000.0
2015-01-14 06:00:00	AMZN	Stock	14.7	14.7	14.7	14.7	13100.0
2015-01-14 07:00:00	AMZN	Stock	14.6665	14.675	14.654	14.654	32100.0
2015-01-14 08:00:00	AMZN	Stock	14.665	14.6875	14.5565	14.595	348660.0
2015-01-14 09:00:00	AMZN	Stock	14.601	14.7955	14.5265	14.554	10802680.0
2015-01-14 10:00:00	AMZN	Stock	14.555	14.583	14.3275	14.395	26464960.0
2015-01-14 11:00:00	AMZN	Stock	14.395	14.4315	14.3252	14.408	10842240.0
2015-01-14 12:00:00	AMZN	Stock	14.4025	14.452	14.3607	14.4272	8323320.0
2015-01-14 13:00:00	AMZN	Stock	14.4265	14.462	14.3855	14.427	8482720.0

> showing 50 of 49,518 rows — these rows as CSV

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