PREVIEW / stock_30min / 2017-04-11

all stock 30-min files

  file:    by_date/stock_30min/2017/2017-04-11.parquet
  size:    1.6 MB
  rows:    82,030
  symbols: 3,066

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-04-11 05:30:00	AAPL	Stock	35.725	35.725	35.7025	35.725	10940.0
2017-04-11 06:00:00	AAPL	Stock	35.75	35.75	35.75	35.75	1200.0
2017-04-11 06:30:00	AAPL	Stock	35.7625	35.775	35.75	35.7525	4048.0
2017-04-11 07:00:00	AAPL	Stock	35.775	35.775	35.755	35.775	10520.0
2017-04-11 07:30:00	AAPL	Stock	35.775	35.775	35.7725	35.775	13164.0
2017-04-11 08:00:00	AAPL	Stock	35.775	35.81	35.75	35.75	65036.0
2017-04-11 08:30:00	AAPL	Stock	35.7525	35.8	35.7525	35.795	58856.0
2017-04-11 09:00:00	AAPL	Stock	35.775	35.7875	35.705	35.725	88252.0
2017-04-11 09:30:00	AAPL	Stock	35.735	35.8375	35.4182	35.505	14962936.0
2017-04-11 10:00:00	AAPL	Stock	35.5062	35.525	35.125	35.2358	16335964.0
2017-04-11 10:30:00	AAPL	Stock	35.2345	35.277	35.015	35.2722	15830368.0
2017-04-11 11:00:00	AAPL	Stock	35.2725	35.325	35.16	35.2175	7577452.0
2017-04-11 11:30:00	AAPL	Stock	35.215	35.3225	35.2038	35.2075	5470140.0
2017-04-11 12:00:00	AAPL	Stock	35.2075	35.3675	35.1825	35.33	5276556.0
2017-04-11 12:30:00	AAPL	Stock	35.33	35.4825	35.3025	35.4475	5193204.0
2017-04-11 13:00:00	AAPL	Stock	35.445	35.5375	35.445	35.5	4546356.0
2017-04-11 13:30:00	AAPL	Stock	35.5025	35.5325	35.39	35.4288	4185832.0
2017-04-11 14:00:00	AAPL	Stock	35.43	35.4675	35.3775	35.4165	3213956.0
2017-04-11 14:30:00	AAPL	Stock	35.4172	35.49	35.375	35.465	4289588.0
2017-04-11 15:00:00	AAPL	Stock	35.465	35.47	35.25	35.3025	5937584.0
2017-04-11 15:30:00	AAPL	Stock	35.3	35.4075	35.28	35.405	12391520.0
2017-04-11 16:00:00	AAPL	Stock	35.4075	35.427	35.35	35.3975	4632516.0
2017-04-11 16:30:00	AAPL	Stock	35.3975	35.4075	35.35	35.35	241484.0
2017-04-11 17:00:00	AAPL	Stock	35.365	35.375	35.34	35.37	22476.0
2017-04-11 17:30:00	AAPL	Stock	35.365	35.3725	35.34	35.34	8000.0
2017-04-11 18:00:00	AAPL	Stock	35.34	35.375	35.34	35.3525	27160.0
2017-04-11 18:30:00	AAPL	Stock	35.35	35.375	35.3425	35.35	24508.0
2017-04-11 19:00:00	AAPL	Stock	35.3525	35.3725	35.34	35.34	16924.0
2017-04-11 19:30:00	AAPL	Stock	35.34	35.3725	35.3275	35.3725	29924.0
2017-04-11 04:30:00	MSFT	Stock	65.55	65.55	65.55	65.55	100.0
2017-04-11 06:30:00	MSFT	Stock	65.77	65.77	65.77	65.77	127.0
2017-04-11 08:00:00	MSFT	Stock	65.55	65.55	65.55	65.55	2573.0
2017-04-11 09:00:00	MSFT	Stock	65.6	65.6	65.4	65.44	31567.0
2017-04-11 09:30:00	MSFT	Stock	65.6	65.61	65.1	65.23	2124174.0
2017-04-11 10:00:00	MSFT	Stock	65.24	65.42	65.04	65.14	1653190.0
2017-04-11 10:30:00	MSFT	Stock	65.135	65.138	64.85	64.99	2225129.0
2017-04-11 11:00:00	MSFT	Stock	64.99	65.21	64.95	65.095	1556842.0
2017-04-11 11:30:00	MSFT	Stock	65.09	65.28	65.08	65.18	870692.0
2017-04-11 12:00:00	MSFT	Stock	65.18	65.44	65.13	65.42	973119.0
2017-04-11 12:30:00	MSFT	Stock	65.424	65.51	65.36	65.48	830344.0
2017-04-11 13:00:00	MSFT	Stock	65.48	65.61	65.47	65.55	722671.0
2017-04-11 13:30:00	MSFT	Stock	65.545	65.579	65.34	65.39	696395.0
2017-04-11 14:00:00	MSFT	Stock	65.39	65.47	65.31	65.34	589613.0
2017-04-11 14:30:00	MSFT	Stock	65.356	65.49	65.32	65.4	727517.0
2017-04-11 15:00:00	MSFT	Stock	65.4	65.42	65.2	65.325	891499.0
2017-04-11 15:30:00	MSFT	Stock	65.325	65.5	65.27	65.5	2067922.0
2017-04-11 16:00:00	MSFT	Stock	65.48	65.48	65.332	65.48	1288301.0
2017-04-11 16:30:00	MSFT	Stock	65.48	65.48	65.48	65.48	44885.0
2017-04-11 17:00:00	MSFT	Stock	65.48	65.55	65.48	65.55	2693.0
2017-04-11 17:30:00	MSFT	Stock	65.48	65.5	65.48	65.48	2509.0

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

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