PREVIEW / stock_30min / 2016-08-30

all stock 30-min files

  file:    by_date/stock_30min/2016/2016-08-30.parquet
  size:    1.6 MB
  rows:    80,927
  symbols: 3,260

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-08-30 04:00:00	AAPL	Stock	26.6475	26.6475	26.6225	26.6275	2000.0
2016-08-30 04:30:00	AAPL	Stock	26.6225	26.6225	26.61	26.61	2400.0
2016-08-30 05:00:00	AAPL	Stock	26.5825	26.5875	26.5525	26.5875	9880.0
2016-08-30 05:30:00	AAPL	Stock	26.575	26.575	26.2675	26.27	77084.0
2016-08-30 06:00:00	AAPL	Stock	26.2675	26.3	25.875	26.19	625664.0
2016-08-30 06:30:00	AAPL	Stock	26.225	26.2625	26.19	26.225	180384.0
2016-08-30 07:00:00	AAPL	Stock	26.23	26.275	26.1325	26.22	309536.0
2016-08-30 07:30:00	AAPL	Stock	26.215	26.3975	26.2125	26.33	345568.0
2016-08-30 08:00:00	AAPL	Stock	26.3375	26.47	26.025	26.425	920140.0
2016-08-30 08:30:00	AAPL	Stock	26.425	26.4625	26.37	26.445	552788.0
2016-08-30 09:00:00	AAPL	Stock	26.4475	26.705	26.3875	26.44	1491128.0
2016-08-30 09:30:00	AAPL	Stock	26.45	26.625	26.375	26.5485	22678952.0
2016-08-30 10:00:00	AAPL	Stock	26.5525	26.5675	26.48	26.4855	8882004.0
2016-08-30 10:30:00	AAPL	Stock	26.485	26.5125	26.435	26.5	7550348.0
2016-08-30 11:00:00	AAPL	Stock	26.4975	26.5588	26.49	26.5125	6043912.0
2016-08-30 11:30:00	AAPL	Stock	26.5135	26.54	26.485	26.5075	3473624.0
2016-08-30 12:00:00	AAPL	Stock	26.5075	26.5575	26.505	26.51	3628064.0
2016-08-30 12:30:00	AAPL	Stock	26.51	26.5362	26.4875	26.4975	2947860.0
2016-08-30 13:00:00	AAPL	Stock	26.4975	26.5075	26.4588	26.46	2959736.0
2016-08-30 13:30:00	AAPL	Stock	26.46	26.485	26.4275	26.45	3955288.0
2016-08-30 14:00:00	AAPL	Stock	26.4475	26.4475	26.395	26.42	4236892.0
2016-08-30 14:30:00	AAPL	Stock	26.4208	26.475	26.3925	26.4588	4116160.0
2016-08-30 15:00:00	AAPL	Stock	26.46	26.4825	26.4425	26.4625	3649792.0
2016-08-30 15:30:00	AAPL	Stock	26.465	26.5	26.4325	26.4975	8696584.0
2016-08-30 16:00:00	AAPL	Stock	26.5	26.5	26.48	26.495	4682688.0
2016-08-30 16:30:00	AAPL	Stock	26.4975	26.5	26.472	26.5	157432.0
2016-08-30 17:00:00	AAPL	Stock	26.4975	26.5075	26.4975	26.505	16000.0
2016-08-30 17:30:00	AAPL	Stock	26.51	26.5175	26.5	26.515	130912.0
2016-08-30 18:00:00	AAPL	Stock	26.515	26.515	26.505	26.5075	6000.0
2016-08-30 18:30:00	AAPL	Stock	26.5075	26.5075	26.5	26.5	11216.0
2016-08-30 19:00:00	AAPL	Stock	26.5	26.5	26.48	26.48	17328.0
2016-08-30 19:30:00	AAPL	Stock	26.4825	26.5075	26.48	26.4975	12528.0
2016-08-30 06:00:00	MSFT	Stock	58.1	58.1	58.1	58.1	5023.0
2016-08-30 07:00:00	MSFT	Stock	58.08	58.08	58.08	58.08	100.0
2016-08-30 07:30:00	MSFT	Stock	58.05	58.05	58.05	58.05	266.0
2016-08-30 08:00:00	MSFT	Stock	58.1	58.1	58.1	58.1	4000.0
2016-08-30 08:30:00	MSFT	Stock	58.1	58.1	58.05	58.1	3654.0
2016-08-30 09:00:00	MSFT	Stock	58.1	58.1	58.02	58.02	8520.0
2016-08-30 09:30:00	MSFT	Stock	57.98	58.19	57.95	58.1	2015500.0
2016-08-30 10:00:00	MSFT	Stock	58.1	58.19	57.78	57.95	1266371.0
2016-08-30 10:30:00	MSFT	Stock	57.94	57.95	57.73	57.82	1062704.0
2016-08-30 11:00:00	MSFT	Stock	57.81	57.88	57.715	57.77	979723.0
2016-08-30 11:30:00	MSFT	Stock	57.765	57.8	57.7	57.765	861765.0
2016-08-30 12:00:00	MSFT	Stock	57.77	57.88	57.77	57.83	583661.0
2016-08-30 12:30:00	MSFT	Stock	57.83	57.9	57.8	57.82	561821.0
2016-08-30 13:00:00	MSFT	Stock	57.813	57.89	57.78	57.83	530654.0
2016-08-30 13:30:00	MSFT	Stock	57.825	57.84	57.75	57.815	524368.0
2016-08-30 14:00:00	MSFT	Stock	57.805	57.81	57.65	57.665	852543.0
2016-08-30 14:30:00	MSFT	Stock	57.665	57.73	57.61	57.72	1002298.0
2016-08-30 15:00:00	MSFT	Stock	57.73	57.81	57.66	57.775	935035.0

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

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