PREVIEW / stock_1hour / 2017-01-04

all stock 1-hour files

  file:    by_date/stock_1hour/2017/2017-01-04.parquet
  size:    1.1 MB
  rows:    51,252
  symbols: 3,167

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-01-04 04:00:00	AAPL	Stock	28.9925	29.0675	28.99	29.0675	3084.0
2017-01-04 06:00:00	AAPL	Stock	29.0375	29.075	29.02	29.02	12736.0
2017-01-04 07:00:00	AAPL	Stock	29.05	29.075	28.95	28.95	112572.0
2017-01-04 08:00:00	AAPL	Stock	28.9625	29.025	28.9525	28.9525	135420.0
2017-01-04 09:00:00	AAPL	Stock	28.975	29.1275	28.9225	29.0675	14562520.0
2017-01-04 10:00:00	AAPL	Stock	29.0698	29.1	28.9675	28.9888	12427616.0
2017-01-04 11:00:00	AAPL	Stock	28.99	29.095	28.9762	29.0925	8544932.0
2017-01-04 12:00:00	AAPL	Stock	29.0925	29.095	29.01	29.0325	5557504.0
2017-01-04 13:00:00	AAPL	Stock	29.035	29.0675	29.0238	29.0525	5238048.0
2017-01-04 14:00:00	AAPL	Stock	29.0525	29.075	29.01	29.0152	7630284.0
2017-01-04 15:00:00	AAPL	Stock	29.015	29.0338	28.975	29.005	13792536.0
2017-01-04 16:00:00	AAPL	Stock	29.005	29.0125	28.985	29.0075	8313252.0
2017-01-04 17:00:00	AAPL	Stock	29.0075	29.0075	29.0025	29.0075	4484.0
2017-01-04 18:00:00	AAPL	Stock	29.0	29.0075	29.0	29.0075	8360.0
2017-01-04 19:00:00	AAPL	Stock	29.0	29.0025	28.9925	29.0	13496.0
2017-01-04 04:00:00	MSFT	Stock	62.67	62.67	62.5	62.5	862.0
2017-01-04 07:00:00	MSFT	Stock	62.6	62.6	62.6	62.6	223.0
2017-01-04 08:00:00	MSFT	Stock	62.6	62.6	62.6	62.6	1386.0
2017-01-04 09:00:00	MSFT	Stock	62.6	62.75	62.24	62.245	2537918.0
2017-01-04 10:00:00	MSFT	Stock	62.24	62.37	62.15	62.35	2289008.0
2017-01-04 11:00:00	MSFT	Stock	62.35	62.39	62.2	62.21	1596987.0
2017-01-04 12:00:00	MSFT	Stock	62.22	62.28	62.12	62.19	1712245.0
2017-01-04 13:00:00	MSFT	Stock	62.192	62.31	62.16	62.21	1688372.0
2017-01-04 14:00:00	MSFT	Stock	62.21	62.5	62.19	62.38	1792155.0
2017-01-04 15:00:00	MSFT	Stock	62.37	62.445	62.23	62.3	3819557.0
2017-01-04 16:00:00	MSFT	Stock	62.3	62.3	62.14	62.3	3121918.0
2017-01-04 17:00:00	MSFT	Stock	62.3	62.3	62.3	62.3	21980.0
2017-01-04 18:00:00	MSFT	Stock	62.3	62.3	62.3	62.3	100.0
2017-01-04 04:00:00	NVDA	Stock	2.555	2.5745	2.55	2.5725	108000.0
2017-01-04 05:00:00	NVDA	Stock	2.5725	2.5725	2.5725	2.5725	10400.0
2017-01-04 06:00:00	NVDA	Stock	2.55	2.55	2.55	2.55	6000.0
2017-01-04 07:00:00	NVDA	Stock	2.5698	2.5712	2.5398	2.57	649000.0
2017-01-04 08:00:00	NVDA	Stock	2.545	2.592	2.5413	2.5862	3939480.0
2017-01-04 09:00:00	NVDA	Stock	2.585	2.6375	2.566	2.5735	208723560.0
2017-01-04 10:00:00	NVDA	Stock	2.5738	2.5862	2.551	2.5565	199551440.0
2017-01-04 11:00:00	NVDA	Stock	2.5563	2.5845	2.5382	2.5733	165667600.0
2017-01-04 12:00:00	NVDA	Stock	2.5733	2.613	2.5658	2.6111	145305480.0
2017-01-04 13:00:00	NVDA	Stock	2.6114	2.6223	2.6015	2.6115	98827920.0
2017-01-04 14:00:00	NVDA	Stock	2.6115	2.619	2.594	2.6085	113116640.0
2017-01-04 15:00:00	NVDA	Stock	2.6082	2.6175	2.5985	2.6098	153078160.0
2017-01-04 16:00:00	NVDA	Stock	2.6098	2.616	2.6062	2.6148	70649400.0
2017-01-04 17:00:00	NVDA	Stock	2.616	2.6235	2.6138	2.62	1035560.0
2017-01-04 18:00:00	NVDA	Stock	2.6235	2.624	2.6188	2.62	440480.0
2017-01-04 19:00:00	NVDA	Stock	2.62	2.6233	2.6175	2.62	458760.0
2017-01-04 07:00:00	AMZN	Stock	37.8	37.8475	37.8	37.8125	48200.0
2017-01-04 08:00:00	AMZN	Stock	37.8	37.8	37.75	37.8	69540.0
2017-01-04 09:00:00	AMZN	Stock	37.8245	37.984	37.7735	37.7935	7198380.0
2017-01-04 10:00:00	AMZN	Stock	37.794	37.857	37.71	37.8415	6622440.0
2017-01-04 11:00:00	AMZN	Stock	37.85	37.8985	37.8005	37.8575	5106320.0
2017-01-04 12:00:00	AMZN	Stock	37.86	37.909	37.8	37.8688	3846800.0

> showing 50 of 51,252 rows — these rows as CSV

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