PREVIEW / stock_1hour / 2015-08-12

all stock 1-hour files

  file:    by_date/stock_1hour/2015/2015-08-12.parquet
  size:    1.0 MB
  rows:    48,896
  symbols: 3,461

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-08-12 04:00:00	AAPL	Stock	28.3075	28.3075	27.7525	27.8525	424576.0
2015-08-12 05:00:00	AAPL	Stock	27.8525	27.95	27.825	27.845	159088.0
2015-08-12 06:00:00	AAPL	Stock	27.845	28.0575	27.8125	28.0125	328964.0
2015-08-12 07:00:00	AAPL	Stock	28.0225	28.07	27.9	28.07	529996.0
2015-08-12 08:00:00	AAPL	Stock	28.0625	28.3725	27.8375	28.1275	3247800.0
2015-08-12 09:00:00	AAPL	Stock	28.1375	28.225	27.4075	27.7312	85012492.0
2015-08-12 10:00:00	AAPL	Stock	27.7275	27.9975	27.595	27.9775	68517604.0
2015-08-12 11:00:00	AAPL	Stock	27.98	28.5	27.97	28.1138	66121708.0
2015-08-12 12:00:00	AAPL	Stock	28.1175	28.6	28.0675	28.55	41927648.0
2015-08-12 13:00:00	AAPL	Stock	28.55	28.8375	28.5225	28.7512	43004892.0
2015-08-12 14:00:00	AAPL	Stock	28.7475	28.8225	28.6128	28.7955	31104024.0
2015-08-12 15:00:00	AAPL	Stock	28.7925	28.855	28.72	28.815	32737388.0
2015-08-12 16:00:00	AAPL	Stock	28.81	28.925	27.6858	28.9025	7979344.0
2015-08-12 17:00:00	AAPL	Stock	28.81	28.9375	28.81	28.86	334172.0
2015-08-12 18:00:00	AAPL	Stock	28.865	28.9225	28.8625	28.8775	68692.0
2015-08-12 19:00:00	AAPL	Stock	28.875	28.925	28.875	28.925	126028.0
2015-08-12 08:00:00	MSFT	Stock	45.67	46.3	45.67	46.03	2349.0
2015-08-12 09:00:00	MSFT	Stock	46.04	46.465	46.03	46.26	3013054.0
2015-08-12 10:00:00	MSFT	Stock	46.26	46.35	45.9	45.96	5230404.0
2015-08-12 11:00:00	MSFT	Stock	45.96	46.005	45.71	45.725	4523429.0
2015-08-12 12:00:00	MSFT	Stock	45.72	46.16	45.705	46.13	2191381.0
2015-08-12 13:00:00	MSFT	Stock	46.13	46.54	46.11	46.5	2897291.0
2015-08-12 14:00:00	MSFT	Stock	46.51	46.78	46.445	46.775	3111148.0
2015-08-12 15:00:00	MSFT	Stock	46.775	46.9	46.69	46.75	5036298.0
2015-08-12 16:00:00	MSFT	Stock	46.74	46.81	46.74	46.77	2596495.0
2015-08-12 17:00:00	MSFT	Stock	46.74	46.76	46.74	46.76	300.0
2015-08-12 18:00:00	MSFT	Stock	46.8	46.89	46.8	46.89	9780.0
2015-08-12 19:00:00	MSFT	Stock	46.86	46.89	46.86	46.88	3700.0
2015-08-12 07:00:00	NVDA	Stock	0.5855	0.5855	0.5855	0.5855	12000.0
2015-08-12 08:00:00	NVDA	Stock	0.5838	0.5838	0.5838	0.5838	8000.0
2015-08-12 09:00:00	NVDA	Stock	0.586	0.5923	0.5815	0.5898	49744440.0
2015-08-12 10:00:00	NVDA	Stock	0.5898	0.5912	0.5868	0.5885	73531000.0
2015-08-12 11:00:00	NVDA	Stock	0.5884	0.5888	0.5868	0.5876	63078560.0
2015-08-12 12:00:00	NVDA	Stock	0.5878	0.5933	0.5875	0.5923	35421880.0
2015-08-12 13:00:00	NVDA	Stock	0.592	0.5965	0.5918	0.5955	31650600.0
2015-08-12 14:00:00	NVDA	Stock	0.5958	0.5971	0.594	0.5961	35844120.0
2015-08-12 15:00:00	NVDA	Stock	0.5963	0.5973	0.5928	0.593	75782720.0
2015-08-12 16:00:00	NVDA	Stock	0.593	0.5935	0.593	0.5935	8167000.0
2015-08-12 18:00:00	NVDA	Stock	0.5964	0.5964	0.5964	0.5964	8000.0
2015-08-12 04:00:00	AMZN	Stock	26.1405	26.1405	26.1405	26.1405	2000.0
2015-08-12 05:00:00	AMZN	Stock	26.1105	26.1105	26.1105	26.1105	2000.0
2015-08-12 06:00:00	AMZN	Stock	26.1355	26.1355	26.1355	26.1355	5480.0
2015-08-12 07:00:00	AMZN	Stock	26.104	26.1895	26.0805	26.175	38800.0
2015-08-12 08:00:00	AMZN	Stock	26.1965	26.24	26.1775	26.2125	126500.0
2015-08-12 09:00:00	AMZN	Stock	26.2015	26.3405	26.005	26.0805	5196200.0
2015-08-12 10:00:00	AMZN	Stock	26.094	26.1525	25.653	25.7	16069140.0
2015-08-12 11:00:00	AMZN	Stock	25.6983	26.021	25.698	25.8515	12143680.0
2015-08-12 12:00:00	AMZN	Stock	25.8505	26.0758	25.817	26.023	6081340.0
2015-08-12 13:00:00	AMZN	Stock	26.03	26.244	26.0115	26.2075	7148960.0
2015-08-12 14:00:00	AMZN	Stock	26.2095	26.2885	26.1255	26.2739	5885720.0

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

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