PREVIEW / stock_1hour / 2015-03-26

all stock 1-hour files

  file:    by_date/stock_1hour/2015/2015-03-26.parquet
  size:    1.0 MB
  rows:    48,588
  symbols: 3,495

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-03-26 04:00:00	AAPL	Stock	30.7375	30.7375	30.2	30.4	450508.0
2015-03-26 05:00:00	AAPL	Stock	30.3775	30.4625	30.3275	30.4	198896.0
2015-03-26 06:00:00	AAPL	Stock	30.4	30.4875	30.375	30.475	136544.0
2015-03-26 07:00:00	AAPL	Stock	30.475	30.5875	30.4625	30.5125	378224.0
2015-03-26 08:00:00	AAPL	Stock	30.51	30.74	30.3875	30.6875	1428440.0
2015-03-26 09:00:00	AAPL	Stock	30.68	31.125	30.65	30.9825	36844400.0
2015-03-26 10:00:00	AAPL	Stock	30.9825	31.07	30.8025	31.0662	35230736.0
2015-03-26 11:00:00	AAPL	Stock	31.065	31.205	30.9375	31.1912	22270464.0
2015-03-26 12:00:00	AAPL	Stock	31.195	31.22	31.0275	31.125	16123044.0
2015-03-26 13:00:00	AAPL	Stock	31.125	31.1475	30.9525	31.1125	15462052.0
2015-03-26 14:00:00	AAPL	Stock	31.1125	31.185	31.03	31.1025	14248480.0
2015-03-26 15:00:00	AAPL	Stock	31.1	31.1725	31.01	31.0625	24633828.0
2015-03-26 16:00:00	AAPL	Stock	31.06	31.105	31.0412	31.08	9891884.0
2015-03-26 17:00:00	AAPL	Stock	31.0825	31.1025	31.06	31.08	104728.0
2015-03-26 18:00:00	AAPL	Stock	31.085	31.1	31.06	31.0925	440356.0
2015-03-26 19:00:00	AAPL	Stock	31.0975	31.13	31.08	31.125	144040.0
2015-03-26 04:00:00	MSFT	Stock	41.16	41.21	41.16	41.16	3400.0
2015-03-26 05:00:00	MSFT	Stock	41.05	41.05	41.04	41.04	1400.0
2015-03-26 06:00:00	MSFT	Stock	41.05	41.18	41.05	41.18	4200.0
2015-03-26 07:00:00	MSFT	Stock	41.14	41.2	41.1	41.17	9044.0
2015-03-26 08:00:00	MSFT	Stock	41.18	41.29	41.11	41.29	18088.0
2015-03-26 09:00:00	MSFT	Stock	41.24	41.46	41.04	41.08	4858064.0
2015-03-26 10:00:00	MSFT	Stock	41.08	41.26	40.92	41.24	7311468.0
2015-03-26 11:00:00	MSFT	Stock	41.24	41.52	41.18	41.514	4400127.0
2015-03-26 12:00:00	MSFT	Stock	41.52	41.565	41.31	41.41	3886843.0
2015-03-26 13:00:00	MSFT	Stock	41.4	41.61	41.33	41.545	3180301.0
2015-03-26 14:00:00	MSFT	Stock	41.545	41.56	41.26	41.28	3350832.0
2015-03-26 15:00:00	MSFT	Stock	41.28	41.35	41.17	41.2	6764971.0
2015-03-26 16:00:00	MSFT	Stock	41.21	41.52	41.19	41.359	2164362.0
2015-03-26 17:00:00	MSFT	Stock	41.24	41.515	41.21	41.21	9455.0
2015-03-26 18:00:00	MSFT	Stock	41.22	41.25	41.22	41.25	2007.0
2015-03-26 19:00:00	MSFT	Stock	41.25	41.26	41.25	41.26	1143.0
2015-03-26 06:00:00	NVDA	Stock	0.5213	0.5213	0.5213	0.5213	24000.0
2015-03-26 08:00:00	NVDA	Stock	0.5245	0.5253	0.5205	0.5247	68000.0
2015-03-26 09:00:00	NVDA	Stock	0.5245	0.5245	0.5115	0.518	54823360.0
2015-03-26 10:00:00	NVDA	Stock	0.518	0.5228	0.5138	0.5225	48703360.0
2015-03-26 11:00:00	NVDA	Stock	0.5222	0.526	0.5196	0.5259	34648040.0
2015-03-26 12:00:00	NVDA	Stock	0.5258	0.5264	0.5188	0.5232	24140000.0
2015-03-26 13:00:00	NVDA	Stock	0.5231	0.5258	0.5207	0.5241	23390840.0
2015-03-26 14:00:00	NVDA	Stock	0.5241	0.525	0.5225	0.5234	23364000.0
2015-03-26 15:00:00	NVDA	Stock	0.5232	0.526	0.5225	0.5242	68377640.0
2015-03-26 16:00:00	NVDA	Stock	0.5241	0.5242	0.5218	0.523	21724960.0
2015-03-26 17:00:00	NVDA	Stock	0.5268	0.5268	0.5268	0.5268	12000.0
2015-03-26 18:00:00	NVDA	Stock	0.5268	0.5268	0.5268	0.5268	8000.0
2015-03-26 04:00:00	AMZN	Stock	18.3835	18.3835	18.3835	18.3835	6000.0
2015-03-26 05:00:00	AMZN	Stock	18.3835	18.3835	18.3835	18.3835	18000.0
2015-03-26 06:00:00	AMZN	Stock	18.3795	18.3795	18.3795	18.3795	3000.0
2015-03-26 07:00:00	AMZN	Stock	18.3815	18.425	18.3815	18.425	29000.0
2015-03-26 08:00:00	AMZN	Stock	18.425	18.45	18.3685	18.435	219580.0
2015-03-26 09:00:00	AMZN	Stock	18.4445	18.57	18.3385	18.4335	10746880.0

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

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