PREVIEW / stock_1hour / 2017-07-12

all stock 1-hour files

  file:    by_date/stock_1hour/2017/2017-07-12.parquet
  size:    1.0 MB
  rows:    48,107
  symbols: 3,007

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-07-12 05:00:00	AAPL	Stock	36.45	36.5	36.4425	36.5	7504.0
2017-07-12 06:00:00	AAPL	Stock	36.4875	36.4925	36.465	36.465	29796.0
2017-07-12 07:00:00	AAPL	Stock	36.4625	36.5375	36.45	36.4625	160460.0
2017-07-12 08:00:00	AAPL	Stock	36.45	36.57	36.3975	36.53	402484.0
2017-07-12 09:00:00	AAPL	Stock	36.53	36.5475	36.24	36.3225	16917656.0
2017-07-12 10:00:00	AAPL	Stock	36.325	36.38	36.205	36.2262	16304600.0
2017-07-12 11:00:00	AAPL	Stock	36.2262	36.395	36.225	36.295	8862356.0
2017-07-12 12:00:00	AAPL	Stock	36.2955	36.3225	36.2425	36.315	6773236.0
2017-07-12 13:00:00	AAPL	Stock	36.3152	36.4	36.2525	36.3962	6288432.0
2017-07-12 14:00:00	AAPL	Stock	36.3975	36.4775	36.3525	36.4688	7233400.0
2017-07-12 15:00:00	AAPL	Stock	36.47	36.515	36.4225	36.4425	15150488.0
2017-07-12 16:00:00	AAPL	Stock	36.435	36.47	36.35	36.375	6482372.0
2017-07-12 17:00:00	AAPL	Stock	36.375	36.435	36.3475	36.35	132520.0
2017-07-12 18:00:00	AAPL	Stock	36.35	36.375	36.35	36.3675	20300.0
2017-07-12 19:00:00	AAPL	Stock	36.375	36.375	36.3525	36.3625	36600.0
2017-07-12 08:00:00	MSFT	Stock	70.55	70.55	70.11	70.38	5570.0
2017-07-12 09:00:00	MSFT	Stock	70.58	70.86	70.55	70.81	2106213.0
2017-07-12 10:00:00	MSFT	Stock	70.81	70.98	70.74	70.87	2371007.0
2017-07-12 11:00:00	MSFT	Stock	70.86	71.03	70.84	70.885	1734440.0
2017-07-12 12:00:00	MSFT	Stock	70.89	71.04	70.82	70.88	1334430.0
2017-07-12 13:00:00	MSFT	Stock	70.88	70.971	70.81	70.955	1101588.0
2017-07-12 14:00:00	MSFT	Stock	70.95	71.04	70.83	70.995	1254108.0
2017-07-12 15:00:00	MSFT	Stock	70.99	71.28	70.97	71.15	4357455.0
2017-07-12 16:00:00	MSFT	Stock	71.15	71.16	71.09	71.15	1959695.0
2017-07-12 17:00:00	MSFT	Stock	71.24	71.24	71.24	71.24	200.0
2017-07-12 18:00:00	MSFT	Stock	71.12	71.25	71.12	71.25	2108.0
2017-07-12 19:00:00	MSFT	Stock	71.25	71.25	71.16	71.17	1000.0
2017-07-12 04:00:00	NVDA	Stock	3.9255	3.9562	3.9255	3.9425	531280.0
2017-07-12 05:00:00	NVDA	Stock	3.9388	3.9425	3.9325	3.9412	591520.0
2017-07-12 06:00:00	NVDA	Stock	3.941	3.9488	3.94	3.94	510440.0
2017-07-12 07:00:00	NVDA	Stock	3.9412	3.9418	3.9188	3.9265	2006160.0
2017-07-12 08:00:00	NVDA	Stock	3.9238	3.9468	3.9188	3.9412	7724200.0
2017-07-12 09:00:00	NVDA	Stock	3.938	3.9675	3.914	3.925	174858000.0
2017-07-12 10:00:00	NVDA	Stock	3.9255	3.9915	3.9238	3.9883	193425680.0
2017-07-12 11:00:00	NVDA	Stock	3.9882	4.0338	3.9858	4.0325	182570400.0
2017-07-12 12:00:00	NVDA	Stock	4.0329	4.0392	4.013	4.0298	134459080.0
2017-07-12 13:00:00	NVDA	Stock	4.0306	4.0486	4.0248	4.0447	98893440.0
2017-07-12 14:00:00	NVDA	Stock	4.0448	4.0612	4.0415	4.0588	109103680.0
2017-07-12 15:00:00	NVDA	Stock	4.0582	4.075	4.0538	4.0635	168793040.0
2017-07-12 16:00:00	NVDA	Stock	4.0628	4.0712	4.0618	4.07	7566400.0
2017-07-12 17:00:00	NVDA	Stock	4.071	4.0748	4.0628	4.074	1306320.0
2017-07-12 18:00:00	NVDA	Stock	4.0748	4.0875	4.0728	4.0842	2344720.0
2017-07-12 19:00:00	NVDA	Stock	4.085	4.0913	4.0825	4.0825	2353960.0
2017-07-12 04:00:00	AMZN	Stock	49.7995	49.8215	49.7995	49.8215	5340.0
2017-07-12 07:00:00	AMZN	Stock	49.825	49.875	49.8225	49.8225	46700.0
2017-07-12 08:00:00	AMZN	Stock	49.8875	50.1375	49.777	50.1375	322040.0
2017-07-12 09:00:00	AMZN	Stock	50.1125	50.2375	49.905	50.0315	12670100.0
2017-07-12 10:00:00	AMZN	Stock	50.0235	50.165	49.9565	50.029	8243980.0
2017-07-12 11:00:00	AMZN	Stock	50.0265	50.2	50.0185	50.1635	6081420.0
2017-07-12 12:00:00	AMZN	Stock	50.175	50.2495	50.1375	50.2315	5102860.0

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

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