PREVIEW / stock_30min / 2018-02-27

all stock 30-min files

  file:    by_date/stock_30min/2018/2018-02-27.parquet
  size:    1.7 MB
  rows:    83,020
  symbols: 2,889

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
2018-02-27 04:00:00	AAPL	Stock	44.755	44.755	44.615	44.69	6496.0
2018-02-27 04:30:00	AAPL	Stock	44.6325	44.7375	44.6325	44.7375	48272.0
2018-02-27 05:00:00	AAPL	Stock	44.745	44.7625	44.6875	44.69	33380.0
2018-02-27 05:30:00	AAPL	Stock	44.7025	44.735	44.6875	44.735	24880.0
2018-02-27 06:00:00	AAPL	Stock	44.7325	44.7325	44.65	44.67	6200.0
2018-02-27 06:30:00	AAPL	Stock	44.6125	44.625	44.575	44.575	31364.0
2018-02-27 07:00:00	AAPL	Stock	44.575	44.6725	44.575	44.64	123648.0
2018-02-27 07:30:00	AAPL	Stock	44.6475	44.675	44.6025	44.6375	110808.0
2018-02-27 08:00:00	AAPL	Stock	44.595	44.685	44.595	44.675	223432.0
2018-02-27 08:30:00	AAPL	Stock	44.66	44.77	44.6125	44.7275	363572.0
2018-02-27 09:00:00	AAPL	Stock	44.7275	44.775	44.7125	44.7725	303204.0
2018-02-27 09:30:00	AAPL	Stock	44.775	44.975	44.7075	44.8525	20764052.0
2018-02-27 10:00:00	AAPL	Stock	44.8475	45.0825	44.83	45.0688	17617584.0
2018-02-27 10:30:00	AAPL	Stock	45.07	45.12	44.695	44.765	13863860.0
2018-02-27 11:00:00	AAPL	Stock	44.765	44.89	44.675	44.7475	9435168.0
2018-02-27 11:30:00	AAPL	Stock	44.75	44.8275	44.685	44.7	6895364.0
2018-02-27 12:00:00	AAPL	Stock	44.6925	44.787	44.54	44.625	8108116.0
2018-02-27 12:30:00	AAPL	Stock	44.6225	44.8575	44.6125	44.84	6208040.0
2018-02-27 13:00:00	AAPL	Stock	44.8375	44.935	44.7775	44.8975	6633348.0
2018-02-27 13:30:00	AAPL	Stock	44.8975	44.9775	44.815	44.8675	7141788.0
2018-02-27 14:00:00	AAPL	Stock	44.8688	44.8775	44.745	44.8425	6736344.0
2018-02-27 14:30:00	AAPL	Stock	44.8435	44.945	44.78	44.8787	6541644.0
2018-02-27 15:00:00	AAPL	Stock	44.8775	44.9125	44.7	44.785	8362176.0
2018-02-27 15:30:00	AAPL	Stock	44.7875	44.85	44.585	44.585	12633660.0
2018-02-27 16:00:00	AAPL	Stock	44.5975	44.635	44.575	44.6125	9202448.0
2018-02-27 16:30:00	AAPL	Stock	44.6125	44.741	44.5975	44.6	61880.0
2018-02-27 17:00:00	AAPL	Stock	44.6	44.6125	44.5925	44.5925	24128.0
2018-02-27 17:30:00	AAPL	Stock	44.6125	44.6125	44.5925	44.61	23080.0
2018-02-27 18:00:00	AAPL	Stock	44.6075	44.635	44.6075	44.63	31664.0
2018-02-27 18:30:00	AAPL	Stock	44.63	44.685	44.63	44.675	35904.0
2018-02-27 19:00:00	AAPL	Stock	44.675	44.7	44.64	44.7	9096.0
2018-02-27 19:30:00	AAPL	Stock	44.675	44.7	44.675	44.6875	38024.0
2018-02-27 07:00:00	MSFT	Stock	95.04	95.24	95.04	95.07	469.0
2018-02-27 07:30:00	MSFT	Stock	95.2	95.36	95.16	95.36	1374.0
2018-02-27 08:00:00	MSFT	Stock	95.295	95.5	95.105	95.43	9142.0
2018-02-27 08:30:00	MSFT	Stock	95.33	95.58	95.31	95.5	4847.0
2018-02-27 09:00:00	MSFT	Stock	95.5	95.77	95.5	95.7	15440.0
2018-02-27 09:30:00	MSFT	Stock	95.74	95.84	95.25	95.38	3441756.0
2018-02-27 10:00:00	MSFT	Stock	95.39	95.83	95.39	95.77	1782545.0
2018-02-27 10:30:00	MSFT	Stock	95.765	95.815	94.955	95.1	1641434.0
2018-02-27 11:00:00	MSFT	Stock	95.105	95.56	94.93	95.04	1288690.0
2018-02-27 11:30:00	MSFT	Stock	95.05	95.17	94.85	94.86	1384513.0
2018-02-27 12:00:00	MSFT	Stock	94.85	95.12	94.56	94.78	1053694.0
2018-02-27 12:30:00	MSFT	Stock	94.78	95.33	94.68	95.3	1000067.0
2018-02-27 13:00:00	MSFT	Stock	95.29	95.345	95.084	95.19	712057.0
2018-02-27 13:30:00	MSFT	Stock	95.17	95.27	94.96	95.04	842179.0
2018-02-27 14:00:00	MSFT	Stock	95.04	95.11	94.75	95.045	1447295.0
2018-02-27 14:30:00	MSFT	Stock	95.04	95.28	94.91	95.02	1134667.0
2018-02-27 15:00:00	MSFT	Stock	95.0	95.04	94.31	94.658	1825545.0
2018-02-27 15:30:00	MSFT	Stock	94.66	94.93	94.21	94.21	3336832.0

> showing 50 of 83,020 rows — these rows as CSV

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