PREVIEW / stock_30min / 2016-12-30

all stock 30-min files

  file:    by_date/stock_30min/2016/2016-12-30.parquet
  size:    1.6 MB
  rows:    82,303
  symbols: 3,165

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-30 04:00:00	AAPL	Stock	29.25	29.25	29.25	29.25	7960.0
2016-12-30 05:30:00	AAPL	Stock	29.2	29.2	29.2	29.2	800.0
2016-12-30 06:00:00	AAPL	Stock	29.2	29.2	29.12	29.12	10000.0
2016-12-30 06:30:00	AAPL	Stock	29.2	29.2375	29.2	29.235	7204.0
2016-12-30 07:00:00	AAPL	Stock	29.24	29.275	29.2275	29.275	29380.0
2016-12-30 07:30:00	AAPL	Stock	29.285	29.3225	29.27	29.27	6956.0
2016-12-30 08:00:00	AAPL	Stock	29.2775	29.28	29.2575	29.2575	40472.0
2016-12-30 08:30:00	AAPL	Stock	29.25	29.25	29.215	29.215	42328.0
2016-12-30 09:00:00	AAPL	Stock	29.22	29.22	29.155	29.165	153592.0
2016-12-30 09:30:00	AAPL	Stock	29.1625	29.3	29.0225	29.05	12615128.0
2016-12-30 10:00:00	AAPL	Stock	29.05	29.1075	29.0175	29.0452	6412184.0
2016-12-30 10:30:00	AAPL	Stock	29.045	29.0825	29.01	29.0522	4874156.0
2016-12-30 11:00:00	AAPL	Stock	29.05	29.11	29.0425	29.101	3854348.0
2016-12-30 11:30:00	AAPL	Stock	29.1005	29.135	29.08	29.085	3181240.0
2016-12-30 12:00:00	AAPL	Stock	29.0825	29.0875	28.8928	28.9725	12503280.0
2016-12-30 12:30:00	AAPL	Stock	28.9725	29.0	28.8975	28.9288	6150924.0
2016-12-30 13:00:00	AAPL	Stock	28.9285	28.985	28.865	28.9575	7125388.0
2016-12-30 13:30:00	AAPL	Stock	28.955	28.97	28.89	28.915	4471316.0
2016-12-30 14:00:00	AAPL	Stock	28.915	28.93	28.885	28.8925	4102148.0
2016-12-30 14:30:00	AAPL	Stock	28.8938	28.93	28.8675	28.89	5466528.0
2016-12-30 15:00:00	AAPL	Stock	28.89	28.9375	28.885	28.9375	6145432.0
2016-12-30 15:30:00	AAPL	Stock	28.9375	28.9975	28.8575	28.96	16103736.0
2016-12-30 16:00:00	AAPL	Stock	28.975	29.0832	28.9025	28.9575	18290304.0
2016-12-30 16:30:00	AAPL	Stock	28.9575	28.9625	28.935	28.9375	778436.0
2016-12-30 17:00:00	AAPL	Stock	28.9375	28.9375	28.925	28.925	31200.0
2016-12-30 17:30:00	AAPL	Stock	28.925	28.9275	28.9075	28.915	13884.0
2016-12-30 18:00:00	AAPL	Stock	28.925	28.925	28.915	28.9225	30092.0
2016-12-30 18:30:00	AAPL	Stock	28.9175	28.9175	28.88	28.88	7696.0
2016-12-30 19:00:00	AAPL	Stock	28.9	28.9	28.8675	28.875	11944.0
2016-12-30 19:30:00	AAPL	Stock	28.875	28.9	28.8675	28.8975	37560.0
2016-12-30 07:00:00	MSFT	Stock	62.73	62.73	62.73	62.73	202.0
2016-12-30 07:30:00	MSFT	Stock	62.99	62.99	62.99	62.99	106.0
2016-12-30 08:00:00	MSFT	Stock	62.99	62.99	62.99	62.99	300.0
2016-12-30 08:30:00	MSFT	Stock	62.99	62.99	62.98	62.98	1190.0
2016-12-30 09:00:00	MSFT	Stock	62.91	62.98	62.91	62.98	9244.0
2016-12-30 09:30:00	MSFT	Stock	62.98	62.99	62.29	62.3	2259034.0
2016-12-30 10:00:00	MSFT	Stock	62.29	62.34	62.03	62.09	1561087.0
2016-12-30 10:30:00	MSFT	Stock	62.09	62.31	62.08	62.3	1098773.0
2016-12-30 11:00:00	MSFT	Stock	62.29	62.38	62.2	62.325	644787.0
2016-12-30 11:30:00	MSFT	Stock	62.32	62.42	62.28	62.335	616055.0
2016-12-30 12:00:00	MSFT	Stock	62.335	62.46	62.22	62.38	1078582.0
2016-12-30 12:30:00	MSFT	Stock	62.38	62.42	62.2	62.336	1088989.0
2016-12-30 13:00:00	MSFT	Stock	62.336	62.385	62.26	62.33	654355.0
2016-12-30 13:30:00	MSFT	Stock	62.325	62.35	62.19	62.21	505454.0
2016-12-30 14:00:00	MSFT	Stock	62.21	62.25	62.15	62.19	1060390.0
2016-12-30 14:30:00	MSFT	Stock	62.19	62.27	62.105	62.16	1012172.0
2016-12-30 15:00:00	MSFT	Stock	62.155	62.28	62.11	62.28	901794.0
2016-12-30 15:30:00	MSFT	Stock	62.28	62.3	62.05	62.15	5002216.0
2016-12-30 16:00:00	MSFT	Stock	62.15	62.2	62.14	62.14	6233183.0
2016-12-30 16:30:00	MSFT	Stock	62.1	62.14	62.02	62.14	37894.0

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

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