PREVIEW / stock_1hour / 2017-01-30

all stock 1-hour files

  file:    by_date/stock_1hour/2017/2017-01-30.parquet
  size:    1.1 MB
  rows:    48,744
  symbols: 3,134

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-30 04:00:00	AAPL	Stock	30.2575	30.2575	30.2325	30.2375	22740.0
2017-01-30 05:00:00	AAPL	Stock	30.25	30.2575	30.25	30.2575	5780.0
2017-01-30 06:00:00	AAPL	Stock	30.2625	30.3	30.2625	30.2675	15288.0
2017-01-30 07:00:00	AAPL	Stock	30.29	30.3	30.2625	30.2975	60196.0
2017-01-30 08:00:00	AAPL	Stock	30.2775	30.425	30.2275	30.265	283508.0
2017-01-30 09:00:00	AAPL	Stock	30.265	30.34	30.165	30.2425	24525512.0
2017-01-30 10:00:00	AAPL	Stock	30.2412	30.2975	30.2275	30.2838	18366784.0
2017-01-30 11:00:00	AAPL	Stock	30.2838	30.325	30.26	30.3125	12990644.0
2017-01-30 12:00:00	AAPL	Stock	30.3135	30.3225	30.28	30.295	9218652.0
2017-01-30 13:00:00	AAPL	Stock	30.2925	30.315	30.275	30.2905	7781992.0
2017-01-30 14:00:00	AAPL	Stock	30.2908	30.3188	30.28	30.3125	8972800.0
2017-01-30 15:00:00	AAPL	Stock	30.3148	30.405	30.2725	30.39	21865624.0
2017-01-30 16:00:00	AAPL	Stock	30.3925	30.4375	30.3138	30.41	8517004.0
2017-01-30 17:00:00	AAPL	Stock	30.41	30.47	30.4075	30.4575	85712.0
2017-01-30 18:00:00	AAPL	Stock	30.45	30.475	30.4375	30.4375	71724.0
2017-01-30 19:00:00	AAPL	Stock	30.44	30.4675	30.4225	30.4625	39460.0
2017-01-30 04:00:00	MSFT	Stock	65.12	65.5	65.12	65.38	6714.0
2017-01-30 05:00:00	MSFT	Stock	65.38	65.38	65.3	65.3	1633.0
2017-01-30 06:00:00	MSFT	Stock	65.41	65.41	65.41	65.41	448.0
2017-01-30 07:00:00	MSFT	Stock	65.4	65.48	65.35	65.43	9515.0
2017-01-30 08:00:00	MSFT	Stock	65.41	65.65	65.35	65.59	40122.0
2017-01-30 09:00:00	MSFT	Stock	65.51	65.79	65.365	65.61	4500087.0
2017-01-30 10:00:00	MSFT	Stock	65.61	65.62	64.87	64.955	4616550.0
2017-01-30 11:00:00	MSFT	Stock	64.96	65.21	64.87	65.17	3753445.0
2017-01-30 12:00:00	MSFT	Stock	65.165	65.19	64.9	64.97	2758558.0
2017-01-30 13:00:00	MSFT	Stock	64.96	65.08	64.9	64.935	2057120.0
2017-01-30 14:00:00	MSFT	Stock	64.935	65.08	64.89	65.007	2207326.0
2017-01-30 15:00:00	MSFT	Stock	65.0	65.13	64.8	65.12	6680124.0
2017-01-30 16:00:00	MSFT	Stock	65.14	65.14	65.04	65.12	2363766.0
2017-01-30 17:00:00	MSFT	Stock	65.1	65.16	65.07	65.13	2051.0
2017-01-30 18:00:00	MSFT	Stock	65.06	65.1	65.06	65.1	1169.0
2017-01-30 19:00:00	MSFT	Stock	65.12	65.13	65.07	65.07	1526.0
2017-01-30 05:00:00	NVDA	Stock	2.7888	2.7888	2.7888	2.7888	6000.0
2017-01-30 07:00:00	NVDA	Stock	2.7762	2.7875	2.7753	2.7755	265760.0
2017-01-30 08:00:00	NVDA	Stock	2.776	2.7888	2.7668	2.775	2278120.0
2017-01-30 09:00:00	NVDA	Stock	2.775	2.7762	2.7088	2.714	106540160.0
2017-01-30 10:00:00	NVDA	Stock	2.7142	2.7278	2.6978	2.7208	106263440.0
2017-01-30 11:00:00	NVDA	Stock	2.7205	2.748	2.718	2.7473	62060640.0
2017-01-30 12:00:00	NVDA	Stock	2.7478	2.7483	2.7383	2.7438	26727720.0
2017-01-30 13:00:00	NVDA	Stock	2.7438	2.7548	2.7415	2.75	45130920.0
2017-01-30 14:00:00	NVDA	Stock	2.75	2.756	2.7413	2.7462	38594600.0
2017-01-30 15:00:00	NVDA	Stock	2.7461	2.751	2.7338	2.7503	65681920.0
2017-01-30 16:00:00	NVDA	Stock	2.7505	2.755	2.7475	2.7525	3431880.0
2017-01-30 17:00:00	NVDA	Stock	2.7525	2.7525	2.7513	2.7513	104320.0
2017-01-30 18:00:00	NVDA	Stock	2.7505	2.7525	2.7483	2.75	224000.0
2017-01-30 19:00:00	NVDA	Stock	2.75	2.7513	2.75	2.75	41600.0
2017-01-30 07:00:00	AMZN	Stock	41.6445	41.6445	41.625	41.625	4000.0
2017-01-30 08:00:00	AMZN	Stock	41.5615	41.6495	41.55	41.56	140960.0
2017-01-30 09:00:00	AMZN	Stock	41.575	41.7115	41.206	41.2495	11538700.0
2017-01-30 10:00:00	AMZN	Stock	41.2576	41.2881	40.819	41.188	20643380.0

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

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