PREVIEW / stock_1hour / 2016-04-01

all stock 1-hour files

  file:    by_date/stock_1hour/2016/2016-04-01.parquet
  size:    1.0 MB
  rows:    48,733
  symbols: 3,345

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-01 04:00:00	AAPL	Stock	27.1725	27.1725	27.1	27.15	10400.0
2016-04-01 05:00:00	AAPL	Stock	27.1375	27.1375	27.1375	27.1375	428.0
2016-04-01 06:00:00	AAPL	Stock	27.1175	27.12	27.1125	27.1125	11720.0
2016-04-01 07:00:00	AAPL	Stock	27.13	27.1925	27.13	27.16	52672.0
2016-04-01 08:00:00	AAPL	Stock	27.1725	27.2875	27.1125	27.1875	590552.0
2016-04-01 09:00:00	AAPL	Stock	27.1875	27.2725	27.05	27.1725	15085652.0
2016-04-01 10:00:00	AAPL	Stock	27.1725	27.3975	27.1175	27.3975	16967432.0
2016-04-01 11:00:00	AAPL	Stock	27.3975	27.5	27.35	27.385	14850784.0
2016-04-01 12:00:00	AAPL	Stock	27.3825	27.44	27.3675	27.3975	5893856.0
2016-04-01 13:00:00	AAPL	Stock	27.3988	27.4675	27.3778	27.4212	6059252.0
2016-04-01 14:00:00	AAPL	Stock	27.4225	27.455	27.3825	27.42	7039864.0
2016-04-01 15:00:00	AAPL	Stock	27.42	27.5	27.3775	27.49	16750472.0
2016-04-01 16:00:00	AAPL	Stock	27.4975	27.51	27.2582	27.5	9877256.0
2016-04-01 17:00:00	AAPL	Stock	27.495	27.5	27.4775	27.4975	75248.0
2016-04-01 18:00:00	AAPL	Stock	27.5	27.505	27.49	27.49	26468.0
2016-04-01 19:00:00	AAPL	Stock	27.4975	27.505	27.4825	27.5	19968.0
2016-04-01 04:00:00	MSFT	Stock	55.03	55.03	55.03	55.03	300.0
2016-04-01 07:00:00	MSFT	Stock	55.03	55.03	54.95	54.99	900.0
2016-04-01 08:00:00	MSFT	Stock	55.0	55.23	54.92	55.23	14697.0
2016-04-01 09:00:00	MSFT	Stock	54.95	55.23	54.57	54.84	3185214.0
2016-04-01 10:00:00	MSFT	Stock	54.84	55.36	54.805	55.35	3054223.0
2016-04-01 11:00:00	MSFT	Stock	55.345	55.37	55.06	55.075	2706294.0
2016-04-01 12:00:00	MSFT	Stock	55.075	55.13	54.86	55.11	1724970.0
2016-04-01 13:00:00	MSFT	Stock	55.11	55.38	55.09	55.304	1713726.0
2016-04-01 14:00:00	MSFT	Stock	55.31	55.525	55.28	55.375	1904888.0
2016-04-01 15:00:00	MSFT	Stock	55.38	55.61	55.38	55.57	4123375.0
2016-04-01 16:00:00	MSFT	Stock	55.555	55.59	55.209	55.57	4723938.0
2016-04-01 17:00:00	MSFT	Stock	55.51	55.52	55.5	55.5	1991.0
2016-04-01 18:00:00	MSFT	Stock	55.5	55.5	55.5	55.5	857.0
2016-04-01 19:00:00	MSFT	Stock	55.47	55.48	55.43	55.43	4670.0
2016-04-01 09:00:00	NVDA	Stock	0.8852	0.8943	0.8785	0.8938	30197920.0
2016-04-01 10:00:00	NVDA	Stock	0.894	0.9008	0.8916	0.8984	58801720.0
2016-04-01 11:00:00	NVDA	Stock	0.8982	0.9023	0.8969	0.8995	42620120.0
2016-04-01 12:00:00	NVDA	Stock	0.8992	0.9002	0.8938	0.8966	30601840.0
2016-04-01 13:00:00	NVDA	Stock	0.8964	0.9012	0.8953	0.8998	31208640.0
2016-04-01 14:00:00	NVDA	Stock	0.8995	0.9012	0.8978	0.8995	30325440.0
2016-04-01 15:00:00	NVDA	Stock	0.8994	0.9043	0.8985	0.9038	58438320.0
2016-04-01 16:00:00	NVDA	Stock	0.9038	0.91	0.8983	0.905	53691640.0
2016-04-01 17:00:00	NVDA	Stock	0.904	0.904	0.904	0.904	5200.0
2016-04-01 18:00:00	NVDA	Stock	0.9085	0.909	0.9062	0.9075	106000.0
2016-04-01 19:00:00	NVDA	Stock	0.9062	0.9088	0.9062	0.9088	133320.0
2016-04-01 07:00:00	AMZN	Stock	29.5655	29.575	29.5	29.5	16600.0
2016-04-01 08:00:00	AMZN	Stock	29.55	29.5845	29.439	29.45	396520.0
2016-04-01 09:00:00	AMZN	Stock	29.425	29.68	29.3455	29.6505	7168460.0
2016-04-01 10:00:00	AMZN	Stock	29.6445	29.885	29.603	29.8117	13468280.0
2016-04-01 11:00:00	AMZN	Stock	29.8155	29.906	29.75	29.8505	6603160.0
2016-04-01 12:00:00	AMZN	Stock	29.8534	29.875	29.7795	29.852	2817400.0
2016-04-01 13:00:00	AMZN	Stock	29.8473	29.9	29.812	29.8873	3538320.0
2016-04-01 14:00:00	AMZN	Stock	29.8845	29.9112	29.8555	29.8635	4564320.0
2016-04-01 15:00:00	AMZN	Stock	29.8705	29.9515	29.844	29.925	9861080.0

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

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