PREVIEW / stock_1hour / 2016-08-05

all stock 1-hour files

  file:    by_date/stock_1hour/2016/2016-08-05.parquet
  size:    1.0 MB
  rows:    48,273
  symbols: 3,257

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-08-05 04:00:00	AAPL	Stock	24.9125	26.5425	24.9125	26.495	9504.0
2016-08-05 05:00:00	AAPL	Stock	26.525	26.525	26.525	26.525	852.0
2016-08-05 06:00:00	AAPL	Stock	26.5	26.5575	26.5	26.54	10940.0
2016-08-05 07:00:00	AAPL	Stock	26.54	26.55	26.49	26.49	52960.0
2016-08-05 08:00:00	AAPL	Stock	26.535	26.6125	26.48	26.6125	399768.0
2016-08-05 09:00:00	AAPL	Stock	26.615	26.76	26.545	26.7475	22401016.0
2016-08-05 10:00:00	AAPL	Stock	26.7475	26.8612	26.7448	26.8388	20447824.0
2016-08-05 11:00:00	AAPL	Stock	26.8375	26.8875	26.8	26.8725	15720728.0
2016-08-05 12:00:00	AAPL	Stock	26.8725	26.91	26.86	26.8825	10624736.0
2016-08-05 13:00:00	AAPL	Stock	26.8838	26.9125	26.8775	26.91	12575608.0
2016-08-05 14:00:00	AAPL	Stock	26.91	26.9125	26.8425	26.86	13804212.0
2016-08-05 15:00:00	AAPL	Stock	26.86	26.9	26.84	26.8675	20762240.0
2016-08-05 16:00:00	AAPL	Stock	26.8662	26.8775	26.8325	26.85	18011276.0
2016-08-05 17:00:00	AAPL	Stock	26.87	26.87	26.8425	26.8575	631948.0
2016-08-05 18:00:00	AAPL	Stock	26.86	26.87	26.855	26.86	3841084.0
2016-08-05 19:00:00	AAPL	Stock	26.86	26.885	26.8575	26.8825	146260.0
2016-08-05 08:00:00	MSFT	Stock	57.42	57.65	57.42	57.64	7370.0
2016-08-05 09:00:00	MSFT	Stock	57.64	58.21	57.45	58.04	5025009.0
2016-08-05 10:00:00	MSFT	Stock	58.04	58.11	57.925	57.994	3918070.0
2016-08-05 11:00:00	MSFT	Stock	58.0	58.02	57.88	57.945	2263446.0
2016-08-05 12:00:00	MSFT	Stock	57.945	58.0	57.89	58.0	1514187.0
2016-08-05 13:00:00	MSFT	Stock	58.0	58.01	57.93	57.96	2000417.0
2016-08-05 14:00:00	MSFT	Stock	57.96	57.99	57.88	57.94	2170981.0
2016-08-05 15:00:00	MSFT	Stock	57.94	58.03	57.83	57.95	4764346.0
2016-08-05 16:00:00	MSFT	Stock	57.96	57.99	57.95	57.95	4684705.0
2016-08-05 17:00:00	MSFT	Stock	57.97	57.99	57.96	57.99	1356.0
2016-08-05 18:00:00	MSFT	Stock	57.96	57.96	57.93	57.93	500200.0
2016-08-05 07:00:00	NVDA	Stock	1.4375	1.4375	1.4375	1.4375	40000.0
2016-08-05 08:00:00	NVDA	Stock	1.4375	1.4488	1.4345	1.445	570800.0
2016-08-05 09:00:00	NVDA	Stock	1.4413	1.4558	1.4413	1.4468	49752920.0
2016-08-05 10:00:00	NVDA	Stock	1.4465	1.4515	1.4402	1.4485	52188360.0
2016-08-05 11:00:00	NVDA	Stock	1.4485	1.4489	1.443	1.4431	25904680.0
2016-08-05 12:00:00	NVDA	Stock	1.4432	1.4507	1.4432	1.45	23604120.0
2016-08-05 13:00:00	NVDA	Stock	1.45	1.4558	1.4498	1.4554	32487040.0
2016-08-05 14:00:00	NVDA	Stock	1.4555	1.4555	1.452	1.4527	23351280.0
2016-08-05 15:00:00	NVDA	Stock	1.4527	1.455	1.4505	1.455	58696920.0
2016-08-05 16:00:00	NVDA	Stock	1.455	1.455	1.4508	1.455	49372200.0
2016-08-05 17:00:00	NVDA	Stock	1.4528	1.455	1.4528	1.455	26000.0
2016-08-05 18:00:00	NVDA	Stock	1.4528	1.455	1.4528	1.453	21800.0
2016-08-05 19:00:00	NVDA	Stock	1.4533	1.4548	1.4533	1.4548	42480.0
2016-08-05 06:00:00	AMZN	Stock	38.2145	38.2145	38.2145	38.2145	5700.0
2016-08-05 07:00:00	AMZN	Stock	38.21	38.219	38.2	38.219	16020.0
2016-08-05 08:00:00	AMZN	Stock	38.176	38.225	38.06	38.2	572380.0
2016-08-05 09:00:00	AMZN	Stock	38.1985	38.382	38.1545	38.3725	9354440.0
2016-08-05 10:00:00	AMZN	Stock	38.3725	38.4085	38.31	38.3899	6944840.0
2016-08-05 11:00:00	AMZN	Stock	38.3845	38.4235	38.335	38.378	4358020.0
2016-08-05 12:00:00	AMZN	Stock	38.3765	38.416	38.3195	38.325	3720120.0
2016-08-05 13:00:00	AMZN	Stock	38.3225	38.35	38.2675	38.317	4937540.0
2016-08-05 14:00:00	AMZN	Stock	38.321	38.342	38.275	38.2948	4763820.0
2016-08-05 15:00:00	AMZN	Stock	38.291	38.325	38.255	38.293	6345300.0

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

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