PREVIEW / stock_30min / 2017-08-15

all stock 30-min files

  file:    by_date/stock_30min/2017/2017-08-15.parquet
  size:    1.6 MB
  rows:    80,228
  symbols: 2,990

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-08-15 04:00:00	AAPL	Stock	40.0825	40.0875	40.0825	40.0875	4616.0
2017-08-15 05:30:00	AAPL	Stock	40.0275	40.0275	40.0275	40.0275	800.0
2017-08-15 06:00:00	AAPL	Stock	40.0825	40.0875	40.03	40.03	11692.0
2017-08-15 06:30:00	AAPL	Stock	40.04	40.0875	40.0375	40.0875	11516.0
2017-08-15 07:00:00	AAPL	Stock	40.0925	40.175	40.0925	40.1375	39284.0
2017-08-15 07:30:00	AAPL	Stock	40.15	40.1575	40.075	40.1225	48424.0
2017-08-15 08:00:00	AAPL	Stock	40.125	40.175	40.1125	40.1275	283468.0
2017-08-15 08:30:00	AAPL	Stock	40.1275	40.215	40.1125	40.2	235092.0
2017-08-15 09:00:00	AAPL	Stock	40.2	40.2425	40.1425	40.1775	299704.0
2017-08-15 09:30:00	AAPL	Stock	40.165	40.2925	40.035	40.186	14711944.0
2017-08-15 10:00:00	AAPL	Stock	40.185	40.2525	40.1025	40.2485	8940476.0
2017-08-15 10:30:00	AAPL	Stock	40.2475	40.335	40.165	40.3	8080636.0
2017-08-15 11:00:00	AAPL	Stock	40.3	40.3675	40.2375	40.366	6097540.0
2017-08-15 11:30:00	AAPL	Stock	40.365	40.4125	40.3035	40.3188	6488788.0
2017-08-15 12:00:00	AAPL	Stock	40.3188	40.4225	40.3052	40.3775	4883504.0
2017-08-15 12:30:00	AAPL	Stock	40.3792	40.545	40.375	40.5388	9880664.0
2017-08-15 13:00:00	AAPL	Stock	40.5388	40.5488	40.4325	40.4975	6710640.0
2017-08-15 13:30:00	AAPL	Stock	40.495	40.5175	40.365	40.4075	7232112.0
2017-08-15 14:00:00	AAPL	Stock	40.405	40.47	40.3962	40.455	4731260.0
2017-08-15 14:30:00	AAPL	Stock	40.4525	40.4625	40.375	40.4125	3720332.0
2017-08-15 15:00:00	AAPL	Stock	40.411	40.4875	40.3975	40.445	7104464.0
2017-08-15 15:30:00	AAPL	Stock	40.4425	40.505	40.385	40.41	9285184.0
2017-08-15 16:00:00	AAPL	Stock	40.4	40.4225	40.3825	40.4	5262584.0
2017-08-15 16:30:00	AAPL	Stock	40.405	40.415	40.375	40.375	493616.0
2017-08-15 17:00:00	AAPL	Stock	40.41	40.41	40.3825	40.3825	1104.0
2017-08-15 17:30:00	AAPL	Stock	40.39	40.4125	40.3875	40.4125	31712.0
2017-08-15 18:00:00	AAPL	Stock	40.415	40.415	40.4	40.415	102192.0
2017-08-15 18:30:00	AAPL	Stock	40.4125	40.4125	40.375	40.3975	151504.0
2017-08-15 19:00:00	AAPL	Stock	40.3925	40.395	40.3775	40.3825	8640.0
2017-08-15 19:30:00	AAPL	Stock	40.355	40.375	40.35	40.35	12684.0
2017-08-15 04:30:00	MSFT	Stock	73.4	73.4	73.4	73.4	1459.0
2017-08-15 06:00:00	MSFT	Stock	73.52	73.52	73.5	73.5	897.0
2017-08-15 07:00:00	MSFT	Stock	73.3	73.45	73.3	73.45	300.0
2017-08-15 07:30:00	MSFT	Stock	73.4	73.45	73.4	73.45	489.0
2017-08-15 08:00:00	MSFT	Stock	73.5	73.5	73.4	73.41	14240.0
2017-08-15 08:30:00	MSFT	Stock	73.41	73.43	73.32	73.41	10559.0
2017-08-15 09:00:00	MSFT	Stock	73.35	73.58	73.35	73.58	5014.0
2017-08-15 09:30:00	MSFT	Stock	73.59	73.59	73.103	73.33	1793069.0
2017-08-15 10:00:00	MSFT	Stock	73.32	73.4	73.04	73.24	1169226.0
2017-08-15 10:30:00	MSFT	Stock	73.25	73.32	73.1	73.23	677715.0
2017-08-15 11:00:00	MSFT	Stock	73.23	73.325	73.165	73.32	738019.0
2017-08-15 11:30:00	MSFT	Stock	73.32	73.37	73.07	73.085	794286.0
2017-08-15 12:00:00	MSFT	Stock	73.091	73.19	73.075	73.179	512468.0
2017-08-15 12:30:00	MSFT	Stock	73.175	73.275	73.15	73.19	472992.0
2017-08-15 13:00:00	MSFT	Stock	73.2	73.2	73.04	73.12	546620.0
2017-08-15 13:30:00	MSFT	Stock	73.11	73.14	73.05	73.13	561568.0
2017-08-15 14:00:00	MSFT	Stock	73.12	73.21	73.11	73.2	488204.0
2017-08-15 14:30:00	MSFT	Stock	73.2	73.24	73.15	73.18	431370.0
2017-08-15 15:00:00	MSFT	Stock	73.19	73.33	73.185	73.29	749448.0
2017-08-15 15:30:00	MSFT	Stock	73.295	73.41	73.2	73.23	2030547.0

> showing 50 of 80,228 rows — these rows as CSV

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