PREVIEW / stock_1hour / 2017-02-13

all stock 1-hour files

  file:    by_date/stock_1hour/2017/2017-02-13.parquet
  size:    1.1 MB
  rows:    48,852
  symbols: 3,107

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
2017-02-13 04:00:00	AAPL	Stock	33.1	33.1	33.03	33.03	9516.0
2017-02-13 05:00:00	AAPL	Stock	33.05	33.075	33.05	33.05	4296.0
2017-02-13 06:00:00	AAPL	Stock	33.0525	33.0875	33.0525	33.0875	11280.0
2017-02-13 07:00:00	AAPL	Stock	33.0625	33.15	33.0625	33.125	104636.0
2017-02-13 08:00:00	AAPL	Stock	33.125	33.22	32.9475	33.2125	540228.0
2017-02-13 09:00:00	AAPL	Stock	33.2075	33.455	33.1875	33.4012	22907440.0
2017-02-13 10:00:00	AAPL	Stock	33.4012	33.4375	33.37	33.395	10064424.0
2017-02-13 11:00:00	AAPL	Stock	33.3938	33.4375	33.33	33.4263	9827484.0
2017-02-13 12:00:00	AAPL	Stock	33.425	33.445	33.4	33.4138	6020704.0
2017-02-13 13:00:00	AAPL	Stock	33.4125	33.425	33.35	33.395	6658036.0
2017-02-13 14:00:00	AAPL	Stock	33.395	33.405	33.3285	33.34	6425580.0
2017-02-13 15:00:00	AAPL	Stock	33.3425	33.395	33.295	33.3225	12757508.0
2017-02-13 16:00:00	AAPL	Stock	33.3225	33.33	33.3	33.3025	8304496.0
2017-02-13 17:00:00	AAPL	Stock	33.3175	33.3675	33.3175	33.3375	128904.0
2017-02-13 18:00:00	AAPL	Stock	33.3275	33.3475	33.3275	33.3475	15204.0
2017-02-13 19:00:00	AAPL	Stock	33.3375	33.3475	33.33	33.3475	67872.0
2017-02-13 04:00:00	MSFT	Stock	64.1	64.1	64.1	64.1	200.0
2017-02-13 07:00:00	MSFT	Stock	64.18	64.18	64.12	64.13	3778.0
2017-02-13 08:00:00	MSFT	Stock	64.2	64.2	64.11	64.11	7881.0
2017-02-13 09:00:00	MSFT	Stock	64.14	64.44	64.13	64.44	2980774.0
2017-02-13 10:00:00	MSFT	Stock	64.44	64.6	64.4	64.53	2262223.0
2017-02-13 11:00:00	MSFT	Stock	64.53	64.58	64.45	64.45	1780546.0
2017-02-13 12:00:00	MSFT	Stock	64.45	64.57	64.44	64.565	1210102.0
2017-02-13 13:00:00	MSFT	Stock	64.56	64.69	64.54	64.685	1557842.0
2017-02-13 14:00:00	MSFT	Stock	64.685	64.86	64.67	64.77	2212050.0
2017-02-13 15:00:00	MSFT	Stock	64.77	64.78	64.56	64.71	4978675.0
2017-02-13 16:00:00	MSFT	Stock	64.72	64.77	64.7	64.73	3105172.0
2017-02-13 17:00:00	MSFT	Stock	64.72	64.76	64.72	64.76	455786.0
2017-02-13 18:00:00	MSFT	Stock	64.76	64.77	64.74	64.74	897.0
2017-02-13 19:00:00	MSFT	Stock	64.77	64.81	64.73	64.81	4655.0
2017-02-13 05:00:00	NVDA	Stock	2.8438	2.8438	2.8375	2.8375	72640.0
2017-02-13 06:00:00	NVDA	Stock	2.8425	2.8505	2.8425	2.85	232040.0
2017-02-13 07:00:00	NVDA	Stock	2.8465	2.85	2.8425	2.845	547840.0
2017-02-13 08:00:00	NVDA	Stock	2.8462	2.859	2.8425	2.847	2664040.0
2017-02-13 09:00:00	NVDA	Stock	2.8452	2.8495	2.7988	2.8041	169535480.0
2017-02-13 10:00:00	NVDA	Stock	2.8045	2.8058	2.7253	2.7405	330900400.0
2017-02-13 11:00:00	NVDA	Stock	2.7405	2.7625	2.728	2.728	154245400.0
2017-02-13 12:00:00	NVDA	Stock	2.7287	2.7413	2.7133	2.7293	116631560.0
2017-02-13 13:00:00	NVDA	Stock	2.7286	2.742	2.7228	2.7298	72390360.0
2017-02-13 14:00:00	NVDA	Stock	2.7295	2.7553	2.705	2.7137	117434080.0
2017-02-13 15:00:00	NVDA	Stock	2.7134	2.7293	2.7065	2.7093	144371080.0
2017-02-13 16:00:00	NVDA	Stock	2.7093	2.7148	2.7025	2.7025	24279160.0
2017-02-13 17:00:00	NVDA	Stock	2.7025	2.7072	2.7003	2.705	1222600.0
2017-02-13 18:00:00	NVDA	Stock	2.705	2.706	2.7025	2.705	857960.0
2017-02-13 19:00:00	NVDA	Stock	2.7048	2.7075	2.7015	2.7072	731360.0
2017-02-13 06:00:00	AMZN	Stock	41.432	41.432	41.4	41.4	6520.0
2017-02-13 07:00:00	AMZN	Stock	41.436	41.5935	41.431	41.5375	70360.0
2017-02-13 08:00:00	AMZN	Stock	41.53	41.709	41.53	41.6375	296300.0
2017-02-13 09:00:00	AMZN	Stock	41.6375	41.745	41.4275	41.67	11468580.0
2017-02-13 10:00:00	AMZN	Stock	41.6638	42.0295	41.645	42.0145	14602740.0

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

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