PREVIEW / stock_30min / 2018-12-13

all stock 30-min files

  file:    by_date/stock_30min/2018/2018-12-13.parquet
  size:    1.7 MB
  rows:    83,222
  symbols: 2,725

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
2018-12-13 04:00:00	AAPL	Stock	42.625	42.625	42.45	42.475	9364.0
2018-12-13 04:30:00	AAPL	Stock	42.55	42.55	42.5475	42.5475	2136.0
2018-12-13 05:00:00	AAPL	Stock	42.55	42.55	42.55	42.55	800.0
2018-12-13 05:30:00	AAPL	Stock	42.55	42.55	42.51	42.51	4768.0
2018-12-13 06:00:00	AAPL	Stock	42.475	42.475	42.4	42.425	11700.0
2018-12-13 06:30:00	AAPL	Stock	42.475	42.475	42.355	42.355	3776.0
2018-12-13 07:00:00	AAPL	Stock	42.375	42.4875	42.365	42.4725	53880.0
2018-12-13 07:30:00	AAPL	Stock	42.4675	42.4875	42.405	42.4475	43420.0
2018-12-13 08:00:00	AAPL	Stock	42.4125	42.6575	42.375	42.625	322612.0
2018-12-13 08:30:00	AAPL	Stock	42.605	42.625	42.4625	42.5175	246472.0
2018-12-13 09:00:00	AAPL	Stock	42.525	42.6475	42.475	42.5775	234712.0
2018-12-13 09:30:00	AAPL	Stock	42.6225	42.7422	42.3875	42.595	13034708.0
2018-12-13 10:00:00	AAPL	Stock	42.6025	43.1425	42.5955	42.9925	15857012.0
2018-12-13 10:30:00	AAPL	Stock	42.9875	43.0675	42.6298	42.8675	12324700.0
2018-12-13 11:00:00	AAPL	Stock	42.865	42.91	42.645	42.8045	8234388.0
2018-12-13 11:30:00	AAPL	Stock	42.7975	43.0575	42.75	42.8288	7254532.0
2018-12-13 12:00:00	AAPL	Stock	42.8225	42.875	42.5475	42.5875	6511108.0
2018-12-13 12:30:00	AAPL	Stock	42.5775	42.7775	42.565	42.635	4578752.0
2018-12-13 13:00:00	AAPL	Stock	42.6325	42.714	42.525	42.6038	4629900.0
2018-12-13 13:30:00	AAPL	Stock	42.6	42.885	42.59	42.675	4950884.0
2018-12-13 14:00:00	AAPL	Stock	42.6775	42.69	42.4625	42.6275	7105796.0
2018-12-13 14:30:00	AAPL	Stock	42.6225	42.7325	42.5075	42.7025	4484128.0
2018-12-13 15:00:00	AAPL	Stock	42.7025	42.7225	42.4725	42.605	5730420.0
2018-12-13 15:30:00	AAPL	Stock	42.6025	42.825	42.565	42.71	10121212.0
2018-12-13 16:00:00	AAPL	Stock	42.7375	42.75	42.63	42.675	8741716.0
2018-12-13 16:30:00	AAPL	Stock	42.6752	42.69	42.625	42.6375	28852.0
2018-12-13 17:00:00	AAPL	Stock	42.6375	42.6625	42.625	42.63	22852.0
2018-12-13 17:30:00	AAPL	Stock	42.6275	42.655	42.58	42.5875	36132.0
2018-12-13 18:00:00	AAPL	Stock	42.5875	42.59	42.5375	42.575	37264.0
2018-12-13 18:30:00	AAPL	Stock	42.59	42.65	42.5875	42.6225	8656.0
2018-12-13 19:00:00	AAPL	Stock	42.625	42.6375	42.625	42.6375	8052.0
2018-12-13 19:30:00	AAPL	Stock	42.625	42.625	42.585	42.6075	60920.0
2018-12-13 04:00:00	MSFT	Stock	109.8	109.8	109.6	109.6	400.0
2018-12-13 06:30:00	MSFT	Stock	109.47	109.47	109.3	109.3	850.0
2018-12-13 07:00:00	MSFT	Stock	109.4	109.69	109.3	109.5	12294.0
2018-12-13 07:30:00	MSFT	Stock	109.64	109.75	109.64	109.74	2050.0
2018-12-13 08:00:00	MSFT	Stock	109.5	110.05	109.35	109.98	19339.0
2018-12-13 08:30:00	MSFT	Stock	109.85	109.95	109.71	109.91	9343.0
2018-12-13 09:00:00	MSFT	Stock	109.92	110.13	109.33	109.33	15434.0
2018-12-13 09:30:00	MSFT	Stock	109.55	110.17	108.93	109.61	2987301.0
2018-12-13 10:00:00	MSFT	Stock	109.62	110.87	109.59	110.03	2455775.0
2018-12-13 10:30:00	MSFT	Stock	110.03	110.06	108.64	109.21	2251693.0
2018-12-13 11:00:00	MSFT	Stock	109.2	109.41	108.87	109.26	1833076.0
2018-12-13 11:30:00	MSFT	Stock	109.26	109.65	108.96	109.01	1770872.0
2018-12-13 12:00:00	MSFT	Stock	109.0	109.2	108.7	108.87	1401933.0
2018-12-13 12:30:00	MSFT	Stock	108.87	109.35	108.86	109.13	1046679.0
2018-12-13 13:00:00	MSFT	Stock	109.12	109.185	108.783	109.04	1131038.0
2018-12-13 13:30:00	MSFT	Stock	109.04	109.77	109.0	109.23	1321258.0
2018-12-13 14:00:00	MSFT	Stock	109.24	109.27	108.63	108.98	1256433.0
2018-12-13 14:30:00	MSFT	Stock	108.972	109.29	108.7	109.117	1222317.0

> showing 50 of 83,222 rows — these rows as CSV

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