PREVIEW / stock_30min / 2017-04-24

all stock 30-min files

  file:    by_date/stock_30min/2017/2017-04-24.parquet
  size:    1.6 MB
  rows:    83,068
  symbols: 3,056

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-04-24 04:00:00	AAPL	Stock	36.0025	36.05	36.0	36.05	4516.0
2017-04-24 04:30:00	AAPL	Stock	36.025	36.025	35.9925	35.9925	6956.0
2017-04-24 05:00:00	AAPL	Stock	35.9925	36.0125	35.9925	36.0125	2716.0
2017-04-24 05:30:00	AAPL	Stock	35.98	35.98	35.9725	35.9725	4332.0
2017-04-24 06:00:00	AAPL	Stock	35.9625	35.9875	35.9625	35.965	10528.0
2017-04-24 06:30:00	AAPL	Stock	35.9875	35.9925	35.95	35.9875	8420.0
2017-04-24 07:00:00	AAPL	Stock	35.975	35.975	35.9	35.9125	43144.0
2017-04-24 07:30:00	AAPL	Stock	35.92	35.935	35.9025	35.91	37360.0
2017-04-24 08:00:00	AAPL	Stock	35.905	35.965	35.5675	35.925	132252.0
2017-04-24 08:30:00	AAPL	Stock	35.925	35.95	35.885	35.905	168328.0
2017-04-24 09:00:00	AAPL	Stock	35.9025	35.915	35.825	35.8775	342896.0
2017-04-24 09:30:00	AAPL	Stock	35.875	35.9875	35.795	35.9625	12721148.0
2017-04-24 10:00:00	AAPL	Stock	35.9625	35.9825	35.8975	35.9525	5862588.0
2017-04-24 10:30:00	AAPL	Stock	35.9525	35.9575	35.8775	35.895	3258820.0
2017-04-24 11:00:00	AAPL	Stock	35.8975	35.9175	35.8575	35.8738	3321912.0
2017-04-24 11:30:00	AAPL	Stock	35.875	35.9225	35.8575	35.9	2874208.0
2017-04-24 12:00:00	AAPL	Stock	35.9025	35.955	35.9025	35.9285	2656420.0
2017-04-24 12:30:00	AAPL	Stock	35.9288	35.9562	35.925	35.9438	1855628.0
2017-04-24 13:00:00	AAPL	Stock	35.945	35.955	35.9288	35.9445	2669380.0
2017-04-24 13:30:00	AAPL	Stock	35.9475	35.96	35.94	35.9575	1962268.0
2017-04-24 14:00:00	AAPL	Stock	35.9552	35.9725	35.915	35.955	3242560.0
2017-04-24 14:30:00	AAPL	Stock	35.955	35.965	35.93	35.95	2248116.0
2017-04-24 15:00:00	AAPL	Stock	35.95	35.9675	35.9175	35.9212	4163340.0
2017-04-24 15:30:00	AAPL	Stock	35.9225	35.9525	35.885	35.9075	7213608.0
2017-04-24 16:00:00	AAPL	Stock	35.91	35.925	35.9	35.9125	7663472.0
2017-04-24 16:30:00	AAPL	Stock	35.9125	35.92	35.91	35.91	53680.0
2017-04-24 17:00:00	AAPL	Stock	35.915	35.9275	35.9125	35.9275	19080.0
2017-04-24 17:30:00	AAPL	Stock	35.9225	35.9375	35.9225	35.9225	3608.0
2017-04-24 18:00:00	AAPL	Stock	35.9225	35.9375	35.915	35.9375	7916.0
2017-04-24 18:30:00	AAPL	Stock	35.9125	35.9375	35.9125	35.915	3548.0
2017-04-24 19:00:00	AAPL	Stock	35.9375	35.9375	35.9325	35.9325	1844.0
2017-04-24 19:30:00	AAPL	Stock	35.9375	35.945	35.93	35.945	16756.0
2017-04-24 04:00:00	MSFT	Stock	67.0	67.41	67.0	67.4	1724.0
2017-04-24 04:30:00	MSFT	Stock	67.34	67.35	67.34	67.35	400.0
2017-04-24 05:00:00	MSFT	Stock	67.34	67.34	67.34	67.34	100.0
2017-04-24 06:00:00	MSFT	Stock	67.39	67.39	67.32	67.32	700.0
2017-04-24 06:30:00	MSFT	Stock	67.32	67.32	67.24	67.24	1346.0
2017-04-24 07:00:00	MSFT	Stock	67.25	67.25	67.23	67.25	2642.0
2017-04-24 07:30:00	MSFT	Stock	67.2	67.23	67.16	67.16	5870.0
2017-04-24 08:00:00	MSFT	Stock	67.16	67.32	66.4	67.25	35388.0
2017-04-24 08:30:00	MSFT	Stock	67.25	67.3	67.19	67.2	38505.0
2017-04-24 09:00:00	MSFT	Stock	67.2	67.48	67.13	67.47	102751.0
2017-04-24 09:30:00	MSFT	Stock	67.47	67.49	67.2	67.34	5014504.0
2017-04-24 10:00:00	MSFT	Stock	67.34	67.43	67.2	67.405	2067492.0
2017-04-24 10:30:00	MSFT	Stock	67.406	67.44	67.33	67.38	1685615.0
2017-04-24 11:00:00	MSFT	Stock	67.38	67.41	67.26	67.395	2114718.0
2017-04-24 11:30:00	MSFT	Stock	67.4	67.4	67.16	67.21	1156699.0
2017-04-24 12:00:00	MSFT	Stock	67.2	67.3	67.184	67.2	1119227.0
2017-04-24 12:30:00	MSFT	Stock	67.205	67.24	67.1	67.21	1412335.0
2017-04-24 13:00:00	MSFT	Stock	67.2	67.31	67.2	67.3	1218396.0

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

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