PREVIEW / stock_1hour / 2016-06-23

all stock 1-hour files

  file:    by_date/stock_1hour/2016/2016-06-23.parquet
  size:    1.0 MB
  rows:    49,342
  symbols: 3,290

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-06-23 04:00:00	AAPL	Stock	23.9875	23.9875	23.9875	23.9875	3484.0
2016-06-23 05:00:00	AAPL	Stock	24.0125	24.095	24.0125	24.0775	6956.0
2016-06-23 06:00:00	AAPL	Stock	24.1	24.12	24.0875	24.095	8112.0
2016-06-23 07:00:00	AAPL	Stock	24.05	24.05	24.015	24.0375	26092.0
2016-06-23 08:00:00	AAPL	Stock	24.02	24.07	23.975	24.0025	276936.0
2016-06-23 09:00:00	AAPL	Stock	24.0075	24.025	23.8125	23.9225	19769844.0
2016-06-23 10:00:00	AAPL	Stock	23.9212	24.0	23.9025	23.985	19917488.0
2016-06-23 11:00:00	AAPL	Stock	23.9862	24.0	23.9	23.9372	14461600.0
2016-06-23 12:00:00	AAPL	Stock	23.9375	23.9525	23.905	23.93	8305876.0
2016-06-23 13:00:00	AAPL	Stock	23.93	23.945	23.9025	23.945	7918404.0
2016-06-23 14:00:00	AAPL	Stock	23.945	23.9525	23.875	23.8825	11267092.0
2016-06-23 15:00:00	AAPL	Stock	23.8825	24.0725	23.8475	24.0225	25116960.0
2016-06-23 16:00:00	AAPL	Stock	24.025	24.1125	23.904	24.075	12413348.0
2016-06-23 17:00:00	AAPL	Stock	24.05	24.125	24.025	24.1	372328.0
2016-06-23 18:00:00	AAPL	Stock	24.105	24.145	24.0875	24.0875	166628.0
2016-06-23 19:00:00	AAPL	Stock	24.0875	24.1125	23.925	23.9875	216552.0
2016-06-23 05:00:00	MSFT	Stock	51.39	51.59	51.39	51.59	1000.0
2016-06-23 06:00:00	MSFT	Stock	51.26	51.45	51.25	51.45	2190.0
2016-06-23 07:00:00	MSFT	Stock	51.27	51.35	51.27	51.35	2200.0
2016-06-23 08:00:00	MSFT	Stock	51.25	51.43	51.1	51.34	26959.0
2016-06-23 09:00:00	MSFT	Stock	51.37	51.49	51.15	51.48	3064714.0
2016-06-23 10:00:00	MSFT	Stock	51.48	51.86	51.4	51.82	3810972.0
2016-06-23 11:00:00	MSFT	Stock	51.805	52.06	51.8	52.0	3381615.0
2016-06-23 12:00:00	MSFT	Stock	51.996	52.05	51.89	51.95	2012814.0
2016-06-23 13:00:00	MSFT	Stock	51.95	51.97	51.84	51.88	2254284.0
2016-06-23 14:00:00	MSFT	Stock	51.88	51.89	51.74	51.79	2711109.0
2016-06-23 15:00:00	MSFT	Stock	51.795	51.94	51.7	51.9	6355591.0
2016-06-23 16:00:00	MSFT	Stock	51.91	52.0	51.74	51.99	3633986.0
2016-06-23 17:00:00	MSFT	Stock	51.91	52.1	51.91	52.09	9261.0
2016-06-23 18:00:00	MSFT	Stock	52.14	52.24	52.06	52.06	5318.0
2016-06-23 19:00:00	MSFT	Stock	52.06	52.15	51.69	51.8	9204.0
2016-06-23 05:00:00	NVDA	Stock	1.1912	1.1912	1.1912	1.1912	20000.0
2016-06-23 06:00:00	NVDA	Stock	1.19	1.19	1.19	1.19	16000.0
2016-06-23 08:00:00	NVDA	Stock	1.1912	1.1948	1.1912	1.1925	182320.0
2016-06-23 09:00:00	NVDA	Stock	1.1925	1.201	1.1912	1.201	28794560.0
2016-06-23 10:00:00	NVDA	Stock	1.201	1.2111	1.2005	1.2102	41590720.0
2016-06-23 11:00:00	NVDA	Stock	1.2102	1.2135	1.209	1.2108	33046360.0
2016-06-23 12:00:00	NVDA	Stock	1.211	1.2125	1.2095	1.2111	23804280.0
2016-06-23 13:00:00	NVDA	Stock	1.211	1.2125	1.205	1.2053	29904000.0
2016-06-23 14:00:00	NVDA	Stock	1.205	1.2101	1.2025	1.2088	51777200.0
2016-06-23 15:00:00	NVDA	Stock	1.2085	1.2128	1.2078	1.2122	56427000.0
2016-06-23 16:00:00	NVDA	Stock	1.2122	1.2138	1.2041	1.2125	12819360.0
2016-06-23 18:00:00	NVDA	Stock	1.215	1.215	1.215	1.215	40000.0
2016-06-23 19:00:00	NVDA	Stock	1.2155	1.2155	1.21	1.2122	295400.0
2016-06-23 05:00:00	AMZN	Stock	35.8345	35.8345	35.8345	35.8345	2000.0
2016-06-23 07:00:00	AMZN	Stock	35.85	35.875	35.7255	35.75	38900.0
2016-06-23 08:00:00	AMZN	Stock	35.754	35.7755	35.725	35.76	76940.0
2016-06-23 09:00:00	AMZN	Stock	35.785	35.8545	35.625	35.8533	8309600.0
2016-06-23 10:00:00	AMZN	Stock	35.856	36.032	35.836	35.9655	12984200.0
2016-06-23 11:00:00	AMZN	Stock	35.9565	35.996	35.906	35.973	4961340.0

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

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