PREVIEW / stock_30min / 2017-02-23

all stock 30-min files

  file:    by_date/stock_30min/2017/2017-02-23.parquet
  size:    1.6 MB
  rows:    82,034
  symbols: 3,086

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-02-23 05:00:00	AAPL	Stock	34.29	34.29	34.29	34.29	3600.0
2017-02-23 05:30:00	AAPL	Stock	34.3175	34.3175	34.3175	34.3175	604.0
2017-02-23 06:00:00	AAPL	Stock	34.29	34.3	34.2875	34.2875	2644.0
2017-02-23 07:00:00	AAPL	Stock	34.3375	34.3375	34.335	34.3375	8600.0
2017-02-23 07:30:00	AAPL	Stock	34.34	34.3425	34.32	34.32	26584.0
2017-02-23 08:00:00	AAPL	Stock	34.3175	34.3375	34.31	34.325	91384.0
2017-02-23 08:30:00	AAPL	Stock	34.3375	34.3425	34.3	34.3075	92944.0
2017-02-23 09:00:00	AAPL	Stock	34.3075	34.375	34.305	34.345	124556.0
2017-02-23 09:30:00	AAPL	Stock	34.345	34.37	34.1725	34.2675	13758452.0
2017-02-23 10:00:00	AAPL	Stock	34.2688	34.2975	34.1388	34.1825	8613932.0
2017-02-23 10:30:00	AAPL	Stock	34.1825	34.251	34.0925	34.0975	6645252.0
2017-02-23 11:00:00	AAPL	Stock	34.0982	34.135	34.075	34.1125	7346392.0
2017-02-23 11:30:00	AAPL	Stock	34.11	34.1925	34.11	34.15	4593628.0
2017-02-23 12:00:00	AAPL	Stock	34.15	34.185	34.115	34.1675	3826796.0
2017-02-23 12:30:00	AAPL	Stock	34.1675	34.1875	34.155	34.1725	2225068.0
2017-02-23 13:00:00	AAPL	Stock	34.1725	34.185	34.14	34.14	1748264.0
2017-02-23 13:30:00	AAPL	Stock	34.14	34.2125	34.14	34.1925	2144752.0
2017-02-23 14:00:00	AAPL	Stock	34.19	34.2025	34.15	34.19	2685832.0
2017-02-23 14:30:00	AAPL	Stock	34.1888	34.2325	34.18	34.2062	2447248.0
2017-02-23 15:00:00	AAPL	Stock	34.205	34.2225	34.1765	34.1765	2636440.0
2017-02-23 15:30:00	AAPL	Stock	34.175	34.1925	34.095	34.1325	9223948.0
2017-02-23 16:00:00	AAPL	Stock	34.125	34.15	34.115	34.135	5953632.0
2017-02-23 16:30:00	AAPL	Stock	34.1325	34.15	34.125	34.1325	130704.0
2017-02-23 17:00:00	AAPL	Stock	34.1425	34.1425	34.1175	34.1325	79408.0
2017-02-23 17:30:00	AAPL	Stock	34.125	34.125	34.1175	34.12	4836.0
2017-02-23 18:00:00	AAPL	Stock	34.12	34.12	34.1	34.1	9424.0
2017-02-23 18:30:00	AAPL	Stock	34.1	34.1125	34.095	34.1125	6980.0
2017-02-23 19:00:00	AAPL	Stock	34.095	34.115	34.0925	34.115	7112.0
2017-02-23 19:30:00	AAPL	Stock	34.1	34.1125	34.1	34.1125	20584.0
2017-02-23 05:00:00	MSFT	Stock	64.35	64.35	64.35	64.35	308.0
2017-02-23 05:30:00	MSFT	Stock	64.35	64.35	64.35	64.35	209.0
2017-02-23 06:00:00	MSFT	Stock	64.35	64.35	64.35	64.35	1983.0
2017-02-23 08:00:00	MSFT	Stock	64.4	64.4	64.3	64.3	1011.0
2017-02-23 08:30:00	MSFT	Stock	64.3	64.33	64.3	64.3	1132.0
2017-02-23 09:00:00	MSFT	Stock	64.33	64.52	64.25	64.41	24882.0
2017-02-23 09:30:00	MSFT	Stock	64.42	64.45	64.25	64.34	1926245.0
2017-02-23 10:00:00	MSFT	Stock	64.34	64.38	64.22	64.33	1295014.0
2017-02-23 10:30:00	MSFT	Stock	64.325	64.38	64.21	64.31	1741924.0
2017-02-23 11:00:00	MSFT	Stock	64.31	64.34	64.195	64.32	1184446.0
2017-02-23 11:30:00	MSFT	Stock	64.32	64.53	64.32	64.44	882159.0
2017-02-23 12:00:00	MSFT	Stock	64.435	64.61	64.42	64.58	977175.0
2017-02-23 12:30:00	MSFT	Stock	64.585	64.62	64.5	64.53	612910.0
2017-02-23 13:00:00	MSFT	Stock	64.53	64.58	64.43	64.445	561363.0
2017-02-23 13:30:00	MSFT	Stock	64.445	64.58	64.44	64.55	662239.0
2017-02-23 14:00:00	MSFT	Stock	64.545	64.59	64.48	64.573	703872.0
2017-02-23 14:30:00	MSFT	Stock	64.58	64.69	64.55	64.65	886409.0
2017-02-23 15:00:00	MSFT	Stock	64.65	64.728	64.61	64.61	1412428.0
2017-02-23 15:30:00	MSFT	Stock	64.61	64.635	64.49	64.62	3826557.0
2017-02-23 16:00:00	MSFT	Stock	64.62	64.62	64.46	64.47	1893613.0
2017-02-23 16:30:00	MSFT	Stock	64.47	64.62	64.46	64.49	18376.0

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

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