PREVIEW / stock_1hour / 2016-09-26

all stock 1-hour files

  file:    by_date/stock_1hour/2016/2016-09-26.parquet
  size:    1.0 MB
  rows:    47,826
  symbols: 3,229

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-09-26 04:00:00	AAPL	Stock	27.8225	27.9225	27.755	27.85	62168.0
2016-09-26 05:00:00	AAPL	Stock	27.875	27.9075	27.84	27.8775	20968.0
2016-09-26 06:00:00	AAPL	Stock	27.8975	27.9625	27.8775	27.93	68288.0
2016-09-26 07:00:00	AAPL	Stock	27.95	28.0375	27.8975	27.975	495332.0
2016-09-26 08:00:00	AAPL	Stock	27.995	28.0125	27.8875	27.9025	644900.0
2016-09-26 09:00:00	AAPL	Stock	27.925	28.32	27.8625	28.27	27769164.0
2016-09-26 10:00:00	AAPL	Stock	28.2675	28.3475	28.2102	28.2575	18995672.0
2016-09-26 11:00:00	AAPL	Stock	28.2575	28.28	28.19	28.2375	10498732.0
2016-09-26 12:00:00	AAPL	Stock	28.2375	28.2732	28.215	28.2175	6935904.0
2016-09-26 13:00:00	AAPL	Stock	28.22	28.25	28.2	28.25	7993944.0
2016-09-26 14:00:00	AAPL	Stock	28.25	28.2625	28.2	28.2125	8244260.0
2016-09-26 15:00:00	AAPL	Stock	28.2112	28.2975	28.195	28.2175	17886144.0
2016-09-26 16:00:00	AAPL	Stock	28.22	28.2625	28.205	28.215	11171952.0
2016-09-26 17:00:00	AAPL	Stock	28.215	28.23	28.2075	28.23	26060.0
2016-09-26 18:00:00	AAPL	Stock	28.23	28.2575	28.215	28.24	105180.0
2016-09-26 19:00:00	AAPL	Stock	28.24	28.24	28.22	28.2325	91208.0
2016-09-26 04:00:00	MSFT	Stock	57.29	57.29	57.29	57.29	600.0
2016-09-26 07:00:00	MSFT	Stock	57.16	57.16	57.16	57.16	100.0
2016-09-26 08:00:00	MSFT	Stock	57.42	57.42	57.0	57.2	1881.0
2016-09-26 09:00:00	MSFT	Stock	57.28	57.28	56.83	56.91	2419685.0
2016-09-26 10:00:00	MSFT	Stock	56.92	57.05	56.85	56.995	2576398.0
2016-09-26 11:00:00	MSFT	Stock	57.0	57.02	56.84	56.9	2167459.0
2016-09-26 12:00:00	MSFT	Stock	56.904	57.03	56.85	57.0	2051330.0
2016-09-26 13:00:00	MSFT	Stock	57.0	57.05	56.95	57.03	1497274.0
2016-09-26 14:00:00	MSFT	Stock	57.035	57.1	56.945	56.96	1317076.0
2016-09-26 15:00:00	MSFT	Stock	56.95	57.1	56.88	56.92	4626202.0
2016-09-26 16:00:00	MSFT	Stock	56.9	57.02	56.86	56.99	3189149.0
2016-09-26 17:00:00	MSFT	Stock	56.9	56.99	56.9	56.96	4377.0
2016-09-26 18:00:00	MSFT	Stock	56.95	56.95	56.95	56.95	1000.0
2016-09-26 19:00:00	MSFT	Stock	56.9	56.9	56.9	56.9	923.0
2016-09-26 07:00:00	NVDA	Stock	1.6175	1.6175	1.6175	1.6175	4800.0
2016-09-26 08:00:00	NVDA	Stock	1.6175	1.6175	1.6125	1.6125	148000.0
2016-09-26 09:00:00	NVDA	Stock	1.615	1.62	1.5883	1.597	48116040.0
2016-09-26 10:00:00	NVDA	Stock	1.5972	1.6115	1.5955	1.6076	45067360.0
2016-09-26 11:00:00	NVDA	Stock	1.6078	1.6125	1.6055	1.6122	21415080.0
2016-09-26 12:00:00	NVDA	Stock	1.6125	1.615	1.611	1.613	14825000.0
2016-09-26 13:00:00	NVDA	Stock	1.613	1.6131	1.6065	1.6104	15284880.0
2016-09-26 14:00:00	NVDA	Stock	1.6102	1.6132	1.6094	1.6118	15561160.0
2016-09-26 15:00:00	NVDA	Stock	1.6115	1.6145	1.6076	1.6085	43020840.0
2016-09-26 16:00:00	NVDA	Stock	1.6095	1.6102	1.6045	1.6063	5519800.0
2016-09-26 17:00:00	NVDA	Stock	1.6055	1.6075	1.6025	1.605	134000.0
2016-09-26 18:00:00	NVDA	Stock	1.6075	1.6125	1.6075	1.6075	36000.0
2016-09-26 19:00:00	NVDA	Stock	1.6025	1.6028	1.6025	1.6028	100000.0
2016-09-26 04:00:00	AMZN	Stock	40.1475	40.1475	39.997	40.0	19000.0
2016-09-26 05:00:00	AMZN	Stock	39.975	39.975	39.975	39.975	2000.0
2016-09-26 06:00:00	AMZN	Stock	40.0965	40.1	40.0965	40.1	31200.0
2016-09-26 07:00:00	AMZN	Stock	40.055	40.1375	40.055	40.1365	41380.0
2016-09-26 08:00:00	AMZN	Stock	40.1125	40.2	40.1125	40.1175	120780.0
2016-09-26 09:00:00	AMZN	Stock	40.1275	40.14	39.9035	40.0005	8096080.0
2016-09-26 10:00:00	AMZN	Stock	40.014	40.2965	39.99	40.1275	6818020.0

> showing 50 of 47,826 rows — these rows as CSV

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