PREVIEW / stock_1hour / 2017-08-21

all stock 1-hour files

  file:    by_date/stock_1hour/2017/2017-08-21.parquet
  size:    1.0 MB
  rows:    47,407
  symbols: 2,969

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-08-21 04:00:00	AAPL	Stock	39.3625	39.3625	39.2875	39.3	5320.0
2017-08-21 05:00:00	AAPL	Stock	39.325	39.3675	39.325	39.35	2600.0
2017-08-21 06:00:00	AAPL	Stock	39.35	39.44	39.3425	39.4175	23484.0
2017-08-21 07:00:00	AAPL	Stock	39.425	39.4625	39.415	39.4375	41960.0
2017-08-21 08:00:00	AAPL	Stock	39.4175	39.46	39.3875	39.425	194772.0
2017-08-21 09:00:00	AAPL	Stock	39.4225	39.4725	39.2175	39.2242	12372084.0
2017-08-21 10:00:00	AAPL	Stock	39.2225	39.2675	38.7775	38.955	24706344.0
2017-08-21 11:00:00	AAPL	Stock	38.955	39.3225	38.8575	39.2325	13209124.0
2017-08-21 12:00:00	AAPL	Stock	39.2325	39.3625	39.195	39.3025	7811688.0
2017-08-21 13:00:00	AAPL	Stock	39.3025	39.32	39.1325	39.1425	6838384.0
2017-08-21 14:00:00	AAPL	Stock	39.1475	39.2075	39.1175	39.1845	5319488.0
2017-08-21 15:00:00	AAPL	Stock	39.1825	39.3525	39.03	39.29	14672280.0
2017-08-21 16:00:00	AAPL	Stock	39.2925	39.3025	39.28	39.3	9224576.0
2017-08-21 17:00:00	AAPL	Stock	39.2775	39.29	39.25	39.29	78852.0
2017-08-21 18:00:00	AAPL	Stock	39.29	39.3025	39.285	39.3025	88140.0
2017-08-21 19:00:00	AAPL	Stock	39.3	39.305	39.2725	39.3	12400.0
2017-08-21 06:00:00	MSFT	Stock	72.45	72.45	72.45	72.45	100.0
2017-08-21 08:00:00	MSFT	Stock	72.5	72.5	72.5	72.5	650.0
2017-08-21 09:00:00	MSFT	Stock	72.58	72.58	72.055	72.083	1507445.0
2017-08-21 10:00:00	MSFT	Stock	72.07	72.14	71.79	71.84	2488424.0
2017-08-21 11:00:00	MSFT	Stock	71.83	72.29	71.75	72.11	2084642.0
2017-08-21 12:00:00	MSFT	Stock	72.11	72.35	72.085	72.121	1490295.0
2017-08-21 13:00:00	MSFT	Stock	72.12	72.15	71.934	71.98	1105544.0
2017-08-21 14:00:00	MSFT	Stock	71.975	72.05	71.855	71.935	1442325.0
2017-08-21 15:00:00	MSFT	Stock	71.93	72.21	71.7	72.14	3419523.0
2017-08-21 16:00:00	MSFT	Stock	72.15	72.25	72.05	72.16	2703869.0
2017-08-21 18:00:00	MSFT	Stock	72.16	72.16	72.15	72.15	20972.0
2017-08-21 19:00:00	MSFT	Stock	72.25	72.25	72.25	72.25	348.0
2017-08-21 06:00:00	NVDA	Stock	4.035	4.035	4.035	4.035	17520.0
2017-08-21 07:00:00	NVDA	Stock	4.0572	4.0575	4.05	4.0575	93440.0
2017-08-21 08:00:00	NVDA	Stock	4.05	4.0745	4.045	4.055	2193640.0
2017-08-21 09:00:00	NVDA	Stock	4.0518	4.0737	4.0205	4.0266	76746320.0
2017-08-21 10:00:00	NVDA	Stock	4.0255	4.0273	3.9343	3.97	186600520.0
2017-08-21 11:00:00	NVDA	Stock	3.9705	4.015	3.9382	4.0055	112356040.0
2017-08-21 12:00:00	NVDA	Stock	4.0035	4.0125	3.988	3.9948	50879640.0
2017-08-21 13:00:00	NVDA	Stock	3.995	3.9985	3.9702	3.9798	34956920.0
2017-08-21 14:00:00	NVDA	Stock	3.98	3.9855	3.9678	3.9747	31177720.0
2017-08-21 15:00:00	NVDA	Stock	3.9745	3.9822	3.9545	3.9785	74583480.0
2017-08-21 16:00:00	NVDA	Stock	3.9788	3.9788	3.9532	3.965	7945960.0
2017-08-21 17:00:00	NVDA	Stock	3.9655	3.9722	3.965	3.9722	422640.0
2017-08-21 18:00:00	NVDA	Stock	3.9702	3.9788	3.9688	3.9688	511840.0
2017-08-21 19:00:00	NVDA	Stock	3.9688	3.9722	3.9663	3.972	257440.0
2017-08-21 05:00:00	AMZN	Stock	47.892	47.9	47.892	47.9	4000.0
2017-08-21 07:00:00	AMZN	Stock	47.9675	48.0195	47.9665	48.0195	25960.0
2017-08-21 08:00:00	AMZN	Stock	48.0245	48.0245	47.93	47.9655	60280.0
2017-08-21 09:00:00	AMZN	Stock	47.97	48.06	47.7	47.7954	7853080.0
2017-08-21 10:00:00	AMZN	Stock	47.8145	47.8145	47.273	47.4265	15876540.0
2017-08-21 11:00:00	AMZN	Stock	47.445	47.7415	47.351	47.6085	6841460.0
2017-08-21 12:00:00	AMZN	Stock	47.6132	47.706	47.535	47.6177	3079580.0
2017-08-21 13:00:00	AMZN	Stock	47.6245	47.6275	47.5252	47.5345	3389740.0

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

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