PREVIEW / stock_1hour / 2016-01-04

all stock 1-hour files

  file:    by_date/stock_1hour/2016/2016-01-04.parquet
  size:    1.1 MB
  rows:    50,413
  symbols: 3,395

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-04 04:00:00	AAPL	Stock	26.3625	26.3625	25.85	25.85	142084.0
2016-01-04 05:00:00	AAPL	Stock	25.8875	25.9425	25.87	25.92	28172.0
2016-01-04 06:00:00	AAPL	Stock	25.9225	25.9225	25.75	25.75	154528.0
2016-01-04 07:00:00	AAPL	Stock	25.75	25.825	25.7025	25.825	408920.0
2016-01-04 08:00:00	AAPL	Stock	25.825	25.895	25.7	25.75	1420288.0
2016-01-04 09:00:00	AAPL	Stock	25.75	25.9225	25.5	25.673	38114564.0
2016-01-04 10:00:00	AAPL	Stock	25.67	25.9838	25.595	25.8355	34837028.0
2016-01-04 11:00:00	AAPL	Stock	25.8325	25.975	25.625	25.9575	22948508.0
2016-01-04 12:00:00	AAPL	Stock	25.96	26.2225	25.9225	26.1955	22266264.0
2016-01-04 13:00:00	AAPL	Stock	26.195	26.2475	26.0775	26.16	19441816.0
2016-01-04 14:00:00	AAPL	Stock	26.16	26.342	26.1025	26.1875	23135720.0
2016-01-04 15:00:00	AAPL	Stock	26.1875	26.34	25.9575	26.3325	31524832.0
2016-01-04 16:00:00	AAPL	Stock	26.3375	26.425	25.7192	26.3875	20394032.0
2016-01-04 17:00:00	AAPL	Stock	26.38	26.4375	26.3725	26.4075	121420.0
2016-01-04 18:00:00	AAPL	Stock	26.4175	26.435	26.4025	26.435	62648.0
2016-01-04 19:00:00	AAPL	Stock	26.435	26.45	26.415	26.435	90608.0
2016-01-04 04:00:00	MSFT	Stock	55.48	55.48	54.55	54.55	876.0
2016-01-04 06:00:00	MSFT	Stock	54.49	54.49	54.49	54.49	500.0
2016-01-04 07:00:00	MSFT	Stock	54.36	54.45	54.21	54.4	10819.0
2016-01-04 08:00:00	MSFT	Stock	54.45	54.7	54.21	54.5	30010.0
2016-01-04 09:00:00	MSFT	Stock	54.5	54.54	53.9	54.47	6275132.0
2016-01-04 10:00:00	MSFT	Stock	54.46	54.465	53.45	53.485	8337277.0
2016-01-04 11:00:00	MSFT	Stock	53.49	53.92	53.39	53.83	5893358.0
2016-01-04 12:00:00	MSFT	Stock	53.83	53.96	53.66	53.936	4992733.0
2016-01-04 13:00:00	MSFT	Stock	53.94	54.08	53.885	53.945	4215022.0
2016-01-04 14:00:00	MSFT	Stock	53.94	54.15	53.84	54.09	4826716.0
2016-01-04 15:00:00	MSFT	Stock	54.09	54.8	53.81	54.79	9585428.0
2016-01-04 16:00:00	MSFT	Stock	54.79	55.0	53.966	54.93	5698082.0
2016-01-04 17:00:00	MSFT	Stock	54.93	55.0	54.88	54.9	6160.0
2016-01-04 18:00:00	MSFT	Stock	54.9	54.9	54.82	54.89	4889.0
2016-01-04 19:00:00	MSFT	Stock	54.93	54.98	54.89	54.9	2223.0
2016-01-04 06:00:00	NVDA	Stock	0.81	0.81	0.81	0.81	8000.0
2016-01-04 07:00:00	NVDA	Stock	0.8075	0.8075	0.7985	0.7988	89600.0
2016-01-04 08:00:00	NVDA	Stock	0.8148	0.8148	0.7988	0.8012	116000.0
2016-01-04 09:00:00	NVDA	Stock	0.8	0.8145	0.7988	0.8075	56167080.0
2016-01-04 10:00:00	NVDA	Stock	0.8072	0.809	0.8028	0.8081	51922520.0
2016-01-04 11:00:00	NVDA	Stock	0.8082	0.8082	0.8038	0.8078	34012800.0
2016-01-04 12:00:00	NVDA	Stock	0.8078	0.8125	0.8052	0.81	31525640.0
2016-01-04 13:00:00	NVDA	Stock	0.8102	0.8115	0.8065	0.8065	30026080.0
2016-01-04 14:00:00	NVDA	Stock	0.8066	0.8082	0.8028	0.8045	30542800.0
2016-01-04 15:00:00	NVDA	Stock	0.8045	0.8098	0.801	0.8092	74652280.0
2016-01-04 16:00:00	NVDA	Stock	0.8092	0.8125	0.8063	0.8125	4024440.0
2016-01-04 17:00:00	NVDA	Stock	0.8148	0.8148	0.8125	0.8125	10000.0
2016-01-04 18:00:00	NVDA	Stock	0.8125	0.8125	0.8125	0.8125	32000.0
2016-01-04 19:00:00	NVDA	Stock	0.8125	0.8125	0.8125	0.8125	20000.0
2016-01-04 04:00:00	AMZN	Stock	33.616	33.616	33.2725	33.282	27400.0
2016-01-04 06:00:00	AMZN	Stock	33.1905	33.25	33.116	33.116	30480.0
2016-01-04 07:00:00	AMZN	Stock	33.1	33.125	32.8705	32.917	295860.0
2016-01-04 08:00:00	AMZN	Stock	32.9	33.0645	32.865	32.918	716300.0
2016-01-04 09:00:00	AMZN	Stock	32.925	33.0	32.4005	32.4536	27281780.0

> showing 50 of 50,413 rows — these rows as CSV

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