PREVIEW / stock_1hour / 2015-09-02

all stock 1-hour files

  file:    by_date/stock_1hour/2015/2015-09-02.parquet
  size:    1.0 MB
  rows:    49,340
  symbols: 3,479

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
2015-09-02 04:00:00	AAPL	Stock	27.0925	27.4975	27.0925	27.325	35624.0
2015-09-02 05:00:00	AAPL	Stock	27.325	27.325	27.2	27.275	38112.0
2015-09-02 06:00:00	AAPL	Stock	27.3125	27.4	27.205	27.235	162364.0
2015-09-02 07:00:00	AAPL	Stock	27.235	27.36	27.2075	27.3275	596472.0
2015-09-02 08:00:00	AAPL	Stock	27.25	27.5	27.225	27.475	1770140.0
2015-09-02 09:00:00	AAPL	Stock	27.4675	27.585	27.315	27.495	33527248.0
2015-09-02 10:00:00	AAPL	Stock	27.4852	27.66	27.2828	27.4338	38982764.0
2015-09-02 11:00:00	AAPL	Stock	27.4375	27.575	27.3675	27.4982	24090912.0
2015-09-02 12:00:00	AAPL	Stock	27.5	27.735	27.3625	27.72	21496212.0
2015-09-02 13:00:00	AAPL	Stock	27.7175	27.815	27.625	27.6865	21140636.0
2015-09-02 14:00:00	AAPL	Stock	27.6842	27.88	27.5375	27.7575	28129572.0
2015-09-02 15:00:00	AAPL	Stock	27.755	28.0825	27.625	28.0825	42066756.0
2015-09-02 16:00:00	AAPL	Stock	28.085	28.095	27.4548	28.025	20572752.0
2015-09-02 17:00:00	AAPL	Stock	28.035	28.085	28.0125	28.04	215432.0
2015-09-02 18:00:00	AAPL	Stock	28.0425	28.1975	28.0425	28.15	479556.0
2015-09-02 19:00:00	AAPL	Stock	28.14	28.17	28.11	28.15	212996.0
2015-09-02 04:00:00	MSFT	Stock	42.05	42.49	42.05	42.49	700.0
2015-09-02 05:00:00	MSFT	Stock	42.54	42.54	42.54	42.54	2000.0
2015-09-02 06:00:00	MSFT	Stock	42.3	42.3	42.3	42.3	300.0
2015-09-02 07:00:00	MSFT	Stock	42.28	42.28	42.28	42.28	100.0
2015-09-02 08:00:00	MSFT	Stock	42.28	42.31	42.2	42.28	10408.0
2015-09-02 09:00:00	MSFT	Stock	42.35	42.4	42.06	42.23	4304270.0
2015-09-02 10:00:00	MSFT	Stock	42.22	42.32	41.88	42.31	5811792.0
2015-09-02 11:00:00	MSFT	Stock	42.305	42.73	42.3	42.64	5077292.0
2015-09-02 12:00:00	MSFT	Stock	42.639	42.89	42.5	42.87	3328579.0
2015-09-02 13:00:00	MSFT	Stock	42.86	43.12	42.83	43.01	3688126.0
2015-09-02 14:00:00	MSFT	Stock	43.014	43.12	42.77	42.93	3154886.0
2015-09-02 15:00:00	MSFT	Stock	42.93	43.38	42.72	43.34	6772887.0
2015-09-02 16:00:00	MSFT	Stock	43.36	43.42	41.82	43.25	3824544.0
2015-09-02 17:00:00	MSFT	Stock	43.28	43.35	43.24	43.25	4953.0
2015-09-02 18:00:00	MSFT	Stock	43.28	43.4	43.28	43.36	32700.0
2015-09-02 19:00:00	MSFT	Stock	43.37	43.37	43.29	43.36	1504.0
2015-09-02 08:00:00	NVDA	Stock	0.5495	0.5498	0.5495	0.5495	40000.0
2015-09-02 09:00:00	NVDA	Stock	0.55	0.5538	0.5445	0.55	42608880.0
2015-09-02 10:00:00	NVDA	Stock	0.5498	0.5515	0.546	0.548	32595400.0
2015-09-02 11:00:00	NVDA	Stock	0.548	0.55	0.5465	0.5485	28259600.0
2015-09-02 12:00:00	NVDA	Stock	0.5482	0.5519	0.5462	0.5518	18437760.0
2015-09-02 13:00:00	NVDA	Stock	0.5518	0.553	0.5498	0.5511	19950680.0
2015-09-02 14:00:00	NVDA	Stock	0.551	0.5535	0.55	0.5522	25818920.0
2015-09-02 15:00:00	NVDA	Stock	0.552	0.5555	0.548	0.5555	68747320.0
2015-09-02 16:00:00	NVDA	Stock	0.5552	0.5552	0.5492	0.5543	87393520.0
2015-09-02 17:00:00	NVDA	Stock	0.5555	0.5555	0.5555	0.5555	8000.0
2015-09-02 04:00:00	AMZN	Stock	25.0615	25.232	25.06	25.232	7000.0
2015-09-02 07:00:00	AMZN	Stock	25.1	25.15	25.1	25.15	38980.0
2015-09-02 08:00:00	AMZN	Stock	25.2	25.275	25.125	25.25	225560.0
2015-09-02 09:00:00	AMZN	Stock	25.2745	25.3125	25.1205	25.1548	9358460.0
2015-09-02 10:00:00	AMZN	Stock	25.15	25.2825	24.886	25.0095	8914240.0
2015-09-02 11:00:00	AMZN	Stock	24.999	25.25	24.9565	25.226	8991380.0
2015-09-02 12:00:00	AMZN	Stock	25.226	25.3535	24.9645	25.3255	7974480.0
2015-09-02 13:00:00	AMZN	Stock	25.3325	25.422	25.221	25.247	9506380.0

> showing 50 of 49,340 rows — these rows as CSV

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