PREVIEW / stock_30min / 2017-01-17

all stock 30-min files

  file:    by_date/stock_30min/2017/2017-01-17.parquet
  size:    1.6 MB
  rows:    82,898
  symbols: 3,127

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-17 04:00:00	AAPL	Stock	29.685	29.685	29.6725	29.6725	880.0
2017-01-17 05:30:00	AAPL	Stock	29.625	29.625	29.6	29.6	5200.0
2017-01-17 06:00:00	AAPL	Stock	29.625	29.625	29.6125	29.6125	4000.0
2017-01-17 06:30:00	AAPL	Stock	29.5675	29.6425	29.5675	29.6425	17956.0
2017-01-17 07:00:00	AAPL	Stock	29.6625	29.685	29.6525	29.6525	37972.0
2017-01-17 07:30:00	AAPL	Stock	29.6575	29.6825	29.635	29.6825	27204.0
2017-01-17 08:00:00	AAPL	Stock	29.665	29.6875	29.6275	29.65	106640.0
2017-01-17 08:30:00	AAPL	Stock	29.6525	29.6725	29.65	29.6675	97640.0
2017-01-17 09:00:00	AAPL	Stock	29.6725	29.6725	29.57	29.58	188464.0
2017-01-17 09:30:00	AAPL	Stock	29.58	29.945	29.555	29.8945	24635380.0
2017-01-17 10:00:00	AAPL	Stock	29.895	29.9775	29.8875	29.9775	11297368.0
2017-01-17 10:30:00	AAPL	Stock	29.975	29.99	29.9525	29.99	7188684.0
2017-01-17 11:00:00	AAPL	Stock	29.9888	30.0	29.91	29.9862	7949580.0
2017-01-17 11:30:00	AAPL	Stock	29.985	30.06	29.9725	30.0138	16020060.0
2017-01-17 12:00:00	AAPL	Stock	30.0125	30.0175	29.955	29.9925	5333616.0
2017-01-17 12:30:00	AAPL	Stock	29.991	29.995	29.9425	29.9538	3776004.0
2017-01-17 13:00:00	AAPL	Stock	29.9525	29.9975	29.95	29.9935	3357568.0
2017-01-17 13:30:00	AAPL	Stock	29.9938	30.0125	29.97	29.992	4923732.0
2017-01-17 14:00:00	AAPL	Stock	29.9908	30.005	29.96	29.9738	5243276.0
2017-01-17 14:30:00	AAPL	Stock	29.9725	29.98	29.895	29.9612	7673404.0
2017-01-17 15:00:00	AAPL	Stock	29.9625	29.9825	29.9275	29.95	5048908.0
2017-01-17 15:30:00	AAPL	Stock	29.9488	30.0	29.941	29.9975	10116668.0
2017-01-17 16:00:00	AAPL	Stock	29.985	30.0	29.7875	29.9925	13121652.0
2017-01-17 16:30:00	AAPL	Stock	29.9925	30.0	29.9875	29.9925	850532.0
2017-01-17 17:00:00	AAPL	Stock	29.9925	30.0	29.9725	29.975	24276.0
2017-01-17 17:30:00	AAPL	Stock	30.0	30.0	29.975	29.9775	8488.0
2017-01-17 18:00:00	AAPL	Stock	29.98	29.9925	29.98	29.9925	1600.0
2017-01-17 18:30:00	AAPL	Stock	29.9925	29.995	29.99	29.99	2008.0
2017-01-17 19:00:00	AAPL	Stock	29.975	29.975	29.975	29.975	400.0
2017-01-17 19:30:00	AAPL	Stock	29.9775	29.99	29.975	29.99	15200.0
2017-01-17 04:00:00	MSFT	Stock	62.7	62.7	62.65	62.65	520.0
2017-01-17 08:00:00	MSFT	Stock	62.69	62.69	62.6	62.6	1142.0
2017-01-17 08:30:00	MSFT	Stock	62.58	62.58	62.58	62.58	1340.0
2017-01-17 09:00:00	MSFT	Stock	62.6	62.69	62.57	62.69	700.0
2017-01-17 09:30:00	MSFT	Stock	62.67	62.7	62.03	62.18	2870050.0
2017-01-17 10:00:00	MSFT	Stock	62.18	62.47	62.18	62.33	1487195.0
2017-01-17 10:30:00	MSFT	Stock	62.34	62.4	62.25	62.355	1117281.0
2017-01-17 11:00:00	MSFT	Stock	62.36	62.36	62.2	62.325	897199.0
2017-01-17 11:30:00	MSFT	Stock	62.325	62.36	62.24	62.326	976916.0
2017-01-17 12:00:00	MSFT	Stock	62.325	62.38	62.215	62.265	557974.0
2017-01-17 12:30:00	MSFT	Stock	62.27	62.3	62.23	62.27	388243.0
2017-01-17 13:00:00	MSFT	Stock	62.27	62.39	62.27	62.39	785309.0
2017-01-17 13:30:00	MSFT	Stock	62.39	62.485	62.37	62.45	842686.0
2017-01-17 14:00:00	MSFT	Stock	62.46	62.52	62.37	62.404	837271.0
2017-01-17 14:30:00	MSFT	Stock	62.41	62.435	62.3	62.37	734085.0
2017-01-17 15:00:00	MSFT	Stock	62.37	62.38	62.31	62.325	995087.0
2017-01-17 15:30:00	MSFT	Stock	62.33	62.54	62.32	62.52	2259799.0
2017-01-17 16:00:00	MSFT	Stock	62.53	62.53	62.44	62.5	4308351.0
2017-01-17 17:00:00	MSFT	Stock	62.53	62.75	62.45	62.6	9995.0
2017-01-17 17:30:00	MSFT	Stock	62.6	62.6	62.6	62.6	100.0

> showing 50 of 82,898 rows — these rows as CSV

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