PREVIEW / stock_1hour / 2016-04-11

all stock 1-hour files

  file:    by_date/stock_1hour/2016/2016-04-11.parquet
  size:    1.0 MB
  rows:    48,289
  symbols: 3,327

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
2016-04-11 04:00:00	AAPL	Stock	27.165	27.3425	27.165	27.3425	2400.0
2016-04-11 05:00:00	AAPL	Stock	27.2775	27.3375	27.2775	27.3375	7616.0
2016-04-11 06:00:00	AAPL	Stock	27.2875	27.31	27.2875	27.31	7600.0
2016-04-11 07:00:00	AAPL	Stock	27.2625	27.3075	27.2625	27.295	69008.0
2016-04-11 08:00:00	AAPL	Stock	27.295	27.3	27.25	27.2925	262736.0
2016-04-11 09:00:00	AAPL	Stock	27.165	27.61	27.165	27.5925	20136676.0
2016-04-11 10:00:00	AAPL	Stock	27.5925	27.6525	27.505	27.51	20490796.0
2016-04-11 11:00:00	AAPL	Stock	27.5078	27.5825	27.395	27.485	13713392.0
2016-04-11 12:00:00	AAPL	Stock	27.485	27.545	27.4225	27.5325	7244632.0
2016-04-11 13:00:00	AAPL	Stock	27.5325	27.5575	27.43	27.4475	7416484.0
2016-04-11 14:00:00	AAPL	Stock	27.4462	27.525	27.4025	27.5175	8277884.0
2016-04-11 15:00:00	AAPL	Stock	27.5175	27.52	27.25	27.2575	17839508.0
2016-04-11 16:00:00	AAPL	Stock	27.255	27.4785	27.23	27.2475	10781036.0
2016-04-11 17:00:00	AAPL	Stock	27.2375	27.245	27.2075	27.215	53440.0
2016-04-11 18:00:00	AAPL	Stock	27.2125	27.215	27.1975	27.2025	54380.0
2016-04-11 19:00:00	AAPL	Stock	27.2	27.2025	27.0375	27.175	76212.0
2016-04-11 06:00:00	MSFT	Stock	54.52	54.52	54.51	54.52	9980.0
2016-04-11 07:00:00	MSFT	Stock	54.58	54.58	54.55	54.55	300.0
2016-04-11 08:00:00	MSFT	Stock	54.58	54.58	54.51	54.58	9860.0
2016-04-11 09:00:00	MSFT	Stock	54.42	54.97	54.42	54.94	2396477.0
2016-04-11 10:00:00	MSFT	Stock	54.95	55.09	54.74	54.75	2530730.0
2016-04-11 11:00:00	MSFT	Stock	54.75	54.87	54.62	54.78	2535306.0
2016-04-11 12:00:00	MSFT	Stock	54.775	55.15	54.71	55.11	2008661.0
2016-04-11 13:00:00	MSFT	Stock	55.1	55.15	54.94	54.97	1872333.0
2016-04-11 14:00:00	MSFT	Stock	54.97	55.04	54.82	55.0	1990940.0
2016-04-11 15:00:00	MSFT	Stock	54.995	54.995	54.3	54.31	4561923.0
2016-04-11 16:00:00	MSFT	Stock	54.31	54.34	54.29	54.3	1967698.0
2016-04-11 17:00:00	MSFT	Stock	54.31	54.31	54.31	54.31	900.0
2016-04-11 18:00:00	MSFT	Stock	54.31	54.31	54.21	54.29	1530.0
2016-04-11 19:00:00	MSFT	Stock	54.29	54.29	54.25	54.29	800.0
2016-04-11 08:00:00	NVDA	Stock	0.895	0.895	0.895	0.895	40000.0
2016-04-11 09:00:00	NVDA	Stock	0.8995	0.905	0.894	0.904	26086800.0
2016-04-11 10:00:00	NVDA	Stock	0.9043	0.9118	0.9028	0.9095	59581960.0
2016-04-11 11:00:00	NVDA	Stock	0.9095	0.9095	0.8958	0.9008	52557640.0
2016-04-11 12:00:00	NVDA	Stock	0.901	0.9043	0.8982	0.9038	39268120.0
2016-04-11 13:00:00	NVDA	Stock	0.9038	0.9056	0.8986	0.8998	46231640.0
2016-04-11 14:00:00	NVDA	Stock	0.8996	0.9015	0.8975	0.9002	42161480.0
2016-04-11 15:00:00	NVDA	Stock	0.9005	0.9007	0.8943	0.8968	64306000.0
2016-04-11 16:00:00	NVDA	Stock	0.897	0.8973	0.897	0.8973	37554080.0
2016-04-11 19:00:00	NVDA	Stock	0.895	0.895	0.888	0.888	86000.0
2016-04-11 06:00:00	AMZN	Stock	29.835	29.835	29.835	29.835	2000.0
2016-04-11 07:00:00	AMZN	Stock	29.801	29.801	29.801	29.801	4000.0
2016-04-11 08:00:00	AMZN	Stock	29.8392	29.875	29.8	29.875	40800.0
2016-04-11 09:00:00	AMZN	Stock	29.8695	29.96	29.7455	29.867	5097440.0
2016-04-11 10:00:00	AMZN	Stock	29.895	30.1425	29.85	30.013	9883980.0
2016-04-11 11:00:00	AMZN	Stock	30.007	30.11	29.9138	30.001	3552340.0
2016-04-11 12:00:00	AMZN	Stock	30.0079	30.1245	29.954	30.1135	4002680.0
2016-04-11 13:00:00	AMZN	Stock	30.1176	30.2	30.0705	30.1627	8004480.0
2016-04-11 14:00:00	AMZN	Stock	30.1715	30.185	29.9785	30.051	4610920.0
2016-04-11 15:00:00	AMZN	Stock	30.06	30.06	29.7895	29.796	9558680.0

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

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