PREVIEW / stock_30min / 2016-12-23

all stock 30-min files

  file:    by_date/stock_30min/2016/2016-12-23.parquet
  size:    1.5 MB
  rows:    79,723
  symbols: 3,149

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-12-23 05:30:00	AAPL	Stock	28.9775	28.9775	28.9775	28.9775	400.0
2016-12-23 06:30:00	AAPL	Stock	28.97	28.97	28.97	28.97	2000.0
2016-12-23 07:00:00	AAPL	Stock	28.99	29.0175	28.99	28.995	18832.0
2016-12-23 07:30:00	AAPL	Stock	28.9775	28.98	28.9575	28.9575	5800.0
2016-12-23 08:00:00	AAPL	Stock	29.0	29.0025	28.9375	28.9575	26756.0
2016-12-23 08:30:00	AAPL	Stock	28.9575	28.975	28.945	28.9475	65100.0
2016-12-23 09:00:00	AAPL	Stock	28.94	28.9775	28.9075	28.95	71172.0
2016-12-23 09:30:00	AAPL	Stock	28.8975	29.125	28.8975	29.1	10874772.0
2016-12-23 10:00:00	AAPL	Stock	29.1	29.115	29.0475	29.0775	4631236.0
2016-12-23 10:30:00	AAPL	Stock	29.0775	29.0875	29.0175	29.025	3797536.0
2016-12-23 11:00:00	AAPL	Stock	29.025	29.039	28.9925	29.035	3618892.0
2016-12-23 11:30:00	AAPL	Stock	29.0375	29.0675	29.0225	29.0525	2523460.0
2016-12-23 12:00:00	AAPL	Stock	29.0525	29.0828	29.0475	29.075	2504856.0
2016-12-23 12:30:00	AAPL	Stock	29.075	29.0988	29.0675	29.095	2221452.0
2016-12-23 13:00:00	AAPL	Stock	29.0928	29.12	29.09	29.095	2983764.0
2016-12-23 13:30:00	AAPL	Stock	29.0938	29.1012	29.0775	29.0862	1528564.0
2016-12-23 14:00:00	AAPL	Stock	29.086	29.0925	29.07	29.0775	1654492.0
2016-12-23 14:30:00	AAPL	Stock	29.0785	29.1012	29.07	29.1	2180864.0
2016-12-23 15:00:00	AAPL	Stock	29.0988	29.11	29.0875	29.0962	2694596.0
2016-12-23 15:30:00	AAPL	Stock	29.0975	29.13	29.08	29.1275	6354772.0
2016-12-23 16:00:00	AAPL	Stock	29.13	29.14	29.0875	29.115	4273416.0
2016-12-23 16:30:00	AAPL	Stock	29.125	29.1375	29.1	29.125	34916.0
2016-12-23 17:00:00	AAPL	Stock	29.13	29.13	29.1225	29.1225	7884.0
2016-12-23 17:30:00	AAPL	Stock	29.1225	29.13	29.1225	29.13	1720.0
2016-12-23 18:30:00	AAPL	Stock	29.1275	29.1275	29.1275	29.1275	400.0
2016-12-23 19:00:00	AAPL	Stock	29.13	29.13	29.13	29.13	8700.0
2016-12-23 19:30:00	AAPL	Stock	29.125	29.1375	29.125	29.1375	7116.0
2016-12-23 07:00:00	MSFT	Stock	63.55	63.55	63.55	63.55	699.0
2016-12-23 07:30:00	MSFT	Stock	63.55	63.55	63.55	63.55	100.0
2016-12-23 08:00:00	MSFT	Stock	63.6	63.63	63.55	63.55	822.0
2016-12-23 08:30:00	MSFT	Stock	63.5	63.63	63.5	63.63	5148.0
2016-12-23 09:00:00	MSFT	Stock	63.55	63.55	63.41	63.51	5158.0
2016-12-23 09:30:00	MSFT	Stock	63.52	63.54	63.1	63.27	1802787.0
2016-12-23 10:00:00	MSFT	Stock	63.27	63.295	63.065	63.071	830576.0
2016-12-23 10:30:00	MSFT	Stock	63.07	63.12	62.93	62.96	811197.0
2016-12-23 11:00:00	MSFT	Stock	62.967	63.02	62.841	62.845	968161.0
2016-12-23 11:30:00	MSFT	Stock	62.85	62.89	62.8	62.87	590727.0
2016-12-23 12:00:00	MSFT	Stock	62.865	63.01	62.865	63.0	502610.0
2016-12-23 12:30:00	MSFT	Stock	62.99	63.005	62.91	62.93	475702.0
2016-12-23 13:00:00	MSFT	Stock	62.925	63.02	62.92	63.0	498777.0
2016-12-23 13:30:00	MSFT	Stock	63.0	63.03	62.93	62.941	457944.0
2016-12-23 14:00:00	MSFT	Stock	62.94	62.98	62.92	62.96	440016.0
2016-12-23 14:30:00	MSFT	Stock	62.96	63.04	62.94	63.035	434850.0
2016-12-23 15:00:00	MSFT	Stock	63.036	63.17	63.034	63.125	605917.0
2016-12-23 15:30:00	MSFT	Stock	63.125	63.25	63.12	63.24	1762316.0
2016-12-23 16:00:00	MSFT	Stock	63.23	63.24	63.14	63.22	1393610.0
2016-12-23 17:00:00	MSFT	Stock	63.24	63.24	63.24	63.24	1500.0
2016-12-23 17:30:00	MSFT	Stock	63.23	63.23	63.22	63.22	1400.0
2016-12-23 18:30:00	MSFT	Stock	63.24	63.24	63.24	63.24	400.0
2016-12-23 19:00:00	MSFT	Stock	63.27	63.27	63.24	63.24	1026.0

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

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