PREVIEW / stock_30min / 2018-10-23

all stock 30-min files

  file:    by_date/stock_30min/2018/2018-10-23.parquet
  size:    1.7 MB
  rows:    85,436
  symbols: 2,786

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-10-23 04:00:00	AAPL	Stock	54.9675	54.9675	54.3275	54.3575	34252.0
2018-10-23 04:30:00	AAPL	Stock	54.3275	54.42	54.3275	54.4	17496.0
2018-10-23 05:00:00	AAPL	Stock	54.3325	54.3325	54.25	54.32	9980.0
2018-10-23 05:30:00	AAPL	Stock	54.25	54.3625	54.22	54.3625	13040.0
2018-10-23 06:00:00	AAPL	Stock	54.325	54.3875	54.31	54.31	9420.0
2018-10-23 06:30:00	AAPL	Stock	54.3175	54.4125	54.2125	54.4125	28508.0
2018-10-23 07:00:00	AAPL	Stock	54.4375	54.5225	54.275	54.35	187116.0
2018-10-23 07:30:00	AAPL	Stock	54.35	54.3675	54.085	54.2875	270380.0
2018-10-23 08:00:00	AAPL	Stock	54.4375	54.55	54.0825	54.095	536884.0
2018-10-23 08:30:00	AAPL	Stock	54.1075	54.15	53.92	54.0575	829136.0
2018-10-23 09:00:00	AAPL	Stock	54.0725	54.075	53.79	53.925	553940.0
2018-10-23 09:30:00	AAPL	Stock	53.95	54.5175	53.825	54.1625	20173544.0
2018-10-23 10:00:00	AAPL	Stock	54.1625	54.1925	53.675	54.0	15378788.0
2018-10-23 10:30:00	AAPL	Stock	54.02	54.3175	53.86	54.0725	9218308.0
2018-10-23 11:00:00	AAPL	Stock	54.0725	54.425	53.935	54.345	7080612.0
2018-10-23 11:30:00	AAPL	Stock	54.3512	54.4175	54.207	54.2188	6434928.0
2018-10-23 12:00:00	AAPL	Stock	54.2188	54.72	54.215	54.6575	6323928.0
2018-10-23 12:30:00	AAPL	Stock	54.6595	54.8575	54.56	54.6025	6399952.0
2018-10-23 13:00:00	AAPL	Stock	54.5975	54.97	54.5725	54.775	5087632.0
2018-10-23 13:30:00	AAPL	Stock	54.775	54.8525	54.6225	54.695	4993728.0
2018-10-23 14:00:00	AAPL	Stock	54.6925	55.1425	54.6925	55.075	6087500.0
2018-10-23 14:30:00	AAPL	Stock	55.075	55.5175	55.07	55.46	7566652.0
2018-10-23 15:00:00	AAPL	Stock	55.4425	55.805	55.44	55.6538	10020196.0
2018-10-23 15:30:00	AAPL	Stock	55.6548	55.8125	55.6025	55.6912	14307904.0
2018-10-23 16:00:00	AAPL	Stock	55.6825	55.805	55.6275	55.8025	7132828.0
2018-10-23 16:30:00	AAPL	Stock	55.7975	55.805	55.75	55.7875	83388.0
2018-10-23 17:00:00	AAPL	Stock	55.7875	55.7925	55.75	55.775	98108.0
2018-10-23 17:30:00	AAPL	Stock	55.7575	55.7625	55.65	55.65	37040.0
2018-10-23 18:00:00	AAPL	Stock	55.7	55.71	55.6275	55.6275	45656.0
2018-10-23 18:30:00	AAPL	Stock	55.6525	55.6575	55.5875	55.5875	47308.0
2018-10-23 19:00:00	AAPL	Stock	55.575	55.6575	55.565	55.6575	36912.0
2018-10-23 19:30:00	AAPL	Stock	55.6575	55.6575	55.575	55.575	133612.0
2018-10-23 04:00:00	MSFT	Stock	108.8	108.8	107.83	107.83	3817.0
2018-10-23 04:30:00	MSFT	Stock	107.82	107.82	107.63	107.63	4630.0
2018-10-23 05:00:00	MSFT	Stock	107.66	107.66	107.38	107.38	1415.0
2018-10-23 05:30:00	MSFT	Stock	107.38	107.91	107.13	107.91	3656.0
2018-10-23 06:00:00	MSFT	Stock	107.7	107.89	107.7	107.89	940.0
2018-10-23 06:30:00	MSFT	Stock	107.67	108.0	107.66	108.0	800.0
2018-10-23 07:00:00	MSFT	Stock	108.19	108.79	107.92	107.96	26010.0
2018-10-23 07:30:00	MSFT	Stock	107.99	108.19	107.53	108.15	31899.0
2018-10-23 08:00:00	MSFT	Stock	107.94	108.62	107.53	107.8	51924.0
2018-10-23 08:30:00	MSFT	Stock	107.8	108.15	107.54	108.0	33820.0
2018-10-23 09:00:00	MSFT	Stock	108.0	108.0	107.25	107.53	68027.0
2018-10-23 09:30:00	MSFT	Stock	107.6	107.77	106.39	106.44	5292390.0
2018-10-23 10:00:00	MSFT	Stock	106.435	106.575	105.11	105.89	4689372.0
2018-10-23 10:30:00	MSFT	Stock	105.9	106.34	105.47	105.855	2774384.0
2018-10-23 11:00:00	MSFT	Stock	105.855	106.63	105.46	106.46	3039242.0
2018-10-23 11:30:00	MSFT	Stock	106.47	106.535	105.69	105.705	1736188.0
2018-10-23 12:00:00	MSFT	Stock	105.72	106.84	105.64	106.784	2157955.0
2018-10-23 12:30:00	MSFT	Stock	106.788	107.46	106.71	106.81	1923716.0

> showing 50 of 85,436 rows — these rows as CSV

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