PREVIEW / stock_30min / 2017-03-24

all stock 30-min files

  file:    by_date/stock_30min/2017/2017-03-24.parquet
  size:    1.5 MB
  rows:    79,860
  symbols: 3,052

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-03-24 04:30:00	AAPL	Stock	35.2675	35.285	35.2675	35.285	1600.0
2017-03-24 06:00:00	AAPL	Stock	35.3075	35.3375	35.2875	35.2875	5928.0
2017-03-24 06:30:00	AAPL	Stock	35.2875	35.2875	35.2875	35.2875	400.0
2017-03-24 07:00:00	AAPL	Stock	35.315	35.3375	35.19	35.2375	100424.0
2017-03-24 07:30:00	AAPL	Stock	35.2375	35.325	35.235	35.3175	36816.0
2017-03-24 08:00:00	AAPL	Stock	35.2625	35.3225	35.225	35.3125	107472.0
2017-03-24 08:30:00	AAPL	Stock	35.3225	35.35	35.3025	35.325	31192.0
2017-03-24 09:00:00	AAPL	Stock	35.325	35.375	35.3025	35.3675	129604.0
2017-03-24 09:30:00	AAPL	Stock	35.3475	35.435	35.3	35.3825	12729580.0
2017-03-24 10:00:00	AAPL	Stock	35.3847	35.385	35.315	35.3325	5376560.0
2017-03-24 10:30:00	AAPL	Stock	35.335	35.4075	35.315	35.3775	4389136.0
2017-03-24 11:00:00	AAPL	Stock	35.38	35.4125	35.3525	35.365	3292436.0
2017-03-24 11:30:00	AAPL	Stock	35.365	35.385	35.3375	35.355	3109116.0
2017-03-24 12:00:00	AAPL	Stock	35.355	35.365	35.2375	35.343	5803008.0
2017-03-24 12:30:00	AAPL	Stock	35.345	35.36	35.2975	35.3225	3311980.0
2017-03-24 13:00:00	AAPL	Stock	35.3212	35.3325	35.2625	35.2775	2691860.0
2017-03-24 13:30:00	AAPL	Stock	35.2758	35.2825	35.1895	35.1938	3204236.0
2017-03-24 14:00:00	AAPL	Stock	35.1925	35.2475	35.1925	35.23	2812928.0
2017-03-24 14:30:00	AAPL	Stock	35.2302	35.255	35.155	35.1675	3664384.0
2017-03-24 15:00:00	AAPL	Stock	35.17	35.19	35.09	35.185	5483316.0
2017-03-24 15:30:00	AAPL	Stock	35.185	35.2875	35.0875	35.1575	15719960.0
2017-03-24 16:00:00	AAPL	Stock	35.16	35.2075	35.16	35.175	7850636.0
2017-03-24 16:30:00	AAPL	Stock	35.1825	35.185	35.025	35.0575	1129540.0
2017-03-24 17:00:00	AAPL	Stock	35.05	35.0625	35.0125	35.045	191280.0
2017-03-24 17:30:00	AAPL	Stock	35.045	35.085	35.0425	35.085	18296.0
2017-03-24 18:00:00	AAPL	Stock	35.0825	35.1	35.0825	35.1	29196.0
2017-03-24 18:30:00	AAPL	Stock	35.1125	35.12	35.105	35.11	11160.0
2017-03-24 19:00:00	AAPL	Stock	35.11	35.11	35.0875	35.1075	10568.0
2017-03-24 19:30:00	AAPL	Stock	35.09	35.1075	35.0825	35.1075	39664.0
2017-03-24 04:30:00	MSFT	Stock	65.0	65.0	65.0	65.0	164.0
2017-03-24 05:00:00	MSFT	Stock	65.08	65.08	65.08	65.08	100.0
2017-03-24 08:00:00	MSFT	Stock	64.9	64.9	64.9	64.9	360.0
2017-03-24 08:30:00	MSFT	Stock	64.92	64.92	64.92	64.92	130.0
2017-03-24 09:00:00	MSFT	Stock	65.05	65.19	65.05	65.17	10402.0
2017-03-24 09:30:00	MSFT	Stock	65.17	65.2	64.835	65.135	2174072.0
2017-03-24 10:00:00	MSFT	Stock	65.13	65.285	65.13	65.205	1103113.0
2017-03-24 10:30:00	MSFT	Stock	65.2	65.4	65.18	65.355	1346478.0
2017-03-24 11:00:00	MSFT	Stock	65.36	65.42	65.31	65.311	965744.0
2017-03-24 11:30:00	MSFT	Stock	65.315	65.44	65.3	65.42	654689.0
2017-03-24 12:00:00	MSFT	Stock	65.42	65.45	65.15	65.3	1231692.0
2017-03-24 12:30:00	MSFT	Stock	65.3	65.35	65.2	65.235	669596.0
2017-03-24 13:00:00	MSFT	Stock	65.24	65.265	65.105	65.174	742408.0
2017-03-24 13:30:00	MSFT	Stock	65.175	65.195	64.98	65.005	669485.0
2017-03-24 14:00:00	MSFT	Stock	65.005	65.139	65.005	65.05	821449.0
2017-03-24 14:30:00	MSFT	Stock	65.05	65.1	64.82	64.845	1126732.0
2017-03-24 15:00:00	MSFT	Stock	64.84	64.957	64.76	64.945	1591865.0
2017-03-24 15:30:00	MSFT	Stock	64.93	65.27	64.87	64.99	5412996.0
2017-03-24 16:00:00	MSFT	Stock	64.99	65.05	64.98	65.0	2311343.0
2017-03-24 16:30:00	MSFT	Stock	65.04	65.05	64.98	65.01	231315.0
2017-03-24 17:00:00	MSFT	Stock	65.01	65.14	65.01	65.05	4700.0

> showing 50 of 79,860 rows — these rows as CSV

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