PREVIEW / stock_1hour / 2017-06-02

all stock 1-hour files

  file:    by_date/stock_1hour/2017/2017-06-02.parquet
  size:    1.0 MB
  rows:    48,163
  symbols: 3,035

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
2017-06-02 04:00:00	AAPL	Stock	38.41	38.41	38.41	38.41	2000.0
2017-06-02 05:00:00	AAPL	Stock	38.4625	38.4625	38.4625	38.4625	3828.0
2017-06-02 06:00:00	AAPL	Stock	38.4575	38.4725	38.425	38.4425	14128.0
2017-06-02 07:00:00	AAPL	Stock	38.435	38.45	38.38	38.3825	24376.0
2017-06-02 08:00:00	AAPL	Stock	38.4375	38.45	38.27	38.345	243420.0
2017-06-02 09:00:00	AAPL	Stock	38.3625	38.41	38.2225	38.3225	10220176.0
2017-06-02 10:00:00	AAPL	Stock	38.3225	38.4288	38.3075	38.4188	9473896.0
2017-06-02 11:00:00	AAPL	Stock	38.4175	38.502	38.4052	38.5	7390068.0
2017-06-02 12:00:00	AAPL	Stock	38.5	38.6692	38.4988	38.656	11376100.0
2017-06-02 13:00:00	AAPL	Stock	38.655	38.775	38.65	38.7738	12702208.0
2017-06-02 14:00:00	AAPL	Stock	38.775	38.8625	38.7675	38.795	13802272.0
2017-06-02 15:00:00	AAPL	Stock	38.8	38.8625	38.735	38.8625	26231172.0
2017-06-02 16:00:00	AAPL	Stock	38.8625	38.8625	38.7505	38.8125	9681752.0
2017-06-02 17:00:00	AAPL	Stock	38.825	38.845	38.81	38.845	79780.0
2017-06-02 18:00:00	AAPL	Stock	38.8375	38.845	38.8225	38.83	53572.0
2017-06-02 19:00:00	AAPL	Stock	38.845	38.845	38.825	38.8375	24924.0
2017-06-02 06:00:00	MSFT	Stock	70.39	70.39	70.39	70.39	142.0
2017-06-02 07:00:00	MSFT	Stock	70.39	70.45	70.15	70.15	372.0
2017-06-02 08:00:00	MSFT	Stock	70.25	70.25	70.1	70.2	4044.0
2017-06-02 09:00:00	MSFT	Stock	70.2	70.74	70.2	70.68	3459802.0
2017-06-02 10:00:00	MSFT	Stock	70.68	70.98	70.67	70.94	3837693.0
2017-06-02 11:00:00	MSFT	Stock	70.94	71.33	70.93	71.3	3549390.0
2017-06-02 12:00:00	MSFT	Stock	71.3	71.37	71.15	71.35	2141999.0
2017-06-02 13:00:00	MSFT	Stock	71.34	71.63	71.3	71.535	2401852.0
2017-06-02 14:00:00	MSFT	Stock	71.535	71.58	71.39	71.54	3198444.0
2017-06-02 15:00:00	MSFT	Stock	71.55	71.86	71.485	71.75	10384085.0
2017-06-02 16:00:00	MSFT	Stock	71.75	71.8	71.72	71.79	3140083.0
2017-06-02 17:00:00	MSFT	Stock	71.76	71.77	71.76	71.76	1867.0
2017-06-02 18:00:00	MSFT	Stock	71.76	71.8	71.76	71.76	525.0
2017-06-02 19:00:00	MSFT	Stock	71.77	71.81	71.76	71.81	1318.0
2017-06-02 04:00:00	NVDA	Stock	3.62	3.62	3.62	3.62	80000.0
2017-06-02 05:00:00	NVDA	Stock	3.625	3.625	3.625	3.625	8000.0
2017-06-02 06:00:00	NVDA	Stock	3.6248	3.6295	3.6242	3.6295	161760.0
2017-06-02 07:00:00	NVDA	Stock	3.6275	3.6312	3.625	3.625	283800.0
2017-06-02 08:00:00	NVDA	Stock	3.625	3.6295	3.5938	3.6	2117160.0
2017-06-02 09:00:00	NVDA	Stock	3.6	3.6325	3.5948	3.6036	94650560.0
2017-06-02 10:00:00	NVDA	Stock	3.6032	3.624	3.5988	3.6145	80844080.0
2017-06-02 11:00:00	NVDA	Stock	3.6148	3.6212	3.6018	3.6065	60151760.0
2017-06-02 12:00:00	NVDA	Stock	3.6062	3.6092	3.5888	3.5922	49586400.0
2017-06-02 13:00:00	NVDA	Stock	3.5923	3.6015	3.592	3.5933	26554600.0
2017-06-02 14:00:00	NVDA	Stock	3.593	3.6088	3.5868	3.601	48594920.0
2017-06-02 15:00:00	NVDA	Stock	3.6016	3.6028	3.585	3.5885	82082360.0
2017-06-02 16:00:00	NVDA	Stock	3.591	3.5913	3.585	3.588	24280400.0
2017-06-02 17:00:00	NVDA	Stock	3.591	3.591	3.588	3.5895	99640.0
2017-06-02 18:00:00	NVDA	Stock	3.5883	3.59	3.588	3.589	110880.0
2017-06-02 19:00:00	NVDA	Stock	3.5892	3.5913	3.5888	3.5913	260440.0
2017-06-02 06:00:00	AMZN	Stock	49.97	49.983	49.97	49.983	7360.0
2017-06-02 07:00:00	AMZN	Stock	49.9585	49.9825	49.95	49.95	37120.0
2017-06-02 08:00:00	AMZN	Stock	49.9515	49.969	49.8525	49.8995	306560.0
2017-06-02 09:00:00	AMZN	Stock	49.864	50.088	49.7835	50.049	12342360.0

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

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