PREVIEW / stock_30min / 2017-08-22

all stock 30-min files

  file:    by_date/stock_30min/2017/2017-08-22.parquet
  size:    1.6 MB
  rows:    79,899
  symbols: 2,985

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-08-22 04:00:00	AAPL	Stock	39.45	39.4525	39.45	39.4525	1320.0
2017-08-22 06:00:00	AAPL	Stock	39.4	39.445	39.4	39.445	2884.0
2017-08-22 06:30:00	AAPL	Stock	39.42	39.4425	39.42	39.4375	7508.0
2017-08-22 07:00:00	AAPL	Stock	39.425	39.45	39.415	39.425	33956.0
2017-08-22 07:30:00	AAPL	Stock	39.425	39.45	39.425	39.4425	18660.0
2017-08-22 08:00:00	AAPL	Stock	39.4475	39.5375	39.425	39.525	204540.0
2017-08-22 08:30:00	AAPL	Stock	39.525	39.525	39.4525	39.485	50040.0
2017-08-22 09:00:00	AAPL	Stock	39.4775	39.5625	39.45	39.55	134704.0
2017-08-22 09:30:00	AAPL	Stock	39.5575	39.81	39.505	39.7285	12794044.0
2017-08-22 10:00:00	AAPL	Stock	39.7288	39.9125	39.7228	39.8375	7833360.0
2017-08-22 10:30:00	AAPL	Stock	39.841	39.8938	39.7825	39.8708	4364016.0
2017-08-22 11:00:00	AAPL	Stock	39.872	39.9225	39.8525	39.895	4613544.0
2017-08-22 11:30:00	AAPL	Stock	39.895	39.9675	39.875	39.9512	4436280.0
2017-08-22 12:00:00	AAPL	Stock	39.9505	40.0	39.9225	39.9362	4752420.0
2017-08-22 12:30:00	AAPL	Stock	39.9375	39.9548	39.8825	39.93	3572840.0
2017-08-22 13:00:00	AAPL	Stock	39.93	39.9825	39.925	39.9442	3038948.0
2017-08-22 13:30:00	AAPL	Stock	39.945	39.965	39.8725	39.895	2419252.0
2017-08-22 14:00:00	AAPL	Stock	39.8925	39.9825	39.8775	39.9625	3200100.0
2017-08-22 14:30:00	AAPL	Stock	39.9638	40.0	39.9375	39.955	3430212.0
2017-08-22 15:00:00	AAPL	Stock	39.9525	39.9688	39.915	39.93	3345296.0
2017-08-22 15:30:00	AAPL	Stock	39.9323	39.99	39.925	39.945	8572704.0
2017-08-22 16:00:00	AAPL	Stock	39.945	39.975	39.945	39.955	9509000.0
2017-08-22 16:30:00	AAPL	Stock	39.96	39.975	39.945	39.97	333016.0
2017-08-22 17:00:00	AAPL	Stock	39.9625	39.975	39.955	39.9625	37604.0
2017-08-22 17:30:00	AAPL	Stock	39.9575	39.98	39.95	39.955	77236.0
2017-08-22 18:00:00	AAPL	Stock	39.955	39.975	39.945	39.975	16652.0
2017-08-22 18:30:00	AAPL	Stock	39.9525	39.9725	39.95	39.9675	4580.0
2017-08-22 19:00:00	AAPL	Stock	39.9725	39.9725	39.9625	39.9625	10200.0
2017-08-22 19:30:00	AAPL	Stock	39.965	39.98	39.965	39.965	23632.0
2017-08-22 07:00:00	MSFT	Stock	72.48	72.48	72.46	72.46	300.0
2017-08-22 08:00:00	MSFT	Stock	72.27	72.51	72.27	72.51	4650.0
2017-08-22 08:30:00	MSFT	Stock	72.57	72.57	72.5	72.56	2025.0
2017-08-22 09:00:00	MSFT	Stock	72.56	72.56	72.5	72.5	5102.0
2017-08-22 09:30:00	MSFT	Stock	72.35	72.94	72.35	72.835	1555658.0
2017-08-22 10:00:00	MSFT	Stock	72.84	73.11	72.83	73.02	1050730.0
2017-08-22 10:30:00	MSFT	Stock	73.02	73.056	72.92	72.99	673227.0
2017-08-22 11:00:00	MSFT	Stock	73.0	73.02	72.95	73.0	688030.0
2017-08-22 11:30:00	MSFT	Stock	73.0	73.03	72.92	72.995	799702.0
2017-08-22 12:00:00	MSFT	Stock	72.995	73.11	72.97	72.99	762290.0
2017-08-22 12:30:00	MSFT	Stock	72.99	73.03	72.86	72.96	468707.0
2017-08-22 13:00:00	MSFT	Stock	72.96	73.0	72.92	72.98	336721.0
2017-08-22 13:30:00	MSFT	Stock	72.98	73.02	72.91	73.0	474031.0
2017-08-22 14:00:00	MSFT	Stock	73.0	73.15	72.975	73.13	818194.0
2017-08-22 14:30:00	MSFT	Stock	73.125	73.2	73.062	73.105	809275.0
2017-08-22 15:00:00	MSFT	Stock	73.1	73.17	73.08	73.11	775909.0
2017-08-22 15:30:00	MSFT	Stock	73.115	73.24	73.11	73.15	2047142.0
2017-08-22 16:00:00	MSFT	Stock	73.15	73.24	73.1	73.19	1922284.0
2017-08-22 16:30:00	MSFT	Stock	73.16	73.16	73.16	73.16	1183.0
2017-08-22 17:00:00	MSFT	Stock	73.12	73.12	73.12	73.12	1200.0
2017-08-22 17:30:00	MSFT	Stock	73.15	73.15	73.15	73.15	351.0

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

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