PREVIEW / stock_1hour / 2016-01-05

all stock 1-hour files

  file:    by_date/stock_1hour/2016/2016-01-05.parquet
  size:    1.0 MB
  rows:    48,698
  symbols: 3,382

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
2016-01-05 04:00:00	AAPL	Stock	26.37	26.37	26.31	26.32	4696.0
2016-01-05 05:00:00	AAPL	Stock	26.3075	26.32	26.225	26.225	11328.0
2016-01-05 06:00:00	AAPL	Stock	26.285	26.285	26.2375	26.2625	2400.0
2016-01-05 07:00:00	AAPL	Stock	26.2625	26.32	26.175	26.255	132040.0
2016-01-05 08:00:00	AAPL	Stock	26.2475	26.37	26.1875	26.3375	568236.0
2016-01-05 09:00:00	AAPL	Stock	26.35	26.4625	26.025	26.0345	22463748.0
2016-01-05 10:00:00	AAPL	Stock	26.03	26.2375	25.9575	26.1238	22372748.0
2016-01-05 11:00:00	AAPL	Stock	26.1238	26.1375	25.9675	26.0225	14696416.0
2016-01-05 12:00:00	AAPL	Stock	26.0238	26.025	25.6025	25.7562	51577988.0
2016-01-05 13:00:00	AAPL	Stock	25.76	25.9375	25.6875	25.87	22131904.0
2016-01-05 14:00:00	AAPL	Stock	25.8712	25.935	25.7273	25.75	20344244.0
2016-01-05 15:00:00	AAPL	Stock	25.75	25.7725	25.65	25.6775	35979496.0
2016-01-05 16:00:00	AAPL	Stock	25.6775	25.705	25.6275	25.6275	13290512.0
2016-01-05 17:00:00	AAPL	Stock	25.6275	25.6275	25.5275	25.6025	313000.0
2016-01-05 18:00:00	AAPL	Stock	25.5925	25.635	25.5825	25.595	82524.0
2016-01-05 19:00:00	AAPL	Stock	25.595	25.595	25.5575	25.5625	149884.0
2016-01-05 04:00:00	MSFT	Stock	54.77	54.77	54.77	54.77	200.0
2016-01-05 06:00:00	MSFT	Stock	54.38	54.59	54.38	54.59	400.0
2016-01-05 07:00:00	MSFT	Stock	54.48	54.7	54.48	54.7	6651.0
2016-01-05 08:00:00	MSFT	Stock	54.7	55.05	54.7	55.0	67014.0
2016-01-05 09:00:00	MSFT	Stock	54.96	55.33	54.77	55.03	3568069.0
2016-01-05 10:00:00	MSFT	Stock	55.03	55.19	54.75	55.07	4408272.0
2016-01-05 11:00:00	MSFT	Stock	55.07	55.15	54.815	55.035	3398373.0
2016-01-05 12:00:00	MSFT	Stock	55.04	55.04	54.54	54.9	3542299.0
2016-01-05 13:00:00	MSFT	Stock	54.89	55.19	54.78	55.106	3002687.0
2016-01-05 14:00:00	MSFT	Stock	55.103	55.39	55.065	55.185	3345880.0
2016-01-05 15:00:00	MSFT	Stock	55.18	55.365	55.03	55.05	7135762.0
2016-01-05 16:00:00	MSFT	Stock	55.05	55.15	55.018	55.09	2975708.0
2016-01-05 17:00:00	MSFT	Stock	55.06	55.06	55.06	55.06	100.0
2016-01-05 19:00:00	MSFT	Stock	55.11	55.11	55.11	55.11	200.0
2016-01-05 07:00:00	NVDA	Stock	0.8125	0.8125	0.8125	0.8125	6600.0
2016-01-05 08:00:00	NVDA	Stock	0.8182	0.835	0.8182	0.8275	373960.0
2016-01-05 09:00:00	NVDA	Stock	0.8242	0.8275	0.8125	0.8182	64072680.0
2016-01-05 10:00:00	NVDA	Stock	0.818	0.8298	0.8148	0.8296	58222000.0
2016-01-05 11:00:00	NVDA	Stock	0.8295	0.836	0.8278	0.8332	64491800.0
2016-01-05 12:00:00	NVDA	Stock	0.8332	0.8338	0.8283	0.8336	41700760.0
2016-01-05 13:00:00	NVDA	Stock	0.8336	0.8351	0.8298	0.8332	40216560.0
2016-01-05 14:00:00	NVDA	Stock	0.8335	0.8336	0.8265	0.8268	32744960.0
2016-01-05 15:00:00	NVDA	Stock	0.827	0.8279	0.8218	0.822	83958320.0
2016-01-05 16:00:00	NVDA	Stock	0.8222	0.8262	0.8222	0.8238	36603880.0
2016-01-05 17:00:00	NVDA	Stock	0.8245	0.8252	0.8245	0.825	21560.0
2016-01-05 18:00:00	NVDA	Stock	0.8252	0.8322	0.8242	0.8288	404680.0
2016-01-05 19:00:00	NVDA	Stock	0.8252	0.8275	0.823	0.8273	350320.0
2016-01-05 04:00:00	AMZN	Stock	31.9025	31.95	31.83	31.85	27260.0
2016-01-05 05:00:00	AMZN	Stock	31.8055	31.8055	31.732	31.7965	21880.0
2016-01-05 06:00:00	AMZN	Stock	31.754	31.754	31.754	31.754	2000.0
2016-01-05 07:00:00	AMZN	Stock	31.775	31.8	31.6525	31.8	51220.0
2016-01-05 08:00:00	AMZN	Stock	31.8	32.225	31.7945	32.175	775460.0
2016-01-05 09:00:00	AMZN	Stock	32.1575	32.3455	31.6695	31.698	17060000.0
2016-01-05 10:00:00	AMZN	Stock	31.6825	31.9625	31.5324	31.847	19814740.0

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

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