PREVIEW / stock_1hour / 2015-04-02

all stock 1-hour files

  file:    by_date/stock_1hour/2015/2015-04-02.parquet
  size:    1.0 MB
  rows:    48,541
  symbols: 3,516

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-04-02 04:00:00	AAPL	Stock	31.055	31.055	30.9975	31.0025	4916.0
2015-04-02 05:00:00	AAPL	Stock	31.0375	31.0625	31.015	31.0625	10244.0
2015-04-02 06:00:00	AAPL	Stock	31.045	31.06	31.025	31.0575	20844.0
2015-04-02 07:00:00	AAPL	Stock	31.055	31.1625	31.0525	31.1525	61040.0
2015-04-02 08:00:00	AAPL	Stock	31.1525	31.2375	31.0425	31.225	673752.0
2015-04-02 09:00:00	AAPL	Stock	31.23	31.2775	31.0775	31.1165	22082076.0
2015-04-02 10:00:00	AAPL	Stock	31.12	31.245	31.0475	31.1375	20048028.0
2015-04-02 11:00:00	AAPL	Stock	31.135	31.235	31.0925	31.2025	13617492.0
2015-04-02 12:00:00	AAPL	Stock	31.2025	31.2625	31.1475	31.21	11197704.0
2015-04-02 13:00:00	AAPL	Stock	31.2075	31.25	31.1775	31.2238	8551988.0
2015-04-02 14:00:00	AAPL	Stock	31.225	31.2625	31.18	31.22	10196592.0
2015-04-02 15:00:00	AAPL	Stock	31.22	31.39	31.218	31.3275	26791020.0
2015-04-02 16:00:00	AAPL	Stock	31.3288	31.371	31.1442	31.335	7670732.0
2015-04-02 17:00:00	AAPL	Stock	31.335	31.3425	31.315	31.32	120216.0
2015-04-02 18:00:00	AAPL	Stock	31.3225	31.3225	31.3175	31.3225	62188.0
2015-04-02 19:00:00	AAPL	Stock	31.3198	31.3275	31.3125	31.3275	65652.0
2015-04-02 04:00:00	MSFT	Stock	40.7	40.7	40.7	40.7	100.0
2015-04-02 07:00:00	MSFT	Stock	40.68	40.68	40.66	40.66	800.0
2015-04-02 08:00:00	MSFT	Stock	40.66	40.69	40.63	40.68	6940.0
2015-04-02 09:00:00	MSFT	Stock	40.68	40.74	40.45	40.555	5065377.0
2015-04-02 10:00:00	MSFT	Stock	40.57	40.61	40.37	40.397	4338205.0
2015-04-02 11:00:00	MSFT	Stock	40.4	40.41	40.3	40.305	3897020.0
2015-04-02 12:00:00	MSFT	Stock	40.31	40.31	40.13	40.14	5300110.0
2015-04-02 13:00:00	MSFT	Stock	40.14	40.22	40.12	40.19	3812450.0
2015-04-02 14:00:00	MSFT	Stock	40.19	40.28	40.17	40.18	3336413.0
2015-04-02 15:00:00	MSFT	Stock	40.19	40.4	40.16	40.29	6551856.0
2015-04-02 16:00:00	MSFT	Stock	40.29	40.416	40.222	40.29	3496942.0
2015-04-02 17:00:00	MSFT	Stock	40.3	40.3	40.28	40.3	20933.0
2015-04-02 18:00:00	MSFT	Stock	40.3	40.339	40.29	40.339	2900.0
2015-04-02 19:00:00	MSFT	Stock	40.29	40.3	40.28	40.28	699.0
2015-04-02 04:00:00	NVDA	Stock	0.5302	0.5302	0.5302	0.5302	4000.0
2015-04-02 06:00:00	NVDA	Stock	0.5258	0.5258	0.5258	0.5258	8000.0
2015-04-02 08:00:00	NVDA	Stock	0.5262	0.5262	0.5262	0.5262	4000.0
2015-04-02 09:00:00	NVDA	Stock	0.5322	0.5322	0.522	0.5275	21431000.0
2015-04-02 10:00:00	NVDA	Stock	0.5275	0.5293	0.5225	0.5253	31543080.0
2015-04-02 11:00:00	NVDA	Stock	0.5253	0.5265	0.523	0.523	16672320.0
2015-04-02 12:00:00	NVDA	Stock	0.5231	0.5265	0.522	0.526	19549840.0
2015-04-02 13:00:00	NVDA	Stock	0.526	0.5295	0.5258	0.5293	24963120.0
2015-04-02 14:00:00	NVDA	Stock	0.529	0.5298	0.5268	0.5275	20165040.0
2015-04-02 15:00:00	NVDA	Stock	0.5277	0.5285	0.5265	0.5265	39273720.0
2015-04-02 16:00:00	NVDA	Stock	0.5265	0.529	0.5265	0.5265	1143840.0
2015-04-02 17:00:00	NVDA	Stock	0.528	0.528	0.528	0.528	4000.0
2015-04-02 19:00:00	NVDA	Stock	0.528	0.528	0.528	0.528	8000.0
2015-04-02 04:00:00	AMZN	Stock	18.494	18.494	18.494	18.494	8000.0
2015-04-02 08:00:00	AMZN	Stock	18.4845	18.494	18.4845	18.494	6000.0
2015-04-02 09:00:00	AMZN	Stock	18.525	18.6604	18.45	18.605	5753740.0
2015-04-02 10:00:00	AMZN	Stock	18.6095	18.664	18.531	18.539	3414300.0
2015-04-02 11:00:00	AMZN	Stock	18.53	18.564	18.485	18.5435	2765720.0
2015-04-02 12:00:00	AMZN	Stock	18.5385	18.5575	18.4955	18.5495	3261320.0
2015-04-02 13:00:00	AMZN	Stock	18.547	18.561	18.5285	18.5385	2510420.0

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

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