PREVIEW / stock_30min / 2016-06-27

all stock 30-min files

  file:    by_date/stock_30min/2016/2016-06-27.parquet
  size:    1.6 MB
  rows:    84,189
  symbols: 3,283

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-27 04:00:00	AAPL	Stock	23.255	23.255	23.25	23.25	19116.0
2016-06-27 04:30:00	AAPL	Stock	23.18	23.26	23.18	23.2375	13160.0
2016-06-27 05:00:00	AAPL	Stock	23.2775	23.28	23.225	23.225	25768.0
2016-06-27 05:30:00	AAPL	Stock	23.2025	23.2075	23.195	23.195	3200.0
2016-06-27 06:00:00	AAPL	Stock	23.25	23.25	23.2	23.205	13344.0
2016-06-27 06:30:00	AAPL	Stock	23.205	23.205	23.165	23.18	95604.0
2016-06-27 07:00:00	AAPL	Stock	23.1825	23.2175	23.175	23.1825	61652.0
2016-06-27 07:30:00	AAPL	Stock	23.1875	23.19	23.1425	23.15	74272.0
2016-06-27 08:00:00	AAPL	Stock	23.1675	23.2375	23.1375	23.235	284476.0
2016-06-27 08:30:00	AAPL	Stock	23.225	23.2875	23.22	23.2675	180428.0
2016-06-27 09:00:00	AAPL	Stock	23.2675	23.2925	23.24	23.2625	273300.0
2016-06-27 09:30:00	AAPL	Stock	23.2625	23.265	22.9525	23.025	29324736.0
2016-06-27 10:00:00	AAPL	Stock	23.025	23.1	22.9875	22.9988	15180188.0
2016-06-27 10:30:00	AAPL	Stock	22.9978	23.05	22.925	22.935	14575652.0
2016-06-27 11:00:00	AAPL	Stock	22.9375	23.02	22.9	22.9658	11752536.0
2016-06-27 11:30:00	AAPL	Stock	22.965	23.0225	22.9532	22.9962	10869864.0
2016-06-27 12:00:00	AAPL	Stock	22.995	23.05	22.965	23.0325	7607172.0
2016-06-27 12:30:00	AAPL	Stock	23.035	23.039	22.94	22.9775	6890412.0
2016-06-27 13:00:00	AAPL	Stock	22.9775	23.0325	22.9525	23.005	5323056.0
2016-06-27 13:30:00	AAPL	Stock	23.005	23.015	22.9	22.945	8701152.0
2016-06-27 14:00:00	AAPL	Stock	22.9425	22.955	22.8875	22.945	7183652.0
2016-06-27 14:30:00	AAPL	Stock	22.9475	22.981	22.8775	22.8962	8342628.0
2016-06-27 15:00:00	AAPL	Stock	22.8975	22.9575	22.875	22.9125	8523288.0
2016-06-27 15:30:00	AAPL	Stock	22.9125	23.07	22.9	23.01	17996192.0
2016-06-27 16:00:00	AAPL	Stock	23.01	23.035	22.9225	23.005	14782380.0
2016-06-27 16:30:00	AAPL	Stock	23.0	23.0025	22.985	22.99	132992.0
2016-06-27 17:00:00	AAPL	Stock	22.995	23.025	22.9775	22.98	63532.0
2016-06-27 17:30:00	AAPL	Stock	23.01	23.01	22.985	22.9975	3939240.0
2016-06-27 18:00:00	AAPL	Stock	22.9875	23.0125	22.9875	23.01	48780.0
2016-06-27 18:30:00	AAPL	Stock	23.005	23.0275	23.0025	23.0025	8024.0
2016-06-27 19:00:00	AAPL	Stock	23.01	23.0125	23.0	23.0025	17456.0
2016-06-27 19:30:00	AAPL	Stock	23.0	23.025	22.9825	23.005	44648.0
2016-06-27 04:00:00	MSFT	Stock	49.6	49.6	49.6	49.6	100.0
2016-06-27 04:30:00	MSFT	Stock	49.56	49.56	49.56	49.56	100.0
2016-06-27 05:00:00	MSFT	Stock	49.52	49.52	49.52	49.52	200.0
2016-06-27 06:00:00	MSFT	Stock	49.49	49.49	49.49	49.49	292.0
2016-06-27 06:30:00	MSFT	Stock	49.36	49.36	49.35	49.35	442.0
2016-06-27 07:00:00	MSFT	Stock	49.46	49.46	49.25	49.25	8827.0
2016-06-27 07:30:00	MSFT	Stock	49.19	49.22	49.19	49.22	3200.0
2016-06-27 08:00:00	MSFT	Stock	49.22	49.25	49.16	49.25	13672.0
2016-06-27 08:30:00	MSFT	Stock	49.23	49.35	49.18	49.2	68770.0
2016-06-27 09:00:00	MSFT	Stock	49.23	49.38	49.11	49.12	57305.0
2016-06-27 09:30:00	MSFT	Stock	49.1	49.12	48.845	49.02	6231375.0
2016-06-27 10:00:00	MSFT	Stock	49.02	49.147	48.81	48.86	2932727.0
2016-06-27 10:30:00	MSFT	Stock	48.854	48.995	48.51	48.57	3653306.0
2016-06-27 11:00:00	MSFT	Stock	48.57	48.671	48.43	48.63	3078349.0
2016-06-27 11:30:00	MSFT	Stock	48.62	48.78	48.58	48.61	2569293.0
2016-06-27 12:00:00	MSFT	Stock	48.61	48.68	48.52	48.62	1670603.0
2016-06-27 12:30:00	MSFT	Stock	48.63	48.66	48.42	48.58	1933898.0
2016-06-27 13:00:00	MSFT	Stock	48.587	48.65	48.485	48.57	1805226.0

> showing 50 of 84,189 rows — these rows as CSV

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