PREVIEW / stock_30min / 2017-01-04

all stock 30-min files

  file:    by_date/stock_30min/2017/2017-01-04.parquet
  size:    1.7 MB
  rows:    85,574
  symbols: 3,167

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-01-04 04:00:00	AAPL	Stock	28.9925	28.9925	28.99	28.99	1484.0
2017-01-04 04:30:00	AAPL	Stock	29.0675	29.0675	29.0675	29.0675	1600.0
2017-01-04 06:00:00	AAPL	Stock	29.0375	29.075	29.0375	29.05	8736.0
2017-01-04 06:30:00	AAPL	Stock	29.05	29.05	29.02	29.02	4000.0
2017-01-04 07:00:00	AAPL	Stock	29.05	29.075	28.9875	28.9875	35436.0
2017-01-04 07:30:00	AAPL	Stock	28.975	28.9825	28.95	28.95	77136.0
2017-01-04 08:00:00	AAPL	Stock	28.9625	29.025	28.9625	29.0025	61960.0
2017-01-04 08:30:00	AAPL	Stock	29.005	29.0125	28.9525	28.9525	73460.0
2017-01-04 09:00:00	AAPL	Stock	28.975	29.0225	28.9225	28.97	278624.0
2017-01-04 09:30:00	AAPL	Stock	28.965	29.1275	28.9375	29.0675	14283896.0
2017-01-04 10:00:00	AAPL	Stock	29.0698	29.1	29.0125	29.0225	6136116.0
2017-01-04 10:30:00	AAPL	Stock	29.0225	29.0362	28.9675	28.9888	6291500.0
2017-01-04 11:00:00	AAPL	Stock	28.99	29.0225	28.9762	29.0145	4685224.0
2017-01-04 11:30:00	AAPL	Stock	29.0148	29.095	29.0125	29.0925	3859708.0
2017-01-04 12:00:00	AAPL	Stock	29.0925	29.095	29.03	29.039	2830696.0
2017-01-04 12:30:00	AAPL	Stock	29.04	29.0525	29.01	29.0325	2726808.0
2017-01-04 13:00:00	AAPL	Stock	29.035	29.05	29.0238	29.04	2137024.0
2017-01-04 13:30:00	AAPL	Stock	29.04	29.0675	29.035	29.0525	3101024.0
2017-01-04 14:00:00	AAPL	Stock	29.0525	29.075	29.0125	29.06	4290016.0
2017-01-04 14:30:00	AAPL	Stock	29.06	29.07	29.01	29.0152	3340268.0
2017-01-04 15:00:00	AAPL	Stock	29.015	29.0338	28.995	29.003	3980820.0
2017-01-04 15:30:00	AAPL	Stock	29.0025	29.0225	28.975	29.005	9811716.0
2017-01-04 16:00:00	AAPL	Stock	29.005	29.01	28.985	29.0075	7954952.0
2017-01-04 16:30:00	AAPL	Stock	29.005	29.0125	29.005	29.0075	358300.0
2017-01-04 17:00:00	AAPL	Stock	29.0075	29.0075	29.0075	29.0075	864.0
2017-01-04 17:30:00	AAPL	Stock	29.005	29.0075	29.0025	29.0075	3620.0
2017-01-04 18:00:00	AAPL	Stock	29.0	29.0025	29.0	29.0	5800.0
2017-01-04 18:30:00	AAPL	Stock	29.005	29.0075	29.0	29.0075	2560.0
2017-01-04 19:00:00	AAPL	Stock	29.0	29.0	28.995	28.995	3500.0
2017-01-04 19:30:00	AAPL	Stock	28.9975	29.0025	28.9925	29.0	9996.0
2017-01-04 04:00:00	MSFT	Stock	62.67	62.67	62.67	62.67	542.0
2017-01-04 04:30:00	MSFT	Stock	62.5	62.5	62.5	62.5	320.0
2017-01-04 07:30:00	MSFT	Stock	62.6	62.6	62.6	62.6	223.0
2017-01-04 08:00:00	MSFT	Stock	62.6	62.6	62.6	62.6	1286.0
2017-01-04 08:30:00	MSFT	Stock	62.6	62.6	62.6	62.6	100.0
2017-01-04 09:00:00	MSFT	Stock	62.6	62.6	62.42	62.42	6605.0
2017-01-04 09:30:00	MSFT	Stock	62.48	62.75	62.24	62.245	2531313.0
2017-01-04 10:00:00	MSFT	Stock	62.24	62.33	62.15	62.168	1394193.0
2017-01-04 10:30:00	MSFT	Stock	62.16	62.37	62.16	62.35	894815.0
2017-01-04 11:00:00	MSFT	Stock	62.35	62.39	62.21	62.23	819245.0
2017-01-04 11:30:00	MSFT	Stock	62.24	62.26	62.2	62.21	777742.0
2017-01-04 12:00:00	MSFT	Stock	62.22	62.26	62.12	62.17	1015370.0
2017-01-04 12:30:00	MSFT	Stock	62.17	62.28	62.15	62.19	696875.0
2017-01-04 13:00:00	MSFT	Stock	62.192	62.28	62.16	62.28	764516.0
2017-01-04 13:30:00	MSFT	Stock	62.276	62.31	62.18	62.21	923856.0
2017-01-04 14:00:00	MSFT	Stock	62.21	62.45	62.19	62.44	882955.0
2017-01-04 14:30:00	MSFT	Stock	62.435	62.5	62.33	62.38	909200.0
2017-01-04 15:00:00	MSFT	Stock	62.37	62.445	62.32	62.332	1039932.0
2017-01-04 15:30:00	MSFT	Stock	62.33	62.39	62.23	62.3	2779625.0
2017-01-04 16:00:00	MSFT	Stock	62.3	62.3	62.14	62.3	2957500.0

> showing 50 of 85,574 rows — these rows as CSV

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