PREVIEW / stock_30min / 2017-07-17

all stock 30-min files

  file:    by_date/stock_30min/2017/2017-07-17.parquet
  size:    1.6 MB
  rows:    80,776
  symbols: 3,005

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-07-17 04:00:00	AAPL	Stock	37.3	37.3	37.3	37.3	2400.0
2017-07-17 05:00:00	AAPL	Stock	37.275	37.275	37.2625	37.275	5712.0
2017-07-17 05:30:00	AAPL	Stock	37.305	37.31	37.305	37.31	1480.0
2017-07-17 06:00:00	AAPL	Stock	37.325	37.3875	37.31	37.375	24280.0
2017-07-17 07:00:00	AAPL	Stock	37.375	37.3825	37.3375	37.3375	30872.0
2017-07-17 07:30:00	AAPL	Stock	37.35	37.3575	37.275	37.3225	70040.0
2017-07-17 08:00:00	AAPL	Stock	37.3025	37.4	37.275	37.2975	163356.0
2017-07-17 08:30:00	AAPL	Stock	37.2975	37.3	37.23	37.2575	155760.0
2017-07-17 09:00:00	AAPL	Stock	37.2575	37.2625	37.2	37.215	182088.0
2017-07-17 09:30:00	AAPL	Stock	37.205	37.675	37.1425	37.653	18842804.0
2017-07-17 10:00:00	AAPL	Stock	37.6552	37.725	37.5425	37.5625	11012804.0
2017-07-17 10:30:00	AAPL	Stock	37.565	37.595	37.475	37.4988	6652944.0
2017-07-17 11:00:00	AAPL	Stock	37.5	37.5375	37.45	37.515	6036252.0
2017-07-17 11:30:00	AAPL	Stock	37.5175	37.5388	37.385	37.4025	3767372.0
2017-07-17 12:00:00	AAPL	Stock	37.4	37.51	37.38	37.4675	3528700.0
2017-07-17 12:30:00	AAPL	Stock	37.47	37.5325	37.455	37.515	2419504.0
2017-07-17 13:00:00	AAPL	Stock	37.5175	37.5325	37.4925	37.4938	2660412.0
2017-07-17 13:30:00	AAPL	Stock	37.4935	37.5125	37.3975	37.4225	3218388.0
2017-07-17 14:00:00	AAPL	Stock	37.4238	37.4475	37.36	37.3825	3305076.0
2017-07-17 14:30:00	AAPL	Stock	37.3825	37.425	37.3575	37.41	3008776.0
2017-07-17 15:00:00	AAPL	Stock	37.415	37.44	37.3925	37.4075	2702588.0
2017-07-17 15:30:00	AAPL	Stock	37.4078	37.475	37.375	37.4	7718180.0
2017-07-17 16:00:00	AAPL	Stock	37.4	37.4625	37.39	37.435	7450856.0
2017-07-17 16:30:00	AAPL	Stock	37.4375	37.4425	37.39	37.4375	67908.0
2017-07-17 17:00:00	AAPL	Stock	37.435	37.455	37.425	37.455	48028.0
2017-07-17 17:30:00	AAPL	Stock	37.455	37.4625	37.43	37.445	15020.0
2017-07-17 18:00:00	AAPL	Stock	37.4375	37.4625	37.425	37.4325	12348.0
2017-07-17 18:30:00	AAPL	Stock	37.45	37.465	37.4375	37.465	12264.0
2017-07-17 19:00:00	AAPL	Stock	37.4525	37.4675	37.445	37.445	24184.0
2017-07-17 19:30:00	AAPL	Stock	37.4675	37.4725	37.4375	37.4375	32316.0
2017-07-17 04:00:00	MSFT	Stock	72.98	72.98	72.98	72.98	340.0
2017-07-17 05:00:00	MSFT	Stock	72.89	72.89	72.82	72.88	4935.0
2017-07-17 05:30:00	MSFT	Stock	72.8	72.8	72.8	72.8	902.0
2017-07-17 06:30:00	MSFT	Stock	72.82	72.95	72.82	72.95	300.0
2017-07-17 07:00:00	MSFT	Stock	72.88	72.98	72.88	72.98	1656.0
2017-07-17 07:30:00	MSFT	Stock	72.98	73.08	72.98	73.02	1184.0
2017-07-17 08:00:00	MSFT	Stock	73.0	73.13	73.0	73.12	11075.0
2017-07-17 08:30:00	MSFT	Stock	73.03	73.09	72.98	73.08	15938.0
2017-07-17 09:00:00	MSFT	Stock	73.07	73.1	72.8	72.8	23813.0
2017-07-17 09:30:00	MSFT	Stock	72.8	72.97	72.72	72.84	2471437.0
2017-07-17 10:00:00	MSFT	Stock	72.85	73.23	72.84	73.01	1671206.0
2017-07-17 10:30:00	MSFT	Stock	73.02	73.08	72.9	72.985	1837244.0
2017-07-17 11:00:00	MSFT	Stock	72.99	73.05	72.84	73.0	1305476.0
2017-07-17 11:30:00	MSFT	Stock	73.0	73.02	72.88	72.98	1113502.0
2017-07-17 12:00:00	MSFT	Stock	72.979	73.16	72.87	73.12	1568726.0
2017-07-17 12:30:00	MSFT	Stock	73.125	73.31	73.12	73.255	929382.0
2017-07-17 13:00:00	MSFT	Stock	73.255	73.3	73.15	73.15	738780.0
2017-07-17 13:30:00	MSFT	Stock	73.15	73.18	72.95	73.025	837363.0
2017-07-17 14:00:00	MSFT	Stock	73.025	73.16	72.99	73.15	838540.0
2017-07-17 14:30:00	MSFT	Stock	73.145	73.21	73.11	73.17	836106.0

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

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