PREVIEW / stock_1hour / 2017-05-30

all stock 1-hour files

  file:    by_date/stock_1hour/2017/2017-05-30.parquet
  size:    1.0 MB
  rows:    47,763
  symbols: 3,051

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-05-30 04:00:00	AAPL	Stock	38.4	38.4275	38.35	38.35	10756.0
2017-05-30 05:00:00	AAPL	Stock	38.3425	38.3425	38.31	38.31	2080.0
2017-05-30 06:00:00	AAPL	Stock	38.3325	38.3475	38.3	38.3375	26524.0
2017-05-30 07:00:00	AAPL	Stock	38.3225	38.3225	38.29	38.3	32376.0
2017-05-30 08:00:00	AAPL	Stock	38.305	38.345	38.2875	38.32	199340.0
2017-05-30 09:00:00	AAPL	Stock	38.31	38.5175	38.3075	38.4625	10827372.0
2017-05-30 10:00:00	AAPL	Stock	38.4625	38.48	38.3325	38.425	10470812.0
2017-05-30 11:00:00	AAPL	Stock	38.4225	38.48	38.4225	38.4725	5458160.0
2017-05-30 12:00:00	AAPL	Stock	38.4725	38.6	38.47	38.5925	9418320.0
2017-05-30 13:00:00	AAPL	Stock	38.5925	38.6075	38.495	38.525	6582064.0
2017-05-30 14:00:00	AAPL	Stock	38.525	38.5372	38.4662	38.4775	5424400.0
2017-05-30 15:00:00	AAPL	Stock	38.4785	38.51	38.4062	38.4175	11305708.0
2017-05-30 16:00:00	AAPL	Stock	38.4175	38.511	38.261	38.4075	8778984.0
2017-05-30 17:00:00	AAPL	Stock	38.4125	38.4225	38.405	38.415	11908.0
2017-05-30 18:00:00	AAPL	Stock	38.415	38.42	38.415	38.42	9540.0
2017-05-30 19:00:00	AAPL	Stock	38.4125	38.4175	38.4	38.4	15912.0
2017-05-30 06:00:00	MSFT	Stock	70.06	70.26	70.0	70.0	803.0
2017-05-30 07:00:00	MSFT	Stock	70.15	70.17	69.89	69.95	6800.0
2017-05-30 08:00:00	MSFT	Stock	69.89	70.0	69.89	69.94	7965.0
2017-05-30 09:00:00	MSFT	Stock	69.94	70.09	69.77	70.0	2246202.0
2017-05-30 10:00:00	MSFT	Stock	70.01	70.2	69.93	69.97	2433791.0
2017-05-30 11:00:00	MSFT	Stock	69.97	70.18	69.96	70.15	1615833.0
2017-05-30 12:00:00	MSFT	Stock	70.16	70.32	70.1	70.18	1430504.0
2017-05-30 13:00:00	MSFT	Stock	70.17	70.23	70.08	70.173	1167346.0
2017-05-30 14:00:00	MSFT	Stock	70.175	70.24	70.15	70.21	929336.0
2017-05-30 15:00:00	MSFT	Stock	70.21	70.41	70.19	70.41	3902725.0
2017-05-30 16:00:00	MSFT	Stock	70.4	70.46	70.4	70.4	1399735.0
2017-05-30 17:00:00	MSFT	Stock	70.4	70.4	70.4	70.4	2686.0
2017-05-30 18:00:00	MSFT	Stock	70.4	70.4	70.4	70.4	700.0
2017-05-30 19:00:00	MSFT	Stock	70.4	70.4	70.37	70.4	1571.0
2017-05-30 04:00:00	NVDA	Stock	3.5625	3.5675	3.5625	3.5675	40000.0
2017-05-30 05:00:00	NVDA	Stock	3.5675	3.5675	3.5675	3.5675	25600.0
2017-05-30 06:00:00	NVDA	Stock	3.5638	3.5825	3.5638	3.5638	427680.0
2017-05-30 07:00:00	NVDA	Stock	3.5695	3.5695	3.5525	3.5562	318720.0
2017-05-30 08:00:00	NVDA	Stock	3.555	3.5865	3.5513	3.5825	8643440.0
2017-05-30 09:00:00	NVDA	Stock	3.5835	3.6408	3.5763	3.6058	202650480.0
2017-05-30 10:00:00	NVDA	Stock	3.6058	3.6573	3.591	3.6385	228488240.0
2017-05-30 11:00:00	NVDA	Stock	3.6388	3.649	3.6208	3.6293	104612080.0
2017-05-30 12:00:00	NVDA	Stock	3.6295	3.6403	3.613	3.6217	66925240.0
2017-05-30 13:00:00	NVDA	Stock	3.6222	3.6282	3.6048	3.615	61538960.0
2017-05-30 14:00:00	NVDA	Stock	3.615	3.615	3.588	3.6054	63531360.0
2017-05-30 15:00:00	NVDA	Stock	3.6057	3.6265	3.6	3.6218	109006000.0
2017-05-30 16:00:00	NVDA	Stock	3.6218	3.625	3.6172	3.6215	80507240.0
2017-05-30 17:00:00	NVDA	Stock	3.6215	3.6272	3.6215	3.6272	633040.0
2017-05-30 18:00:00	NVDA	Stock	3.6255	3.635	3.625	3.635	652440.0
2017-05-30 19:00:00	NVDA	Stock	3.6325	3.6388	3.6263	3.6263	1015280.0
2017-05-30 04:00:00	AMZN	Stock	49.9995	49.9995	49.9015	49.9015	34060.0
2017-05-30 05:00:00	AMZN	Stock	49.9605	49.9605	49.9065	49.9065	7800.0
2017-05-30 06:00:00	AMZN	Stock	49.9485	49.9515	49.9165	49.9165	16960.0
2017-05-30 07:00:00	AMZN	Stock	49.9015	49.9015	49.7825	49.7825	101380.0

> showing 50 of 47,763 rows — these rows as CSV

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