PREVIEW / stock_1hour / 2016-08-02

all stock 1-hour files

  file:    by_date/stock_1hour/2016/2016-08-02.parquet
  size:    1.0 MB
  rows:    48,630
  symbols: 3,244

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-02 04:00:00	AAPL	Stock	26.5	26.5	26.375	26.395	13292.0
2016-08-02 05:00:00	AAPL	Stock	26.395	26.395	26.36	26.3875	7200.0
2016-08-02 06:00:00	AAPL	Stock	26.4125	26.4625	26.38	26.4125	37024.0
2016-08-02 07:00:00	AAPL	Stock	26.4125	26.4625	26.4	26.4	115000.0
2016-08-02 08:00:00	AAPL	Stock	26.435	26.455	26.405	26.435	259440.0
2016-08-02 09:00:00	AAPL	Stock	26.4375	26.5175	26.2975	26.335	22126256.0
2016-08-02 10:00:00	AAPL	Stock	26.335	26.3525	26.1275	26.1325	27366212.0
2016-08-02 11:00:00	AAPL	Stock	26.1325	26.1925	26.0625	26.1075	15812424.0
2016-08-02 12:00:00	AAPL	Stock	26.1075	26.5125	26.05	26.0585	10498892.0
2016-08-02 13:00:00	AAPL	Stock	26.06	26.125	26.0	26.105	12864028.0
2016-08-02 14:00:00	AAPL	Stock	26.105	26.1875	26.0725	26.12	11778692.0
2016-08-02 15:00:00	AAPL	Stock	26.12	26.1595	26.0975	26.1175	15443236.0
2016-08-02 16:00:00	AAPL	Stock	26.1175	26.175	26.0925	26.12	6125176.0
2016-08-02 17:00:00	AAPL	Stock	26.1225	26.1275	26.1175	26.125	107220.0
2016-08-02 18:00:00	AAPL	Stock	26.1225	26.13	26.1075	26.1075	90224.0
2016-08-02 19:00:00	AAPL	Stock	26.1175	26.1175	26.1	26.1025	24624.0
2016-08-02 06:00:00	MSFT	Stock	56.19	56.38	55.93	56.38	2298.0
2016-08-02 07:00:00	MSFT	Stock	56.45	56.55	56.45	56.55	1098.0
2016-08-02 08:00:00	MSFT	Stock	56.46	56.71	56.46	56.64	6844.0
2016-08-02 09:00:00	MSFT	Stock	56.65	56.9	56.58	56.75	5122811.0
2016-08-02 10:00:00	MSFT	Stock	56.755	56.81	56.34	56.41	6563644.0
2016-08-02 11:00:00	MSFT	Stock	56.4	56.605	56.32	56.505	3522565.0
2016-08-02 12:00:00	MSFT	Stock	56.505	56.67	56.493	56.559	3058060.0
2016-08-02 13:00:00	MSFT	Stock	56.55	56.57	56.31	56.505	3889118.0
2016-08-02 14:00:00	MSFT	Stock	56.51	56.7	56.5	56.63	3643353.0
2016-08-02 15:00:00	MSFT	Stock	56.63	56.689	56.54	56.58	5823976.0
2016-08-02 16:00:00	MSFT	Stock	56.58	56.64	56.55	56.6	1823015.0
2016-08-02 17:00:00	MSFT	Stock	56.58	56.68	56.58	56.68	81341.0
2016-08-02 18:00:00	MSFT	Stock	56.59	56.59	56.57	56.57	500.0
2016-08-02 19:00:00	MSFT	Stock	56.57	56.57	56.56	56.56	1004.0
2016-08-02 07:00:00	NVDA	Stock	1.4188	1.4188	1.4188	1.4188	84000.0
2016-08-02 08:00:00	NVDA	Stock	1.4275	1.4275	1.4225	1.425	62000.0
2016-08-02 09:00:00	NVDA	Stock	1.4268	1.4268	1.4075	1.4098	31538680.0
2016-08-02 10:00:00	NVDA	Stock	1.4098	1.4098	1.3902	1.394	53225800.0
2016-08-02 11:00:00	NVDA	Stock	1.3936	1.3982	1.3908	1.3945	30681880.0
2016-08-02 12:00:00	NVDA	Stock	1.3945	1.396	1.3913	1.3924	19016840.0
2016-08-02 13:00:00	NVDA	Stock	1.3924	1.397	1.3875	1.3954	19899760.0
2016-08-02 14:00:00	NVDA	Stock	1.3953	1.4005	1.3945	1.3988	36280240.0
2016-08-02 15:00:00	NVDA	Stock	1.3988	1.4023	1.3978	1.401	38225160.0
2016-08-02 16:00:00	NVDA	Stock	1.401	1.404	1.4	1.404	6686880.0
2016-08-02 17:00:00	NVDA	Stock	1.401	1.401	1.4005	1.4005	808360.0
2016-08-02 18:00:00	NVDA	Stock	1.401	1.408	1.401	1.407	104360.0
2016-08-02 19:00:00	NVDA	Stock	1.4035	1.4062	1.4035	1.4055	260760.0
2016-08-02 05:00:00	AMZN	Stock	38.3745	38.3745	38.315	38.315	6000.0
2016-08-02 06:00:00	AMZN	Stock	38.35	38.35	38.35	38.35	2000.0
2016-08-02 07:00:00	AMZN	Stock	38.313	38.335	38.297	38.3	41780.0
2016-08-02 08:00:00	AMZN	Stock	38.3	38.3	38.256	38.2875	148960.0
2016-08-02 09:00:00	AMZN	Stock	38.267	38.28	37.973	38.1585	14267480.0
2016-08-02 10:00:00	AMZN	Stock	38.1585	38.189	37.851	37.861	14452400.0
2016-08-02 11:00:00	AMZN	Stock	37.8615	38.0335	37.8545	37.987	8847600.0

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

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